Analytics and Management Reporting Specialist

MHIRJ; Boisbriand; On-site; CAD 90,000 - 135,000; Full time

Benefits offered by this job

Health insurance

Annual leave

Competitive compensation and bonus

Retirement savings plans

Employee discounts

Job summary

MHIRJ is seeking an Analytics and Management Reporting Specialist to join the Information Technology team. You will harmonize reporting across functions, establish enterprise-wide standards, and transform complex data into strategic information for executives to drive informed decisions.

This role blends hands-on report development with governance, partnering with senior leaders, and managing the lifecycle of reports and datasets in a Databricks and Power BI environment to deliver leading

Qualifications

• 7+ years in enterprise reporting, BI, or analytics.
• Strong Power BI data modeling, DAX, and dashboards.
• Experience with Databricks and modern data platforms.
• Translate requirements into actionable executive indicators.

Responsibilities

• Design, develop, and govern enterprise reports and datasets.
• Collaborate with executives to translate goals into dashboards.
• Establish KPI definitions and reporting standards across units.
• Provide L2/L3 support for reporting incidents and governance.

Skills

Power BI

SQL

Data storytelling

Stakeholder management

Analytics strategy

Tools

Databricks

Azure

Azure Data Factory

Snowflake

Power BI Service

SQL Server

Azure DevOps

Job description

MHIRJ is the merger of two important heritages: Mitsubishi Heavy Industries (MHI) and the CRJ Series program. We provide comprehensive operational, engineering, and customer support solutions, including maintenance, refurbishment, technical publications, marketing, and sales activities for the global regional aircraft industry. We are looking for an Analytics and Management Reporting Specialist to join our ranks in the Information Technology team.

Position Summary

MHIRJ is looking for a full-time Analytics and Management Reporting Specialist, an intelligent, curious individual passionate about the challenges of solving problems of various natures and complexities to improve people's lives. You will collaborate with a dynamic, tight-knit, and pleasant agile team.

The role of Analytics and Management Reporting Specialist plays an essential role in harmonizing reporting across the company's various functions, establishing organization-wide reporting standards, and transforming complex data into strategic information for executives. This information supports informed strategic decision-making. The incumbent will help evolve the organization beyond lagging indicators toward leading indicators aligned with key business objectives.

This highly visible position involves direct interactions with senior executives, IT teams, and data platform teams. It is critical to ensuring that MHIRJ leadership has the right information at the right time to make informed, forward-looking decisions. If you are passionate about transforming data into concrete value and evolving reporting from simple dashboards to a true strategic guidance tool, we would like to meet you.

Unlike traditional BI developer roles focused primarily on project delivery, the Analytics and Management Reporting Specialist position combines a strategic dimension and hands-on report development with ongoing operational responsibility. It thus ensures that reporting solutions remain accurate, reliable, and continuously supported in the production environment.

Your contribution as an Analytics and Management Reporting Specialist:

Enterprise reporting strategy and execution:

• Execute and evolve the enterprise reporting strategy using Databricks as the data foundation and Power BI as the primary visualization platform.
• Design and deliver standardized, reusable reporting assets to ensure consistency, accuracy, and scalability of reports across MHIRJ.
• Work closely with IT and data platform teams to ensure alignment between ingestion, modeling, and reporting layers.

Partnership with executives and business units:

• Work directly with business and corporate function leaders to understand strategic goals and translate them into clear, decision-ready dashboards and reports.
• Develop executive-level reports highlighting trends, risks, opportunities, and leading indicators rather than being limited to historical views, while strengthening operational reporting to support daily activities and increase business value.
• Act as a trusted advisor by helping leaders interpret information and understand its impact on company results.

Reporting standards and governance:

• Define and enforce enterprise-wide reporting standards (metric definitions, visualization best practices, refresh frequency, and performance expectations).
• Promote a single source of truth through clear KPI definitions and governed datasets.
• Foster data literacy by guiding stakeholders on the proper interpretation and use of reports.

Advanced analytics and strategic insight generation:

• Evolve reporting beyond descriptive analytics into diagnostic and predictive analysis.
• Identify trends, anomalies, and early warning signals enabling proactive decision-making.
• Continuously evolve indicators so they remain aligned with constantly changing business priorities.

