data mining analyst

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, organizational knowledge, communication, innovation, 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)