OMERS Administration Corporation

BI & Data Analyst (12 Months Contract)

Finance & Insurance
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Undergraduate degree in Accounting, Mathematics, Computer Science, or related field
  • 3+ years of experience as a Data Analyst or BI Data Analyst
  • Strong communication skills for engaging with diverse organizational groups
  • Able to thrive in dynamic environments and adapt to evolving requirements
  • Proficient in project management with the ability to prioritize competing deadlines
  • Willingness to learn new technologies like RPA and continuously seek efficiency improvements
  • Experience with Power BI, SQL, advanced Excel, and familiarity with BI Tools and VBA is an asset.

Responsibilities

  • Collaborate with management to prioritize analytics and information needs
  • Analyze financial and operational data from various stakeholder teams
  • Identify efficiencies and drive process improvements for reporting automation
  • Interpret and report on trends from complex data sets
  • Explore large data sets to extract and present meaningful insights and KPIs
  • Clean and troubleshoot data issues while adhering to data governance policies
  • Prepare materials for executive-level discussions.

Benefits

  • Eligible for an annual Incentive Award under the Short-term and Long-term Incentive plans
  • Participation in group benefits and retirement plans
  • Flexible hybrid work guideline requires in-office attendance 4 days a week.
  • Emphasis on collaboration and connectivity within the team.
Full Job Description
The Analyst, Business Intelligence acts as a business partner to our finance stakeholders, performing data analysis using a wide variety of applications (including Power BI and SQL), and driving automation effort. To succeed in this role, candidates must be able to drive project completion with strong communication and project management, combined with experience in data analytics, big data mining, and data flow and structure. This role will require effective customer service management, with a proven ability to build relationships between the business groups, financial team and IT department, while being able to multitask in a complex environment. As a member of this team, you will: - Collaborate with management teams to prioritize business, analytics and information needs and understand project requirements - Work with financial and operational data from primary or secondary data sources from different stakeholder teams and business functions - Seek efficiencies in existing processes and execute process improvement initiatives, including exploring and identifying potential new tools and technologies for enhancing reporting automation capabilities - Identify, analyze, interpret, and report on trends or patterns in complex data sets - Exploring large data sets and drawing meaningful conclusions and insights, including identifying critical metrics and KPIs - Filter and "clean" data by reviewing extracts, reports, printouts, and performance indicators to identify, troubleshoot and resolve problems, including data quality, integrity issues and follow data governance policies - Assist with the preparation and development of reporting, presentations and various materials for discussion at the executive level To succeed in this role, you have: - Undergraduate degree in Accounting, Mathematics, Computer Science or a related field. - Have a minimum of 3+ years of demonstrated experience in a similar role (e.g. Data Analyst or BI Data Analyst). - Team oriented individual with strong communication skills, who is comfortable engaging with different groups within the organization (including non-technical audiences). - Thrives in dynamic environments by adapting to evolving requirements and refining approaches as new information emerges, even when processes are not fully defined. - Strong project management and organizational skills and ability to work under pressure and manage high priority projects with multiple or competing deadlines. - Willingness to learn new technologies, including RPA, with a strong inclination to improve processes and not settle for 'status quo' to generate efficiencies and improve capabilities. - Experience with Power BI, SQL, and advanced Excel functionality (including Power Query) to develop automation solutions. Experience with other BI Tools and VBA would be an asset. - Technical expertise in data mining and analysis, with an understanding of financial reporting concepts. - Demonstrate strong problem-solving skills and innovative approaches for resolution. 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 4 days per week. This posting is for an existing vacancy. The expected salary range for this position is $72,000.00 - $108,000.00 per year, prorated based on the term of the contract. You may also be eligible to receive an annual Incentive Award pursuant to our Short-term Incentive plan and our Long-Term Incentive plan (if applicable), and to participate in our group benefits and retirement plans - details on these elements of compensation are included within OMERS & Oxford offer letters.

About OMERS Administration Corporation

OMERS Administration Corporation is a Canadian pension fund that manages investments for the Ontario Municipal Employees Retirement System (OMERS). OMERS is one of Canada's largest pension funds, with over 500,000 members and over CAD 100 billion in net assets. OMERS Administration Corporation manages a diversified portfolio of investments across various asset classes, including public equity, private equity, infrastructure, real estate, and fixed income. The company's mission is to provide secure and sustainable pensions to its members while generating returns that help fund their pensions. OMERS Administration Corporation is headquartered in Toronto, Canada.
Learn more about OMERS Administration Corporation
Size
2,700 employees
Industry

Similar Jobs

More Jobs at OMERS Administration Corporation

More Finance & Insurance Jobs

Find similar BI & Data Analyst (12 Months Contract) jobs: