Senior Data Analyst (Data Engineer)

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.

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.

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

English or French Essential, Bilingual (English and French) an asset

Reading: Functional Level

Writing: Functional Level

Oral: Functional Level

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: Payment of professional association memberships, online learning opportunities including a LinkedIn Learning subscription and second language training.

Perks: Discounts through CF One Member Appreciation.

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.

March 3, 2025

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.