Senior Data Analyst – Hybrid, Power BI & ETL Specialist

Canadian Forces Morale and Welfare Services

Ottawa

Hybrid

CAD 70,000 - 110,000

Full time

6 days ago

Be an early applicant

Application generator

Turn this role into an interview — a resume and cover letter built around what this employer wants.

Get past ATS filters

Benefits offered by this job

Health Benefits

Flexible work options

Group Savings Plans

Professional development

Job summary

CFMWS in Ottawa is seeking a Data Analyst to implement analytics solutions, ingest data from multiple sources, and support dashboard creation for business teams. You will reverse engineer data models, assess data quality, and assist migration initiatives.

You will design data pipelines, perform ETL, and build Power BI semantic models, reports, and dashboards across development, testing, and production environments. English or French essential; hybrid work arrangement.

Qualifications

College diploma in a related field and several years of experience in data analysis, development, or a related field.
Experience with data modeling methodologies and BI solution implementation.
Strong skills in SQL-based data extraction, ETL/ELT processes, and Power BI semantic modeling.

Responsibilities

Analyze data to identify business insights and support data migration initiatives.
Design and develop ETL processes and data pipelines.
Create Power BI semantic models, relationships, and security requirements.
Develop dashboards and reports across development, testing and production environments.