Data Engineer
Job Description
Senior Data Engineer role supporting a federal fraud control modernization effort through redesigned and optimized data pipelines and workflows.
- Engineer, transform, and manage large datasets from diverse sources with data integrity, reliability, and consistency
- Design, optimize, and maintain complex SQL queries for ETL across distributed databases
- Develop and automate ETL pipelines using Apache Airflow for high availability and resilience
- Write modular, well-documented Python for data processing, feature engineering, and workflow orchestration
- Implement data validation, cleansing, and quality checks throughout the pipeline lifecycle
- Apply software engineering best practices including version control, code reviews, logging, monitoring, and error handling
- Collaborate with data scientists to optimize model pipelines for performance, maintainability, and scalability
- Prepare and maintain technical documentation such as data dictionaries, model specs, workflow guides, and architectural artifacts
- Support Agile cycles by contributing to documentation and refinement of model workflows and data processes
- Participate in deployment activities, perform testing and validation, and complete post-implementation reviews
Requirements
- Ability to obtain and maintain an Agency Public Trust clearance
- Bachelor’s degree and 7+ years of relevant experience
- Expertise in SQL and ETL workflows with experience in distributed database technologies: Redshift, Snowflake, BigQuery
- Experience with Apache Airflow or similar orchestration frameworks
- Strong Python skills, especially pandas and NumPy, plus automation libraries
- Hands-on experience building data quality checks and validation frameworks
- Familiarity with GitHub, Bitbucket, or similar version control tools
- Knowledge of logging
Technologies
- SQL
- ETL
- Apache Airflow
- Python
- pandas
- NumPy
- Redshift
- Snowflake
- BigQuery
- GitHub
- Bitbucket
- Agile
Desired Qualifications (Non-Essential)
- Experience supporting federal agencies, especially in fraud or anomaly detection
- Familiarity with cloud platforms: AWS, Azure, GCP
- Exposure to containerization tools: Docker, Kubernetes
- Exposure to CI/CD, DevOps practices, and infrastructure as code
- Knowledge of data governance, PII handling, and federal security standards
- Experience with model documentation, feature tracking, and model lifecycle management
Benefits
- Competitive compensation
- Comprehensive insurance options
- Matching contributions through the 401(k) plan and the share purchase plan
- Paid time off for vacation, holidays, and sick time
- Paid parental leave
- Learning opportunities and tuition assistance
- Wellness and Well being programs
Location: Baltimore, MD (onsite). Schedule: On site 5 days a week in Woodlawn, MD.
Compensation: USD 89,600 - 198,400 per yearly.