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 and passionate person who embraces the challenges of solving problems of various nature and complexity 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 insights for executives. 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 interactions with senior executives, 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 turning data into concrete value and evolving reporting from simple dashboards to true strategic guidance, we would like to meet you.
Unlike traditional BI developer roles focused primarily on project delivery, the Analytics and Management Reporting Specialist combines a strategic dimension and hands-on report development with ongoing operational responsibility, ensuring 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 leaders and corporate functions to understand strategic objectives and translate them into clear dashboards and reports ready to support decision making.
- Develop reports for senior management highlighting trends, risks, opportunities and leading indicators rather than just a historical view, while strengthening operational reporting to support daily activities and increase business value.
- Act as a trusted advisor by helping leaders interpret insights and understand their impact on business 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, reliable version of the 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 analytics.
- Identify trends, anomalies and early warning signals enabling proactive decision making.
- Continuously evolve metrics to keep them 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 analytics and data maturity roadmap.
Operations, lifecycle and report support:
- Design and develop enterprise reports and datasets, then manage their full lifecycle including planning, refreshing, validation and dissemination.
- Monitor report execution, proactively identify failures and ensure prompt resolution to meet Service Level Agreement (SLA) commitments.
- Provide Level 2 and 3 (L2/L3) support for reporting incidents, including resolving data, performance and access issues.
- Perform root cause analysis, 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:
- More than 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 metrics generating clear, actionable insights for decision-making.
- Experience producing reports 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 enterprise environments.
- Knowledge of product- or platform-driven analytical operating models.
- Familiarity with data governance, metric standardization and reporting best practices.
- Experience 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 designing, developing and maintaining automated CI/CD pipelines for deploying applications, data or AI 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 because the selected person will regularly communicate with colleagues, clients or partners located outside of 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 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 our 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.
Details
- City
- Boisbriand, Quebec, CA
Need help?
- support@aerowork.ca
- Phone
- 1-450-403-4300