Data Analyst

Springfield, Ohio
Not Specified
Sep 18, 2016
Nov 17, 2016
Job Type
Not Specified
Career Level
Not Specified
Assurant is hiring an Operations Analyst III - Data Integrity in our Springfield, OH service center. The Operations Analyst-Data Integrity assists in design, develops, tests, and delivers data mining, analytic, or reporting solutions based on requirements provided by a business user, following department protocols and development and migration standards. The incumbent will also have responsibilities for business unit support and maintenance of existing reporting, analytic, or data mining solutions which support business processes or decision support. The analyst gains working knowledge of related source data systems and tool sets. Key Accountabilities
  • Assists in design solutions for approved projects and change requests of moderate complexity and risk
  • Responsible for the design of dashboard reporting for data analytics that target opportunities for identifying cost savings, efficiencies, waste, and customer impact. This includes data mining solutions based on provided oral and written requirements
  • Responsible for requirements gathering, data analysis, and development activities
  • Collaborate with various levels of ASP business leaders as part of large projects and those of a smaller scale in order to meet business needs tied to our core goals for Profitable Growth
  • Participate in solution development according to business and technical requirements that focus on SLA performance in key functional areas
  • Develop, test, and implement tools for data analysis targeting anomalies in data, trending of performance of primary functional areas (Processing, Customer Care, Loss Drafts, etc.)
  • Develops, tests, documents, and implements ad-hoc reports and project based dashboard reports, analytics, or data mining solutions with guidance from project managers, senior staff members, and management
  • Develop tools for measuring, analyzing and reporting of quality assurance
  • Responsible for design of dashboard reporting and data analysis that target quality of key functional processes
  • Perform root cause analysis and defect correction and recommended improvement as indicated by test results
  • Monitor data generated by the outcomes, report results and document findings according to current standards
  • Learn continuously and participate in cross training events
  • Learn new data mining, analytical, and reporting tools as they become available – keep knowledge current and identify the best tool based on project/task need
  • Collaborate with other DIG team members continuously to share, learn, and implement new tools and best practices

Basic Qualifications:

  • 2 years of formal business communication describing problems and providing recommended solutions to a wide audience
  • 2 years of experience analyzing technical problems and providing recommendations for solutions of moderate risk
  • 2 years of experience data mining using SQL Server with experience writing moderately complex Transactional SQL procedures
  • 2 years of experience building and supporting MS Access databases
  • 2 years of advanced knowledge of fundamental concepts and practices of reporting using MS Excel and PowerPoint
  • 2 years writing moderately complex queries using MS SQL Server and MS Access
  • 1 year of Tableau dashboard reporting (author)
  • Associate's or Bachelor's degree, or High School Diploma or GED plus three years working in a data analytics/data mining position

Other Requirements

  • Advanced effective oral and written communication skills
  • Strong analytical skills
  • Advanced knowledge of fundamental concepts and practices of reporting using Excel.
  • Ability to write moderately complex queries using Microsoft SQL Server, MS Access, and Excel
  • Ability to prioritize and manage multiple tasks and assignments
  • Ability to deliver results on time and to expectations
  • Ability to have general understanding of underlying business need
  • Ability to adhere to best development practices Ability to work in a matrix-managed environment
  • Ability to travel (5%)

Preferred Qualifications

  • Six Sigma Green Belt or Black Belt certification and/or formal data analytics training
  • 2 years experience working in mortgage lending, banking, or hazard insurance processing environment