01 Feb
Canadian Forces Morale and Welfare Services - CFMWS
Quebec City
WHO WE ARE CFMWS. A job with purpose. Our 4000+ person strong organization champions a healthy, fun, creative and active lifestyle for Canadian Armed Forces members, Veterans and their families. Help us deliver a variety of recreation and fitness programs, offer family support, organize charity events and make sure our members access retail, travel and banking discounts and customized financial services. At Canadian Forces Morale and Welfare Services (CFMWS), we love what we do. And we live it too.
THE ROLE Under the direction of Senior Manager, Data and Analytics Architecture , the Data Engineer will be responsible for implementing an end-to-end analytics solution using Microsoft Fabric to ingest data from various sources,
create a semantic models, and enable dashboard/visualization creation for the business team. They assist the data management team in implementing data governance frameworks, policies, and controls.
In addition, they design and implement data pipelines in Microsoft Fabric, including source mapping and documentation, create and optimize semantic models including defining business entities, relationships, and security requirements. They implement data governance policies including classification, sensitivity, access controls, and quality validation through Microsoft Purview integration.
The Data Engineer set up development, testing, and production environments. They create comprehensive technical documentation covering configurations, data models and business rules.
QUALIFICATIONS NEEDED Education, Certifications and Licenses
College diploma or certificate in Business Administration, Computer Science, Computer Engineering, Information Technology or a related field AND several years of experience in application development, data analysis, database design or a related field
Experience
In data modeling (Star schema & Data vault, an asset)
In database platform (SQL server, Azure SQL, an asset)
In data quality framework
In End-to-end data pipeline development and optimization
In architecture implementation
In Power BI semantic model development
In multi-platform data integration
In technical documentation
In applying policies, procedures, and regulations
Competencies
Client focus, organizational knowledge, communication, innovation, teamwork and leadership.
Skills and Abilities
Cross-functional team collaboration
Technical skills (an asset):
MS Fabric, Azure Synapse, Data Factory, Power BI, Azure Data Lake
T-SQL, Spark SQL, Python/PySpark, DAX, Power Query (M)
Version control (Git) & DevOps CI/CD
Lakehouse and Medallion Architecture
LANGUAGE REQUIREMENTS English or French Essential,
Bilingual (English and French) an asset
Reading: Functional Level
Writing: Functional Level
Oral: Functional Level
BENEFITS AVAILABLE Health Benefits: Drug coverage, healthcare spending account, virtual care (telemedicine), Employee and Family Assistance Program, mental health support, travel insurance, dental, vision, life insurance, disability insurance and accidental death and dismemberment coverage.
Work Life Balance: A wide range of paid/unpaid leave, including paid vacation, family related leave and personal days.
Retirement Planning: A Group Savings Plans.
Learning and Development: P ayment of professional association memberships, online learning opportunities including a Linked I n Learning sub scription and second language training.
Perks: Discounts through CF One Member Appreciation.
OTHER INFORMATION This is a temporary position with an anticipated start date of 3 March 2025 and end date of 26 February 2027.
This is a hybrid position with an assigned work location allowing the employee to work partly from a corporate office and partly from a home office in accordance with the CFMWS Flexible Work Options Policy, and with approval from the direct manager.
You may be eligible for a Scarce Skills premium.
START DATE March 3, 2025
INCLUSION AND ACCOMMODATION CFMWS is committed to providing an inclusive, equitable and accessible environment, where all employees feel valued, respected and supported.
We welcome applications from all qualified candidates who can help us build a workforce that reflects the diversity of Canadian society. Workplace accommodation measures are available to all candidates identifying a need during the selection process.
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.