Enable job alerts via email!
Data Analyst (Power BI Developer)
OMERS
Toronto
Hybrid
CAD 75,000 - 100,000
Full time
Boost your interview chances
Create a job specific, tailored resume for higher success rate.
Job summary
Join a leading global investor as a Data Analyst (Power BI Developer). You'll work with cutting-edge tools to analyze complex data sets and deliver insights that guide key business decisions. This role offers opportunities for professional growth while being part of a dynamic team committed to excellence. Ideal candidates have strong analytical skills, experience in Power BI, SQL, and Python, and a passion for data-driven decision making.
Benefits
Qualifications
- 5 years of hands-on experience in Data analysis and Power BI development.
- Strong proficiency in Power BI, including DAX and data modeling.
- Experience with relational databases and data warehousing concepts.
Responsibilities
- Collect and integrate data from multiple sources ensuring accuracy.
- Analyze data for insights and support decision-making.
- Create dashboards and visualizations using Power BI.
Skills
Education
Tools
Job description
Join to apply for the Data Analyst (Power BI Developer) role at OMERS
Join to apply for the Data Analyst (Power BI Developer) role at OMERS
Choose a workplace that empowers your impact.
Join a global workplace where employees thrive. One that embraces diversity of thought, expertise and experience. A place where you can personalize your employee journey to be — and deliver — your best.
We are a purpose-driven, dynamic and sustainable pension plan. An industry leading global investor with teams in Toronto to London, New York, Singapore, Sydney and other major cities across North America and Europe. We embody the values of our 600,000+ members, placing their best interests at the heart of everything we do.
Join us to accelerate your growth & development, prioritize wellness, build connections, and support the communities where we live and work.
Don’t just work anywhere — come build tomorrow together with us.
Know someone at OMERS or Oxford Properties? Great! If you're referred, have them submit your name through Workday first. Then, watch for a unique link in your email to apply.
We are seeking for a highly skilled and motivated Data Analyst(Power BI Developer) to join our Pension Products & Technology team in Toronto. The ideal candidate will have at least 5 years of hands-on experience in data analysis, leveraging tools such as Power BI, SQL, Python, and Excel to deliver advanced analytics, develop insightful dashboards, and create impactful reports that drive data-informed decisions. This is a fantastic opportunity for a Data Analyst to work with cutting-edge data analytical tools while being part of a dynamic Pension Data team that fosters collaboration, encourages innovation, and supports professional growth.
As a member of this team, you will be responsible for:
Data Collection & Integration
- Collect data from multiple sources, such as databases, APIs, or external systems.
- Integrate data from various sources, ensuring that it’s accurate, consistent, and complete.
- Manage large datasets and ensure the proper storage and retrieval processes are in place.
- Clean and preprocess raw data to remove errors, inconsistencies, or duplicate entries.
- Transform data into a structured format suitable for analysis, applying necessary formatting or aggregation techniques.
- Validate data to ensure its accuracy and integrity before performing analysis.
- Analyze data to identify trends, patterns, and relationships that can provide insights.
- Use statistical methods and predictive models to address business problems and support decision-making.
- Perform descriptive and exploratory analysis to understand key metrics and KPIs.
- Create reports, dashboards, and visualizations to communicate data insights clearly and effectively using Power BI and Excel.
- Automate recurring reports to improve efficiency and ensure timely delivery of insights.
- Present findings to stakeholders with clear, actionable insights through reports and presentations.
- Collaborate with cross-functional teams, including business stakeholders, product teams, and development engineering teams, to understand data requirements and deliver insights.
- Translate complex data into understandable terms for non-technical stakeholders.
- Work closely with team members to define key performance indicators (KPIs) and measurement frameworks.
- Identify opportunities to improve existing data processes and analytical techniques.
- Keep up with the latest trends and best practices in data analysis, visualization, and tools.
- Experiment with new methods and tools to enhance the quality and speed of data analysis.
- Ensure data security, privacy, and compliance with regulations during the collection and analysis process.
- Implement processes for quality control to ensure the accuracy and reliability of data.
- Monitor and audit data sources for consistency and potential issues over time.
- Develop SQL Queries & Conduct ad-hoc analysis to address immediate data requests and to provide urgent data insights.
- Document analysis methods, assumptions, and results for transparency and reproducibility.
- Share insights and learnings with the broader team, contributing to a knowledge-sharing culture.
- Bachelor’s degree in computer engineering, Computer Science, Information Technology, or a related field (or equivalent experience).
- 5 years of hands-on experience in Data analysis, Power BI development and SQL Quary Development.
- Strong proficiency in Power BI, including Power Query, Power BI Service, and Power BI Desktop.
- Expertise in DAX (Data Analysis Expressions) for creating measures, calculated columns and complex DAX expressions.
- Must have experience building semantic data models in Power BI
- Experience working with relational databases and data warehousing concepts.
- Proficiency in SQL and Python for querying and transforming data.
- A team player and motivated self-starter
- Strong problem-solving and critical-thinking skills.
- Experience with Azure Data Services (Azure SQL Database, Azure Data Factory)
- Excellent communication and presentation skills.
- Attention to detail and a commitment to accuracy.
- Ability to manage multiple projects and meet deadlines.
- Strong Understanding of DB Pension Knowledge is an asset.
As one of Canada’s largest defined benefit pension plans, our people-first culture is at its best when our workforce reflects the communities where we live and work — and the members we proudly serve.
From hire to retire, we are an equal opportunity employer committed to an inclusive, barrier-free recruitment and selection process that extends all the way through your employee experience. This sense of belonging and connection is cultivated up, down and across our global organization thanks to our vast network of Employee Resource Groups with executive leader sponsorship, our Purpose@Work committee and employee recognition programs.
- Seniority levelMid-Senior level
- Employment typeFull-time
- Job functionInformation Technology
Referrals increase your chances of interviewing at OMERS by 2x
Mississauga, Ontario, Canada 22 hours ago
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
job faster
