Data Analyst (Power BI/SQL Developer)

OMERS

OMERS serves as a dynamic pension plan and leading global investor with teams across the world, including Toronto, London, and New York. They are dedicated to embodying the values of their over 600,000 members and placing their interests first. As part of their supportive and innovative environment, they encourage personal growth, wellness, and community involvement.

In this role you can expect to have the responsibilities:

• Collect and integrate data from multiple sources, ensuring accuracy and consistency.
• Clean and preprocess raw data to remove errors and inconsistencies.
• Analyze data using statistical methods to identify trends and inform decisions.
• Create and automate reports, dashboards, and visualizations using Power BI and Excel.
• Collaborate with cross-functional teams to deliver insights and define KPIs.
• Identify opportunities to improve data processes and stay updated with latest practices.
• Ensure data security, privacy, and compliance.
• Develop SQL queries for ad-hoc analysis and urgent data requests.
• Document analysis methods and share insights with the team.

This role comes with the following benefits:

• Flexible hybrid work environment, requiring one day in the office per week.
• Cultivated sense of belonging and connection through Employee Resource Groups and recognition programs.

This role requires you to have:

• Bachelor’s degree in a relevant field or equivalent experience.
• 5 years of experience in data analysis and Power BI development.
• Proficiency in Power BI, including DAX and building semantic data models.
• Experience with relational databases and SQL
• Strong problem-solving and critical-thinking skills.
• Excellent communication and presentation skills.

You would benefit from having:

• Experience with Azure Data Services.
• Strong understanding of DB Pension Knowledge.

OMERS champions diversity and inclusion through equal opportunity practices, ensuring a barrier-free recruitment and work environment. They embody a people-first culture, valuing the diversity within the communities they serve.