BI & Data Analyst (12 Months Contract)

OMERS•Toronto, ON

1d•CA$72,000 - CA$108,000•Hybrid

About The Position

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.

Requirements

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.
Technical expertise in data mining and analysis, with an understanding of financial reporting concepts.
Demonstrate strong problem-solving skills and innovative approaches for resolution.

Nice To Haves

Experience with other BI Tools and VBA would be an asset.

Responsibilities

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