Data Engineer

ProSearch; Portsmouth (NH); Hybrid; USD 90,000 - 130,000; Full time

Job summary

ProSearch in Portsmouth, NH is seeking a Data Engineer to build, maintain, and optimize data integrations, pipelines, and cloud-based data solutions. This role focuses on turning raw data into reliable assets that support reporting, analytics, and informed business decisions.

The ideal candidate will have hands-on experience with AWS data services, ETL development, SQL and database design, and data migration, enjoy solving complex data challenges, and thrive in a hybrid in-office setting in

Qualifications

• Experience as a Data Engineer or similar role with ETL and data integration.
• Experience with large-scale data migration and transformation projects.
• Strong experience with AWS-based data platforms and services.
• Advanced SQL and database development skills.
• Experience building and maintaining ETL and data integration solutions.

Responsibilities

• Build and maintain data integrations across multiple systems.
• Develop and support ETL processes and data pipelines.
• Execute data migration projects involving large datasets.
• Extract, transform, cleanse, validate, and load data from various sources.
• Design and maintain data marts for reporting and analytics.
• Partner with stakeholders to understand data requirements and improve data accessibility.
• Monitor and troubleshoot data workflows and integration processes.
• Optimize SQL queries, stored procedures, and database performance.
• Support data quality, accuracy, and governance initiatives.

Skills

AWS Data Services

ETL Development

SQL & Database Development

Data Migration

Data Integration

Snowflake

Microsoft SQL Server

Tools

AWS Glue

AWS Lambda

Amazon S3

Amazon EC2

Amazon Redshift

Amazon Athena

AWS CloudWatch

AWS Database Migration Service

AWS IAM

Microsoft SQL Server

Snowflake

Job description

We're seeking a Data Engineer near Portsmouth, NH, to help build, maintain, and optimize data integrations, data pipelines, and cloud-based data solutions. This role is ideal for someone who enjoys solving complex data challenges, improving data quality, and transforming raw data into reliable assets that support reporting, analytics, and business decision-making.

Top Skills Needed

• AWS Data Services
• ETL Development
• SQL & Database Development
• Data Migration
• Data Integration
• Snowflake
• Microsoft SQL Server

What You'll Do

• Build and maintain data integrations across multiple systems
• Develop and support ETL processes and data pipelines
• Execute data migration projects involving large and complex datasets
• Extract, transform, cleanse, validate, and load data from various sources
• Design and maintain data marts for reporting and analytics
• Partner with stakeholders to understand data requirements and improve data accessibility
• Monitor and troubleshoot data workflows and integration processes
• Optimize SQL queries, stored procedures, and database performance
• Support data quality, accuracy, and governance initiatives

Qualifications

Required

• Experience as a Data Engineer, ETL Developer, Data Integration Engineer, Database Developer, or similar role
• Experience with large-scale data migration and transformation projects
• Strong experience with AWS-based data platforms and services
• Advanced SQL and database development skills
• Experience building and maintaining ETL and data integration solutions
• Strong analytical and problem‑solving abilities
• Experience working with structured and unstructured data
• In‑office and on‑site in Portsmouth, NH when needed

Technologies

• AWS Glue
• AWS Lambda
• Amazon S3
• Amazon EC2
• Amazon Redshift
• Amazon Athena
• AWS CloudWatch
• AWS Database Migration Service (DMS)
• AWS IAM
• Microsoft SQL Server
• Snowflake

Preferred

• Experience migrating on‑premises applications to cloud environments
• Experience supporting modern data architectures

Why This Opportunity Stands Out

• Hybrid schedule in the Portsmouth, NH area
• Opportunity to work with modern AWS data technologies
• Hands‑on involvement in data migration, ETL, and cloud data initiatives
• Exposure to Snowflake, Redshift, PostgreSQL, and SQL Server environments
• Meaningful technical work with visible impact on analytics and reporting capabilities