This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
Are you an experienced BI professional looking for your next high-impact project? Our Calgary client is seeking a talented Senior Business Intelligence and Analytics Analyst for an exciting long-term engagement focused on modernizing and expanding their data portfolio. In this role, you will play a key part in analyzing, designing, and implementing enterprise-grade reporting and data solutions. If you want to apply your deep data expertise to a stable, multi-platform environment within a dynamic public sector setting, this contract is the perfect opportunity for you.
Job Responsibility
Coordinate directly with subject matter experts to gather and define complex reporting requirements
Work closely with the IT Governance team to validate and refine solution architectural proposals
Review, optimize, and update existing data marts to ensure high performance and accuracy
Develop and modify ETL scripts to onboard new tables and data sources
Design and implement efficient data pipelines within Azure Data Factory
Prepare comprehensive technical documentation to ensure smooth long-term maintenance
Train and transition knowledge to internal support staff for post-implementation success
Requirements
Minimum of five years of experience within the last seven years developing business intelligence and analytics solutions using Informatica, SAP BusinessObjects, or Microsoft data platforms
Minimum of five years of experience applying data modelling principles including Kimball Dimensional Modelling
Minimum of five years of hands-on experience working with database technologies and scripting in Oracle or SQL Server
At least two years of experience mentoring and guiding other business intelligence and analytics developers
Strong knowledge of cloud data architecture, Azure security controls, and DevOps frameworks, supplemented by relevant certifications or experience with Denodo
What we offer
Work on a large-scale, ongoing portfolio with a prominent public sector organization
Gain exposure to a diverse tech stack spanning Informatica, SAP, and modern Microsoft cloud platforms
Take ownership of end-to-end solutions from initial requirement gathering to final implementation
Collaborate with enterprise architecture and governance teams on major data initiatives
Mentor and guide internal developers to help elevate team capabilities