Investment Data Analyst

Nationwide Mutual Insurance•Columbus, OH

2d•Hybrid

About The Position

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 Investment Data Management professional supporting Data Insights will translate investment-business needs into reliable, governed data products and business intelligence solutions. This position combines business partnership with hands-on technical delivery across cloud data platforms, data models, reporting tools, and emerging artificial intelligence capabilities.

Requirements

Demonstrated experience with SQL, relational data concepts, data modeling, data warehousing, data transformation, and data validation.
Experience working with Snowflake and/or Databricks, including data storage, compute, processing, notebooks, jobs, dataflows, or related cloud data 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 that support accurate and efficient business consumption.
Familiarity with Python or similar scripting languages for lightweight automation, analysis, testing, or data-quality tasks.
Ability to learn and apply artificial intelligence tools and techniques in a controlled, practical, and business-focused manner, with appropriate attention to data security, governance, accuracy, and human review.
Hands-on experience with Snowflake (or Databricks) in an enterprise data environment.
Strong programming skills in Python and SQL
Practical understanding of cloud data architecture, dimensional modeling, data integration, and orchestration tools.
Strong problem-solving, communication, and collaboration skills, with the ability to work effectively across technical and business teams.
Undergraduate studies in computer science, management information systems, business, statistics, math, a related field or comparable experience and education strongly preferred.
6-10 years of relevant experience with data management organization/standards or practices.
Experience engaging business leaders, data architects and external consultants to identify and fill gaps in data and analytics environment.
Proficient in data acquisition, data wrangling and/or data visualization techniques and tools (i.e., SQL, R, Python, Tableau, Power BI, etc.), and cloud technologies – Azure and AWS (i.e., Redshift, S3, EC2, etc.).
Experience in statistical analysis, interpreting results in determining data quality and fit for purpose.
Data application and practices knowledge, with expertise using SQL to perform data analysis (experience in Snowflake and Databricks preferred)
Sound decision making and strong analytical skills with high attention to detail and accuracy
Exhibits interpersonal skills and effective written and oral communication
Ability to work independently and as part of a team
Ability to effectively adapt to rapidly changing technology and apply it to business needs

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 converting business needs into implementable solutions.
Experience with Openflow and Snowflake AI products (Cortex Code, Cortex Analyst, etc) is preferred.
Insurance/financial services industry knowledge a plus.
Graduate studies in business, statistics, math, computer science or a related field are a plus.
Certifications are not required but encouraged.
Demonstrated expertise in building relationships, facilitating meetings, influencing others, and setting priorities

Responsibilities

Designs, develops, and maintains data models, curated datasets, semantic models, and data products that support investment reporting, analytics, operational processes, and self-service business intelligence.
Builds, supports, and troubleshoots data pipelines, dataflows, notebooks, jobs, scheduled processes, and related integrations; investigates failures, identifies root causes, and coordinates timely remediation.
Uses data modeling principles to define relationships, business rules, transformations, keys, hierarchies, measures, and other structures needed to create consistent and reusable data products.
Creates and maintains Business Objects universes, reports, scheduled distributions, and related reporting components, while supporting the transition of legacy reporting capabilities to modern, governed solutions where appropriate.
Develops and enhances Power BI datasets, semantic models, reports, dashboards, measures, filters, and user experiences; applies established reporting and analytic standards to promote consistent interpretation of investment data.
Partners with business users and Technology teams to define requirements, evaluate source-system and downstream impacts, document technical designs, estimate work, and sequence delivery through an agile work process.
Performs complex data profiling, reconciliation, and validation across investment data sources; establishes data-quality checks, exception handling, monitoring, and operational procedures to identify and resolve issues before they affect consumers.
Supports end-to-end testing, including test scenario development, data validation, regression testing, User Acceptance Testing, defect triage, release readiness, and post-release verification.
Collaborates with data governance, data management, reporting, infrastructure, vendor, and investment-business partners to ensure data access, security, controls, and audit expectations are met.
Evaluates and applies emerging artificial intelligence capabilities responsibly, including AI-assisted documentation, natural-language interaction with data, data-quality monitoring, summarization, and other use cases that improve productivity or access to governed information.
Communicates technical concepts clearly to audiences with varying levels of technical expertise; facilitates working sessions, presents recommendations, provides status and risk updates, and builds consensus around data and reporting solutions.
Participates in production support and operational activities, including monitoring scheduled processes, reviewing exceptions, reloading or correcting data when appropriate, coordinating incident resolution, and communicating impacts to stakeholders.
Identifies, executes, and communicates data strategy opportunities, defining long-term goals and key performance indicators to further a data-driven culture in support of business priorities.
Consults and provides direction on acquisition, curation, and consumption of data for analytical and operational uses, producing data source documentation and assisting with development and maintenance of reference data and mastering rules to ensure a single version of the truth across all data consumers.
Collaborates on mapping the end-to-end flow of data and the business processes and/or technical interfaces which would be created or impacted and recommends solutions/adaptations.
Develops collaborative relationships with business, Technology, and vendor partners, communicating data impacts and promoting transparency around data issue identification and resolution.
Prompts data, reporting and analytic requirements from business requestors to generate solutions.
Participates in planning and execution of UAT, triage issues and works with development team on remediation approach to ensure data integrity.
Performs data management activities, including classifying information into logical categories, generating data lineage, developing data quality and transformation rules, conducting complex data profiling, implementing data monitoring techniques using standardized tools, reviewing daily exceptions, reloading data, and applying data overrides as necessary.
Uses moderate to complex visualization techniques and skills to present data in support of business needs.
Enforces data governance structure, standards, and procedures to ensure data is well-defined, consistent, accurate, accessible, and secure.
Governs all data access requests and has final right of refusal for accesses.
Demonstrates knowledge and understanding of investment asset classes, and those data elements most critical to support business processes.
Integrates emerging data and analytic trends, competitive research, and industry best practices into Nationwide.

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