Data Management Analyst

Website Mckesson Canada

Job Description:

The Data Management Analyst acts as the subject matter expert in data collection and reporting for McKesson Specialty Health. The incumbent is responsible for defining requirements based on user requests (internal and external) to develop, improve, and implement reporting solutions and other interactive reporting tools required to monitor trends & KPIs and provide insight into the business.

Job Responsibilities:

  • Analyze data to identify trends, exceptions, and areas for further investigation
  • Manage the end-to-end development cycle of Power BI reports and dashboards (supplemental use of Excel and PowerPoint from concept through to deployment to aid with monitoring and decision making
  • Document process, models, designs, and solutions and able to explain, train, and discuss with the team
  • Analyze current ETL process, define and design new systems
  • Identifies, analyzes, researches, and resolves data issues and makes appropriate recommendations.
  • Liaise with stakeholders for new report development, both internal and external
  • Develop and generate business reports, including ad hoc reporting to support business decisions as well as develop reports on key business metrics to measure the performance and success of any key initiatives
  • Create automation for repeating reporting tasks, identify gaps and opportunities in our current data flow processes to increase data quality and highlight bad data points
  • Understand, clean, and transform a large amount of complex data from multiple sources, including various internal and external databases to develop data solutions, conduct data analysis and maintain the business intelligence

Job Requirements:

  • Knowledge of Power BI using Snowflake and Salesforce
  • Experience with Power BI Dynamic Row Level Security, Power Apps and Power Query
  • Strong experience with Microsoft Office mainly Excel and PowerPoint
  • Proficiency in utilizing advanced SQL data extraction and manipulation tools
  • Programming skills Python or R is an asset
  • Advanced MS Excel proficiency (Pivots, VLOOKUPs)
  • Must have experience in creating visualizations, reports, and dashboards in Power BI including publishing reports and dashboards using Power BI Service & Gateways
  • Sound knowledge of database management, data modeling, data mining, business intelligence, and OLAP(Online Analytical Processing)
  • 3+ years of proven experience in database analytics, reporting and Power BI development

Job Details:

Company: Mckesson Canada

Vacancy Type: Full Time

Job Location: Mississauga, ON, CA

Application Deadline: N/A

Apply Here