Data Analyst (Data Engineer)

At Canadian Forces Morale and Welfare Services (CFMWS), we’re more than just a workplace; we’re a proud community dedicated to supporting Canadian Armed Forces members, veterans and their families in their daily lives. We carefully curate and provide programs and services designed to meet their unique needs and enhance their mental, social, physical, financial and familial well-being. CFMWS employees deliver programs and services including recreation, sports and fitness programs, customized financial services, retail services, access to retail savings and discounts and offers family support and organizes charity events.

Our success stems from living our values. Our employees care about their role in supporting Canadian Armed Forces members, veterans and their families and act with integrity in all they do. Thriving in our close-knit environment, we act as one team with one mission. We constantly seek new ideas and creative ways to deliver the best possible programs and services.

As an employer, we offer a commitment to your health, wellness and growth. We provide a diverse range of roles across many locations and a career where you can make a meaningful impact.

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 including classification, sensitivity, access controls, and quality validation. 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. 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, certificate, or degree in Computer Science, Information Technology, Data Engineering, Cloud Computing or a related field AND several years of experience in application development, data analysis, database design or a related field.

Experience

Data modeling methodologies (Star schema, Snowflake schema; Data Vault is an asset)

End-to-end data pipeline development, optimization, and monitoring

Data quality frameworks, validation techniques, and data profiling

Database platforms (SQL Server, Azure SQL; Oracle is an asset)

Fabric/Power BI semantic model development and DAX optimization

Multi-platform data integration and ETL/ELT design patterns

Lakehouse and Medallion Architecture implementation

Data lineage documentation and data mapping

Technical documentation and solution design

Applying organizational policies, procedures, and data governance regulations

Technical skills

Microsoft Fabric (Data Factory, data pipelines, lakehouses, warehouses, notebooks, Spark job definitions)
Power BI (semantic modeling, DAX, Power Query M, dataflows)
SQL (advanced T-SQL, stored procedures, query optimization)
Spark (PySpark, Spark SQL, Delta Lake)
Python for data engineering and transformation
ETL/ELT design patterns and best practices
Lakehouse and Medallion Architecture (Bronze/Silver/Gold)
Azure data services (Azure Data Lake Storage Gen2, Azure Synapse Analytics, Azure SQL)
Version control (Git) and Azure DevOps CI/CD
SSIS, SSRS, SSMS (an asset)

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

Reading: Functional

Writing: Functional

Oral: Functional

Health Benefits: Drug coverage, healthcare spending account, virtual care (telemedicine), Employee and Family Assistance Program, mental health support, travel insurance, dental, vision, life insurance and disability insurance.

Work Life Balance: Flexible work options and a wide range of paid/unpaid leave, including paid vacation, family related leave and personal days.

Retirement Planning: A Defined Benefit Pension Plan and 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.

Explore all the benefits CFMWS offers by visiting: https://cfmws.ca/Benefits

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.

This position is a two-year term.

The selection process will be done virtually.

You may be eligible to receive a Scarce Skills Premium for this position as outlined in the attached IT Scarce Skills Compensation Agreement.

Competencies

Client focus, organizational knowledge, communication, innovation, teamwork and leadership.

Skills and Abilities

Cross-functional team collaboration

As soon as possible

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. If contacted in relation to a job opportunity or assessment, you should advise the recruitment team in a timely fashion of the accommodation measures which must be taken to enable you to be assessed in a fair and equitable manner. Information received relating to accommodation measures will be addressed confidentially.