Investment Data Analyst
Nationwide
Get a reply from this employer — a resume and cover letter tailored to exactly what they’re hiring for.
Benefits offered by this job
Job summary
Nationwide seeks an Investment Data Management professional to translate investment needs into governed data products and BI solutions. You will deliver cloud data platforms, models, and analytics while partnering with business users and technology teams.
The role requires 6-10 years of data management experience, strong SQL/Python skills, Snowflake/Databricks knowledge, and expertise in Power BI and data governance. Hybrid work with in‑office Columbus presence.
Qualifications
- SQL, data warehousing, and data validation experience.
- Experience with Snowflake and/or Databricks and BI platforms.
- Proficiency in Power BI and Python; strong data governance understanding.
Responsibilities
- Designs, builds, and maintains data models, datasets, and data products.
- Develops data pipelines, notebooks, jobs, and data integrations; troubleshoot issues.
- Creates BI reports/dashboards and supports governance, security, and audit needs.
- Collaborates with users and tech teams to translate requirements into governed solutions.
- Applies AI concepts to data solutions with emphasis on accuracy and governance.
- Supports testing, UAT, releases, and post‑release validation.
Skills
Education
Tools
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.
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.
- 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.
- 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.
- 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.
Success in this role requires balancing hands‑on technical execution with strong business partnership. The professional will be expected to produce trustworthy and reusable data solutions, improve the reliability of reporting and analytics, proactively identify data or process risks, and help the Data Insights team expand the practical use of cloud platforms and artificial intelligence while maintaining Nationwide’s standards for security, governance, quality, and accessibility.
- Design, build, and maintain scalable data pipelines and analytics solutions using Snowflake.
- Develop reliable data products that support business intelligence, advanced analytics, machine learning, and AI use cases.
- 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.
- Implement data governance, security, lineage, monitoring, testing, and CI/CD practices across the data platform.
- 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.
- 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.
Nationwide’s industry leading workforce is passionate about creating data and business intelligence solutions that are secure, reliable, accessible, and efficient in support of our mission to provide extraordinary care. Nationwide embraces an agile work environment and collaborative culture through the understanding of business processes, relationship entities and requirements using data analysis, quality, visualization, governance, engineering, robotic process automation, and machine learning to produce targeted data solutions. If you have the drive and desire to be part of a future forward data enabled culture, we want to hear from you.
As an Investment Data Management professional, you will serve as the primary liaison between the business and Technology, developing and driving data and analytic strategies and solutions to deliver prioritized business capabilities. You will be responsible for creating and maintaining the vision for the data ecosystem, with focus on improving efficiency, effectiveness, and quality of data‑driven business processes and decisions. Your role provides business‑minded thought leadership throughout all phases of data development, including intake, work initiation, requirement gathering and iteration planning and project estimations. You will serve as the data‑related voice of the customer in translating functional data and analytic requirements into solutions for consumption and use by the respective business area, managing communications between Technology and business, resolving blockers/questions/support needs, conducting/coordinating User Acceptance Testing (UAT) and approving releases. You will evaluate potential data impacts, coordinate with stakeholders, and serve as steward for data governance, access rights/audits and defect resolution.
Reports to AVP or Data Leader
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.
Certifications are not required but encouraged.
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.
- 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.
Regularly and consistently demonstrates Nationwide Values
Not Eligible (Exempt)
Normal office environment.
The above statements cover what are generally believed to be 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.
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,
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.
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.
The national salary range for Investment Professional : $100,000.00-$168,000.00
The expected starting salary range for Investment Professional : $100,000.00-$168,000.00
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
