Specialist, Data Designer (Annuity Data Platform)

Nationwide Mutual Insurance•Columbus, OH

3d•Hybrid

About The Position

If you’re passionate about being part of a dynamic organization that enables a Fortune 100 company with nearly $70 billion in annual sales to drive innovation and adopt new technologies that deliver business results, then Nationwide’s Technology team could be the place for you! 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. This role will work a hybrid schedule coming into the Columbus, Ohio office 2 days (Wednesday & Thursday) per week. Expert in complex source‑to‑target data mapping and data analysis , including detailed documentation and validation of transformation logic across systems Strong SQL and data‑profiling capability to analyze source data, assess data quality, and support trusted data delivery Proven ability to document integration requirements and system dependencies and effectively communicate with business and technical stakeholders Good understanding of Data Modeling Knowledge of Financial/Annuities domain is a plus #LI-AC1 Job Description Summary Nationwide’s industry leading workforce is passionate about creating data solutions that are secure, reliable 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 a Data Designer you’ll process, organize, structure or present data to make it meaningful for business decision making and to position data-intensive projects/programs for success. You’ll be an integral part of a project, program or team and perform a variety of tasks related to identifying business partners’ analytical needs and obtaining, collecting, organizing and interpreting data. You’ll perform analysis and interpret results, providing insights and recommendations. This may take the form of thematic maps, reports, charts, tables and other analytic visualization.

Requirements

Expert in complex source‑to‑target data mapping and data analysis , including detailed documentation and validation of transformation logic across systems
Strong SQL and data‑profiling capability to analyze source data, assess data quality, and support trusted data delivery
Proven ability to document integration requirements and system dependencies and effectively communicate with business and technical stakeholders
Good understanding of Data Modeling
Undergraduate studies in computer science, management information systems, business, statistics, math, a related field or comparable experience and education strongly preferred.
Two to five years of relevant experience with data quality rules, data management organization/standards or practices.
Experience in statistical analysis, interpreting results in determining data quality and fitness.
Experience using data quality results to determine whether existing sources of data are enough for business needs.
Good oral and written communication skills.

Nice To Haves

Knowledge of Financial/Annuities domain is a plus
Graduate studies in business, statistics, math, computer science or a related field are a plus.
Insurance/financial services industry knowledge a plus.
Certifications are not required but encouraged.

Responsibilities

Evaluates information from many sources, provides recommendations, reconciles conflicts, cleans data into a consumable format and classifies the information into logical categories.
Uses basic to moderate visualization techniques and skills to present findings of data exploration exercises.
Maps the flow of data and the business processes and/or technical interfaces which would be created or impacted.
Recommends solutions and adaptations as appropriate.
Documents the source to target mappings for data integration and web services.
Applies secure software and systems engineering practices throughout the delivery lifecycle to ensure our data and technology solutions are protected from threats and vulnerabilities.
Aligns with data quality and transformation rules and develops infrastructure and/or other tools to communicate mapping to relevant groups.
Identifies and documents the sources of existing and new data.
Works with enterprise partners to conduct complex data profiling using standardized tools.
Obtains and manages data, performs analyses, interprets results, and provides insights and recommendations to internal clients.
Prepares thematic maps, reports, charts, tables, and other analytic visualization to support business needs.
Creates or reviews conceptual, logical and physical data models and determines the most appropriate method to represent the data for business consumption/use.
Collaborates with project teams to ensure compliance with the Enterprise Data Governance policy and standards on information risk and data protection guidelines.
Recommends and executes changes in data analytics; including methodologies, practices, and tools.
May perform other responsibilities as assigned.

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