Job Description

Your Future Evolves HereEvolent Health has a bold mission to change the health of the nation by changing the way health care is delivered. Our pursuit of this mission is the driving force that brings us to work each day. We believe in embracing new ideas, challenging ourselves and failing forward. We respect and celebrate individual talents and team wins. We have fun while working hard and Evolenteers often make a difference working in everything from scrubs to jeans.Are we growing? Absolutely and Globally. In 2021 we grew our teams by almost 50% and continue to grow even more in 2022. Are we recognized as a company you are supported by for your career and growth, and a great place to work? Definitely. Evolent Health International (Pune, India) has been certified as Great Places to Work in 2021. In 2020 and 2021 Evolent in the U.S. was both named Best Company for Women to Advance list by Parity.org and earned a perfect score on the Human Rights Campaign (HRC) Foundations Corporate Equality Index (CEI). This index is the nation's foremost benchmarking survey and report measuring corporate policies and practices related to LGBTQ+ workplace equality.We recognize employees that live our values, give back to our communities each year, and are champions for bringing our whole selves to work each day. If youre looking for a place where your work can be personally and professionally rewarding, dont just join a company with a mission. Join a mission with a company behind it.What Youll Be Doing:Position SummaryEvolent is looking for a Sr. Data Engineer of Health Care Data, to be a key member of the technology leadership team. This individual will play a critical role in executing Evolents mission by managing data-driven activities related to data engineering, ETL, data profiling, data discovery and analysis, requirements definition, testing and continuous improvement of data collection, mapping, analysis and transformation processes specifically related to implementation of new client data portfolios.Essential Functions

• SAS skills for Extract, transformation and Loading tasks.
• Strong SQL skills.
• Having SSIS Knowledge is a plus.
• Deep understanding of data warehousing concepts.
• A knack for dealing with healthcare datasets and finding relationships in the data and any gaps/issues.
• Patience and persistence to sift through complex data/information to get to the core knowledge.
• Intense intellectual curiosity and an ability to view problems with a fresh perspective.
• Excellent written computer and oral communication skills.
• Gain familiarity and knowledge of the Evolent administrative data lifecycle from requirements through data analysis to engineering and testing. Learn through hands-on work how each function works to become SME in data engineering.
• Analyze data files, data layouts and data dictionaries from providers of health care administrative data (eligibility, account/plan, medical claims, pharmacy claims, etc.) to understand data structure and operating rules for Extraction, Transformation and Loading to common data format.
• Develop technical solutions for the end-to-end data life cycle in the data warehouse.
• Collaborate with data warehouse QA and Analyst teams to ensure seamless execution of test cases end-to-end.
• Liaise with onshore team to ensure best practices are followed and issues/concerns are addressed proactively.
• Mentor analysts and junior level resources in best practices and guidelines for implementations and data analysis; aid in development of learning activities.
• Alert service delivery managers to potential risks to project and timelines along with issues of importance.
• Overall US Healthcare insurance domain knowledge.
• Knowledge of medical claim file contents (both UB04 and HCFA-1500) and significance of individual fields.

Preferred functions

• Experience with clinical coding systems: ICD diagnosis codes, ICD procedure codes, CPT codes, revenue codes, provider NPI codes, NDC Rx codes.

Skill Set RequirementsHiring Manager to fill in below.Leverage this competency scale definition (1 being lowest and 5 highest) for below.Optional to have (can be skipped in the search criteria) Ok to have (can be skipped in the search criteria) Good to have (to be included in search criteria) Must have (need to be in the search criteria) Mandatorily to have (need to be in the search criteria)Mandatory skill set (Maximum 5)S No|Skills|Competency level (1-5)1|SAS|52|SQL|43|SSIS|24|ETL|55|US Healthcare Insurance domain|5Good to have skill set (Maximum 5)S No|Skills|Competency level (1-5)1|Communication skills|4Academic Qualification

• 8+ years of experience in information technology.
• Bachelor's Degree required.
• ETL, SAS, SQL, SSIS skills to create technical solutions for data loading, transformation and extracting.
• Understanding of Medical Claims, Rx Claims, Eligibility/Membership, healthcare insurance benefit and group account setup, Provider data and related processes around them is desirable.

Mandatory Requirements:We require that all employees have the following technical capability at their home: High speed internet over 10 Mbps, the ability to plug in directly to the home internet router. These at-home technical requirements are subject to change with any scheduled re-opening of our office locations. Evolent Health is an equal opportunity employer and considers all qualified applicants equally without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, or disability status.

Evolent Health