Job Summary:
Must live in EST to be considered for this position
The Data Solutions Engineer II is responsible for bringing strong knowledge of Data Warehousing (including ETL, development, testing, ad-hoc reporting, and business analysis) to the Finance function and participating in the full life cycle of data and analytic solutions, broadly from requirements through ETL/ELT, production, consumption and ad-hoc reporting.
Essential Functions:
- Develop end-to-end data warehouse / data mart solutions, utilizing Databricks and Microsoft technologies. Patterns include traditional dimensional modeling (Kimball), and schema-less (big data) models.
- Develop data modeling expertise on one or more insurance-specific data / workflows, such as claims, care management (CM), utilization management (UM), eligibility, and population health
- Partner with Data Solutions Analysts, and line-of-business stakeholders in product ideation, requirements gathering, data reviews, ongoing data quality, and troubleshooting
- Develop or support reports, dashboards, and ad-hoc analysis supporting business consumers
- Test, debug, and performance tune data pipelines and end-user queries
- Maintain the highest level of data security and confidentiality, conforming to all HIPAA and contract requirements
- Perform any other job duties as requested
Education and Experience:
- Bachelor's degree in computer science, engineering, mathematics, a related field, or equivalent combination of education and experience is required
- A minimum of four (4) years’ data engineering-level SQL experience (including data modeling, profiling and cleansing, and building complex data sets) is required
- A minimum of two (2) years’ experience building enterprise data solutions (data warehouses and data marts) is required
- A minimum of two (2) years’ experience building customer facing data solutions (PowerBI, Tableau, Oracle, advanced Excel, etc.) is required
- A minimum of two (2) years’ experience in healthcare data is preferred
Competencies, Knowledge and Skills:
- Experience with Azure Databricks, Spark (PySpark/SparkSQL) and modern data lake/lakehouse platforms (Azure Data Lake, Snowflake, Hadoop).
- Strong proficiency in Python for data engineering, including data transformation, pipeline development, and analytics support.
- Advanced SQL expertise, including designing and optimizing ETL/ELT pipelines, and implementing data warehouse modeling (fact/dimension, star schema).
- Experience building and maintaining data pipelines across staging, curated, and consumption layers.
- Experience working with diverse data sources including ODS, flat files, EDI/HL7, APIs, and streaming data.
- Familiarity with Azure ecosystem tools (Azure Data Factory, Synapse Analytics) is preferred.
- Experience with Power BI / SSRS / Tableau for reporting and data visualization is added advantage .
- Knowledge of healthcare data domains including patient, claims, billing, diagnosis, and procedure codes is preferred.
- Experience with healthcare insurance data such as medical/pharmacy claims, HIE, utilization management (UM), and member demographics is preferred.
- Proficient with the Microsoft 365 suite, including extensive use of Teams, SharePoint, and Excel.
- Good written and verbal communication skills
Licensure and Certification:
- Relevant Microsoft certifications (SQL, PowerBI, Azure) is preferred
- Databricks certification and/or badging is preferred
Working Conditions:
- General office environment; may be required to sit or stand for extended periods of time
Compensation Range:
$72,200.00 - $115,500.00CareSource takes into consideration a combination of a candidate’s education, training, and experience as well as the position’s scope and complexity, the discretion and latitude required for the role, and other external and internal data when establishing a salary level. In addition to base compensation, you may qualify for a bonus tied to company and individual performance. We are highly invested in every employee’s total well-being and offer a substantial and comprehensive total rewards package.
Compensation Type (hourly/salary):
SalaryOrganization Level Competencies
Fostering a Collaborative Workplace Culture
Cultivate Partnerships
Develop Self and Others
Drive Execution
Influence Others
Pursue Personal Excellence
Understand the Business
Top Skills
What We Do
Health Care with Heart. It is more than a tagline; it’s how we do business. CareSource has been providing life-changing health care to people and communities for nearly 30 years and we will continue to be a transformative force in the industry by placing people over profits. CareSource is and will always be members first. Even as we grow, we remember the reason we are here – to make a difference in our members’ lives by improving their health and well-being. Today, CareSource offers a lifetime of health coverage to nearly 2 million members through plan offerings including Marketplace, Medicare Advantage and Medicaid. With our team of 4,000 employees located across the country, we continue to clear a path to better life for our members. Visit the "Life" section to see how we are living our mission in the states we serve. CareSource is an equal opportunity employer and gives consideration for employment to qualified applicants without regard to race, color, religion, sex, age, national origin, disability, sexual orientation, gender identity, genetic information, protected veteran status or any other characteristic protected by applicable federal, state or local law. If you’d like more information about your EEO rights as an applicant under the law, please click here: https://www.eeoc.gov/employers/upload/poster_screen_reader_optimized.pdf and here: https://www.dol.gov/ofccp/regs/compliance/posters/pdf/OFCCP_EEO_Supplement_Final_JRF_QA_508c.pdf Si usted o alguien a quien ayuda tienen preguntas sobre CareSource, tiene derecho a recibir esta información y ayuda en su propio idioma sin costo. Para hablar con un intérprete, Por favor, llame al número de Servicios para Afiliados que figura en su tarjeta de identificación. 如果您或者您在帮助的人对 CareSource 存有疑问，您有权 免费获得以您的语言提供的帮助和信息。 如果您需要与一 位翻译交谈，请拨打您的会员 ID 卡上的会员服务电话号码
.png)
