Data Management and Reporting Analyst

**Consider an opportunity to join our talented team**
- The Medical Council of Canada (MCC) was recognized as a National Capital Region Top Employer for ten consecutive years_

**Want to contribute to the health and wellbeing of Canadians?**
At the MCC, you’ll be part of a dynamic team that ensures that physicians have the competencies to support safe, accessible health care in Canada.

You’ll be immersed in an exceptional work environment that fosters professional development and work-life balance.

**Data Management and Reporting Analyst**

**Full Time Permanent**

**Ottawa, Ontario, Canada**

**Hybrid role**

Are you passionate about turning raw data into powerful insights that drive business decisions? Join us as a Data Management and Reporting Analyst at MCC, where you'll play a key role in collecting, organizing, and safeguarding our data. Reporting to the Senior Manager, Business Technology, you'll collaborate with project teams across the organization to enhance data quality and ensure our data tells the story it’s meant to. If you have a sharp analytical mind, a knack for detail, and the ability to transform data into strategic actions, we want you on our team

**What you’ll do**
- Establish, implement, manage and continuously improve best practices, in collaboration with MCC governance representatives.
- Reduce duplicative efforts by promoting best practices.
- Foster adoption of data-related processes, standards, and security guidelines.
- Collaborate to analyze and document business requirements.
- Participate in the design and development of MCC Data Governance Framework model
- Architect, design, develop and implement analytical solutions involving multiple data sources including MS SQL Server (enterprise, hosted).
- Design and implement data marts and data with different solutions.
- Facilitate communication with business data owners.
- Provide a deep understanding of data management best practices and shares that knowledge across the organization.

**What you need to succeed**

**Experience**
- 3-5 years of experience in Information Architecture, Database Information Management, Data Migration, Data Architecture, Data Modeling, and Data Analytics Solutions

**Technical Skills**
- Experience using business intelligence and automation platforms such as:

- Microsoft BI tools (SSIS, SSRS, SSAS, Power BI), MS Power Platform, MS Power Platform (Power BI, Power Apps, Power Virtual Agent, Power Automate)
- .NET Applications, MS Azure, MS Azure Data Factory, Azure Synapse, Azure Databricks
- Java, JavaScript
- Knowledge and experience in managing data sources and reporting tools using:

- MS SQL Server, MS Data bricks
- Strong knowledge and experience in development of online solutions and distributed systems
- Hands-on experience employing modelling tools for the purpose of process modelling and analysis
- Experience working in Microsoft Azure DevOps (ADO)
- Enterprise Data Warehousing (EDW)
- Predictive Analytics
- Business Intelligence (BI)
- Big Data Analytics, (AI)
- SharePoint repositories

**Competencies**
- Strong interpersonal skills with the ability to foster collaborative relationships with business and technical teams
- Excellent communications, including technical written skills
- Strong teamwork and collaboration
- Highly organized, analytical, process oriented and methodical
- Highly developed attention-to-detail to detect and solve problems
- Ability to manage multiple changing priorities, including under pressure and while working to deadlines
- Demonstrates judgement, initiative, resourcefulness, tact, and discretion
- Ability to work independently and as part of a team

**Education**
- A bachelor’s degree in data science, Computer Science, Information Technology, or a related field.
- The following would be considered an asset
- Microsoft Certified Analyzing Data with Microsoft Power BI
- Microsoft Certified Solutions Expert (MCSE): Data and Business Intelligence
- Database Management
- Scrum / Agile

**Language**
- Advanced oral and written skills in English are required, with oral and written skills in French considered an asset

**The perks**
- A defined benefit pension plan
- A complete benefit package on your first day on the job
- Three weeks’ vacation right off the bat
- A company-paid holiday closure in December - our gift to you
- A 35-hour work week
- Compressed and telework programs
- Free onsite parking - any day, any time
- Free virtual Mobility and Strength & Conditioning classes

**Visit our **Careers **page to learn more about the many reasons you can thrive at the MCC.**

**The MCC is an equal opportunity employer, co**mmitted to diversity and inclusion in the workplace at all levels of its organization.**
**Accommodations can be provided at all stages of the hiring process; we ask applicants to make their needs known in advance.**

**Please note that only those invited for an interview will be contacted.