Data Solutions Engineer III-2

CareSource • Dayton, OH

20h

About The Position

The Data Solutions Engineer III is responsible for bringing advanced knowledge of Data Warehousing (including ETL, development, testing, ad-hoc reporting, and business analysis) to the Finance function, and is regarded as subject-matter expert and mentor for one or more data domains. Essential Functions: Participate in the full life cycle of data and analytic solutions, broadly from requirements through ETL / ELT, production, consumption, and ad-hoc reporting 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 Serve as a champion and mentor for junior colleagues and data consumers, through training, mentorship, architectural design, testing, and documentation 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

Requirements

• Bachelor's degree in computer science, engineering, mathematics, a related field, or equivalent combination of education and experience is required
• A minimum of six (6) years’ data engineering-level SQL experience (including data modeling, profiling and cleansing, and building complex data sets) is required
• A minimum of four (4) years’ experience building enterprise data solutions (data warehouses and data marts) is required
• A minimum of four (4) years’ experience building customer facing data solutions (PowerBI, Tableau, Oracle, advanced Excel, etc.) is required
• A minimum of three (3) years’ experience in healthcare data is required
• Expert 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
• Skilled in 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)
• Advanced knowledge of Azure Databricks and SparkSQL, or similar data lake platforms (Azure Data Lake, Snowflake, Hadoop, etc.)
• Knowledge of Python, including Python-specific data modeling skill supporting data transformation and data science
• Data expertise within healthcare insurance-specific domains, such as claims (medical and pharmacy), health information exchange (HIE), utilization management (UM), demographics, and common healthcare code sets and processes (patient registry, billing, diagnosis, procedure codes)
• Proficient with the Microsoft 365 suite, including extensive use of Teams, SharePoint, and Excel
• Excellent written and verbal communication skills

Nice To Haves

• Relevant Microsoft certifications (SQL, PowerBI, Azure) is preferred
• Databricks certification and/or badging is preferred

Responsibilities

• Participate in the full life cycle of data and analytic solutions, broadly from requirements through ETL / ELT, production, consumption, and ad-hoc reporting
• 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
• Serve as a champion and mentor for junior colleagues and data consumers, through training, mentorship, architectural design, testing, and documentation
• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 1,001-5,000 employees