Senior Data Engineer, Risk Technology
At IMCO, our talent is among the best! IMCO offers a uniquely stimulating and rewarding environment where you can help build and drive organizational transformation, all while seeking to challenge yourself, learn, and grow your career.
Our culture is built on collaboration and passion, with a shared commitment to delivering lasting value to the clients we serve. Located in downtown Toronto, our vision is to be the partner of choice for Ontario’s public sector funds and to build a high-performing, value-driven asset management firm.
This job posting is for an existing vacancy. If you are ready to deliver best-in-class service and join a collaborative, motivated and fun team of professionals, IMCO offers the opportunity to do impactful work and broaden your expertise.
If you’re looking to use your expertise to drive strategic outcomes, we’d love to hear from you.
Risk Technology is part of the Data Technology group and partners primarily with Investment Risk to deliver technology, data, analytics, reporting, and production-support capabilities through small and medium-sized initiatives, multi-year programs, and ongoing operational services.
As a key member of the Risk Technology team, the Senior Data Engineer will be the team’s senior hands-on Power BI developer, responsible for designing complex reports and visuals, scalable semantic models, and governed business intelligence solutions. The successful candidate will be expected to apply a practical understanding of Fabric capacity, compute consumption, memory constraints, performance, and workload management.
The role also requires strong data engineering capability. The successful candidate will build and support reliable data pipelines that hydrate Power BI semantic models from enterprise data warehouses and will develop complex ETL and transformation solutions using Azure Databricks, Snowflake, Azure Data Factory, SQL, Python, and PySpark.
This position combines deep technical delivery with stakeholder partnership. The incumbent will collaborate with business users, business systems analysts, data engineers, platform teams, and external providers, and will contribute to a constructive, inclusive, and accountable team environment. The role follows the organization’s hybrid working model and requires regular in-office collaboration.
The incumbent will report to the Senior Manager, Data Technology.
As a Member of Our Team You Will be Responsible For:
Power BI development and reporting framework (Primary Area of Accountability)
- Design, develop, test, deploy, and support sophisticated Power BI reports, dashboards, and interactive visual experiences for Investment Risk and related stakeholders.
- Build and optimize enterprise-grade Power BI semantic models, including dimensional design, relationships, measures, calculation groups where appropriate, row-level security, object-level security, incremental refresh, and model performance tuning.
- Write and optimize complex DAX and Power Query (M) logic, applying clear development standards and reusable design patterns.
- Partner closely with business users to translate analytical requirements into intuitive visual designs, rapidly prototype solutions, validate usability, and incorporate feedback throughout delivery.
- Understand and actively manage Fabric ca...
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis.