Position Overview & Specifications
This is Data Solutions with Purpose! Bring your deep knowledge of financial reporting, and strong data skills to our state-of-the-art Databricks platform and join us as we change lives – together! This role focuses upon financial subjects within the health insurance industry: Claims, membership, eligibility, and financial accounting. You will work closely with both our business partners and engineers to design, test, and report from datasets that impact the lives of millions of members within a dynamic, growing organization!
Job Summary
The Data Solutions Analyst II blends two related functions: Data Warehousing (including ETL, development, testing, and ad-hoc reporting, and Business Analytics (including requirements gathering, analysis, presentation).
Essential Functions
Participate in the full life cycle of data and analytic solutions, broadly from requirements through ETL, production, consumption, and ad-hoc reporting. Including:Develop end-to-end data warehouse / data mart solutions, utilizing Databricks and Microsoft technologiesDevelop expertise on one or more insurer-specific data / workflows, such as claims, care management (CM), utilization management (UM), eligibility, and population healthPartner with stakeholders in product ideation, requirements gathering, data reviews, troubleshootingDevelop 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 requirements
Education And Experience
Bachelor's degree in computer science, engineering, mathematics, a related field, or equivalent combination of education and experience is requiredA minimum of four (4) years’ advanced SQL experience (including data modeling, profiling and cleansing, and building complex data sets) is requiredA minimum of two (2) years’ experience building enterprise data solutions (data warehouses and data marts) is requiredA minimum of two (2) years’ experience building customer facing data solutions (PowerBI, Tableau, Oracle, advanced Excel, etc.) is requiredA 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 layersProficient 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 SparkSQLWorking knowledge of PythonPython-specific data modeling skill supporting data transformation and data scienceKnowledge of common healthcare data domains and processes (patient registry, billing, diagnosis, procedure codes)Healthcare insurance-specific domains, such as claims (medical and pharmacy), health information exchange (HIE), utilization management (UM), demographicsProficient with the Microsoft 365 suite, including extensive use of Teams, SharePoint, and ExcelGood written and verbal communication skills
Licensure And Certification
Relevant Microsoft certifications (SQL, PowerBI, Azure) is preferredDatabricks 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
Salary
Job Summary
The Data Solutions Analyst II blends two related functions: Data Warehousing (including ETL, development, testing, and ad-hoc reporting, and Business Analytics (including requirements gathering, analysis, presentation).
Essential Functions
Participate in the full life cycle of data and analytic solutions, broadly from requirements through ETL, production, consumption, and ad-hoc reporting. Including:Develop end-to-end data warehouse / data mart solutions, utilizing Databricks and Microsoft technologiesDevelop expertise on one or more insurer-specific data / workflows, such as claims, care management (CM), utilization management (UM), eligibility, and population healthPartner with stakeholders in product ideation, requirements gathering, data reviews, troubleshootingDevelop 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 requirements
Education And Experience
Bachelor's degree in computer science, engineering, mathematics, a related field, or equivalent combination of education and experience is requiredA minimum of four (4) years’ advanced SQL experience (including data modeling, profiling and cleansing, and building complex data sets) is requiredA minimum of two (2) years’ experience building enterprise data solutions (data warehouses and data marts) is requiredA minimum of two (2) years’ experience building customer facing data solutions (PowerBI, Tableau, Oracle, advanced Excel, etc.) is requiredA 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 layersProficient 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 SparkSQLWorking knowledge of PythonPython-specific data modeling skill supporting data transformation and data scienceKnowledge of common healthcare data domains and processes (patient registry, billing, diagnosis, procedure codes)Healthcare insurance-specific domains, such as claims (medical and pharmacy), health information exchange (HIE), utilization management (UM), demographicsProficient with the Microsoft 365 suite, including extensive use of Teams, SharePoint, and ExcelGood written and verbal communication skills
Licensure And Certification
Relevant Microsoft certifications (SQL, PowerBI, Azure) is preferredDatabricks 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
Salary