Senior Data Analyst
Top Benefits
About the role
CFMWS – WHERE PURPOSE MEETS PASSION!
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.
THE ROLE
Under the direction of Senior Manager, Data and Analytics Architecture, the Data Analyst will implement analytics solutions to ingest data from various sources, analyze complex datasets, and enable dashboard creation for business teams. They will reverse engineer existing data models, assess data quality, and support migration initiatives. The Data Analyst designs and develops data pipelines, performs ETL operations, and creates Power BI semantic models including business entities, relationships, and security requirements. They assist in implementing data governance frameworks while ensuring proper data mapping and transformation processes. Key responsibilities include data analysis to identify business insights, reverse engineering legacy systems, executing data migration strategies, developing ETL processes, creating Power BI semantic models, and developing dashboards and reports across development, testing, and production environments.
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
Data modeling methodologies (Star schema, Snowflake schema, …)
Database platforms (SQL Server, Oracle, Azure SQL)
Data quality frameworks and validation techniques
Data profiling and data lineage documentation
ETL/ELT processes and data transformation techniques
Power BI semantic model development and DAX optimization
Business intelligence and analytics solution implementation
Reverse engineering of existing data systems and models
Technical documentation and data mapping
Competencies
Client focus, analytical thinking, organizational knowledge, communication, innovation, problem-solving, attention to detail, teamwork and leadership.
Skills and Abilities
Cross-functional team collaboration
Technical skills :
SQL Server (advanced SQL, stored procedures, optimization), SSIS, SSRS, SSMS Oracle (advanced SQL, PL/SQL)
Power BI (semantic modeling, DAX, Power Query M)
ETL/ELT design patterns and best practices
Azure Synapse Analytics Version control (Git) and DevOps CI/CD
Lakehouse and Medallion Architecture
LANGUAGE REQUIREMENTS
English or French Essential, Bilingual (English and French) an asset
Reading: Functional
Writing: Functional
Oral: Functional
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 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: 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
OTHER INFORMATION
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.
The selection process will be done virtually.
This position is a one-year term.
START DATE
As soon as possible
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. 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.
Job Reference: CFMWS14808
About Canadian Forces Morale and Welfare Services
The Canadian Forces Morale and Welfare Services (CFMWS) supports the Canadian Armed Forces members and their families wherever they are in the world through the provision of fitness, recreation and leisure activities, family and charitable support, retail as well as personal financial services. We offer our employees the opportunity to work with a purpose every day in an inclusive, healthy, respectful and rewarding work environment.
Senior Data Analyst
Top Benefits
About the role
CFMWS – WHERE PURPOSE MEETS PASSION!
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.
THE ROLE
Under the direction of Senior Manager, Data and Analytics Architecture, the Data Analyst will implement analytics solutions to ingest data from various sources, analyze complex datasets, and enable dashboard creation for business teams. They will reverse engineer existing data models, assess data quality, and support migration initiatives. The Data Analyst designs and develops data pipelines, performs ETL operations, and creates Power BI semantic models including business entities, relationships, and security requirements. They assist in implementing data governance frameworks while ensuring proper data mapping and transformation processes. Key responsibilities include data analysis to identify business insights, reverse engineering legacy systems, executing data migration strategies, developing ETL processes, creating Power BI semantic models, and developing dashboards and reports across development, testing, and production environments.
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
Data modeling methodologies (Star schema, Snowflake schema, …)
Database platforms (SQL Server, Oracle, Azure SQL)
Data quality frameworks and validation techniques
Data profiling and data lineage documentation
ETL/ELT processes and data transformation techniques
Power BI semantic model development and DAX optimization
Business intelligence and analytics solution implementation
Reverse engineering of existing data systems and models
Technical documentation and data mapping
Competencies
Client focus, analytical thinking, organizational knowledge, communication, innovation, problem-solving, attention to detail, teamwork and leadership.
Skills and Abilities
Cross-functional team collaboration
Technical skills :
SQL Server (advanced SQL, stored procedures, optimization), SSIS, SSRS, SSMS Oracle (advanced SQL, PL/SQL)
Power BI (semantic modeling, DAX, Power Query M)
ETL/ELT design patterns and best practices
Azure Synapse Analytics Version control (Git) and DevOps CI/CD
Lakehouse and Medallion Architecture
LANGUAGE REQUIREMENTS
English or French Essential, Bilingual (English and French) an asset
Reading: Functional
Writing: Functional
Oral: Functional
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 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: 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
OTHER INFORMATION
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.
The selection process will be done virtually.
This position is a one-year term.
START DATE
As soon as possible
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. 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.
Job Reference: CFMWS14808
About Canadian Forces Morale and Welfare Services
The Canadian Forces Morale and Welfare Services (CFMWS) supports the Canadian Armed Forces members and their families wherever they are in the world through the provision of fitness, recreation and leisure activities, family and charitable support, retail as well as personal financial services. We offer our employees the opportunity to work with a purpose every day in an inclusive, healthy, respectful and rewarding work environment.