Data Engineer

The Data Engineer will support the Department of Homeland Security (DHS) - Immigration & Customs Enforcement (ICE), Enforcement & Removal Operations (ERO), Law Enforcement & Analysis (LESA) division and be responsible for developing ERO strategies to enhance its business procedures continuously. The Data Engineer provides expertise in database architecture, data pipeline development, and data quality monitoring to support the U.S. Immigration and Customs Enforcement (ICE) Enforcement and Removal Operations (ERO) Law Enforcement Systems and Analysis (LESA) Division. Supporting the Statistical Unit (STU), the Data Engineer ensures the design, execution, and validation of data processes, reporting methodologies, and recurring deliverables. This role also supports transition planning, onboarding, and compliance with DHS/ICE reporting standards, while enhancing interoperability and information sharing across LESA, ERO, and DHS stakeholders.

This contract is pending award.

Must be a U.S. Citizen.

Clearance Required: Able to obtain ICE 6C/Full Background Investigation (BI) level or higher clearances.

Responsibilities:

• Draft and deliver a Transition Plan including:
• Timeline for FTE staff onboarding

• Staff resumes with skillset matrices
• Training timeline for assuming report deliverables
• Shift schedule for 7 am – 7 pm EST coverage
• Initial onboarding training plan (due by end of first week of transition)
• Provide onboarding training materials for federal staff review by the first week of the transition period
• Meet bi-weekly with the STU Unit Chief and federal staff to communicate staffing changes, coverage, tasking status, and propose process improvements. Provide written deliverable reports at each meeting
• Provide written notice of staffing changes with resumes/skillset matrices at least two weeks prior to onboarding
• Confirm in writing that new staff have been properly onboarded within two weeks of start date
• Provide written notice in advance of any major schedule changes impacting 7 am – 7 pm EST coverage; serve as POC for high-priority requests during weekends/holidays as needed
• Provide subject matter expertise and actively participate in methodology and reporting requirements meetings with STU and other stakeholders
• Create and maintain methodology documentation, SOPs, user guides, and validation documentation as directed
• Gather and draft business requirements to develop or adapt existing business rules and reporting methodologies
• Participate in testing and validation of business rule implementations; provide final training documentation
• Conduct Data Quality Monitoring by analyzing datasets to identify patterns, insights, and anomalies. Document findings, provide recommendations, and report to federal staff in writing
• Streamline methodology updates, data queries, and immigration lifecycle variables to improve reporting and forecasting
• Report on key performance indicators (KPIs) across the data and visualization enterprise
• Promote interoperability of methodologies and products with other LESA and ERO models to enhance reporting and decision-making

• Provide all report deliverables in standard formatting, following STU SOPs for creation, documentation, storage, validation, and maintenance
• Gather requirements, design, and execute recurring reports from databases of record at prescribed frequencies
• Gather requirements, design, and execute reports for federally directed taskings
• Conduct daily or as-requested peer reviews of deliverables to support tasking validation
• Complete a Weekly Population Report Validation by validating standard populations and filters in systems of record, identifying/reporting data quality issues, and submitting deliverables in writing by 3 pm EST on the first business day of each week
• Support ad-hoc activities, requests, model, and tool enhancements, prioritizing and validating requests with LESA stakeholders
• Collaborate with the STU Unit Chief and federal staff to determine delivery mechanisms and deadlines

Qualifications:

• Minimum 5 years of relevant experience

Preferred Qualifications:

• Previous support to federal law enforcement agencies
• Proficiency in SQL, Python, and ETL tools; experience with data warehouse and database platforms
• Demonstrated experience with data quality monitoring, validation, and reporting
• Strong technical writing and documentation skills (SOPs, user guides, validation documentation)
• Excellent communication and stakeholder engagement skills
• Strong technical writing, documentation, and training development skills
• Familiarity with DHS/ICE operations, acquisition, and reporting processes
• Excellent communication and stakeholder engagement abilities

About Mayvin

Mayvin is more than a workplace—it’s a community built on innovation, inclusion, and impact. Enjoy outstanding benefits and amenities, a truly inclusive work environment, and continuous opportunities for professional growth. Your contributions are recognized and rewarded, and—most importantly—your voice matters. Here, you're treated with the dignity and respect you deserve.

Mayvin is proud to support the national security mission of the United States through exceptional service to the Departments of Defense, Homeland Security, and Justice. Join us in solving the nation's toughest challenges—because at Mayvin, #PeopleMatter and it's time to #ReimagineYourMission.