Centene Corporation Actuarial Analyst - SQL/Excel in Charlotte, North Carolina
You could be the one who changes everything for our 25 million members. Centene is transforming the health of our communities, one person at a time. As a diversified, multi-national organization, you’ll have access to competitive benefits including a fresh perspective on workplace flexibility.
Support all aspects of the regulatory Actuarial & Financial Reporting for existing and new lines of Medicaid business. Actuarial Financial reports entail categorizing utilization, medical expense, premium, and administrative expenses across types of service, lines of business, rate cohorts, and other state specific criteria.
In this Actuarial Analyst role, you will:
This Actuarial Analyst position is an ideal fit for candidates who desire to expand both their technical skillsets (SQL/Excel) and actuarial/financial reporting and health insurance knowledge.
Ensure that all regulatory Actuarial Financial reports, supplemental reports, and audits (where applicable) are accurate, in compliance with applicable regulations, have appropriate sign off, and are submitted on time.
Ensure that all reports are reconciled to the general ledger, encounter data, and/or audited financial statements.
Work collaboratively with Market, Accounting, Actuarial, Medical Economics and other departments to understand and gather the financial data required to produce the required regulatory reports.
Use tools to develop processes and implement procedures for gathering, categorizing, and allocating claim and financial data. Sources and tools include but not limited to data warehouse tables, Medical Economics data, Actuarial data, Access Databases, SQL, SAS and Excel spreadsheets.
Proactively work with Accounting, Actuarial, and Market departments to ensure that financial data is recorded correctly in the reports.
Our Comprehensive Benefits Package:
Flexible work solutions including remote options, hybrid work schedules and dress flexibility
Paid Time Off including paid holidays
Health insurance coverage for you and dependents
401(k) and stock purchase plans
Tuition reimbursement and best-in-class training and development
Bachelor’s degree or equivalent experience.
0-3 years of actuarial experience.
Passed one actuarial exam.
Within our actuarial department, your talents and skills will be challenged, recognized and rewarded. We are a pay-for-performance environment that promotes employees based on talent and contribution. In order to maintain our tremendous growth in this space, our over 400 member Actuary team is growing. Located across the country, this team uses:
Technical skills to build leading edge models, predict outcomes and assess future impacts
Business skills to develop strategy with senior leadership
Personal skills to interact with state, federal and private employer customers
Management skills to organize cross department projects
Areas of focus within our Actuarial Department includes: Medicare / Medicaid / Marketplace / Commercial / Risk Adjustment / Reserving / Actuarial Analytics / Value-Based Care / Actuarial Reporting / Health Policy
Centene Corporation, a FORTUNE 25 company, is the leading multi-national healthcare enterprise committed to helping people live healthier lives. We are revolutionizing the world of healthcare through digital transformation. Our world class teams use collective innovation to turn visions into action and challenge what is possible.
We are an industry leader with a local focus and a global vison:
Listed on FORTUNE magazine’s World’s Most Admired Companies List for 2nd consecutive year.
Ranked No.2 on the FORTUNE 500 Measure Up Initiative, a new benchmark to identify companies building inclusive and fair workplaces.
National footprint in all 50 states, serving 1 in 15 individuals in the U.S.
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.
TITLE: Actuarial Analyst - SQL/Excel
LOCATION: Charlotte, North Carolina