Job Description: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
