Nationwide is looking to solve the problem of leveraging data to drive business insights and decisions, and is seeking a Data Modeler/Data Analyst Lead to design, develop, and maintain data models and analytical solutions to support this goal.
Requirements
- 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).
- Experience working in an Agile environment using Lean, Kanban and Scrum practices.
- Insurance and Financial domain experience is highly desired.
- Data application and practices knowledge.
- Solid decision making, oral and written communication skills.
Responsibilities
- Collaboration Effectiveness – 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.
- 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.).
- Structured execution of data analysis, data profiling, and data mapping tasks.
- Ensures referential integrity is maintained via data modeling design and data quality recommendations.
- Designing data models for multiple distinct patterns (e.g. relational, dimensional, hybrid) associated with data warehouse, BI, and large data applications.
- Creation of net new data models and extension of existing 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.
Other
- Undergraduate studies in computer science, management information systems, business, statistics, math, a related field or comparable experience and education strongly preferred.
- Five to eight years of relevant experience with data quality rules, data management organization/standards or practices.
- Ability to influence, negotiate and set priorities needed.
- Regularly and consistently demonstrates the Nationwide Values.
- Overtime Eligibility: Exempt (Not Eligible)
