Note: The job is a remote job and is open to candidates in USA. Dynamo Technologies, LLC is a digital transformation company providing technology and mission support services. The Senior Data Engineer will provide technical expertise in data engineering, data operations, data quality, analytics, and data management while designing, developing, operating, and maintaining data pipelines, data products, ETL processes, and data warehouse solutions supporting CFPB mission requirements.
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
Skills
- • 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
- • 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
- • 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
- • 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
Company Overview