Senior Data Analyst, Investment Professional

Nationwide; Columbus (OH); On-site; USD 127,000 - 213,000; Full time

Benefits offered by this job

Medical/dental/vision

Life insurance

Disability insurance

PTO & holidays

401(k) with company match

Job summary

Nationwide, a Fortune 100 company, is seeking an Investment Professional Data Analyst to shape how data drives front-office decisions in a multi-billion-dollar investment portfolio. You will design analytics structures, power front-office dashboards, and develop reusable data products that accelerate research and AI-enabled workflows.

You will collaborate with Data Governance and Tech teams to ensure scalable, auditable data pipelines, with strong SQL, Python, and BI tool expertise.

Qualifications

• Proven advanced SQL and data-modeling capability with experience building complex queries and robust analytical data models.

Responsibilities

• Design curated analytic data structures and shared business logic for core dimensions in partnership with Data Governance and Data Management.
• Provide controlled, reusable data access through SQL, APIs, and related interfaces for quantitative analysts and reporting teams.
• 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.
• Support data needs for AI and agentic workflows with governance and auditing.
• Collaborate with Technology to align analytics with enterprise architecture (Snowflake, Databricks, Aladdin).
• Build analytics-ready datasets and reusable data products for reporting, research, and evolving AI workflows.
• Apply automation and AI-enabled techniques to improve data ingestion, tagging, reconciliation, and metadata capture.

Skills

SQL

Data modeling

Python

Power BI/Tableau

Data governance

Git

Automation/AI workflows

Communication

Education

Bachelor’s degree

Advanced degree or certifications

Tools

Snowflake

Databricks

Job description

Job Conditions
Overtime Eligibility: Exempt

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.
The hired associate must reside within 35 miles of the following location:
Columbus: One Nationwide Plaza, Columbus OH, 43215
Work schedule: 3 days in office, 2 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.
Job Description

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

Job Conditions

Overtime Eligibility: Exempt

Working Conditions: Normal office environment.

Values: Regularly and consistently demonstrates Nationwide Values.

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

We have an array of benefits to fit your needs, including: 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. To learn more about the benefits we offer, click here.

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.

The national salary range for Investment Professional - Data Analyst : $127,000.00-$213,000.00

The expected starting salary range for Investment Professional - Data Analyst : $127,000.00-$213,000.00