Data Analyst II PowerBI, SQL

Overview

Remote
USD 55,100.00 - 99,000.00 per year
Full Time

Skills

Analytical Skill
Data Modeling
Health Care Administration
Data Collection
Finance
Pharmacy
HEDIS
Reporting
Data Cleansing
Trend Analysis
Health Care
Business Objects
ODS
Training
Statistics
Data Analysis
Writing
Data Manipulation
Stored Procedures
Query Optimization
Performance Tuning
Normalization
Microsoft Excel
SQL
Microsoft Visual Studio
Microsoft SSIS
Microsoft Power BI
Management
Database
Data Warehouse
Snow Flake Schema
Secure Shell
WinSCP
FileZilla
Command-line Interface
SFTP
Health Insurance
Forms
Law

Job Details

You could be the one who changes everything for our 28 million members. Centene is transforming the health of our communities, one person at a time. As a diversified, national organization, you'll have access to competitive benefits including a fresh perspective on workplace flexibility.

Remote Available.

Position Purpose:
Responsible for analytical data needs. Handle complex data requests, reports, and predictive data modeling.

  • Analyze health management programs including: data collection, validation and outcome measurement.

  • Financial, pharmacy, claims, provider, and member data.

  • IRS, CMS, HHSC, HEDIS reporting.

  • Internal data cleansing and data reconciliation analysis.

  • Trend analysis in various functional areas of health care management.

  • Create and generate reports through MS-Excel, MS-Access, and SQL using Business Objects interface and direct links to core databases (ODS/EDW).

  • Produce reports for and interface with senior management and internal and external stakeholders.

  • Gather and interpret business requirements and monitor data trends to proactively identify issues.

  • Execute data changes and update core systems as needed.

  • Handle multiple projects and timelines effectively and communicate risks and issues to manager regularly.

  • Assist with training lower level Data Analysts.

  • Performs other duties as assigned.

  • Complies with all policies and standards.

Education/Experience:
Bachelor's degree's related field or equivalent experience. 2+ years of statistical analysis or data analysis experience.

For Nebraska Total Care, the following is required:
  • Proficiency in SQL, writing complex queries, data manipulation, stored procedures, functions, and triggers, query optimization and performance tuning.
  • Understanding of normalization/denormalization and designing relational schemas.
  • Experience with MS-Excel, SQL using Visual Studio, automating jobs with Visual Studio SSIS, Power BI interface and direct links to core databases (EDW/Snowflake).
  • Understanding of how SFTP works. (SSH-based file transfer)
  • Familiarity with tools like WinSCP, FileZilla, or command-line SFTP

Pay Range: $55,100.00 - $99,000.00 per year

Centene offers a comprehensive benefits package including: competitive pay, health insurance, 401K and stock purchase plans, tuition reimbursement, paid time off plus holidays, and a flexible approach to work with remote, hybrid, field or office work schedules. Actual pay will be adjusted based on an individual's skills, experience, education, and other job-related factors permitted by law, including full-time or part-time status. Total compensation may also include additional forms of incentives. Benefits may be subject to program eligibility.

Centene is an equal opportunity employer that is committed to diversity, and values the ways in which we are different. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or other characteristic protected by applicable law.

Qualified applicants with arrest or conviction records will be considered in accordance with the LA County Ordinance and the California Fair Chance Act
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.