Investment Data Analyst

Technical Requirements and Experience

• Demonstrated experience with SQL, relational data concepts, data modeling, data warehousing, data transformation, and data validation.

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.

Preferred Qualifications

• Experience supporting investment management, asset management, insurance, financial services, or other data-intensive business processes.

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.

Role Summary

Design, build, and maintain scalable data pipelines and analytics solutions using Snowflake.

Key Responsibilities

• Engineer batch and streaming data pipelines using Python, SQL, OpenFlow, Spark, or comparable technologies.

Engineer batch and streaming data pipelines using Python, SQL, OpenFlow, Spark, or comparable technologies.

Build and optimize lakehouse or cloud data warehouse solutions, with strong attention to performance, scalability, data quality, and cost management.

Partner with analysts, architects, and business stakeholders to translate requirements into governed, production-ready data solutions.

• Apply AI and machine learning concepts to support use cases such as generative AI, retrieval-augmented generation, intelligent automation, or predictive analytics.

Apply AI and machine learning concepts to support use cases such as generative AI, retrieval-augmented generation, intelligent automation, or predictive analytics.

Required/Preferred Qualifications

• Hands-on experience with Snowflake (or Databricks) in an enterprise data environment.

Hands-on experience with Snowflake (or Databricks) in an enterprise data environment.

Strong programming skills in Python and SQL

• Experience with Openflow and Snowflake AI products (Cortex Code, Cortex Analyst, etc) is preferred.

Experience with Openflow and Snowflake AI products (Cortex Code, Cortex Analyst, etc) is preferred.

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.

• 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 with flexibility to come in 4 days.
• This role does not qualify for employer sponsored work authorization. Nationwide does not participate in the STEM OPT extension program.
• #LI-SS1

Job Description Summary

Key Responsibilities

• 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.
• May perform other responsibilities as assigned.
• Reporting Relationships: Reports to AVP or Data Leader

Typical Skills and Experiences

• Education: Undergraduate studies in computer science, management information systems, business, statistics, math, a related field or comparable experience and education strongly preferred. Graduate studies in business, statistics, math, computer science or a related field are a plus.
• License/Certification/Designation: Certifications are not required but encouraged.
• Experience: 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. Insurance/financial services industry knowledge a plus.

Knowledge, Abilities and Skills

• 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
• Demonstrated expertise in building relationships, facilitating meetings, influencing others, and setting priorities
• 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 HR Business Partner.
• Values: Regularly and consistently demonstrates Nationwide Values

Job Conditions

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