What are the responsibilities and job description for the Data Solutions Engineer III (ETL/Power BI) position at CareSource?
Job Summary :
The Data Solutions Engineer III is responsible for bringing advanced knowledge of Data Warehousing and Business Intelligence (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. This individual role will focus heavily upon Power BI development.
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
- Responsible for the design and development of complex Power BI reports and interactive dashboards
- Create, design and optimize central semantic models using DAX, Power Query, and other Power BI tools to empower end-users to leverage self-service 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
- Leverage Microsoft Fabric personas (Data Engineering, Data Factory, Data Warehouse) to streamline data integration, governance, and reporting, enhancing data-driven decision making.
- 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
- Maintain deep technical and business knowledge of Microsoft Power Platform, keeping up with industry trends
- 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 :
Competencies, Knowledge and Skills :
Licensure and Certification :
Working Conditions :
Compensation Range :
79,800.00 - $127,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 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.
Salary : $79,800 - $127,600