Data Solutions Engineer II

CareSource is a healthcare management organization, and they are seeking a Data Solutions Engineer II to enhance their Finance function through data warehousing expertise. The role involves developing data warehouse solutions, collaborating with stakeholders, and ensuring data security and quality.

Responsibilities:

• 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

Requirements:

• Must live in EST to be considered for this position
• 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
• 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
• Proficient with the Microsoft 365 suite, including extensive use of Teams, SharePoint, and Excel
• Good written and verbal communication skills
• A minimum of two (2) years' experience in healthcare data is preferred
• 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
• Relevant Microsoft certifications (SQL, PowerBI, Azure) is preferred
• Databricks certification and/or badging is preferred