Jobs / Esi***
Data Engineer
Esi*** · Columbia, MD, United States
Visa sponsorship details are locked. Unlock company name and apply link with .
Columbia, MD, United States93,300-136,400 USD/yearlyHybrid
Remuneration
93,300-136,400 USD/yearly
Location
Columbia, MD, United States
Visa sponsorship
Sponsors visa
Job summary
Description: About Us Esi*** is a modern digital services company that partners with government agencies to improve the lives and protect the well-being of all Americans, from veterans and service members to children, families, and seniors.
Benefits
ESimplicity offers a comprehensivePackage, including medical, dental, and vision coverage, 401(k) retirementPaid time off, paid holidays, life and disability insurance, and additional wellEligibility may vary based on employment status and applicable plan terms.Reasonable Accommodation:Applicants who need assistance or accommodation should contact Human Resources.Equal Employment Opportunity:ESimplicity is an Equal Opportunity Employer, including disability and protected
Qualifications
- ETL design documents, mapping documents, data models, data dictionaries, deployment references, operations and maintenance guides, and test plans.
- Deploy code through automated CI/CD pipelines using CloudFormation templates, following agency release, security, and governance processes.
- Collaborate with Data Officers, Data Stewards, SMEs, data providers, and IV&V teams to understand
- and deliver user-accepted solutions; engage closely with the Product Owner and cross-functional teams to provide timely updates and resolve issues.
- Leverage AI-assisted development
- Required
- Bachelor's degree in Data Science, Computer Science, Engineering, or a related technical discipline.
- In lieu of a degree, four additional years of related experience is required
- Minimum of 5 years of related data engineering experience developing and deploying data pipelines in production.
- Hands-on experience developing ETL pipelines in AWS using Glue, Spark/PySpark, Lambda, and S3.
- Proficiency in Python (adhering to PEP 8) and strong SQL
- Experience with financial/regulatory datasets, public company filings data, or other high-sensitivity federal data.
Responsibilities
- Develop production-grade ETL workflows using AWS Glue, PySpark, Python, Lambda, and EMR, integrated with a shared ETL common library and orchestrated via Amazon Managed Workflows for Apache Airflow (MWAA).
- Develop semantic-layer objects (tables, views, materialized views) that ensure complete data coverage, optimized query performance, and consistent application of business logic.
- Develop XML parsing/shredding logic for high-volume regulatory filings using Glue PySpark, supporting schema evolution and batch processing per program standards.
- Design pipelines with query performance in mind and support rollback, reload, and date-range reprocessing capabilities without manual intervention.
- Create and maintain required engineering artifacts, including business
Skills
CommunicationElectronic Health Records
Certifications
AWS CertifiedProduct Owner
Degrees
AssociateBachelorDegree
Work schedule
On-callRotationShift
Travel
Occasional travelTravel
Industry
AutomotiveInsurancePublic-sector
Company size
EnterpriseSmb
Contract length
5 years
Security clearance
Public trustSecurity clearance