Consultant, Data Designer - Python / SQL

If you’re passionate about innovation and love working in an environment where you can constantly improve and adopt new technologies to drive business results, then Nationwide’s Information 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.

If you are passionate about the importance of data in delivering on Nationwide’s future strategic objectives and in creating the data blueprints required to achieve our business’ performance plans, then we have a great opportunity for you.  As a member of the Enterprise Data Office, the Data Designer works closely with our data architects, business stakeholders, and subject matter experts to understand their data requirements and ultimately translate them into physical data models. You will also be responsible for ensuring the accuracy, completeness, and consistency of our data models, as well as maintaining their documentation and metadata. Your expertise in data modeling tools and techniques, as well as your ability to communicate complex data concepts to non-technical stakeholders, will be critical to the success of our data-driven projects.

A successful candidate should possess the following skills and/or experiences:

• Demonstrated skill working directly with stakeholders, business partners, SMEs, systems peers, and cross-functional teams to elicit data requirements and design appropriate data models that align with business needs.

• Structured execution of data analysis, data profiling, and data mapping tasks.

• Translating current and future business requirements into conceptual, logical, and physical data model designs.  Proficiency in utilizing standard data modeling tools (e.g. Erwin, ER Studio, Toad DM, PowerDesigner, etc.).

• Designing data models for multiple distinct patterns (e.g. relational, dimensional, hybrid) associated with data warehouse, BI, and big data applications.

• Creation of new and extension of existing data models across multiple DBMS platforms (e.g. Oracle, SQL Server, DB2, Snowflake, Teradata, NoSQL).

• Ability to understand and explain complex data integration and extraction/transformation/load processes.

• Demonstrated experience identifying and resolving data model performance issues to optimize database performance and enhance overall system functionality.

• Documenting and communicating data model designs and standards to ensure understanding and compliance with expectations for interoperability across the organization.

• Proven communication skills illustrating ability to effectively interact with people at all levels of business and technology organizations.

• Fluency in Python, SQL, and Unix.  High proficiency with generating complex SQL queries is required.

• Version control of databases and metadata management tools (e.g. Git, Liquibase, etc).

• Insurance and Financial domain experience is highly desired.

• Experience working in an Agile environment using Lean, Kanban and Scrum practices.

Compensation grade G5

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.

Job Description