Senior Data Engineer

Compunnel, Inc.; Merrimack (NH); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading tech company is seeking a Senior Data Engineer in Merrimack, New Hampshire. The role involves designing ETL solutions and integrating data using cloud technologies. Candidates must have over 6 years of data engineering experience, proficiency in Python and SQL, and AWS services expertise. Strong communication skills are essential. This high-exposure position offers opportunities to mentor junior engineers and collaborate with major clients.

Qualifications

• 6+ years of experience in data engineering.
• Heavy SQL experience for analysis and validation.
• Strong debugging and production support skills.

Responsibilities

• Design and develop ETL reporting and analytics solutions.
• Implement innovative data integration solutions using cloud technologies.
• Collaborate with Data Architects, Business Analysts, and Solution Architects.

Skills

Python for ETL batch jobs

SQL for data analysis

AWS services proficiency

Data warehousing methodologies

Debugging and production support

Excellent communication skills

Education

Bachelor’s degree in Computer Science or related field

Tools

AWS (IAM, EC2, S3, Lambda, RDS)

Postgres database

DevOps, CI/CD tools (Maven, Jenkins, Docker)

Job description

We are Seeking a Senior Data Engineer to support data needs for institutional advisor services, including portfolio construction, model management, and funds comparison. This is a high-exposure role working with major clients, requiring strong communication skills and expertise in data engineering, ETL processes, and cloud technologies.

Key Responsibilities:

• Design and develop ETL reporting and analytics solutions.
• Implement innovative data integration solutions using cloud and traditional infrastructure technologies.
• Move data through various stages into target databases (Postgres).
• Support production debugging and processing of vendor data.
• Collaborate with Data Architects, Business Analysts, and Solution Architects for end-to-end development activities.
• Create, update, and maintain technical documentation for software-based projects.
• Solve production issues and provide ongoing support.
• Participate in architecture, technical design, and product implementation discussions.
• Work in Agile environment based on JIRA stories.
• Mentor junior data engineers and assist in technical guidance.

Required Qualifications:

• Bachelor’s degree in Computer Science or related field (preferred).
• 6+ years of experience in data engineering.
• Strong experience with Python for ETL batch jobs.
• Heavy SQL experience for data analysis, validation, and querying.
• Proficiency with AWS services (IAM, EC2, S3, Lambda, RDS).
• Experience with Postgres database.
• Advanced knowledge of data warehousing methodologies and concepts.
• Familiarity with DevOps, CI/CD tools (Maven, Jenkins, Docker).
• Strong debugging and production support skills.
• Excellent interpersonal and communication skills.
• Ability to work with global Agile teams and mentor peers.

Preferred Qualifications:

• Experience with Snowflake.
• Java for API development (training can be provided).
• Asset management domain knowledge.
• Experience with ETL tools (Informatica, Snaplogic).
• Working knowledge of Unix/Linux and shell scripting.