Financial Operations 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

Posting Description

Who We AreNFP, an Aon Company, is a multi-year Best Places to Work award winner in BusinessInsurance. We are an organization of consultative advisors and problem solvers. We help companies and individuals around the globe address their most significant risk, workforce, wealth management and retirement challenges through custom solutions and a people-first approach. To learn more, please visit: https://www.NFP.com.

Principal Duties and Responsibilities /Essential Functions:

• 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.

Minimum Requirements for Education, Experience, and Certifications/Licenses:

• 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

Qualifications & Skills:

• Quality Assurance & Detail Orientation: Demonstrated ability to perform detailed reviews, identify inconsistencies, maintain accurate records, and follow controlled processes.
• Process Improvement: Ability to evaluate current workflows, identify inefficiencies or error risks, and implement practical improvements that strengthen quality and timeliness.
• Communication: Communicates clearly and professionally in writing and verbally with technical teams, business partners, and leaders.
• Documentation & Organization: Ability to maintain clear procedures, requirements, audit trails, schedules, and version-controlled reporting materials.
• Learning Agility: Initiative to expand technical and business knowledge, resolve roadblocks, and adapt prior expertise to new reporting and analytics responsibilities.
• Perseverance & Resiliency: Ability to manage competing priorities, follow through on commitments, meet deadlines, and remain effective during change or periods of high demand.
• Quantitative Skills: Ability to apply percentages, ratios, addition, subtraction, multiplication, division, and reasonableness testing in reporting and quality-control activities.

What We Offer

We're proud to offer a competitive salary, PTO & paid holidays, 401(k) with match, exclusive discount programs, health & wellness programs, and more. Our PeopleFirst culture focuses on building and nurturing lifelong relationships with our employees because, at the end of the day, we exist to be there for others. The base salary range for this position is $55,000 – $65,000. The base salary offered will be determined by factors including, but not limited to, experience, credentials, education, certifications, skill level required for the position, the scope of the position, and geographic location. Actual base salary offered will be determined on a case‑by‑case basis.

NFP and You... Better Together!

NFP is aninclusive Equal Employment Opportunity employer.

#NFP