Data Analyst, Investment Professional

Nationwide Mutual Insurance Company; Columbus (OH); On-site; USD 119,000 - 199,000; Full time

Benefits offered by this job

401(k) with company match

Pension plan

Paid time off

Holidays

Job summary

Nationwide Mutual Insurance Company seeks an experienced Investment Professional Data Analyst to shape how data informs investment decisions. You will build analytic data products powering front‑office dashboards, AI workflows, and quantitative tools within a multi‑billion dollar portfolio environment.

You will collaborate across teams to design data structures, ensure governance, and deliver scalable data pipelines using Snowflake, Databricks, and Python-based analytics.

Qualifications

• Proven advanced SQL and data‑modeling capability with experience building complex queries and robust analytical data models.
• Hands‑on experience with Snowflake and Databricks.
• Practical Python skills for data engineering/analytics (pandas, PySpark).
• Experience publishing reusable datasets to BI tools with performance tuning.
• Familiarity with data governance, lineage, and version control.

Responsibilities

• Design curated analytic data structures and shared business logic in partnership with Data Governance and Data Management.
• Provide controlled, reusable data access through SQL, APIs, and related interfaces for quantitative analysts and portfolio managers.
• Build and maintain analytics and semantic layer supporting front‑office dashboards and quantitative tools.
• Monitor and improve data quality, consistency, and documentation of analytical data and reports.
• Collaborate with Technology to align analytics layer with enterprise architecture including Snowflake, Databricks and Aladdin.
• Build analytics‑ready datasets and reusable data products for reporting and evolving AI workflows; avoid one‑offs.

Skills

Advanced SQL

Data modeling

Snowflake

Databricks

Python (pandas/PySpark)

BI dataset design

Version control (Git)

Data governance

Education

Bachelor’s degree in computer science / related field

Advanced degree or certifications

Tools

Snowflake

Databricks

Power BI/Tableau

Job description

As a team member in Finance at Nationwide, a Fortune 100 company with nearly $70 billion in annual sales, the opportunities are endless! Let Nationwide help create your career journey! At Nationwide®, “on your side” goes beyond just words. Our customers are at the center of everything we do and we’re looking for associates who are passionate about delivering extraordinary care.

Location & Schedule

The hired associate must reside within 35 miles of the following location: Columbus: One Nationwide Plaza, Columbus OH, 43215. Work schedule: 2 days in office, 3 days remote. This role does not qualify for employer sponsored work authorization. Nationwide does not participate in the STEM OPT extension program.

Job Description Summary

Do you thrive on making sense of complex data and transforming it into insight that drives business impact? Are you energized by working at the crossroads of analytics, technology, and investment strategy? If solving challenging data problems in a highly collaborative, mission-driven environment excites you, this is the job for you. As a Consultant, Investment Professional Data Analyst, you will play a critical role in shaping how Nationwide Investments leverages data to deliver smarter, faster, and more consistent decisions. You’ll build the analytic structures and reusable data products that power front‑office dashboards, AI‑driven workflows, and quantitative tools. You’ll apply your technical expertise and collaborate with your team to design high‑impact solutions that matter in a multi‑billion‑dollar investment portfolio environment.

Responsibilities

• Design curated analytic data structures and shared business logic, including sectors, ratings, strategy tags, benchmarks, and other core dimensions, in partnership with Data Governance and Data Management.
• Provide controlled, reusable data access through SQL, APIs, and related interfaces for quantitative analysts, portfolio manager, enterprise portfolio managers, reporting teams, enabling a consistent source of truth for investment analytics.
• Build and maintain the analytics and semantic layer that supports front‑office dashboards, quantitative tools, and research workflows.
• Monitor and improve the quality, consistency, and documentation of analytical data and reports that sit on top of enterprise golden sources.
• Support data needs for AI and agentic workflows in a governed, auditable way, including input/output structuring and data persistence.
• Collaborate with Technology and platform teams to align the analytics layer with enterprise architecture, including Snowflake, Databricks, and Aladdin.
• Support continuous improvement of data, tooling, and reporting processes across the investment analytics function.
• Build analytics‑ready datasets and reusable data products for reporting, research, quantitative models, and evolving AI‑enabled workflows, rather than one‑off extracts or bespoke data pulls.
• Apply automation and AI‑enabled techniques where appropriate to improve data ingestion, tagging, reconciliation, anomaly detection, metadata capture, and documentation, with human review and appropriate controls.
• Help improve coding, testing, version‑control, and documentation practices for the production of data pipelines, analytical datasets, and related workflow tools.
• Design data assets and interfaces that are explainable, documented, and reusable across front office teams, while reducing manual spreadsheet‑based processing and redundant logic.
• Support the evolution of the investment analytics architecture by ensuring data structures, mappings, and lineage are compatible with changing enterprise platforms, workflows, and future‑state needs.
• Contribute to a collaborative team environment that emphasizes experimentation, shared tooling, documentation, and continuous improvement across data and analytics processes.
• May perform other responsibilities as assigned.

