Business Data Analyst | Analyste, Données dentreprise

About us

We are a purpose-driven organization dedicated to serving Canadians and safeguarding their hard-earned money when it matters most. Every day we honor our promises by working together as one team with Canadians best interests at heart. We are committed to fostering an inclusive and supportive culture guided by determination accountability and a bias for action.

The right challenge is waitingbring your experience and make a difference. Join our team and see how far your skills can take you.

About the role

The Business Data Analyst transforms enterprise data into actionable insights that support strategic and operational decision-making. This role is responsible for the analysis and design of scalable data solutions and delivering interactive dashboards and analytical outputs using Power BI Databricks SQL-based data platforms and Microsoft Power Platforms.This position bridges business strategy and technical execution ensuring data is accurate accessible governed and aligned to organizational priorities.

This role can be performed from ourOttawa or Torontooffices following a hybrid model is a full-time permanentopportunity.

CORE RESPONSIBILITIES required for this role

• Partner with the Data Architect and support business stakeholders to understand reporting analytics and performance measurement needs.

• Act as the primary liaison with internal and/or external stakeholders to capture requirements and advise on optimal data product solutions.

• Translate business questions into technical data requirements and analytical models.

• Document data definitions and ensure alignment with enterprise standards.

• Develop and maintain scalable data pipelines using Databricks (Spark / SQL / Python as applicable).

• Clean transform and model structured and semi-structured datasets.

• Optimize data queries and workflows for performance and reliability.

• Support data quality validation and reconciliation processes.

• Leverage Power Automate to streamline reporting workflows and data refresh processes.

• Develop lightweight business applications using Power Apps where appropriate.

• Integrate analytics solutions with SharePoint Teams and other Microsoft ecosystem tools.

• Maintain documentation for dashboards pipelines and business rules.

• Identify opportunities to automate simplify and standardize reporting processes.

• Design write and optimize SQL queries views and stored procedures to support analytics reporting and data validation activities.

• Participate in the development of data products including dashboards and visualizations ETL and database design.

• Support semantic models and analytical layers including familiarity with SQL Server Analysis Services (SSAS) Tabular or Online analytical processing(OLAP) models where used in the enterprise reporting stack.

• Assist with the development and application of standardized methods to integrate data from numerous sources into corporate data systems ensuring data integrity and interoperability with corporate applications and business intelligence solutions.

• Monitor performance and business use of data systems to identify areas of opportunities for optimization and enhancements and provide recommendations.

About you

You take pride in the work that you do and are passionate about making a difference andan impact. You face challenges head-on are an excellent communicator and collaborator and act with integrity.

SKILLS you bring

• Advance proficiency in Power BI (DAX data modelling visualization best practices).

• Strong hands-on experience with Databricks (Python Spark).

• Strong SQL skills and working knowledge of Microsoft SQL Server data platforms including databases and data warehouses.

• Familiarity with SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) are considered an asset.

• Working knowledge of Microsoft Power Platform (PowerApps Power Automate).

• Experience with relational database and data warehousing concepts.

• Understanding of ETL/ELT processes and data transformation frameworks.

• Ability to work with large complex datasets and cloud-based data environments.

Required EDUCATION & EXPERIENCE

• Bachelors degree in data Analytics Computer Science Business Statistics or related field.

• 35 years of experience in business intelligence analytics or data engineering roles.

• Experience working in regulated or complex enterprise environments is an asset.

• Microsoft certifications (e.g. Power BI Azure Data Engineer) are considered an asset.

• Certifications in data or business intelligence development are considered assets.

Must have

Language Requirements:English Essential

Security Clearance:Eligibility to obtain a Secret-level security clearance

Closing Date

Applications will be reviewed on a rolling basis with priority given to applications received by March 27 2026. The posting may close earlier or remain open longer depending on application volume.

AI Use Disclosure
Artificial intelligence and automated screening tools are not utilized in this hiring process.

Equity Diversity & Inclusion and Accommodation Request

CDIC is an inclusive equitable and diverse workplace. We want to give all qualified applicants the chance to shine during the selection process. We believe that everyone should be treated equally and fairly regardless of race colour religion sex disability age sexual orientation gender identity national origin veteran status or genetic information. CDIC will strive to provide equal opportunity to all. If you need an accommodation to apply for a position or participate in an interview please contact us at .

Sound like you

If you are passionate about serving Canadians and see yourself as our future Business Data Analystplease click the apply now button below.