Data Solutions Engineer II (Managed Care - Clinical Focus)

This is Data Engineering with Purpose ! Bring your strong ETL and architecture skills to our state-of-the-art Databricks platform and join us as we change lives- together ! This role focuses upon clinical subjects within the health insurance industry : member conditions, social determinants of health, clinical programming, and population health.

You will be hands-on in transforming and delivering datasets that impact the lives of millions of members within a dynamic, growing organization!

Job Summary :

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 :

• Advanced SQL skills, including the ability to develop upon and maintain systems utilizing contemporary data warehousing patterns including ETL / ELT, fact and dimension modeling, and deploying analytic resources via staging tiers and consumption layers
• Proficient working with and warehousing data from multiple sources, such as operational data stores (ODS), flat file, EDI / HL7, API, etc.
• Proficiency with the Microsoft data ecosystem (SSRS, SSIS, PowerBI)
• Experience with Azure Databricks and SparkSQL, or similar data lake platforms (Azure Data Lake, Snowflake, Hadoop, etc.)
• Working knowledge of Python, including Python-specific data modeling skill supporting data transformation and data science
• Knowledge of common healthcare data domains and processes (patient registry, billing, diagnosis, procedure codes)
• Preferred knowledge of healthcare insurance-specific domains, such as claims (medical and pharmacy), health information exchange (HIE), utilization management (UM), demographics
• 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 :

$69,400.00 - $111,000.00

CareSource 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.

We are highly invested in every employee’s total well-being and offer a substantial and comprehensive total rewards package.

Compensation Type (hourly / salary) :

Salary

Organization Level Competencies

Create an Inclusive Environment

Cultivate Partnerships

Develop Self and Others

Drive Execution

Influence Others

Pursue Personal Excellence

Understand the Business