Data Analyst II
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.
Must be authorized to work in the U.S. without the need for employment-based visa sponsorship now or in the future. Sponsorship and future sponsorship are not available for this opportunity, including employment-based visa types H-1B, L-1, O-1, H-1B1, F-1, J-1, OPT, or CPT
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
• Collect, cleanse, reconcile, validate and support ongoing processes and programs to support business needs. May include financial, claims, provider, member, clinical, quality, and compliance data
• Create and automate ETL processing through development of SQL-based stored procedures and SSMS
• Create and generate reports through SQL using Power BI interface and direct links to core databases (Teradata and Snowflake)
• May include 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 related field or equivalent experience. 2+ years of statistical analysis or data analysis experience or 1+ years of related IT experience, including data warehouse, coding or ETL experience. Power BI, Advanced SQL preferred. Snowflake and Teradata experience preferred. SSIS/SSMS experience preferred.
By applying to this requisition, you acknowledge and understand that you may be considered for other job opportunities for which Centene believes you may be qualified
Pay Range: $56,200.00 - $101,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
Apply tot his job
Apply To this Job
Must be authorized to work in the U.S. without the need for employment-based visa sponsorship now or in the future. Sponsorship and future sponsorship are not available for this opportunity, including employment-based visa types H-1B, L-1, O-1, H-1B1, F-1, J-1, OPT, or CPT
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
• Collect, cleanse, reconcile, validate and support ongoing processes and programs to support business needs. May include financial, claims, provider, member, clinical, quality, and compliance data
• Create and automate ETL processing through development of SQL-based stored procedures and SSMS
• Create and generate reports through SQL using Power BI interface and direct links to core databases (Teradata and Snowflake)
• May include 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 related field or equivalent experience. 2+ years of statistical analysis or data analysis experience or 1+ years of related IT experience, including data warehouse, coding or ETL experience. Power BI, Advanced SQL preferred. Snowflake and Teradata experience preferred. SSIS/SSMS experience preferred.
By applying to this requisition, you acknowledge and understand that you may be considered for other job opportunities for which Centene believes you may be qualified
Pay Range: $56,200.00 - $101,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
Apply tot his job
Apply To this Job