Choose a workplace that empowers your impact.
Know someone at OMERS or Oxford Properties?
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.
- Data Cleaning and Preprocessing
- 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.
Data Analysis \& Interpretation
- 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.
- Reporting \& Visualization
- 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.
Collaboration \& Communication
- 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.
Continuous Learning and Improvement
- 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.
Data Governance \& Quality Assurance
- 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.
- Ad-Hoc SQL Query Development \& Analysis
- Develop SQL Queries \& Conduct ad-hoc analysis to address immediate data requests and to provide urgent data insights.
Documentation \& Knowledge Sharing
- Document analysis methods, assumptions, and results for transparency and reproducibility.
- Share insights and learnings with the broader team, contributing to a knowledge-sharing culture.
To Succeed In This Role, You Have
- 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 Query 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.
We believe that time together in the office is important for OMERS and Oxford, the strength of our employees, and the work we do for our pension members. In delivering on our pension promise, keeping us connected to our work and each other, our flexible hybrid work guideline requires teams to come in to the office 1 days per week
