Job Summary:
The Data Solutions Engineer I is responsible for bringing knowledge of Data Warehousing (including ETL, development, testing, ad-hoc reporting, and business analysis) to the Finance function and participating in the full life cycle of data and analytic solutions, broadly from requirements through ETL/ELT, production, consumption and ad-hoc reporting.
Essential Functions:
- Assist in the development of 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
- Assist in testing, debugging, and performance tuning 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 one (1) year of data engineering-level SQL experience is required
- A minimum of one (1) year experience building customer facing data solutions (PowerBI, Tableau, Oracle, advanced Excel, etc.) is required
- A minimum of one (1) year experience building enterprise data solutions (data warehouses and data marts) is preferred
- A minimum of one (1) year experience in healthcare data is preferred
Competencies, Knowledge and Skills:
- Demonstrable skills in complex joins, cardinality, aggregations and window functions, common table expressions and object types (including views, stored procedures, user-defined functions, etc.) is required
- Advanced SQL skills, including the ability to contribute to the development and maintenance of systems utilizing contemporary data warehousing patterns including ETL / ELT, fact and dimension modeling, and deploying analytic resources via staging tiers and consumption layers
- Familiar with working with and warehousing data from multiple sources, such as operational data stores (ODS), flat file, EDI/HL7, API, etc.
- Familiar with the Microsoft data ecosystem (SSRS, SSIS, PowerBI)
- Familiar with Azure Databricks and SparkSQL, or similar data lake platforms (Azure Data Lake, Snowflake, Hadoop, etc.)
- Working knowledge of Python, including Python-specific data modeling skill supporting data transformation and data science
- Familiar with common healthcare data domains and processes (patient registry, billing, diagnosis, procedure codes)
- Preferred knowledge of healthcare insurance-specific domains, such as claims (medical and pharmacy), health information exchange (HIE), utilization management (UM), demographics
- Proficient with the Microsoft 365 suite, including extensive use of Teams, SharePoint, and Excel
- Good 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:
$60,300.00 - $96,500.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 (hourly/salary):
Salary
Organization Level Competencies
This job description is not all inclusive. CareSource reserves the right to amend this job description at any time. CareSource is an Equal Opportunity Employer. We are dedicated to fostering an inclusive environment that welcomes and supports individuals of all backgrounds.