I’m Steven Mitchell Heinei, a data-driven analytics leader with 18 years of experience turning complex data into clear, actionable insights. I’ve built and modernized reporting and analytics ecosystems using tools like Power BI, Tableau, and SQL—creating dashboards and data models that help teams track performance, find trends, and make faster, better decisions. Across government and healthcare to insurance and finance, I’ve implemented data governance frameworks, automated reporting, and improved data quality and lineage so stakeholders can trust the numbers. Highlights include rolling out organization-wide data governance, deploying Power BI infrastructure at scale, and building reusable SQL/ETL patterns that reduce manual effort while improving accessibility and decision support for large user communities.…

Steven Mitchell Heinei

I’m Steven Mitchell Heinei, a data-driven analytics leader with 18 years of experience turning complex data into clear, actionable insights. I’ve built and modernized reporting and analytics ecosystems using tools like Power BI, Tableau, and SQL—creating dashboards and data models that help teams track performance, find trends, and make faster, better decisions. Across government and healthcare to insurance and finance, I’ve implemented data governance frameworks, automated reporting, and improved data quality and lineage so stakeholders can trust the numbers. Highlights include rolling out organization-wide data governance, deploying Power BI infrastructure at scale, and building reusable SQL/ETL patterns that reduce manual effort while improving accessibility and decision support for large user communities.…

Available to hire

I’m Steven Mitchell Heinei, a data-driven analytics leader with 18 years of experience turning complex data into clear, actionable insights. I’ve built and modernized reporting and analytics ecosystems using tools like Power BI, Tableau, and SQL—creating dashboards and data models that help teams track performance, find trends, and make faster, better decisions.

Across government and healthcare to insurance and finance, I’ve implemented data governance frameworks, automated reporting, and improved data quality and lineage so stakeholders can trust the numbers. Highlights include rolling out organization-wide data governance, deploying Power BI infrastructure at scale, and building reusable SQL/ETL patterns that reduce manual effort while improving accessibility and decision support for large user communities.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
See more

Work Experience

