Investment Data Analyst

Nationwide•Columbus, OH

1d•$100,000 - $168,000•Hybrid

About The Position

Nationwide is seeking an Investment Data Management professional to translate investment-business needs into reliable, governed data products and business intelligence solutions. The role combines business partnership with hands-on technical delivery across cloud data platforms, data models, reporting tools, and emerging artificial intelligence capabilities. The position supports investment reporting, analytics, operational processes, and self-service business intelligence, while helping improve the reliability and accessibility of data-driven decisions. The associate serves as a primary liaison between business and Technology, translating functional data and analytic requirements into implementable solutions. Responsibilities span intake and planning, requirements gathering, delivery estimates, data strategy, data quality, governance, testing, release coordination, production support, and stakeholder communications. The role also supports the development and maintenance of scalable data pipelines and analytics solutions, particularly using Snowflake, and explores practical AI and machine-learning applications while maintaining security, governance, quality, and human-review expectations. The position is hybrid, with three days in the office and two days remote, and flexibility to come in four days. The hired associate must reside within 35 miles of One Nationwide Plaza in Columbus, Ohio. The role is not eligible for employer-sponsored work authorization; Nationwide does not participate in the STEM OPT extension program. It is an exempt position in a normal office environment and reports to an AVP or Data Leader.

Requirements

Demonstrated experience with SQL, relational data concepts, data modeling, data warehousing, data transformation, and data validation.
Experience with Snowflake and/or Databricks, including cloud data storage, compute, processing, notebooks, jobs, dataflows, or related capabilities.
Experience developing or supporting business intelligence solutions using Power BI, Business Objects, or comparable enterprise reporting and visualization platforms.
Working knowledge of semantic models, reusable datasets, measures, reporting layers, and visualization techniques.
Familiarity with Python or a similar scripting language for automation, analysis, testing, or data-quality tasks.
Ability to learn and apply AI tools and techniques in a controlled, practical, business-focused manner, with attention to data security, governance, accuracy, and human review.
Strong programming skills in Python and SQL.
Practical understanding of cloud data architecture, dimensional modeling, data integration, and orchestration tools.
Strong problem-solving, communication, collaboration, analytical, and decision-making skills; attention to detail and accuracy.
Ability to work independently and as part of a team, adapt to changing technology, build relationships, facilitate meetings, influence others, and set priorities.
Six to ten years of relevant experience with data management organizations, standards, or practices.
Experience engaging business leaders, data architects, and external consultants to identify and fill gaps in data and analytics environments.
Proficiency in data acquisition, data wrangling, and/or data visualization tools and techniques, such as SQL, R, Python, Tableau, or Power BI, and cloud technologies such as Azure or AWS.
Experience in statistical analysis and interpreting results to determine data quality and fitness for purpose.
Undergraduate studies in computer science, management information systems, business, statistics, mathematics, a related field, or comparable experience and education are strongly preferred.
Must reside within 35 miles of One Nationwide Plaza, Columbus, Ohio.
The role does not qualify for employer-sponsored work authorization; Nationwide does not participate in the STEM OPT extension program.

Nice To Haves

Experience supporting investment management, asset management, insurance, financial services, or other data-intensive business processes.
Experience building or supporting enterprise data products, reporting centers of excellence, data dictionaries, governance standards, or self-service analytics capabilities.
Experience modernizing or transitioning reporting and data solutions across legacy and cloud platforms.
Experience explaining technical recommendations and data limitations to business stakeholders and translating business needs into implementable solutions.
Experience with Openflow and Snowflake AI products such as Cortex Code or Cortex Analyst.
Graduate studies in business, statistics, mathematics, computer science, or a related field.
Certifications are encouraged but not required.
Insurance or financial services industry knowledge.

Responsibilities

Design, develop, and maintain data models, curated datasets, semantic models, and data products for investment reporting, analytics, operational processes, and self-service business intelligence.
Build, support, and troubleshoot data pipelines, dataflows, notebooks, jobs, scheduled processes, and integrations; investigate failures, identify root causes, and coordinate remediation.
Define data relationships, business rules, transformations, keys, hierarchies, and measures to produce consistent, reusable data products.
Create and maintain Business Objects universes, reports, scheduled distributions, and related reporting components, and support modernization of legacy reporting capabilities.
Develop and enhance Power BI datasets, semantic models, reports, dashboards, measures, filters, and user experiences in accordance with reporting and analytics standards.
Partner with business users and Technology teams to define requirements, assess source and downstream impacts, document technical designs, estimate work, and sequence delivery through an agile process.
Profile, reconcile, and validate investment data; establish data-quality checks, exception handling, monitoring, and operational procedures.
Support end-to-end testing, including scenario development, data validation, regression testing, User Acceptance Testing, defect triage, release readiness, and post-release verification.
Collaborate with governance, data management, reporting, infrastructure, vendor, and investment-business partners to meet data access, security, control, and audit expectations.
Evaluate and apply AI capabilities responsibly, including AI-assisted documentation, natural-language interaction with data, data-quality monitoring, and summarization.
Communicate technical concepts to audiences with different levels of technical expertise; facilitate working sessions, present recommendations, provide status and risk updates, and build consensus.
Participate in production support by monitoring scheduled processes, reviewing exceptions, reloading or correcting data when appropriate, coordinating incident resolution, and communicating impacts.
Identify and communicate data strategy opportunities, define long-term goals and performance indicators, and promote a data-driven culture in support of business priorities.
Consult on data acquisition, curation, and consumption; document data sources and help maintain reference data and mastering rules to support a single version of the truth.
Map end-to-end data flows and affected business processes or technical interfaces, and recommend solutions or adaptations.
Prompt business requestors for data, reporting, and analytics requirements and develop solutions.
Coordinate UAT, triage issues, work with development teams on remediation, and help ensure data integrity and approve releases as applicable.
Perform data management activities such as classifying information, generating lineage, developing data-quality and transformation rules, profiling data, monitoring data, reviewing exceptions, reloading data, and applying overrides as necessary.
Use visualization techniques to present data in support of business needs.
Enforce data governance structures, standards, and procedures; govern data access requests and exercise final right of refusal for access.
Apply knowledge of investment asset classes and critical data elements to support business processes.
Incorporate emerging data and analytics trends, competitive research, and industry practices into Nationwide; perform other assigned responsibilities.

Benefits

Medical insurance
Dental insurance
Vision insurance
Life insurance
Short- and long-term disability coverage
Paid time off: newly hired associates receive a minimum of 18 days per full calendar year, prorated quarterly based on hire date
Nine paid holidays
Eight hours of Lifetime paid time off
Eight hours of Unity Day paid time off
401(k) with company match
Company-paid pension plan
Business casual attire