Data Engineer

This Senior Data Engineer role supports a federal agency in modernizing its fraud control strategy by redesigning and optimizing fraud detection data pipelines and workflows. You will lead scalable, secure, and flexible data engineering solutions for the iClaim model infrastructure while working closely with data scientists and federal stakeholders.

Responsibilities

• Engineer, transform, and manage large datasets coming from diverse sources while maintaining data integrity, reliability, and consistency.
• Design, optimize, and maintain complex SQL queries to support ETL operations across distributed databases.
• Develop and automate ETL pipelines using platforms such as Apache Airflow, with a focus on high availability and resilience.
• Write modular, well-documented Python code for data processing, feature engineering, and workflow orchestration.
• Implement comprehensive data validation, cleansing, and quality checks across pipeline stages.
• Apply software engineering best practices, including version control, code reviews, logging, monitoring, and error handling.
• Collaborate with data scientists to improve model pipelines for performance, maintainability, and scalability.
• Create and maintain technical documentation such as data dictionaries, model specifications, workflow guides, and architectural artifacts.
• Support Agile development cycles by contributing to documentation and refinement of model workflows and data processes.
• Participate in deployment activities and perform testing, validation, and post-implementation reviews.

Required Qualifications

• 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, including experience with distributed database technologies such as Redshift, Snowflake, and BigQuery.
• Experience with Apache Airflow or similar orchestration frameworks.
• Strong Python development skills, including pandas, NumPy, and automation libraries.
• Hands-on experience building data quality checks and validation frameworks.
• Familiarity with GitHub, Bitbucket, or comparable version control tools.
• Knowledge of logging.

Preferred / Non-Essential Skills

• Experience supporting federal agencies, especially for fraud or anomaly detection.
• Familiarity with cloud platforms (AWS, Azure, GCP) and 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.

Technologies

SQL, ETL, Apache Airflow, Python, pandas, NumPy, Redshift, Snowflake, BigQuery, GitHub, Bitbucket, Agile

Compensation and Location

Baltimore, MD (onsite). Salary range: USD 89,600 - 198,400 per year.

This position is on site 5 days a week in Woodlawn, MD.

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