Business Reporting and Analytics Specialist

MHIRJ is the fusion 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, sales and marketing activities for the global regional aircraft industry. We are looking for a Business Reporting and Analytics Specialist to join our ranks in the Information Technology team.

Job Summary

MHIRJ is looking for a full-time Business Reporting and Analytics Specialist, an intelligent, curious person 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 Business Reporting and Analytics Specialist plays a vital role in harmonizing reporting across different company functions, establishing organizational-level reporting standards, and transforming complex data into strategic insights for leadership. This information supports informed strategic decision-making. The incumbent will help evolve the organization beyond lagging indicators toward predictive and advanced leading indicators aligned with key business objectives.

This highly visible position involves direct interaction with senior management, IT teams, and data platform teams. It is critical to ensuring that MHIRJ leaders have 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 Business Reporting and Analytics 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 a Business Reporting and Analytics Specialist:

Corporate Reporting Strategy and Execution:

• Execute and evolve the corporate 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.
• Collaborate closely with IT teams and data platform teams to ensure alignment between ingestion, modeling, and reporting layers.

Partnership with Leaders and Business Units:

• Work directly with business leaders and corporate functions to understand strategic objectives 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 a historical view, 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 data sets.
• 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 toward diagnostic and predictive analytics.
• Identify trends, anomalies, and early signals enabling proactive decision-making.
• Continuously evolve metrics so they remain aligned with constantly changing business priorities.

Continuous Improvement:

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

Operations, Lifecycle, and Report Support:

• Design and develop corporate reports and datasets, then ensure complete lifecycle management including planning, refreshing, validation, and dissemination.
• Monitor report execution, proactively identify failures, and ensure their 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.

Here is what is needed to succeed:

• Over 7 years of experience in roles related to corporate 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 metrics generating clear, actionable insights for decision-making.
• Experience producing reports intended for senior management.
• Excellent stakeholder management skills and the ability to influence without direct hierarchical authority.
• Excellent communication skills, with the ability to simplify complex data concepts for non-technical audiences.
• Experience in complex, matrixed, or regulated corporate environments.
• Knowledge of product- or platform-oriented 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.
• Proficiency in 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 command of SQL for writing and optimizing queries, stored procedures, and triggers.
• Advanced SQL development and optimization skills.
• 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).
• Proficiency in 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 Quebec.

If your experience matches the qualifications required for this position, we encourage you to apply - we would love to meet you!

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 a Business Reporting and Analytics 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 our behaviors which 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 advancement 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.