ICF is a mission-driven company filled with people who care deeply about improving the lives of others and making the world a better place. Our core values include Embracing Difference; we seek candidates who are passionate about building a culture that encourages, embraces, and hires dimensions of difference.
Our Health Engineering Solutions (HES) team works side by side with customers to articulate a vision for success, and then make it happen. We know success doesn't happen by accident. It takes the right team of people, working together on the right solutions for the customer. We are looking for a seasoned Senior Data Engineer who will be a key driver to make this happen.
You will work on projects that support the Centers for Medicare and Medicaid Services (CMS) as we develop a next-generation analytics and reporting system that directly impacts healthcare quality.
Responsibilities:
- 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
Basic Qualifications:
- 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; c
- andidate must have resided in the US 3 of the last 5 years.
Preferred Qualifications:
- 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.
Professional Skills:
- Strong technical communication skills; both written and verbal
- Ability to work independently and collaboratively
- Flexible and willing to accept a change in priorities as necessary
- Demonstrated time management skills
- Strong organizational skills with attention to detail
- Strong critical thinking, problem solving and structuring and analytical skills
- SAFe Experience a plus.
#DMX-HES
#Li-cc1
#Indeed
Working at ICF
ICF is a global advisory and technology services provider, but we’re not your typical consultants. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges, navigate change, and shape the future.
We can only solve the world's toughest challenges by building an inclusive workplace that allows everyone to thrive. We are an equal opportunity employer, committed to hiring regardless of any protected characteristic, such as race, ethnicity, national origin, color, sex, gender identity/expression, sexual orientation, religion, age, disability status, or military/veteran status. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals. For more information, please read our EEO & AA policy.
Reasonable Accommodations are available, including, but not limited to, for disabled veterans, individuals with disabilities, and individuals with sincerely held religious beliefs, in all phases of the application and employment process. To request an accommodation please email [email protected] and we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations. Read more here: Requesting an Accommodation for the ICF interview process.
Read more about workplace discrimination rights, the Pay Transparency Statement, or our benefit offerings which are included in the Transparency in (Benefits) Coverage Act.
Pay Range - There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, geographic location, education and certifications as well as contract provisions regarding labor categories that are specific to the position.
The pay range for this position based on full-time employment is:
$84,533.00 - $143,706.00
Nationwide Remote Office (US99)
Top Skills
What We Do
ICF is a global advisory and technology services company with approximately 9,000 employees in industries across the public and private sectors. For over 50 years, we’ve been helping clients take on some of the world’s most complex challenges to produce exceptional results. Our work is the catalyst to help shape the future for all.
Beyond our purpose-driven work, we invest in our employees and their experience with us. We have numerous options for healthcare and many additional benefits, including immediate access to 401k retirement matching and pet insurance. Our Employee Community Networks help members find support, belonging, and growth by enhancing internal networks and professional development. We offer paid volunteer time and match your donations. As learning is a never-ending journey, we offer tuition reimbursement, mentorship programs, communities of practice to contribute to and grow from, and memberships to LinkedIn Learning and Coursera. We aim to consider every aspect of how to invest in people so they can belong, grow, and thrive with us.
Why Work With Us
At ICF, we are a purpose-driven company with a strong culture and underlying values that prize diversity, opportunity, equality, and respect. We are not all the same. And that has always been our greatest strength. We are at our best when every member of our team feels respected, included, and heard—when everyone can show up as themselves and do th