Senior Business Intelligence Developer, Finance Data & Analytics (15 Month Contract)

We are seeking a Senior Business Intelligence Developer to join our Finance Data & Analytics Team on a 15 month contract. In this role, you will report to the Product Manager Data & Analytics and will be responsible for designing, developing, and maintaining Power BI reports, dashboards, and analytics solutions. You will also work closely with stakeholders to gather business requirements, analyze data, and develop solutions using Alteryx and Azure Synapse.
If you are a highly motivated, experienced Power BI developer with a passion for data visualization and analytics, we encourage you to apply for this exciting opportunity.
Key Responsibilities

• Stay up-to-date with the latest Power BI features and best practices and continuously improve the quality and performance of Power BI solutions
• Provide training and support to end-users to ensure successful adoption of Power BI solutions
• Gather and analyze business requirements from stakeholders and translate them into technical specifications for data models, reports, and dashboards
• Create and maintain data models and relationships in Power BI to ensure data consistency across reports and dashboards
• Develop Power BI reports and dashboards that are visually appealing, intuitive, and provide actionable insights to stakeholders
• Develop and maintain ETL workflows using Alteryx and Azure Synapse to ensure data quality and accuracy
• Collaborate with other developers, analysts, and stakeholders to ensure successful project delivery and adoption of Power BI solutions

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field
• Strong SQL skills to write complex queries, optimize data retrieval, and troubleshoot data issues
• Strong analytical and problem-solving skills
• 5+ years of experience developing Power BI reports, dashboards, and analytics solutions
• Experience with data visualization best practices and design principles
• Experience with DAX and M formula languages in Power BI to create complex calculations and data models
• Strong experience with Alteryx and Azure Synapse to perform data transformation, data integration, and data preparation
• Strong communication and collaboration skills
• Experience with Power Query to connect to various data sources, transform data, and load data into Power BI

Our story
Founded in 1962, OMERS is one of Canada’s largest defined benefit pension plans, with $124 billion in net assets as at December 31, 2022. OMERS is a jointly-sponsored pension plan, with more than 1,000 participating employers ranging from large cities to local agencies, and over half a million active, deferred and retired members. OMERS members include union and non-union employees of municipalities, school boards, local boards, transit systems, electrical utilities, emergency services and children’s aid societies across Ontario. Contributions to the Plan are funded equally by members and employers. OMERS teams work in Toronto, London, New York, Amsterdam, Luxembourg, Singapore, Sydney and other major cities across North America and Europe – serving members and employers and originating and managing a diversified portfolio of high-quality investments in public markets, private equity, infrastructure and real estate.
OMERS is committed to having a workforce that reflects the communities in which we live and work. We are an equal opportunity employer committed to a barrier-free recruitment and selection process. At OMERS inclusion and diversity means belonging. How we create a sense of belonging is through our employees and our vast network of Employee Resource Groups. Whether you are passionate about gender, pride, or visible minorities, we have groups that are focused on making a difference in all of our lives.