Sr Data Engineer

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