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

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

Competencies, 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 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

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:

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. 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):

Organization Level Competencies

• Fostering a Collaborative Workplace Culture

• Cultivate Partnerships

• Develop Self and Others

• Drive Execution

• Influence Others

• Pursue Personal Excellence

• Understand the Business