Financial Operations Associate

NFP, an Aon company; Chesterfield (MO); On-site; USD 55,000 - 65,000; Full time

Benefits offered by this job

PTO & Holidays

401(k) with match

Health & wellness programs

Discount programs

Job summary

NFP, an Aon Company, is seeking a data analytics professional to coordinate reporting, data preparation, and dashboard delivery for healthcare and client data.

You will collaborate with analytics, product, clinical, account teams to gather requirements and deliver interactive dashboards while ensuring data quality in a fast-paced environment. This role offers a competitive salary, PTO, and 401(k) with match.

Qualifications

• Education: High School Diploma required; Bachelor's degree preferred.
• Experience: 0-1 year in data entry, reporting, or analytics preferred.
• Coding: Python, SQL, DAX, Power Query (M), VBA.
• Libraries: Pandas, NumPy, OpenPyxl.
• Databases/Platforms: Snowflake, MS SQL Server, Microsoft Fabric.
• BI/Reporting: Power BI, Tableau, Microsoft Fabric; Excel advanced.

Responsibilities

• Coordinate day-to-day production, delivery, and maintenance of reports and dashboards.
• Prepare healthcare, pharmacy benefits, and client data for reporting and analysis.
• Gather requirements with analytics, product, clinical, account teams.
• Respond to internal data requests and complete ad hoc reporting.
• Maintain data dictionaries, quality-control checklists, and templates.
• Apply healthcare context to review data and flag concerns.
• Support CRM and accounting system maintenance and integrations.

Skills

Quality Assurance

Process Improvement

Communication

Documentation

Learning Agility

Perseverance

Quantitative Skills

Education

High School Diploma

Bachelor's in Data Analytics / Info Systems

Tools

Python

SQL

DAX

Power Query

VBA

Pandas

NumPy

OpenPyxl

Snowflake

SQL Server

Microsoft Fabric

Power BI

Tableau

Excel

PivotTables

Formulas

Job description

Posting Description

Who We Are

NFP, an Aon Company, is a multi-year Best Places to Work award winner in Business Insurance. 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 an inclusive Equal Employment Opportunity employer.

#NFP

2588340