Data Solutions Engineer III-2

Job Summary: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 reportingDevelop 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 healthPartner with Data Solutions Analysts, and line-of-business stakeholders in product ideation, requirements gathering, data reviews, ongoing data quality, and troubleshootingServe as a champion and mentor for junior colleagues and data consumers, through training, mentorship, architectural design, testing, and documentationDevelop or support reports, dashboards, and ad-hoc analysis supporting business consumersTest, debug, and performance tune data pipelines and end-user queriesMaintain the highest level of data security and confidentiality, conforming to all HIPAA and contract requirementsPerform any other job duties as requestedEducation and Experience:Bachelor's degree in computer science, engineering, mathematics, a related field, or equivalent combination of education and experience is requiredA minimum of six (6) years' data engineering-level SQL experience (including data modeling, profiling and cleansing, and building complex data sets) is requiredA minimum of four (4) years' experience building enterprise data solutions (data warehouses and data marts) is requiredA minimum of four (4) years' experience building customer facing data solutions (PowerBI, Tableau, Oracle, advanced Excel, etc.) is requiredA minimum of three (3) years' experience in healthcare data is requiredCompetencies, Knowledge and Skills: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 layersSkilled 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 scienceData 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 ExcelExcellent written and verbal communication skillsLicensure and Certification:Relevant Microsoft certifications (SQL, PowerBI, Azure) is preferredDatabricks certification and/or badging is preferredWorking Conditions:General office environment; may be required to sit or stand for extended periods of timeCompensation Range:$92,300.00 - $161,600.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

Created: 2025-12-04