Blacksburg, VA, United States

ETL Consultant

 Job Description:

Hatch I.T. is partnering with Socially Determined to find an ETL Consultant. More info below!



About The Role

We seek an ETL Consultant with health care data experience to join our Technical Solutions Team. You would be a great fit for this position if you have passion for making social impact and technical skills to support client data ingestion work.

The role is designed to be a remote work-from-home position.

What Youll Do:

  • Create scripts used for ETL, validate data flow in the client data ingestion process
  • Translate business requirements to script or query updates
  • Take ownership and accountability for your work
  • Deliver quality client data packages in a timely manner
  • Mentor and guide junior team members
  • Think and design for edge cases
  • Identify opportunities for innovation, automation and continuous improvement

What youll need:

  • Advanced knowledge and experience in Python and PostgreSQL
  • Experience with AWS environment and can comfortably extract or load files to AWS S3
  • Familiarity with Cloud Based Big Data Environment tools such as Zeppelin, AWS Glue, Jupyter notebooks)
  • Bachelors degree in Computer Science or equivalent degree
  • 3-5 years of relevant work experience in health care sector including health care data manipulation
  • Ability to think critically, identify issues, and proactively propose solutions
  • Willingness to work in a fast-paced, team-oriented, mission-driven start-up environment
  • Passion for improving the health of communities and enhancing the performance of our clients
  • Desire to be a team player, collaborative and comfortable working in a matrix team environment
  Required Skills:

SSRS Data Transformation Services (DTS) MySQL Extract, Transform, Load (ETL) SSAS NoSQL PostgreSQL SQL ETL Tools Data Analysis ETL AWS Python Database Development SSIS Amazon Web Services RDBMS Data Warehousing Amazon S3