Data Engineer
Summary
Designs and maintains scalable data pipelines in Azure to ingest, transform, and validate product-safety datasets for analytics and ML, ensuring reliable, governed data for CPSC’s mission.
As a Data Engineer in CPSC's Analytics Center of Excellence, your work strengthens evidence-based decision-making and supports the agency's mission to protect the public from unsafe products. The Data Engineer will design, develop, and optimize scalable data pipelines and services that power advanced analytics and machine learning solutions. The work that you do ensures that data is reliable, accessible, and ready for downstream use by data scientists, analysts, and AI/ML systems.
This position is officially titled Data Scientist. The working title is Data Engineer. The Data Engineer strengthens CPSC's Sentinel-driven product safety analytics and provides the foundation to introduce myriad operational efficiencies by delivering high-quality, secure, and interoperable data solutions in modern cloud environments. The Data Engineer will: Design and maintain production-grade ETL/ELT pipelines using Python and Microsoft-based frameworks to ingest, transform, validate, and optimize large structured and unstructured datasets. Implement schema enforcement, data validation, and quality controls to ensure reliable, reproducible data across diverse sources. Develop scalable, fault-tolerant pipelines using open-source and cloud-native patterns. Architect and manage Azure data solutions-including Data Lake Storage, Azure SQL, and related analytics integrations-and build automated workflows using Azure Data Factory or similar tools. Create high-performance Python-based data services; implement logging, monitoring, and performance tuning for operational robustness. Build APIs and microservices that enable secure, seamless data exchange and integration with analytics and machine-learning platforms. Partner with data scientists, analysts, and cloud architects to deliver clean, governed data for predictive modeling, real-time monitoring, and actionable insights. Apply data governance best practices to ensure compliance, auditability, and reproducibility across workflows. Advise on data engineering initiatives and contribute to cross-agency data fusion projects; maintain current knowledge of evolving industry and federal data engineering standards. Participate in CPSC and government-wide data engineering working groups and communities of practice. Perform other duties as assigned.
Must be a U.S. Citizen. This is a Public Trust Position. Employment in this position requires a background investigation. If you are selected and cannot meet the criteria requirement for the pre-employment waiver and/or a favorable suitability determination within a reasonable period of time due to disclosed or undisclosed background issues, the employment offer may be withdrawn. If you are a male born after December 31, 1959 you must certify that you have registered with the Selective Service System, or are exempt from having to do so under the Selective Service Law. Please see http://www.sss.gov for more information. Selectees will be required to complete a "Declaration of Federal Employment", (OF-306), prior to appointment and the appropriate background investigation forms to determine suitability for Federal employment. False statements or responses on these forms can jeopardize your employment opportunity and subject you to disciplinary action, including removal from Federal service. The selectee will be required to complete a Personal Identity Verification (PIV) process that requires two forms of identification from the I-9 Form. We will compare information provided on the I-9 Form to records available from the U.S. Department of Homeland Security. The system confirms employee's identity and eligibility to work in the United States. Learn more about E-Verify, including your rights and responsibilities. As a condition of employment for accepting this position, you will be required to serve a 1-year probationary period during which we will evaluate your fitness and whether your continued employment advances the public interest. In determining if your employment advances the public interest, we may consider: your performance and conduct; the needs and interests of the CPSC; whether your continued employment would advance organizational goals of the CPSC or the Government; and whether your continued employment would advance the efficiency of the Federal service. Upon completion of your probationary period your employment will be terminated unless you receive certification, in writing, that your continued employment advances the public interest.