Senior Data Engineer: Data Pipelines, ETL & AWS

Dynamo Technologies LLC; Northern (KY); Hybrid; USD 100,000 - 125,000; Full time

Job summary

Dynamo Technologies LLC is seeking a Senior Data Engineer to support the Consumer Financial Protection Bureau (CFPB). The role focuses on data engineering, data operations, data quality, analytics, and data management, designing, developing, and maintaining pipelines and data warehouse solutions.

The candidate should have hands-on experience with Python or R, complex SQL, enterprise databases, Linux/UNIX and Windows environments, and cloud-based data environments (AWS).

Qualifications

• Bachelor's degree or higher in Information Systems, Computer Science, Data Science, Mathematics, Statistics, Operations Management, Engineering, or related field.
• Six years of relevant professional experience supporting data engineering, data operations, data quality, or data analytics.

Responsibilities

• Design, develop, maintain, and troubleshoot data pipelines and data products supporting enterprise analytics and reporting.
• Develop and maintain ETL processes to extract, transform, cleanse, validate, and load data from multiple sources.
• Use Python or R to support data analytics, data operations, automation, backend development, and data pipeline activities.
• Write, optimize, and troubleshoot complex SQL queries using enterprise databases such as PostgreSQL and Microsoft SQL Server.
• Develop and maintain data warehouse solutions, including data structures, transformations, and operational processes.
• Support data quality initiatives by identifying data issues, performing root cause analysis, and implementing solutions to improve data accuracy.
• Monitor and troubleshoot data pipelines, ETL processes, databases, and other data operations to ensure reliable data delivery.
• Develop database stored procedures, functions, and other database objects to support data processing and application requirements.
• Support data integration efforts across enterprise applications and data sources.
• Collaborate with developers, analysts, business stakeholders, and other technical teams throughout the software and data development lifecycle.

Skills

Python or R

PostgreSQL or MS SQL Server

ETL pipelines

Data warehouse development

Linux/UNIX and Windows

DevOps for data projects

Data operations troubleshooting

Analytical thinking

Requirements gathering

Collaborative teamwork

Education

Bachelor's degree or higher in a technical field

Tools

AWS

Salesforce data integrations

Job description

Dynamo Technologies LLC is seeking a Senior Data Engineer to support the Consumer Financial Protection Bureau (CFPB). The role focuses on data engineering, data operations, data quality, analytics, and data management, designing, developing, and maintaining pipelines and data warehouse solutions.

The candidate should have hands-on experience with Python or R, complex SQL, enterprise databases, Linux/UNIX and Windows environments, and cloud-based data environments (AWS).