Senior Data Analyst (Data Engineer)

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.

Location: Montréal North, CA

Posted Date: 1/30/2025