Financial Operations & Data Analytics Associate

AON PLC; Chesterfield (MO); On-site; USD 55,000 - 65,000; Full time

Benefits offered by this job

PTO & paid holidays

401(k) with match

Health & wellness programs

Exclusive discount programs

PeopleFirst culture

Job summary

NFP is seeking a data analytics professional in Missouri to coordinate and deliver recurring reports, dashboards, and operational analytics. You will clean and prepare healthcare data, collaborate across analytics, product, clinical, and operations teams, and respond to data requests with proper validation.

The role emphasizes data quality, documentation, and communication of findings to both technical and nontechnical stakeholders.

Qualifications

• Education: High School Diploma required; Bachelor’s degree in Data Analytics, Information Systems, or related field preferred.
• Experience: 0–1 year of experience in data entry, reporting, or analytics preferred
• Coding Languages & Querying: Python, SQL, DAX, Power Query (M), VBA
• Libraries & Analytics: Pandas, NumPy, OpenPyxl
• Databases & Platforms: Snowflake, Microsoft SQL Server, Microsoft Fabric
• Data Prep & ETL: Data Cleansing, Data Validation, Data Transformation, Data Normalization, Data Merging
• BI Platforms: Microsoft Power BI (Desktop & Service), Tableau, Microsoft Fabric
• Spreadsheet Engineering: Advanced Excel, PivotTables, Complex Formulas, Power Query
• Deliverables: Interactive Dashboards, Executive Reporting, KPI Development, Data Storytelling, Report Optimization

Responsibilities

• Coordinate the day-to-day production, delivery, and maintenance of recurring reports, dashboards, and operational reporting products.
• Clean, format, organize, and prepare healthcare, pharmacy benefit, operational, and client data for reporting and analysis.
• Collaborate with analytics, product, clinical, account management, and operations teams to gather requirements, clarify business rules, and support new or enhanced reporting products.
• Respond to internal data requests and complete ad hoc reporting and research with appropriate oversight, documentation, and validation.
• Maintain reporting procedures, data dictionaries, quality-control checklists, issue logs, and version-controlled templates.
• Apply healthcare and clinical context when reviewing data, recognizing unusual patterns, and communicating potential concerns to the appropriate subject-matter experts.
• Communicate findings, status updates, risks, and process changes clearly to technical and nontechnical stakeholders and support hypercare.
• Project work in support of CRM and accounting system maintenance and integrations.

Skills

Python

SQL

Power Query

DAX

Pandas

Excel

Education

High School Diploma

Bachelor’s degree in Data Analytics or related field

Tools

Snowflake

Microsoft SQL Server

Microsoft Fabric

Power BI

Tableau

Excel

Job description

NFP is seeking a data analytics professional in Missouri to coordinate and deliver recurring reports, dashboards, and operational analytics. You will clean and prepare healthcare data, collaborate across analytics, product, clinical, and operations teams, and respond to data requests with proper validation.

The role emphasizes data quality, documentation, and communication of findings to both technical and nontechnical stakeholders.