Lead Analyst, Business Analytics – Data Engineering
The Cigna Group
ETLOraclePythonScalaSQLSSISTableau
Report Developer IV – LTSS and Dual Eligible Program
CareSource
full-time
Posted on:
Origin: • 🇺🇸 United States
Visit company websiteSalary
💰 $92,300 - $161,600 per year
Job Level
SeniorLead
Tech Stack
ETLPythonSQLSSISTableau
About the role
- Generate complex reports and dashboards to track KPIs and metrics related to LTSS & Dual Program reporting impacting patient care, operational efficiency, and financial performance
- Utilize statistical methods and machine learning techniques to identify trends, forecast future outcomes, and drive actionable insights
- Design and develop dynamic, user-friendly dashboards using business intelligence tools (e.g., Tableau, Power BI) and continuously enhance them to ensure data relevance, accuracy, and timeliness
- Analyze and evaluate current operations processes to identify opportunities for optimization, cost reduction, Case manager effectiveness and improved patient experience
- Recommend strategies for improving operational efficiency and implementing changes to workflows in alignment with business objectives
- Ensure high levels of data accuracy, integrity, consistency, and completeness through effective data governance practices
- Work closely with data engineering teams to ensure data is sourced and integrated from multiple systems with high reliability
- Develop LTSS & Dual Program reporting solutions that are scalable and include efficient database solutions for supporting reporting functionality
- Create ETL solutions for automated, scheduled data refreshes and regular report delivery
- Develop and deploy Power BI dashboards which provide leadership with actionable insights that drive critical business decisions
- Transform data sets and quantitative and qualitative analysis into usable and effective data for department leaders
- Build complex analytic tools that utilize the data pipeline to provide actionable insights, key performance metrics, historical trends, and benchmarks
- Identify, design, and implement internal process improvements, automating manual processes, and optimizing data delivery
- Perform complex analysis on data to provide insight and address critical business questions and present findings in an executive-level format
- Gather and analyze data, define and document business requirements, recommend technology requirements, review functional specs, and test relevant systems
- Develop, document and perform testing and validation as needed and create, implement and enforce coding standards for the team
- Lead and participate in complex, large-effort data transformation and visualization projects requiring cross-functional coordination and collaboration
Requirements
- Bachelor’s degree in Computer Science, MIS, or related field or equivalent years of relevant work experience is required
- Minimum of seven (7) years of experience working with ETL, BI, and database solutions is required
- Experience translating business requirements is required
- Extensive data analysis experience is required
- Relevant healthcare or LTSS and/or Dual Eligible reporting experience is preferred
- Familiarity with LTSS/DSNP data/report regulations is preferred
- Advanced proficiency in data modeling, business intelligence tools, and process optimization strategies
- Advanced proficiency with SQL, SSIS, and Power BI
- Experience designing and developing dashboards using BI tools (e.g., Tableau, Power BI)
- Expert analytical skills and ability to create reports, dashboards and presentations
- Expert proficiency using Microsoft Excel
- Demonstrated graphic development and strong presentation skills
- High level of skill in building analytic tools that utilize the data pipeline
- Advanced proficiency performing root cause analysis
- Knowledge of statistical techniques and concepts; AI or ML preferred
- Experience with DevOps and CI/CD is preferred
- Relevant certification in one or more of the following or related is preferred: Tableau, SQL, SSIS, SSRS, Databricks, Data Engineering, Power BI, Python
- Demonstrated ability to create cohesive, strategic plans for developing complex solutions
- Strong problem solving, communication, and the ability to manage multiple priorities and meet deadlines
