Position Title: Senior Technology Specialist - Data Developer/Modeler

Reports To: Senior Technology Manager, Data Delivery

Department: Data & Integration Platform
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: Now is an exciting time to join Equitable Life! We are growing and looking to add a Senior Technology Specialist - Data Developer/Modeler to our Technology team.

We are looking for a highly motivated Data Developer/Modeler to join Equitable's Technology team. The role will contribute to Equitable's Data Hub architecture vision by establishing and executing on the EQ Datahub framework within the Microsoft Azure Cloud platform, using best practices and industry standards. As a Data Developer/Modeler, you will play a pivotal role in designing, implementing, and optimizing data models that underpin our applications and systems. You'll collaborate with cross-functional teams, analyze business requirements, and create robust data structures. If you're passionate about data architecture, have a keen eye for detail, and enjoy solving complex puzzles, we'd love to hear from you! You will look for direction from the Team Leader.

As a mutual-owned company, our focus is completely on our clients. With today's clients, we know to be nimble and responsive to our clients' needs to help us reach our growth targets. Through our adoption of agile values and principles, we are on a journey to continue offering the best service in the industry, as recommended by advisors, and bring on new experiences to help improve the financial health and security of our clients. As a team we'll discover the right solutions and be on a constant journey of learning while bringing our skills, experience, and ideas together.

The Data Developer/Modeler will collaborate with the Architects, DevOps members and team members to define target state data solutions. We are an organization that values diverse thinking, rewards both behaviors and delivery, and focuses on growth and continuous improvement. This role is a unique opportunity to join a team that is at the beginning of a multi-year growth plan whose work will have direct impact on company direction, our customers, and our industry.

Come join one of the Waterloo Area and Southwestern Ontario's Top Employers for 2024!

What you will be doing:

• Understand our business intelligence strategies and roadmaps and ensure your contributions align with the organization's goals and objectives.
• Design and implement data models, data warehouses using Microsoft Azure technologies.
• Translate business requirements into conceptual, logical, and physical data models.
• Collaborate with data architects, analysts, and developers to ensure data models align with business goals.
• Evaluate existing data systems and propose improvements.
• Define naming conventions, data types, and relationships.
• Create data flow diagrams and maintain data dictionaries.
• Troubleshoot and optimize data models for performance.
• Ensure compliance with industry standards and best practices.
• Participate in data governance initiatives.
• Analyze and interpret data to identify trends, patterns, anomalies, and opportunities for improvement.
• Communicate and present data insights and recommendations to senior team members in a clear and compelling way.
• Stay updated on the latest trends and best practices in business intelligence and data analytics.
• Analyzing existing BI solutions and meet with team members to discuss transition plan to Microsoft Azure/PowerBI.
• Being transparent with the team about challenges, failures, and successes.
• Supporting the production environment and the daily/monthly batch processes
• You'll work with various Azure data storage options, including Azure SQL Database, Azure Data Lake Storage, and Azure Blob Storage.
• You'll develop and implement data integration processes using tools like Azure Data Factory.
• You'll create data processing workflows and pipelines to support data analytics and operational reporting.
• Building and managing data pipelines, design and maintain documentation for data models, database schemas, and SQL code.

What you will bring:

• Bachelor's degree in Computer Science, Information Technology, Statistics, Mathematics, or a related field.
• Minimum of 3-5 years of hands-on experience in data modeling, or a similar role
• Proficiency in SQL and other data query languages.
• Proficiency in relational database management systems (RDBMS).
• Strong knowledge of SQL and data modeling tools.
• Knowledge of Microsoft Azure cloud resources.
• Experience in data modeling, data warehousing, ETL, and data visualization techniques.
• Strong analytical and problem-solving skills, with the ability to translate complex data into actionable insights.
• Excellent communication and presentation skills, with the ability to explain technical concepts to non-technical audiences.
• Ability to work independently and collaboratively in a fast-paced and dynamic environment.
• Experience with metadata management is a plus.
• Certifications in data modeling (e.g., CDMP) are 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

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