Data Analyst

Equitable • Waterloo, ON

3d • Hybrid

About The Position

At Equitable, we believe work should be a place where you feel supported, inspired, and empowered to grow. In our caring and collaborative environment, your curiosity is encouraged, your passion is recognized, and your contributions truly matter. Together, we create meaningful impact, for our clients, our communities, and each other. The Opportunity: At Equitable, we believe great things happen when we work together. We’re a Canadian mutual company driven by purpose - putting people first and helping Canadians protect today and prepare for tomorrow. If you’re passionate about making a difference and growing your career in an inclusive and collaborative environment, we’d love to hear from you. Our culture is built on care, passion and curiosity. We put people above all else, strive to be our best and welcome new ideas to deliver positive outcomes. We are looking to add a Data Analyst to our Individual Data Analytics team. The Data Analyst is a role reporting to the AVP, Data Insights & Enablement. They will play a pivotal role in the lifecycle of delivering insights gained from the extraction and analysis of data to improve business processes, supporting the strategy and goals of Equitable’s Individual business. The bulk of the work will be in data collection and integration, data exploration and preparation, management and problem analysis, and data visualization. This includes infrastructure for data presentation (dashboards, BI tooling, ongoing delivery of report, etc.), and the infrastructure for data hygiene. The newly hired data analyst will be a key interface for the Individual business unit. Candidates need to be very much self-driven, curious, and creative. Join one of the region’s top employers and be part of something that truly makes a difference.

Requirements

• 2+ years of experience in data extraction, leveraging SQL and python, querying large data sets from multiple sources
• 2+ years of experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement. in data analysis and presentation of insights
• 2+ years of experience in statistical business analysis
• 2+ years of experience with BI software programs such as Tableau, Qlik, and Microsoft Power BI
• 2+ years of experience with Advanced Excel for analyzing data
• 2+ Experience with object-oriented/object function scripting languages: Python, Java, C#, etc.
• 2+ Experience supporting and working with cross-functional teams in a dynamic environment.
• Post-secondary education in Economics, Business, Finance, Engineering, Statistics, Computer Science or related fields
• Knowledge and experience with displaying complex quantitative data in a simple, intuitive format and to present findings in a clear and concise manner.
• Experience with data modelling and navigating data warehouses;
• Ability to create conceptual, logical and physical data models and diagrams for relational database systems
• Experience with displaying complex data in a simple, intuitive format
• Data standardization
• Mastering data
• Ability to investigate, familiarize and master new data sources quickly
• Familiar with Active Directory, Database Administration and Infrastructure technologies (networking, addressing, storage, SAN/LAN, backups, security, firewalls, rights management).

Responsibilities

• Working closely with the business and technical teams to identify the definition and analysis of how information assets drive business outcomes
• Applying detailed knowledge and hands-on experience of data structures, and data warehousing strategies to contribute to the development and maintenance of business intelligence and reporting tools.
• Document understanding of how data is turned into knowledge to support business decisions and possess a keen understanding of the business environment
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Work with a variety of contextual data sources: Types: Structured and non structured (Image, XML, audio transcription, etc) Domains: Operational, Underwriting, Sales, Web, etc.
• Create deployment pipeline architecture related to Business Intelligence solutions.
• Create and manage data pipelined architecture required for optimal extraction, transformation and loading of data (ETL) from a wide variety of data sources.
• Create and manage utilities and data tools used to support Analytics solutions and Data Science team members.
• Create and manage data models in all their forms including conceptual models, relational database designs, and others.
• Create data artifacts including defining quality requirements, conceptual and physical data models, ETL processes and data views.
• Automation / optimization of existing manual processes
• CI/CD – data operations

Benefits

• Career Growth: Regular learning sessions and development opportunities
• Total Rewards: Incentive pay, annual salary reviews, employer-paid benefits and pension matching
• Time Away: Competitive vacation plus one paid volunteer day each year
• Flexibility: Healthy work-life balance with employee wellness always top of mind, complemented by a “dress for your day” approach
• discretionary annual incentive award tied to business performance
• wide range of competitive benefits

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree