Consultant, Data Analyst

Nationwide Mutual Insurance•Des Moines, IA

6d•Hybrid

About The Position

Nationwide’s Technology team develops secure, reliable, and efficient data solutions in support of the company’s mission. The Data Analyst processes, organizes, structures, and presents data to support business decisions and data-intensive projects. The role works with business partners to identify analytical needs, obtain and interpret data, provide insights and recommendations, and create visualizations such as maps, reports, charts, and tables. The posting also describes work gathering and analyzing requirements for Guidewire ClaimCenter and PolicyCenter for Commercial lines of business. This includes source-to-target mapping for integrations and downstream applications, data cleaning and transformation, SQL-based data validation, data modeling, and supporting data governance. The position reports to a Manager/Director of Data Management and works in a hybrid office environment.

Requirements

Six to eight years of relevant experience with data quality rules and data management organization, standards, or practices.
Experience in statistical analysis and interpreting results to determine data quality and fitness.
Experience using data quality results to determine whether existing data sources meet business needs.
Ability to recommend alternate data sources and perform data modeling.
Knowledge of data applications and practices.
Solid decision-making and communication skills.
Ability to influence, negotiate, and set priorities.
The role-specific description requires a bachelor’s degree in Computer Science or Computer Information Systems and five years of experience performing the listed duties.

Nice To Haves

Undergraduate studies in computer science, management information systems, business, statistics, mathematics, a related field, or comparable experience and education.
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

Evaluate information from multiple sources, reconcile conflicts, clean data into a consumable format, classify information, and provide recommendations.
Use moderate to complex visualization techniques to present findings from data exploration.
Map data flows, business processes, and technical interfaces, and recommend solutions or adaptations.
Apply secure software and systems engineering practices throughout the delivery lifecycle.
Document source-to-target mappings for data integration and web services, and ensure alignment with data quality and transformation rules.
Develop infrastructure or tools to communicate data mappings to relevant groups.
Identify and document sources of existing and new data.
Conduct complex data profiling with enterprise partners using standardized tools.
Contribute to the creation or review of conceptual, logical, and physical data models, selecting appropriate representations for business use.
Perform data modeling across DBMS platforms and tune models for performance on specific platforms.
Consult proactively on data needs and provide recommendations and direction.
Manage data acquisition, analysis, and interpretation, and provide insights and recommendations to internal clients.
Create thematic maps, reports, charts, tables, and other analytic visualizations to support business needs.
Ensure compliance with Enterprise Data Governance policy, information risk standards, and data protection guidelines.
Recommend and execute changes to data analytics methodologies, practices, and tools.
Gather and analyze business and data requirements for Guidewire ClaimCenter and PolicyCenter, and implement these systems for Commercial lines of business.
Perform source-to-target data mapping for PolicyCenter third-party integrations and downstream applications, including data cleaning and transformation rules.
Write complex SQL queries for data validation and work with data quality issues.
Assist database modelers in preparing logical and physical data models; perform data mapping and logical data modeling.
Create class diagrams and Entity Relationship diagrams and use SQL queries to filter data in Oracle databases.
Translate business and data requirements into data models supporting Enterprise Data Models, data warehouses, and analytical systems.
Develop best practices, standards, and methodologies for Data Governance.
Perform other responsibilities as assigned.

Benefits

Medical, dental, and vision coverage.
Life insurance.
Short- and long-term disability coverage.
Paid time off, with newly hired associates receiving 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.