Position Title: SeniorData Analyst
Reports To: AVP, Data & Analytics
Department: Individual Product Management
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 to add a Senior Data Analyst to our Individual Product Management team.

The Senior Data Analyst is a role in the Analytics and Insights team, reporting to the AVP, Analytics and Insights. 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 defining the back-end systems for data persistence and usage, 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.

Now is an exciting time to join one of the Waterloo Area's Top Employers for 2024!

What you will be doing:

• Works closely with the business and technical teams to identify the definition and analysis of how information assets drive business outcomes
• Applies detailed knowledge and hands-on experience of data structures, data pipelines, deployment pipelines, data modeling, and data warehousing strategies to contribute to the development and maintenance of business intelligence and reporting tools.
• Documents 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 operational data sources and create intermediary reporting databases as needed:
  • Types: Structured and non structured (Image, XML, audio transcription, etc)
  • Domains: Operational, Underwriting, Sales, Web, etc.
• Creates and manages deployment pipeline architecture and infrastructure related to Business Intelligence solutions.
• Creates and manages data pipelined architecture and infrastructure required for optimal extraction, transformation and loading of data (ETL) from a wide variety of data sources.
• Creates and manages utilities and data tools used to support Analytics solutions and Data Science team members.
• Creates and manages data models in all their forms including conceptual models, relational database designs, and others.
• Creates 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 ops

What you will bring:

• 5+ years of experience in data extraction, leveraging SQL and python, querying large data sets from multiple sources
• 5+ 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
• 5+ years of experience in statistical business analysis
• 5+ years of experience with BI software programs such as Tableau, Qlik, and Microsoft Power BI
• 3+ years of experience building and optimizing data pipelines, data architectures and data sets.
• 5+ years of experience with Advanced Excel for analyzing data
• 5+ Experience with object-oriented/object function scripting languages: Python, Java, C#, etc.
• 5+ 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
• Experience in deploying data pipelines - manually and automated
• Experience in infrastructure / back end tool support
• 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)

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
• A company subsidized 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

To learn more about Equitable, we encourage you to explore our organization.
At Equitable, we are committed to providing equal access to employment opportunities across our organization. Please contact our HR team at careers@equitable.ca if you would like to receive our job postings in an alternative format or require an accommodation with the application process.
#LI-Hybrid