Principal Data Engineer

Compunnel, Inc.; Smithfield (RI); On-site; USD 120,000 - 160,000; Full time

Job summary

A leading technology firm is seeking a Principal Data Engineer to lead data engineering efforts for a strategic initiative. The ideal candidate will have extensive experience in data platforms, cloud technologies, and developing scalable data solutions. Responsibilities include designing data infrastructure, developing ELT/ETL pipelines, and collaborating with cross-functional teams. This role offers a challenging environment focused on innovation and continuous improvement.

Qualifications

• 10+ years of experience in data engineering or related roles.
• 6+ years of experience in data warehousing and data mart implementations.
• 4+ years of experience developing ELT/ETL pipelines for Snowflake.

Responsibilities

• Lead solution design, data analysis, and implementation of scalable data infrastructure.
• Develop ELT/ETL pipelines to support data movement and transformation.
• Collaborate with cross-functional teams to integrate client hierarchies and segmentation rules.

Skills

Data Engineering

Cloud Technologies

Python

SQL

DevOps

Container Technologies

Education

Bachelor’s or Master’s degree in Computer Science, Engineering, or related field

Tools

Snowflake

AWS (EC2, IAM, S3, EKS, KMS, CloudWatch, CloudFormation)

Control-M

Docker

Kubernetes

Job description

We are seeking a highly skilled and motivated Principal Data Engineer to join the Institutional Business Enablement Technology data squad.

This role will lead data engineering efforts for a strategic Territory Management Conversion and Client Infrastructure initiative, supporting streamlined sales segmentation models.

The ideal candidate will bring deep expertise in data platforms, cloud technologies, and modern data engineering practices, with a passion for solving complex problems through collaboration and innovation.

Key Responsibilities

• Lead solution design, data analysis, and implementation of scalable data infrastructure using Snowflake, AWS, and Python.
• Develop ELT/ETL pipelines to support data movement and transformation across platforms.
• Collaborate with CRM Sales and cross-functional teams to integrate client hierarchies, territory logic, and segmentation rules.
• Support testing, production rollout, and quality execution of data initiatives.
• Optimize SQL queries and data ingestion performance.
• Contribute to DevOps practices including CI/CD pipeline setup and automation.
• Participate in Agile ceremonies and promote cloud-first methodologies.
• Mentor team members and foster a culture of continuous improvement and innovation.

Required Qualifications

• Bachelor’s or Master’s degree in Computer Science, Engineering, or related field.
• 10+ years of experience in data engineering or related roles.
• 6+ years of experience in data warehousing and data mart implementations.
• 4+ years of experience developing ELT/ETL pipelines for Snowflake.
• 4+ years of experience with AWS services (EC2, IAM, S3, EKS, KMS, CloudWatch, CloudFormation).
• Strong programming skills in Python or Java.
• Proficiency in SQL and experience with query optimization.
• Experience with job scheduling tools (Control-M preferred).
• Strong data modeling skills (Dimensional or Data Vault).
• Experience with container technologies (Docker, Kubernetes).
• Familiarity with DevOps tools (Maven, Jenkins, Stash, Ansible).
• Experience working in Agile environments (Kanban, Scrum).
• Excellent interpersonal, analytical, and problem-solving skills.

Preferred Qualifications

• Advanced SQL/Snow SQL knowledge.
• Experience in CRM data integration and territory management.
• Background in financial services or enterprise data platforms.