Principal/Lead Data Integration Specialist

Company: CAGC

Service: Business Intelligence

Job Categories: Full-time permanent position

Work Model: Hybrid (2 days in the office)

Language: English is required and French is an asset.

The Opportunity:

We are a leading Canadian cooperative financial services company committed to actively promoting a sustainable and resilient society, and our team is essential to the success of this strategy. That’s why our people are our priority. We offer a vibrant company culture and opportunities for development that allow our team to realize their full potential and achieve our purpose. And the best part: you’ll work with people who truly care about you, our clients, and our communities.

Advanced science and analytics are at the heart of our business intelligence team’s decision-making. We promote a scientific culture through our passion for continuous learning, diversity, and innovation. We strive to present only one version of the truth by providing our business partners with comprehensive data and valuable insights to help our organization achieve operational excellence.

As a Principal/Lead Data Integration Specialist, you will autonomously contribute to various initiatives by creating data engineering solutions for analytical purposes while supporting your team. You are responsible for delivering operational value by creating, maintaining, and implementing downstream data solutions (e.g., ingestion, transformation, and databases) throughout the software development lifecycle and effectively communicating said value to business stakeholders.

How You Create Impact:

• Work efficiently with data engineering tools: general-purpose languages used in data engineering or business intelligence and related frameworks or interfaces, data collection and processing, and development and operations platforms.
• Debug, analyze, and resolve complex database and SQL-related issues to ensure optimal performance and stability.
• Investigate, troubleshoot, and analyze the root causes of SQL performance issues and data discrepancies.
• Contribute autonomously to data quality assessment and the design of automated controls.
• Define and build data solutions (data model, data pipelines, APIs, etc.) and support others in their execution.
• Mentor and support team members by sharing technical expertise, development best practices, and industry standards.
• Develop analytical solutions effectively to address business problems by understanding the role of data in reports, metrics, predictive models, and other analytical solutions within the business intelligence environment.
• Contribute to the design of analytical solutions considering scalability, automation, security, long-term maintainability, and performance.
• Apply and promote software development lifecycle (SDLC) practices, including code reviews, testing, deployment standards, solution monitoring, and operational support.
• Thoroughly understand the insurance domain (metrics, ICP, key concepts), operational objectives, and how your tasks contribute to achieving business objectives and their links to them.
• Communicate conclusions autonomously and effectively to business stakeholders.
• To Join Our Team:
• You have 4 to 7 years of experience in data engineering/integration or a related field.
• You hold a bachelor’s degree in computer science or a related field.
• You have experience in solving complex problems by adopting a fresh perspective on existing solutions, demonstrating judgment based on the analysis of multiple information sources, and formulating clear recommendations for improvement.
• You have excellent knowledge and understanding of data analysis, programming, modeling techniques, data warehousing, data management, research, architecture, and design.
• You possess strong knowledge of the following areas: data engineering and integration, data modeling techniques, data warehousing, data management and governance, and SDLC practices.
• You have hands-on experience in developing and supporting enterprise data solutions using modern cloud technologies such as SQL, Python, Azure Synapse Analytics, Azure Data Lake Storage (ADLS), GitHub, and/or Azure DevOps.
• Experience with the following technologies is considered an asset: Databricks, Apache Spark / PySpark, Delta Lake, Microsoft Fabric, and Power BI.
• You have experience in designing and implementing logical and physical data models for analytical and operational reporting solutions.
• The person in this role primarily works with non-French-speaking groups and teams outside Quebec. Therefore, English proficiency is mandatory. Essential tasks requiring knowledge of a language other than French cannot be reassigned to other team members.
• How You Stand Out:
• You leverage your innovative mindset to improve operational efficiency and have the ability to influence change, prioritizing customer needs.
• You demonstrate critical thinking to recognize assumptions, evaluate arguments, draw conclusions, and propose solutions proactively.
• You possess strong communication skills to clearly convey messages and explore different perspectives.
• You build trust and advise colleagues to foster their development.

What You Need to Know

• If your application is selected, we will conduct a credit check and criminal record check as a condition of employment.
• How You Benefit:
• Opportunities for training and development to build your career.
• Flexible work schedule and paid time off to meet your needs and those of your family.
• Holistic approach to your well-being, physical and mental health programs, and workplace solidarity culture.
• Paid volunteer days to give back to your community.
• In addition to our competitive salaries and incentive programs, eligible employees also benefit from a comprehensive total rewards program, including collective pension plans and group insurance (e.g., medical benefits, well-being, dental care, disability, and life insurance), mental health support, and an employee assistance program.

Expected Salary Range: $83,774 - $133,700+ (minimum and maximum, full scale).

The salary of the selected candidate is determined by Co-operators at its discretion and varies based on several factors, including: local market conditions, geographic region, and relevant factors related to the position, such as knowledge, skills, abilities, experience, and training.

Employees may also have the opportunity to participate in incentive programs and earn additional compensation based on individual or company performance, or other business measures.