Senior Data Engineer

September 15

Apply Now

Receive Emails with Similar Jobs

ICF

WebsiteLinkedInAll Job Openings

Aviation • Climate • Cybersecurity • Digital and Marketing • Education

5001 - 10000

💰 Grant on 2023-02

Description

• Develop, modify, run, and test Airflow DAGs and/or Spark Applications interacting with Postgres, Redshift, Oracle databases. • Identify defects in the code and/or data. • Develop and run DBT tests. • Develop and run Automated Testing Scripts. • Data Engineering test plan generation. • Understanding and testing of complex Data Models. • Implement/modify Jenkins CI/CD pipelines. • Validate csv output report files, both manual and Python automation integrated in Jenkins. • Reporting of validation results, Data Model output, Automation reporting. • Close interaction with Dev and business team on refinement, implementation, and execution of data items.

Requirements

• Bachelor's degree with 5 years experience as a data engineer, software developer, or tech lead. • 2 years experience in SQL and Python code language • Candidate must reside in the United States and be able to obtain a Public Trust clearance; candidate must have resided in the US 3 of the last 5 years. • 2 years experience in: Database testing (DBT), Postgres, Redshift database, SQL, Apache Airflow DAG, Apache Spark, Python code language, Amazon Web Services (AWS), Jenkins (CI/CD), Git and GitHub for version control and management, Alembic database migration tool. • Bachelor's degree in Computer Science • AWS certifications (e.g., Cloud Practitioner, Developer, Solution Architect, Data Analytics, or Database). • Strong understanding of relational database and data warehousing concepts (e.g., OLAP, dimensional modeling). • Prior experience working with Medicare and/or Medicaid data. • Experience with one or more BI tools, such as Superset, Tableau, MicroStrategy, Looker, etc. • Prior experience working remotely full-time. • Federal Government contracting work experience.