Data Specialist - Insights

Position Title: Data Specialist - Insights
Reports To: Director of Data Practices and Insights
Department: Corporate/Impact
Term: Permanent Full-Time


Work Arrangements: This is a hybrid role. You will work in our office in Waterloo, ON a minimum of two (2) assigned, consecutive days every other week, plus a fifth (5th) assigned day per month. You are welcome to work from the office more than the minimum requirement and there may be some roles that are required to work in our office more than the minimum requirement.


The Opportunity: Equitable is growing! We are looking for a Data Specialist - Insights to join our Corporate/Impact team!

The Data and Insights Specialist is a key role supporting the Director of Data Practices and Insights. The focus of the role is to guide the business in conceptualizing and implementing reporting and BI solutions and projects while leveraging enterprise data capabilities and leading data practices and aligning to the Enterprise Data Strategy.  The individual is a subject matter expert who will partner with Business team members to design, implement, and evolve reporting and BI solutions. They will also provide the coaching, guidance, and influence necessary to enable a high performing and outcome focused cross functional team.

Now is an exciting time to join one of the Waterloo Area’s and Southwestern Ontario’s Top Employers for 2024!     

What you will be doing:

• Data Initiatives and Project Support: Partner with the business, technology, and data teams to support data projects involving the enterprise data platform, reporting, analytics, operations, and digital capabilities. This includes eliciting data requirements, analyzing expectations, aligning to data standards, and recommending robust data practices.
• Data Subject Matter Expertise: Build expertise about data and data flows in the business applications (source systems) and enterprise data platform; share that knowledge with business and technology teams in support of reporting/BI, analytics, and digital initiatives. Ensure a sustainable process is in place to allow this knowledge to be retained and shared for the organization.
• Stakeholder Collaboration and Relationship Management: Build and maintain robust relationships with business and technology stakeholders rooted in strong collaboration and delivery of impact through data advice and reporting/BI solutions.
• Data Practices and Community: Research reporting, insights and BI leading practices and tools; advise business on best approaches to obtain, manage, and visualize/design visualizations of data across the full journey of creating a BI solution. Assist with sustaining a Community of Practice for data and analytics to share learnings and successes, collaborate on issues and initiatives, and elevate the data expertise within the organization.
• Visualization and Reporting/BI solutions: Leverage leading practices to build and evolve reporting / BI solutions for the business using enterprise tools and platforms. This includes assessing and advising on design directions and reporting / BI requirements, analysing and sourcing data, data modelling, designing / implementing visualizations, completing robust documentation, aligning with Data Strategy, Governance & Quality expectations, and guiding the business to utilize the solutions.
• Data Governance Alignment:  Partner with the enterprise Data Governance and Quality team to build and run the processes, policies, and tools to oversee and manage Equitable’s data. Contribute to the collection and maintenance of metadata, identification of appropriate data quality rules, and participate in data issue investigation/resolution as appropriate.
• Performance and Effectiveness: Support with the definition and implementation of key performance indicators (KPIs) and metrics to measure the impact / value from supporting the business with data advisory and insights delivery; provide regular reports / updates to senior management.

 
What you will bring:

• 5+ years of experience with a mix of project management, reporting/BI, business/data analysis, data science, and data governance
• Post-secondary education or equivalent combination of education and experience in the following or related disciplines: Computer Science, Information Systems, Engineering, Business or another relevant field
• Experience with databases / data warehouses, data integration, and data modelling concepts and tools; expertise with data extraction and manipulation using SQL or similar tools (including advanced Excel skills for data analysis); experience using Power platform suite such as Power Apps, Power BI etc. to build reporting / BI visualizations.
• Experience with projects crossing business and technology areas, particularly projects optimizing, reporting on, or managing customer / client data
• Excellent interpersonal and stakeholder management skills, with a proven ability to advise, influence, and collaborate effectively across business partners at different levels.
• Demonstrable track record of working cross-functionally with stakeholders to secure buy-in, creating accepted solutions, and working flexibly to accommodate changing priorities.
• Strong analytical and problem-solving abilities, with meticulous attention to detail and a commitment to continuous improvement; robust prioritization and organizational skills to remain focused on the key outcomes.
• Excellent verbal and written communication skills with the ability to communicate clearly and concisely and present complex / technical concepts simply.
• Analytical mindset and problem-solving approach; focus on bridging the gap between business and technical teams from a data perspective.
• Familiarity with data governance, data management, and data quality processes and techniques; knowledge of coding/programming languages (e.g. Python, Java, C#) is highly desirable
• Experience in Insurance or Financial Services industry is an asset; specifically, familiarity with insurance-specific data models and operational/business processes, with experience in insurance core systems (e.g., policy administration, claims management) is highly desirable.

What’s in it for you:

• A healthy work-life balance with employee wellness top of mind
• Annual bonus program, annual vacation allowance, and company-paid benefits program
• An additional paid volunteer day each year so you can spend time giving back to the community
• Immediate enrollment in the company’s pension program with employer matching
• Employee resource groups that support an inclusive work environment
• Tuition support and specialized program assistance
• An onsite, full-service cafeteria with a variety of daily options
• Discounts on company products and services, and access to exclusive employee perks
• Regular EQ Together events focused on company togetherness and collaboration
  
  

As part of the recruitment/offer process you will be required to:

• Provide two professional references (minimum one supervisor and above)
• Undergo a criminal background check