Reporting Relationships

Reports to leader of Investment Analytics. This is an individual contributor role.

Typical Skills and Experiences

• Education: Bachelor’s degree in computer science, information systems, data analytics, mathematics, engineering, or a related field preferred. Advanced degree or relevant certifications preferred.
• Experience: Typically, eight or more years’ experience building and supporting analytical data, business intelligence, or investment data environments. Experience working with enterprise data warehouses, analytical reporting, and reusable data models in a complex business setting is preferred. Experience in financial services, asset management, insurance, or capital markets is desirable. Experience supporting AI‑enabled analytics, analytics engineering workflows, or governed automation in an enterprise environment is preferred.
• Knowledge, Abilities and Skills: Proven advanced SQL and data‑modeling capability with experience building complex queries and robust analytical data models. Hands‑on experience with Snowflake and comfort working in modern analytics environments such as Databricks. Practical Python skills for data engineering and analytics (pandas, PySpark, or similar). Demonstrated experience designing and maintaining analytics or semantic layers for BI and quantitative use cases. Experience publishing reusable datasets to BI tools such as Power BI/Tableau, including dataset design and performance tuning. Working familiarity with investment data structures such as positions, transactions, benchmarks, and reference data. Understanding of data governance, lineage, quality monitoring, and version control practices. Ability to work cross‑functionally and communicate technical concepts clearly. Familiarity with automation or AI‑enabled data workflow techniques with human oversight. Knowledge of software engineering practices relevant to analytics environments, including Git, pull requests, and documentation. Ability to balance speed, control, transparency, and maintainability. Curiosity and comfort in tech‑evolving team environments.
• Staffing exceptions to the above must be approved by the hiring manager’s leader and HR Business Partner. Other criteria, including leadership skills, competencies and experiences may take precedence. Staffing exceptions to the above must be approved by the hiring manager’s leader and Human Resource Business Partner.

Values

Regularly and consistently demonstrates Nationwide Values.

Regularly and consistently demonstrates Nationwide Values.

Job Conditions

Overtime Eligibility: Exempt

Working Conditions: Normal office environment.

ADA: The above statements cover what are generally believed to be the principal and essential functions of this job. Specific circumstances may allow or require some people assigned to the job to perform a somewhat different combination of duties.

Benefits

• medical/dental/vision
• life insurance
• short and long term disability coverage
• paid time off with newly hired associates receiving a minimum of 18 days paid time off each full calendar year pro‑rated quarterly based on hire date
• nine paid holidays
• 8 hours of Lifetime paid time off
• 8 hours of Unity Day paid time off
• 401(k) with company match
• company‑paid pension plan
• business casual attire
• and more

Equal Opportunity

Nationwide is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive culture where everyone feels challenged, appreciated, respected and engaged. Nationwide prohibits discrimination and harassment and affords equal employment opportunities to employees and applicants without regard to any characteristic (or classification) protected by applicable law.

NOTE TO EMPLOYMENT AGENCIES

We value the partnerships we have built with our preferred vendors. Nationwide does not accept unsolicited resumes from employment agencies. All resumes submitted by employment agencies directly to any Nationwide employee or hiring manager in any form without a signed Nationwide Client Services Agreement on file and search engagement for that position will be deemed unsolicited in nature. No fee will be paid in the event the candidate is subsequently hired as a result of the referral or through other means.

Nationwide pays on a geographic‑specific salary structure and placement within the actual starting salary range for this position will be determined by a number of factors including the skills, education, training, credentials and experience of the candidate; the scope, complexity and location of the role as well as the cost of labor in the market; and other conditions of employment. If a Sales job, Sales Incentives, based on performance goals are possible in addition to this range. Note on Compensation for Part‑Time Roles: Please be aware that the salary ranges listed below reflect full‑time compensation. Actual compensation may be prorated based on the number of hours worked relative to a full‑time schedule.

Compensation

The national salary range for Investment Professional - Data Analyst : $119,000.00-$199,000.00

The expected starting salary range for Investment Professional - Data Analyst : $119,000.00-$199,000.00

Additional Information

To learn more about the benefits we offer.

At Nationwide, we find purpose in protecting people, businesses and futures with extraordinary care – and we’ve been doing that since 1926. Our financial strength and caring culture extend beyond our associates into the communities we serve. You really can feel the difference at Nationwide, which is why we continue to be named one of the Fortune 100 Best Companies To Work For.