Demo

Data Solutions Engineer III (ETL/Power BI)

CareSource
Dayton, OH Full Time
POSTED ON 1/13/2025
AVAILABLE BEFORE 4/7/2025

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 :

  • 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' of experience in data analysis, BI development (including data modeling, profiling and cleansing, and building complex data sets) is required
  • A minimum of five (5) years' experience building customer facing reporting 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 :

  • Proven analytic skills in solving multi-dimensional problems and experience in creating reports, models, dashboards and presentations to senior leadership and business partners
  • Ability to lead data visualization and modeling efforts
  • Proficiency with the Microsoft Power Platform ecosystem (Power BI, Power Apps, Power Automate) and wire-framing tools
  • Proficiency with Azure Databricks and SparkSQL, or similar data lake platforms (Azure Data Lake, Snowflake, Hadoop, etc.)
  • Advanced programming skills (DAX, M Query, SQL and Excel)
  • Experience with Microsoft Fabric is preferred
  • Proficiency with cloud tools such as Azure Databricks is a plus
  • 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 :

    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

  • Create an Inclusive Environment
  • Cultivate Partnerships
  • Develop Self and Others
  • Drive Execution
  • Influence Others
  • Pursue Personal Excellence
  • Understand the Business
  • 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

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Data Solutions Engineer III (ETL/Power BI)?

    Sign up to receive alerts about other jobs on the Data Solutions Engineer III (ETL/Power BI) career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $89,551 - $118,439
    Income Estimation: 
    $116,726 - $151,072
    Income Estimation: 
    $124,724 - $161,246
    Income Estimation: 
    $71,122 - $96,652
    Income Estimation: 
    $92,929 - $122,443
    Income Estimation: 
    $92,929 - $122,443
    Income Estimation: 
    $122,257 - $154,284
    Income Estimation: 
    $122,257 - $154,284
    Income Estimation: 
    $143,391 - $179,890
    Income Estimation: 
    $168,522 - $211,152
    Income Estimation: 
    $189,259 - $248,928
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at CareSource

    CareSource
    Hired Organization Address Dayton, OH Full Time
    Job Summary: The Print Production Analyst III manages print and mail projects with varying degrees of complexity, and ex...
    CareSource
    Hired Organization Address Dayton, OH Full Time
    Job Summary The Employee Experience Specialist II is responsible for supporting the design and implementation of perform...
    CareSource
    Hired Organization Address Dayton, OH Full Time
    Job Summary The Print Production Analyst III manages print and mail projects with varying degrees of complexity, and exe...
    CareSource
    Hired Organization Address Dayton, OH Full Time
    Job Summary : The Employee Experience Specialist II is responsible for supporting the design and implementation of perfo...

    Not the job you're looking for? Here are some other Data Solutions Engineer III (ETL/Power BI) jobs in the Dayton, OH area that may be a better fit.

    Data Engineer

    Navia Benefit Solutions, Moraine, OH

    Data Center Engineer

    INSPYR Solutions, Vandalia, OH

    AI Assistant is available now!

    Feel free to start your new journey!