Data Analysis Intern - Imersis

WHY NEWWAVE?

NewWave is a people first corporation who has been widely recognized for putting our social responsibility at the very heart of everything we do. For employees the NewWave experience is one of enrichment, challenge, and growth. Our culture is centered on recognizing our people come first, embracing a growth mindset, striving for excellence, and driving the greater good.

POSITION SUMMARY

Imersis is a cloud-based, data quality tool, designed to help state Medicaid agencies prepare Transformed Medicaid Statistical Information System (T-MSIS) data for advanced analytics and to meet federal requirements. This position will help an emerging Python/SQL Developer hone their skills while supporting the continued advancement of the Imersis system. Interns will be considered for full time positions as Jr. Data Engineers long term.

What We Need you to Do:

• Write/edit calculations using Python Pyspark from high level specifications that will evaluate data quality of T-MSIS data
• Write/edit SQL Warehouse and Databricks Catalog queries for data visualizations in Apache Superset
• Run ETL pipelines in Databricks to test T-MSIS Data Quality
• Communicate with our testing partners to identify, triage, and fix bugs and errors in both the back end and front end of the application

What We Need you to Bring:

• Experience with Python, SQL
• Must be "Data-minded", brings examples of showing analytical skills to organize and manipulate large amounts of data

Skills that would set you apart:

• Pyspark, SQL Warehouse
• Knowledge/experience in healthcare, especially claims experience
• Experience working in Databricks
• Git experience

Skills we will provide as part of this internship:

• T-MSIS data structures
• Working with Protected Health Information (PHI)
• Diverse database loading/extraction skills
• Constructing ETL pipelines

Our Clients and Teammates Require:

- Candidates will be subject to a background check.
- Must have lived in the United States at least 3 out of the last 5 years.
- Excellent interpersonal, verbal and written communication, and organizational skills - must be able to communicate fluently in English both verbally and in writing.
- Must be able to thrive in a fast-paced, rapidly evolving environment with varying priorities, based on a team building culture.

NewWave is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Opportunity/Affirmative Action Employer, making decisions without regard to race, color, religion, creed, sex, sexual orientation, gender identity, marital status, national origin, age, veteran status, disability, or any other protected class. NewWave is a proud Veteran friendly employer.