Sql Python Excel Power Bi Tableau Jobs in Milwaukee, WI

Anticipated End Date:

Position Title:

Job Description:

Actuarial Analyst II

Location: This role requires associates to be in-office 1 - 2 days per week, fostering collaboration and connectivity, while providing flexibility to support productivity and work-life balance. This approach combines structured office engagement with the autonomy of virtual work, promoting a dynamic and adaptable workplace. Alternate locations may be considered if candidates reside within a commuting distance from an office.

Please note that per our policy on hybrid/virtual work, candidates not within a reasonable commuting distance from the posting location(s) will not be considered for employment, unless an accommodation is granted as required by law.
The Actuarial Analyst II completes projects and performs complex actuarial studies.

Join a high-impact team driving advanced analytics and actuarial innovation across Local Group, Individual, Medicaid, and Medicare lines of business. The Trend Insight Innovations team is pioneering the use of weekly trend data, predictive analytics, AI-enabled insights, and multi-source health indicators to anticipate future health cost drivers and enable faster, smarter business decisions. We are modernizing how emerging cost drivers are detected and communicated to support critical decisions for executive, actuarial, financial, and other key business stakeholders.
How you will make an impact:

• Obtains, verifies, analyzes and models data including risk reporting and forecasting.
• Analyze and monitor weekly incurred claims, paid claims, pharmacy, lab, and authorization data to identify cost drivers, data anomalies, and emerging trends. Perform validation, reconciliation, and reasonability checks to ensure weekly trend reporting is accurate, reliable, and appropriately interpreted.
• Develop and support actuarial studies using large, complex datasets to evaluate health claim activity, emerging cost pressures, and key drivers such as utilization shifts, unit cost, mix, seasonality, and claims lag.
• Investigate new data sources and potential KPIs by assessing data quality, relevance, limitations, and business interpretability, while contributing to integration efforts and enhancements to the Leading Indicator dashboard tool.
• Assist in building and refining predictive models, analytical frameworks, early-warning systems, dashboards, and automated reporting processes used to monitor and anticipate future health cost trends across multiple lines of business.
• Translate complex data insights into clear, actionable intelligence for actuarial, health cost management, finance, and other business partners.
• Prepare summaries, exhibits, visualizations, and executive-level reporting used to communicate key findings, inform cost management strategies, support financial planning, and assist with quarterly earnings preparation.
• Collaborate with actuaries, data scientists, and business partners to improve the interpretability, automation, and visual storytelling of complex trend data.

Minimum Requirements: Requires a BA/BS degree and to have passed a minimum of three Society of Actuaries (SOA) or Casualty Actuarial Society (CAS) actuarial exams and a minimum of 1 year related experience; or any combination of education and experience, which would provide an equivalent background.
Preferred Skills, Capabilities and Experiences:

• Experience using Snowflake, SQL, Python, Excel, Power BI, Tableau, or similar tools for data extraction, manipulation, statistical analysis, reporting, and visualization.
• Experience working with large claims datasets, healthcare cost metrics, utilization metrics, or other healthcare data sources.
• Strong attention to detail and problem-solving ability, including the ability to validate results, identify data anomalies, investigate unexpected trend changes, and explore unfamiliar data sources.
• Developing ability to apply actuarial judgment, statistical techniques, and business context to interpret complex trends and distinguish meaningful signals from normal variation.
• Ability to translate analytical findings into clear, concise insights for both technical and non-technical audiences.
• Curiosity and developing proficiency in using approved AI-enabled tools and automation techniques to improve analytical efficiency, reporting, and business outcomes.

Job Level:

Workshift:

Job Family:

Please be advised that Elevance Health only accepts resumes for compensation from agencies that have a signed agreement with Elevance Health. Any unsolicited resumes, including those submitted to hiring managers, are deemed to be the property of Elevance Health.

Who We Are

Elevance Health is a health company dedicated to improving lives and communities - and making healthcare simpler. We are a Fortune 25 company with a longstanding history in the healthcare industry, looking for leaders at all levels of the organization who are passionate about making an impact on our members and the communities we serve.

How We Work

At Elevance Health, we are creating a culture that is designed to advance our strategy but will also lead to personal and professional growth for our associates. Our values and behaviors are the root of our culture. They are how we achieve our strategy, power our business outcomes and drive our shared success - for our consumers, our associates, our communities and our business.

We offer a range of market-competitive total rewards that include merit increases, paid holidays, Paid Time Off, and incentive bonus programs (unless covered by a collective bargaining agreement), medical, dental, vision, short and long term disability benefits, 401(k) +match, stock purchase plan, life insurance, wellness programs and financial education resources, to name a few.

Elevance Health operates in a Hybrid Workforce Strategy. Unless specified as primarily virtual by the hiring manager, associates are required to work at an Elevance Health location at least once per week, and potentially several times per week. Specific requirements and expectations for time onsite will be discussed as part of the hiring process.

The health of our associates and communities is a top priority for Elevance Health. We require all new candidates in certain patient/member-facing roles to become vaccinated against COVID-19 and Influenza. If you are not vaccinated, your offer will be rescinded unless you provide an acceptable explanation. Elevance Health will also follow all relevant federal, state and local laws.

Elevance Health is an Equal Employment Opportunity employer, and all qualified applicants will receive consideration for employment without regard to age, citizenship status, color, creed, disability, ethnicity, genetic information, gender (including gender identity and gender expression), marital status, national origin, race, religion, sex, sexual orientation, veteran status or any other status or condition protected by applicable federal, state, or local laws. Applicants who require accommodation to participate in the job application process should submit the following form: Accessibility Accommodation Request Form and a member of the team will be in contact. Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state, and local laws, including, but not limited to, the Los Angeles County Fair Chance Ordinance and the California Fair Chance Act.

Prospective employees required to be screened under Florida law should review the education and awareness resources at HB531 | Florida Agency for Health Care Administration.

NOTE: Workday keeps job postings active through 11:59:59 PM on the day before the listed end date. Example: If the end date is 3/13, the posting will automatically come down on 3/12 at 11:59:59 PM. In other words - the job is posted until 3/13, not through 3/13.