Senior Technology Specialist, Data Developer

Position Title: Senior Technology Specialist, Data Developer 

Reports To: Lead Technology Manager, Data Platforms

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 to our Technology team.

We are looking for a highly motivated Data Developer to join Equitable's Technology team. A team player who will collaborate closely with cross-functional teams to understand business requirements and translate them into scalable data solutions using Azure Synapse Analytics and other relevant technologies. Also, modernize the existing data pipelines from SQL server to Azure Synapse Analytics.

What you will be doing:

• Building Data Pipelines: Design, develop, and maintain data pipelines and ETL processes using Azure Synapse data pipelines and modernize existing SQL Server on prem data sources to ensure efficient data ingestion, transformation, and loading.
• Hands on Knowledge on API’s and Azure APIM, how API’s are interacting with APIM to access the backend API’s
• DevOps: Implement CI/CD pipelines and automation scripts for deploying, testing, and monitoring data solutions in collaboration with the DevOps team.
• Security and Compliance: Ensure data security, integrity, and compliance with regulatory standards by implementing appropriate access controls and encryption mechanisms.
• Performance Optimization: Perform performance tuning and optimization of data solutions to meet SLAs and scalability requirements.
• Communication: Effectively communicate complex findings and insights to both technical and non-technical stakeholders. Prepare and deliver presentations to convey the value of data initiatives.
• Stay Current: Stay updated with the latest advancements in Azure Synapse Analytics, SQL Server, and other relevant technologies, and provide recommendations for adopting new tools and techniques.
• Participate in on-call rotation 

What you will bring:

• Bachelor’s or master’s degree in computer science, Engineering, or a related field.
• 5+ years of experience working as a Data Engineer or similar role.
• Proficiency in programming languages such as Pyspark Python, and SQL.
• Hands-on experience with Azure Synapse Analytics, including Azure SQL Data Warehouse and Azure Data Lake Storage.
• Proficiency in SQL programming and database design principles, with expertise in SQL Server ANSI-SQL and T-SQL.
• Strong understanding of ETL processes and tools.
• Experience in developing and maintaining interactive reports and dashboards.
• Familiarity with Continuous Integration/Continuous Deployment (CI/CD) practices and tools, such as Azure DevOps or Jenkins.
• Excellent problem-solving skills and ability to troubleshoot complex data issues.
• Strong communication skills with the ability to explain complex concepts to both technical and non-technical audiences.

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