Continuous improvement:

• Gather stakeholder feedback to improve usability, performance, and relevance of reports.
• Identify opportunities to simplify, automate, or retire low-value reports.
• Contribute to the evolution of MHIRJ's roadmap regarding analytics and data maturity.

Operations, lifecycle, and report support:

• Design and develop enterprise reports and datasets, then manage their complete lifecycle, including planning, refreshing, validation, and dissemination.
• Monitor report execution, proactively identify failures, and ensure rapid resolution to meet service level agreement (SLA) commitments.
• Provide Level 2 and Level 3 (L2/L3) support for reporting incidents, including resolving data, performance, and access issues.
• Perform root cause analyses, document fixes, and implement preventive measures to improve solution stability.
• Maintain reporting assets through rigorous version control, comprehensive documentation, and a controlled deployment process.
• 6-7 Bullets Points

Here is what is needed to succeed:

• Over 7 years of experience in roles related to enterprise reporting, business intelligence (BI), or analytics.
• Solid hands-on expertise with Power BI (data modeling, DAX, performance optimization, and dashboard design).
• Experience working with modern data platforms, ideally Databricks.
• Strong business acumen demonstrated by the ability to translate reporting requirements into relevant indicators generating clear, actionable insights for decision-making.
• Experience producing reports intended for senior management.
• Excellent stakeholder management skills and ability to influence without direct hierarchical authority.
• Excellent communication skills, with the ability to popularize complex data concepts to non-technical audiences.
• Experience in complex, matrixed, or regulated corporate environments.
• Knowledge of product- or platform-driven analytical operating models.
• Familiarity with data governance, metric standardization, and reporting best practices.
• Experience in promoting and adopting standardized reporting solutions across multiple business units.

Technical skills (functional or practical knowledge considered an asset)

• Knowledge of the Azure analytical ecosystem (Power BI, enterprise gateways, Microsoft Fabric) as well as BI practices in a corporate environment.
• Knowledge of Star Schema modeling: fact and dimension tables, RLS (Row-Level Security), CLS (Column-Level Security), OLS (Object-Level Security), and Slowly Changing Dimensions.
• Knowledge of Lakehouse platforms such as Databricks or Snowflake.
• Mastery of tools such as Azure DevOps, Microsoft Visio, Planner/Project, and SharePoint.
• Experience using and integrating APIs.
• Experience in designing, developing, and maintaining automated CI/CD pipelines for deploying applications, data, or artificial intelligence solutions.
• Demonstrated experience as a BI specialist (ETL developer).
• Solid experience with ELT/ETL tools such as Azure Data Factory (ADF) or their equivalents.
• Experience with data warehouses, data lakes, and business intelligence environments.
• Excellent mastery of SQL for writing and optimizing queries, stored procedures, and triggers.
• Advanced skills in SQL development and optimization.
• Experience with Microsoft technologies such as SQL Server, Azure SQL, SSIS, and Azure Data Factory (ADF).
• Knowledge of ETL processes applied to star schemas, analytical cubes, and Data Lake concepts.
• Understanding of Enterprise Gateways.
• Familiarity with cloud data services such as Azure Data Lake and Azure Synapse Analytics.
• Experience with support ticket management platforms such as ServiceNow.
• Knowledge of programming languages such as Python, PowerShell, or .NET (asset).
• Mastery of the Microsoft 365 suite.
• English is required for the position as the selected person will regularly need to communicate with colleagues, clients, or partners located outside of Quebec.

Why join us?

Are you passionate about aviation? Are you eager to make a significant impact on customers? Do you aspire to a fulfilling career as an Analytics and Management Reporting Specialist? If so, you are in the right place. At MHIRJ, we recognize and appreciate your contribution to our unified team. We live by our values and embody behaviors that drive our success. Take flight with a team that shares your passion and supports you in your journey. Let's fly together at MHIRJ!

We offer comprehensive benefits for you and your family, as well as numerous career growth opportunities.

• Competitive health, dental, and vision insurance
• Annual leave bank
• Competitive compensation and annual bonus plan
• Retirement savings plans
• Employee discounts and much more!

MHIRJ is an equal opportunity employer and encourages women, Indigenous peoples, persons with disabilities, and members of visible minorities to apply.