Specialist, Data Solution Analyst - DPIM

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.

• Developing SQL queries and statements for a variety of purposes such as data quality checks, downstream partner information requests, and data cleanup jobs involving inserts and updates. 

• Traversing Linux database servers. 

• Building and running XML batch processes via the command line. 

• Utilizing Python and JupyterLab/Notebooks to compare, manipulate, and analyze data across different databases, extracts, and systems to ensure normalization and consistency. 

• Researching questions and issues from business partners on a case-by-case basis as a part of production support. 

• Identifying data quality issues and reviewing error reports to communicate findings to team members and business partners. 

• Coordinating data changes and data flows within ETL and MDM processes- including team members as well as upstream and downstream partners. 

• Participating in daily Agile stand-up meetings with the development team that involve the completion of Jira task cards. 

• Analyzing business and technical requirements for translation into database processes. 

• Collaborating with team members on a variety of projects focused on improving data quality and functionality. 

• Assisting the production support team with ServiceNow incident tickets. 

• Mapping the flow of data and the business processes and/or technical interfaces which would be created or impacted and recommending solutions/adaptations. 

  

Skills: 

  

• Previous experience in an MDM (Master Data Management)  

• Experience with SQL in DB2, Oracle, and Teradata environments.  

• A deep understanding of large relational databases. 

• Experience with Python  

• Experience in data analysis tasks in Jupyter Notebooks.  

• Proficiency in writing scripts that can be used with embedded SQL. 

• Experience with Power BI  

• Technical Analysis 

• Proficiency in translating business needs into technical requirements. 

• Experience R4J a plus. 

• Ability to demonstrate effective communication skills. 

• Ability handle several projects at one time. 

• Familiarity with running API calls. 

• Experience running basic Linux,