Taro Logo

ETL Solutions Designer/Architect (Data Engineer)

Global financial services and insurance company helping clients achieve lifetime financial security and live healthier lives.
$78,000 - $128,000
Data
Senior Software Engineer
Hybrid
5,000+ Employees
5+ years of experience
Finance

Description For ETL Solutions Designer/Architect (Data Engineer)

Sun Life, a leading global financial services and insurance company, is seeking a Senior Data Engineer - Solutions Designer/Architect to join their Data Engineering and Operations team. This role offers an exciting opportunity to work with cutting-edge data technologies while making a meaningful impact on the organization's data-driven decision-making processes.

The position involves designing and implementing sophisticated data pipelines using modern technologies like AWS Glue, Kafka, and Step Functions. As a senior member of the team, you'll not only be hands-on with technical work but also guide and mentor other data engineers, ensuring best practices in ETL development and data sourcing.

The ideal candidate brings 5-10 years of experience in ETL design and development, with strong expertise in Python, SQL, and various AWS services. You'll work in a collaborative environment with cross-functional teams, turning complex data challenges into actionable solutions while maintaining high standards for data quality and security.

Sun Life offers a competitive salary range of $78,000-$128,000, along with comprehensive benefits including wellness programs and hybrid work arrangements. The company is recognized as a Best Workplace in Ontario and has received the Canada Order of Excellence for Mental Health at Work®, demonstrating their commitment to employee well-being.

This role presents an excellent opportunity for a seasoned data professional looking to make a significant impact while working with a diverse team in a supportive, inclusive environment. You'll be part of a global organization of 30,000 employees across 26 countries, helping to drive transformation and innovation in financial services and insurance.

Last updated 4 hours ago

Responsibilities For ETL Solutions Designer/Architect (Data Engineer)

  • Design, develop, and maintain scalable data pipelines using AWS Glue, Kafka, and Step Functions
  • Implement and optimize ETL processes using tools like SSIS, Informatica, or Talend
  • Guide and mentor Data Engineers on best practices for ETL development and data sourcing
  • Create and maintain data models to support business intelligence and analytics initiatives
  • Collaborate with cross-functional teams to understand data requirements and deliver solutions
  • Ensure data quality, security, and compliance with industry standards and regulations
  • Troubleshoot data-related issues and implement solutions

Requirements For ETL Solutions Designer/Architect (Data Engineer)

Python
Kafka
  • Bachelor's degree in computer science, Information Technology, or related field
  • 5-10 years of experience in ETL design, modeling, and development
  • Strong proficiency in SQL and Python programming
  • Experience with AWS services, particularly Glue, Step Functions
  • Expertise in data warehousing concepts and methodologies
  • Proficiency in ETL tools (e.g., Informatica, Talend, SSIS)
  • Experience with various database systems and data formats
  • Familiarity with Kafka and stream processing concepts
  • Experience with big data technologies such as Hadoop, Spark, or Hive
  • Knowledge of data visualization tools (e.g., Tableau, Power BI)
  • AWS certifications (preferred)
  • Strong communication and leadership abilities

Benefits For ETL Solutions Designer/Architect (Data Engineer)

Medical Insurance
Mental Health Assistance
  • Wellness programs supporting mental, physical, and financial health
  • Career development opportunities
  • Hybrid work model
  • Incentive plans
  • Comprehensive benefits package

Jobs Related To Sun Life ETL Solutions Designer/Architect (Data Engineer)