Senior Software Engineer (Node)

• Job Description

  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 SemanticBits 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 seeking a talented Data Engineer who is responsible for creating OLTP queries used by front-end engineers to display reports to the end users. You will be working with a team of likeminded data engineers. If you are someone who wants your work to contribute to systems that collect healthcare data used by hundreds of thousands of daily users, we want to (virtually) meet you!  

   

  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. This program allows for the continued quality of clinicians’ work according to CMS standards. We are a collaborative company, so we want you to use your knowledge of Spark to teach others, inform design decisions, and debug runtime problems.  

   

  Our mission is to help the government improve healthcare for patients and reduce costs. We value individuals that are experts in their disciplines, highly communicative, and self-motivated to own their work. Technology and domain experts work side-by-side in highly dynamic teams with all the roles necessary to deliver high-quality digital services. In addition, critical to our success is forming teams of highly diverse individuals passionate about making a difference.  

   

  Tools & Technology:

  • Postgres, Python, SQL, Stored Procedures 
  • Jenkins  
  • AWS Redshift   
  • Git and GitHub  
  • AWS Airflow
  • Confluence 
  • PySpark
  • DBT
  • AWS services such as EMR, EKS, Lambda

   

  Key Responsibilities:

  • Write new database stored procedures and functions to support QMIR data needs. 
  • Write new and modify. Existing scripts to maintain QMIR data.
  • Maintain existing stored procedures and functions in Redshift and Postgres database. 
  • Support Production issues with investigation and performance tuning of SQL code. 
  • Maintain and perform alembic migrations scripts in Git repo for script changes and incident tickets. 

   

  Basic Qualifications:

  • Master’s degree with 3 years’ experience, Bachelor’s Degree with 5 years’ experience, or Associates degree with 7 years’ experience.  
  • 5+ years of experience with Python, Postgres, SQL, and Redshift 
  • Must have lived in the United States for 3 full years of the last 5 years
  • Candidate must be able to obtain and maintain a Public Trust
  • Candidate must reside in the US, be authorized to work in the US, and work must be performed in the US

   

  Preferred qualifications:

  • Experience working in the healthcare industry with PHI/PII  
  • Federal Government contracting work experience.  
  • Expertise working as part of a dynamic, interactive Agile team. 
  • Strong written and verbal communication skills  
  • Demonstrated time management skills.  
  • Strong organizational skills with attention to detail  
  • Curiosity about how things work, ability to look out for potential risks.  

  Job Location: This position requires that the job be performed in the United States.  If you accept this position, you should note that ICF does monitor employee work locations and blocks access from foreign locations/foreign IP addresses, and also prohibits personal VPN connections.

• Additional Job DescriptionAdditional Job DescriptionA seasoned, experienced professional with a full understanding of area of specialization. Resolves a wide range of issues in creative ways. This job is the fully qualified, career-oriented, professional position. Represents the level at which a career may stabilize for many years or even until retirement. Works on problems of diverse scope where analysis of data requires evaluation of clearly identified factors. Demonstrates good judgment in selecting methods and techniques for obtaining solutions. Networks with senior internal and external personnel in own area of expertise. Works under fairly limited direction. Normally receives little instruction on day-to-day work, general instructions on new assignments. Determines and develops approach to solutions within policies and procedures. Work is evaluated upon completion to ensure objectives have been met.

Working