Financial Operations Associate

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

Benefits offered by this job

PTO & paid holidays

401(k) with match

Exclusive discount programs

Health & wellness programs

Job summary

NFP, an Aon Company, seeks a data analytics professional to coordinate reports and dashboards, clean healthcare data, and collaborate across analytics, product, clinical, and operations teams.

The role requires 0-1 year in data analytics, proficiency in Python/SQL/DAX, and strong Excel skills. Expect responsible data governance and strong communication to stakeholders.

Qualifications

• Education: High School Diploma required; Bachelor's degree preferred in data analytics or related field.
• 0-1 year of experience in data entry, reporting, or analytics.
• Proficient in Python, SQL, DAX, Power Query (M), and VBA.
• Familiar with Pandas, NumPy, OpenPyxl.
• Experience with Snowflake, Microsoft SQL Server, and Microsoft Fabric.
• Data prep, ETL, cleansing, validation, and transformation.
• BI platforms: Power BI, Tableau; Excel advanced skills incl. PivotTables.
• Deliverables: interactive dashboards, KPI development, data storytelling.

Responsibilities

• Coordinate day-to-day production and delivery of dashboards and reports.
• Prepare and clean healthcare, pharmacy benefit, and client data for analysis.
• Collaborate with analytics, product, clinical, and ops teams to gather requirements.
• Respond to data requests with validation and proper documentation.
• Maintain data dictionaries, QC checklists, and versioned templates.
• Review data with healthcare context and communicate findings to stakeholders.
• Support CRM and accounting system maintenance and integrations.

Skills

Python

SQL

DAX

Power Query

VBA

Pandas

NumPy

OpenPyxl

Excel

PivotTables

Data Visualization

Education

Bachelor's degree in Data Analytics or Information Systems

Tools

Snowflake

Microsoft SQL Server

Microsoft Fabric

Power BI

Tableau

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

• PTO & paid holidays
• 401(k) with match
• exclusive discount programs
• health & wellness programs

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