Data Governance and Analytics Experience Manager at Government of Canada (ON and Nova Scotia)
March 1, 2024 - Present
Introduced and implemented Power BI infrastructure to satisfy internal analytics metrics and reporting needs for both Ontario and Nova Scotia governments. Established a data governance framework extending across the organization, worked with business groups to build end-to-end Power BI solutions tracking overtime across 11 Nova Scotia sites, and partnered with SMEs to create a Power BI dashboard for Ontario healthcare reporting standards—collecting, processing, and reporting financial and statistical data to government stakeholders. Built reusable SQL-based CRM solutions via Snowflake extracts imported into SMSs for quarterly repeatability, mentored junior analysts in Power BI and SQL, and led rollout of an organization-wide data governance framework focusing on data standards/definitions, lineage/source-of-truth, data quality/stewardship, and reporting/analytics governance. Also coordinated efforts supporting 100+ employee data points across governance domains.
Associate Director of Data Analytics - AbbVie Patient Engagement at IQVIA
March 1, 2024 - Present
Led the analytical needs of the AbbVie Patient Engagement program, directing dashboard development and dissemination via SQL from Postgres and DataBricks in Tableau and Power BI for 70+ users. Built Databricks-backed dashboards to track patient activity, movement, and program attrition, increasing visibility of the patient journey by 80%. Partnered with the CoPay Engagement team to deliver Power BI dashboards for Quarterly Reporting, merging Patient Engagement and CoPay data to present a more complete patient story. Spearheaded migration of 100+ Postgres views to a Databricks data warehouse, collaborating with Data Engineers to improve data accessibility and dashboard performance while reducing infrastructure costs. Automated daily enrollment counts in Databricks, saving 1+ hour per day in manual processing.
Associate Director of Data Analytics at IQVIA
June 1, 2021 - November 30, 2023
Led analytics strategy and reporting modernization for AbbVie’s Patient Engagement program, progressing from Principal Data Analyst to Associate Director. Oversaw analytics for data infrastructure, dashboard development, and cross-functional insights supporting over one million patients. Built an unified quarterly reporting framework by integrating Patient Engagement and CoPay data in Power BI, led migration of 100 accessibility and improved infrastructure efficiency, automated daily enrollment reporting to eliminate manual effort, delivered IQVIA and AbbVie reporting value, and increased patient activity and attribution visibility by 80% through DataBricks-powered dashboards. Enhanced immunology program decision-making using daily Tableau Online reporting used by 17 corporate data analysts (contract).
Principal Data Analyst at IQVIA (Customertimes Canada)
June 1, 2021 - March 1, 2024
Engineered and maintained Postgres SQL queries and Tableau dashboards supporting AbbVie's Immunology and Specialty Patient Engagement initiative, informing decisions impacting hundreds of thousands of patients. Streamlined Daily Patient Engagement Reporting with customized Tableau reports distributed across management levels. Orchestrated SSMS SQL queries merging IRIS and Intrali Claim datasets, pinpointing data discrepancies and fortifying the Accident Year reconciliation initiative; collaborated with SMEs and senior management to develop a corporate-wide tactical proof of concept. Designed and deployed interactive Power BI and Tableau dashboards for Accident Year reconciliation. Migrated financial dashboards from Tableau to Power BI to align with the corporate Power BI infrastructure.
Data Analyst (Contract) at AXIS Capital
November 1, 2020 - May 31, 2021
Created SQL logic to combine IRIS and Intrali Claim data and produced Power BI dashboards for insurance/reinsurance groups. Migrated financial dashboards from Tableau to Power BI to align to corporate infrastructure and reduce IT overhead. Orchestrated complex SSMS SQL queries merging IRIS and Intrali Claim datasets, delivering 22 interactive Power BI and Tableau dashboards for Accident Year reconciliation and reducing IT overhead by migrating 15 financial dashboards. Coordinated a corporate-wide tactical solution proof of concept with SMEs and senior managers to support faster decision-making at AXIS Capital.
Data Analyst at IQVIA
November 1, 2020 - May 31, 2021
Created SQL logic to combine IRIS and Intrial Claim data. Produced Power BI dashboards for insurance/reinsurance groups and migrated multiple financial dashboards from Tableau to Power BI to align with corporate Power BI infrastructure and reduce IT overhead. Orchestrated complex SSMS SQL queries merging IRIS and Intrial Claim datasets to pinpoint discrepancies and strengthen Accident Year reconciliation initiatives across the firm. Delivered interactive Power BI and Tableau dashboards improving accessibility for insurance/reinsurance groups and reduced IT overhead by migrating financial dashboards from Tableau to Power BI, standardizing corporate infrastructure. Led development of a corporate-wide tactical solution proof of concept by coordinating with SMEs and senior managers to accelerate decision-making at AXIS Capital.
Corporate Data Analyst (Contract) at AXIS Capital
November 1, 2020 - June 1, 2021
Created SQL logic to combine IRIS and Intrali Claim data; produced Power BI dashboards for Insurance/Reinsurance groups. Orchestrated complex SSMS SQL queries merging IRIS and Intrali Claim datasets, pinpointing data discrepancies and fortifying the Accident Year reconciliation initiative, coordinating with SMEs and senior management to create a corporate-wide tactical solution. Designed and deployed interactive Power BI and Tableau dashboards for accident year reconciliation. Migrated several financial dashboards from Tableau to Power BI for insurance/reinsurance groups, reducing IT overhead costs by 20%.
Data Analyst at Sky Cap Financial
August 1, 2020 - December 31, 2020
Updated and created Power BI dashboards for clients’ financial profiles. Revised financial and NSF dashboards by updating measures and calculated columns with accurate and efficient DAX code reflecting business requirements. Enabled near real-time management insights by coordinating Power BI Online and gateway refresh setups processing data hourly. Increased operational efficiency by presenting daily loan activity via development of three interactive Power BI dashboards updated daily for stakeholders’ decision-making. Enhanced data accuracy by updating five financial dashboards’ measures and columns aligned with business needs, and delivered continuous client financial profile updates by maintaining and creating four Power BI dashboards reflecting current data.
Data Analyst (Contract) at SkyCap Financial
August 1, 2020 - November 1, 2020
Updated and created Power BI dashboards for clients' financial profiles. Updated Financial and NSF dashboards by updating measures and calculated columns with accurate and efficient DAX code. Pioneered development of interactive Power BI dashboards presenting daily loan activity, refreshed every morning, providing stakeholders insights to make informed decisions and boost operational efficiency. Coordinated with IT partners to establish Power BI Online and Gateways for dashboards to be refreshed on a daily and, in some cases, hourly basis, delivering near real-time insights.
Principal Analyst at Ontario Colleges Application Services (OCAS)
August 1, 2019 - December 31, 2019
Responsible for Power BI dashboards analyzing enrollment activity across Ontario Colleges. Built Power BI dashboards with Oracle SQL back-end queries providing student application and enrollment insights across 24 Ontario colleges within an Agile SDLC. Produced enrollment insight dashboards for the OCAS Domestic Insights project, supporting data accuracy/availability with creation of 12 dashboards. Improved three internal Power BI dashboards for PMO and Call Centre, increasing operational transparency by tracking project and call center metrics. Developed five Power BI dashboards analyzing enrollment data across 24 colleges, improving leadership’s strategic decision-making.
Data Analyst at Ontario Colleges Application Services (OCAS)
August 1, 2019 - August 1, 2020
Principal analyst responsible for Power BI dashboards to analyze enrolment activity across all Ontario Colleges. Built Power BI dashboards to provide student application and enrollment insights across all 24 Ontario Colleges, informing strategic decisions by leadership within an Agile SDLC. Constructed OCAS Domestic Insights Project dashboards and enhanced internal Power BI dashboards for PMO and Call Centre Services, monitoring project performance and call center efficiency to improve operational transparency.
Business Data Analyst (Contract) at CARFAX Canada
January 1, 2019 - July 31, 2019
Created SQL and Power BI analytics using CARFAX and other third-party data subscriptions for business insights. Pioneered creation of seven Power BI dashboards highlighting profit growth trends, increasing sales team engagement with dealership partners by 30%. Designed, developed, and published ad-hoc SQL reports monthly enabling data-driven decisions on product direction for product teams and management. Conducted detailed data quality analyses on Vehicle History Reports, Polk VIN data, and Odometer readings covering 70 million records. Investigated and provided business rules to data engineers for the new International Insights project used to aid vendor POC requirements and validate KM on CARFAX reports.
Business Data Analyst (Contract) at CARFAX Canada - an IHS Markit Company
January 1, 2019 - April 1, 2019
Created SQL & Power BI analytics, using Carfax and other 3rd party data subscriptions for business insights. Pioneered the development of dashboards showcasing profit growth trends for dealership groups; enabled sales teams to boost engagement with dealership partners. Designed, developed, and published operational ad-hoc SQL reports monthly, enabling data-driven decisions on product direction for product teams and management. Conducted in-depth data quality research on Vehicle History Reports, Polk VIN data, and odometer readings. Investigated and provided business rules to Data Engineers for the new International Insights Project to validate data on Carfax reports.
Business Data Analyst at IHS Markit
February 1, 2014 - December 31, 2018
Analyzed CRM data to find data deficiencies using Tableau and provided a business process for data improvements. Gathered requirements enhancing the Canadian clientele CRM and increasing collected data for detailed trend analysis using Tableau. Generated weekly, monthly, and quarterly Tableau reports on data quality analysis from enhanced CRM data, disseminated to SMEs and management. Spearheaded mapping of thousands of Canadian wells, facilities, and pipelines, improving data completeness using enhanced CRM data. Resolved data quality issues by creating Tableau dashboards for the IHS PPD M database data quality using CRM data to find and categorize data issues. Improved data quality by resolving hundreds of CRM data deficiencies using Tableau with a MySQL backend, enhancing business processes at IHS Markit. Led Canadian clientele CRM enhancement, increasing collected data by 70% to enable detailed trend analysis with Tableau.
Business Data Analyst - Canadian Information Operations at IHS Markit
February 1, 2014 - May 1, 2016
Analyzed CRM data to find data deficiencies using Tableau and provide a business process for data improvements. Gathered requirements that enhanced the Canadian Clientele CRM, enabling increased data collection for trend analysis. Generated weekly, monthly, and quarterly Tableau reports on data quality. Led a data mapping project for Canadian wells, facilities, and pipeline data, leading to improvements in data completeness. Resolved data quality issues by creating Tableau dashboards on the data quality of the IHS PPDM database to identify and categorize data issues.

Education

B.A Geography at Western University
January 11, 2030 - January 12, 2026
B.SC. Computer Science at Western University
January 11, 2030 - January 12, 2026
B.A. Geography at Western University
September 1, 2004 - January 1, 2004
B.S. Computer Science at Western University
September 1, 1999 - January 1, 1999

Qualifications

Add your qualifications or awards here.

Industry Experience

Healthcare, Financial Services, Professional Services, Software & Internet, Government, Education

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
See more

Hire a Data Analyst

We have the best data analyst experts on Twine. Hire a data analyst in Halifax today.