Consultant, Data Analyst

Nationwide•Des Moines, IA

8d•$118,000 - $178,000•Hybrid

About The Position

The Consultant, Data Analyst processes, organizes, structures, and presents data to support business decision-making and data-intensive projects. The role identifies analytical needs, obtains and interprets data, provides insights and recommendations, and creates visualizations such as maps, reports, charts, and tables. The position also gathers and analyzes business and data requirements for Guidewire ClaimCenter and PolicyCenter, supports implementation for commercial lines of business, and performs source-to-target mapping for integrations and downstream applications. It contributes to data validation, profiling, modeling, governance, and secure data and technology solutions. The role works with business and enterprise partners to translate requirements into data models and useful analytical solutions.

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 assess whether existing data sources meet business needs.
Experience recommending alternate data sources and performing data modeling.
Knowledge of data applications and practices.
Solid decision-making and communication skills.
Ability to influence, negotiate, and set priorities.
A bachelor's degree in Computer Science or Computer Information Systems and five years of experience performing the listed duties are specified in the posting's role-specific description.
Undergraduate studies in computer science, management information systems, business, statistics, math, a related field, or comparable experience and education are strongly preferred.
Ability to demonstrate Nationwide Values consistently.

Nice To Haves

Insurance or financial services industry knowledge.
Graduate studies in business, statistics, math, computer science, or a related field.
Relevant certifications; certifications are encouraged but not required.

Responsibilities

Evaluate information from multiple sources, reconcile conflicts, clean data, classify information, and recommend solutions.
Use visualization techniques to present findings from data exploration.
Map data flows, business processes, and technical interfaces; recommend solutions or adaptations.
Apply secure software and systems engineering practices throughout the delivery lifecycle.
Document source-to-target mappings for data integrations and web services, and communicate mapping requirements to relevant groups.
Align data integration work with data quality and transformation rules; develop infrastructure or tools to support this work.
Identify and document existing and new data sources.
Conduct complex data profiling with enterprise partners using standardized tools.
Contribute to creating or reviewing conceptual, logical, and physical data models, selecting appropriate representations for business use, and tuning models for performance across DBMS platforms.
Consult proactively on data needs and provide recommendations and direction.
Manage data acquisition, analysis, and interpretation; provide insights and recommendations to internal clients.
Create thematic maps, reports, charts, tables, and other visualizations to support business needs.
Ensure compliance with Enterprise Data Governance policies, standards, information-risk requirements, 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; support implementation for commercial lines of business.
Perform source-to-target 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 with logical and physical data models; perform data mapping and logical data modeling.
Create class diagrams and entity-relationship diagrams, and use SQL 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 to support Data Governance.
May 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.