Data Analyst II PowerBI, SQL

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

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