Senior Data Engineer

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

Where Passion, Growth, and Success Come Together

Why a Career at Dynamo?

At Dynamo, we don’t just offer technology company jobs—we build careers. We’re passionate about bringing together driven, collaborative professionals who thrive on solving challenges and making an impact. When you join our team, your growth becomes our priority. From tailored professional development plans to mentorship opportunities, we invest in equipping you with the skills and knowledge needed to excel in your role and beyond.

Our culture is built on trust, inclusivity, and camaraderie—we’re more than colleagues; we’re a family. Through team-building events, community service initiatives, and a commitment to work-life balance, we create an environment where every team member feels valued and supported.

At Dynamo, we believe exceptional work deserves exceptional rewards. That’s why we offer a competitive benefits package that supports your well-being, financial health, and professional ambitions:

• 100% Paid Medical Benefits and Disability Insurance Coverage
• Health Savings Account (H.S.A.)
• 401K with Company Match
• Tuition Reimbursement for continued learning
• Monthly Commuting Stipends
• Generous Paid Time Off (PTO) and Holidays
• A collaborative, growth-focused workplace culture

When you join Dynamo, you’re not just taking a job—you’re becoming part of a team that’s reshaping the future with bold ideas, innovative solutions, and a shared commitment to excellence.

Your future is bright at Dynamo—come grow with us.

When you join Dynamo, you don’t just become another number, you become part of a family. A family who thrives to keep morale high and opportunities endless.

Dynamo Technologies LLC is seeking a Senior Data Engineer to support the Consumer Financial Protection Bureau (CFPB). The selected candidate will provide technical expertise in data engineering, data operations, data quality, analytics, and data management. This role will support the design, development, operation, and maintenance of data pipelines, data products, ETL processes, and data warehouse solutions in support of CFPB mission requirements.

The ideal candidate will have strong hands-on experience with Python or R, complex SQL development, enterprise databases, Linux/UNIX environments, and data engineering practices. Experience supporting cloud-based data environments, particularly Amazon Web Services (AWS), is highly desirable.

Duties/ 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, consistency, and reliability.
• Monitor and troubleshoot data pipelines, ETL processes, databases, and other data operations to ensure reliable and timely 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.
• Work in Linux/UNIX and Windows server environments to support data operations, application deployments, and troubleshooting.
• Apply DevOps principles and practices to data engineering and application development processes.
• Collaborate with stakeholders to gather requirements, analyze business processes, and translate mission needs into scalable technical data solutions.
• Support the development and maintenance of web applications and other technical solutions that enable data analytics and data-driven decision-making.
• Support integration and analysis of Salesforce data and other enterprise data sources.
• Document data processes, technical requirements, data flows, pipelines, and operational procedures.
• Identify opportunities to improve data engineering processes, automation, performance, and reliability.
• Collaborate with developers, analysts, business stakeholders, and other technical teams throughout the software and data development lifecycle.

Required Skills/Abilities:

• Hands-on professional experience with Python or R for data analytics, data operations, automation, backend development, or data pipeline development.
• Strong proficiency writing and optimizing complex SQL queries using enterprise databases such as PostgreSQL or Microsoft SQL Server.
• Experience developing and supporting ETL processes and data pipelines.
• Experience with data warehouse development and operations.
• Experience working in both Linux/UNIX and Windows environments.
• Knowledge of DevOps principles and practices as applied to data engineering and software development.
• Experience troubleshooting data operations, data pipelines, data quality issues, and backend data processes.
• Strong analytical, problem-solving, and technical documentation skills.
• Ability to gather requirements and translate business and operational needs into technical data solutions.
• Ability to work collaboratively with technical teams, business stakeholders, and end users.

Nice-to-Have Skills:

• Experience developing and operating data pipelines and data products in Amazon Web Services (AWS) or other cloud environments.
• Experience creating database stored procedures and functions.
• Experience developing web applications or backend services that support data analytics.
• Experience working with Salesforce data and Salesforce integrations.
• Experience with cloud-based data engineering, data warehouse, or analytics platforms.
• Experience with additional programming or scripting languages used for data engineering.
• Experience with automated testing, continuous integration/continuous deployment (CI/CD), and DevOps tools.
• Experience supporting federal government or financial regulatory organizations.
• Familiarity with data governance, metadata management, and enterprise data quality practices.

Education and Experience:

• Bachelor's degree or advanced degree in Information Systems, Computer Science, Data Science, Mathematics, Statistics, Operations Management, Engineering, or a related technical or quantitative field is highly preferred.
• Minimum of six (6) years of relevant professional experience supporting data engineering, data operations, data quality, data analytics, data management, or related technical functions.
• Equivalent combination of education and relevant professional experience may be considered.

Salary Range: The salary range for this position represents Dynamo's good-faith estimate of the compensation expected to be offered at the time of posting. Actual compensation will be determined based on several factors, including, but not limited to, the responsibilities of the role, the candidate's experience, skills, education, work location, and internal equity.

$100k-$125k annually

Dynamo is a full lifecycle digital transformation company providing best-in-class technology and mission support services to our clients. Dynamo’s mission is to lead the digital transformation industry and provide best-in-class solutions for our clients with a truly human touch.

We leverage industry leading practices to empower our clients, ultimately providing them with the necessary tools, knowledge, and information required to successfully achieve their strategic goals, while optimizing their operations.

Through our partnerships, boldness, and authenticity, Dynamo goes against the grain of a traditional government contracting company by providing top-caliber team members, delivering quality results, and always exceeding expectations.

Dynamo Technologies is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, national origin, religion, sex, pregnancy, disability, protected veteran status, age, or any other characteristic protected by law.

Individuals with Disabilities (IWD) Contact Statement

The Dynamo Technologies Career page is accessible to any and all users. If you would like to contact us regarding the accessibility of this portal or you need assistance completing the application process, please contact [e-mail] . This contact information is for accommodation requests only and cannot be used to inquire about the status of applications.

Equal Employment Opportunity Commission (EEOC) and Office of Federal Contract Compliance Programs (OFCCP)

Applicants to and employees of most private employers, state and local governments, educational institutions, employment agencies and labor organizations are protected under Federal law from discrimination. Click here to learn more.

Get in touch with us today to explore how Dynamo can help power your success.