Data Engineer, Insights Analyst

Adept Consulting Services, Inc.

. Design, build, and maintain scalable data pipelines and analytical data environments.

Posted 11/6/2026full-timeRemote • Pennsylvania • United StatesMid-LevelSenior💰 $150,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and maintaining scalable data pipelines and cloud-based data solutions, with a strong focus on data integration, validation, and analytics. Proficient in SQL and experienced in collaborating with cross-functional teams to deliver actionable insights and improve data workflows.

Highest-signal resume keywords

SQL ProficiencyData Pipeline DevelopmentDashboard CreationData Quality ValidationAWS Services Experience

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLData Pipeline DevelopmentData IntegrationData ValidationDashboard CreationAnalytical ModelingData GovernanceStatistical AnalysisPredictive ModelingMachine Learning

Soft Skills

CommunicationCollaborationOrganizational SkillsProblem-SolvingAttention to Detail

Tools & Technologies

AWS S3AWS GlueAWS RedshiftAWS EMRAWS AthenaAWS KinesisAWS LambdaApache AirflowAWS Step Functions

Industry Keywords

Data PipelinesData GovernanceMetadata ManagementSystem MigrationsData Quality

Tech Stack

Tools & technologies

AirflowAmazon RedshiftApacheAWSCloudSQL

About the role

Key responsibilities & impact

Design, build, and maintain scalable data pipelines and analytical data environments.
Integrate, clean, and transform data from multiple systems to meet documented business and technical requirements.
Develop and maintain cloud-based data solutions and orchestration workflows.
Implement data validation, monitoring, logging, and alerts to support reliable data delivery.
Create dashboards, reports, and analytical models that communicate findings clearly to technical and non-technical audiences.
Investigate data issues, identify root causes, and recommend improvements.
Automate manual processes and improve workflow performance, reliability, and scalability.
Collaborate with analysts, data scientists, business leaders, and other stakeholders to develop useful data products.
Support data conversions and migrations associated with system upgrades or replacements.
Maintain documentation for data sources, definitions, structures, workflows, and dependencies.
Handle confidential information in accordance with applicable privacy, security, and data governance requirements.

Requirements

What you’ll need

Proficiency in SQL, including writing complex queries and working with relational databases.
Experience building and maintaining data pipelines and integrating data from multiple sources.
Experience developing dashboards, reports, or analytical tools that answer business questions.
Experience validating data quality and investigating data or workflow issues.
Ability to explain analytical findings and technical concepts to different audiences.
Ability to organize work, communicate priorities, and collaborate across teams.
Ability to handle sensitive information appropriately.
Relevant skills and experience may be demonstrated through employment, education, training, or comparable practical work.
Preferred: Experience with AWS services such as S3, Glue, Redshift, EMR, Athena, Kinesis, or Lambda.
Preferred: Experience with Apache Airflow, AWS Step Functions, or similar orchestration tools.
Preferred: Experience working with large datasets, unstructured data, stream processing, or message queuing.
Preferred: Experience supporting statistical analysis, predictive modeling, or machine learning.
Preferred: Experience with data governance, metadata management, or system migrations.

Benefits

Comp & perks

Health Care Plan (Medical, Dental & Vision)
Retirement Plan (401k)
PTO