Claims Data Reporting & Visualization Consultant (hybrid or remote)

• About Us

   

  The world isn’t standing still, and neither is Allstate. We’re moving quickly, looking across our businesses and brands and taking bold steps to better serve customers’ evolving needs. That’s why now is an exciting time to join our team. You’ll have opportunities to take risks, challenge the status quo and shape the future for the greater good.

   

  You’ll do all this in an environment of excellence and the highest ethical standards – a place where values such as integrity, inclusive diversity and accountability are paramount. We empower every employee to lead, drive change and give back where they work and live. Our people are our greatest strength, and we work as one team in service of our customers and communities.

   

  Allstate operate a very flexible hybrid working policy that will allow you to design your working week in collaboration with your manager with a blend of remote and office working for NI based employees as well as condensed working patterns (4 day week/9 day fortnight). Employees based in GB will be employed on a permanent remote working contract.

   

  Join our team and you’ll find challenge and reward in a culture of innovation, support and balance. 

   

   

  Location

   

   

  Belfast/ Derry-Londonderry/ Strabane/ Remote, GB

   

   

  Your role in the team

   

  This is an exciting opportunity to join Allstate Northern Ireland (ANI) as we build out a small team in ANI, with various levels of experience to develop reporting and ETL processes for our Claims organization.

  As a Data Reporting & Visualization Analyst you will be responsible for supporting the information needs of the Claims Workflow COE department. You will contribute to the development of data and information delivery solutions in response to business initiatives and issues. You will investigate, track, prioritize, and communicate data and reporting related issues. You will use data and reports to tell a story, adding value and identifying opportunities where you see potential for Claims to work more efficiently

   

   

  Responsibilities include (but are not limited to):

   

   

  Technology Requirements

   

  • Collaborates with and consults to leadership regarding technology needs and solutions
  • Maintains adherence to Information Security Standards for employees and leaders
  • Identify opportunities to enhance and automate existing reporting processes
  • ETL development /Writing analytics programs (transformations/calculations)
    • MSSQL
    • SQL Server Integration Services (SSIS) 
    • Stored Procedures
    • Oracle
    • Dremio
    • Python
    • C#
  • Using the above tools to structure data for use in data visualization environments (Tableau, Power BI, etc.) 
  • Works within an Agile Scrum environment to deliver value to the stake holders
  • Customer Service
  • Makes and maintains a connection with the stake holder by understanding and meeting their needs; serves the stake holder with empathy; and follows up to ensure that stake holder needs have been met
  • Researches and responds to moderately complex and occasionally complex customer communications, concerns, conflicts or issues

   

  Reporting Requirements

   

  • Preparing reports that effectively communicate trends, patterns, and predictions using relevant data to enable leader’s visibility of progress towards Claims strategic goals
  • Assists and leads in developing analytics “story” and visual presentation strategies to ensure data is conveyed in meaningful and interpretive formats for all audience levels.
  • Analyzes structured and unstructured data from a number of sources to identify drivers.
  • Reviews results, identifies variances to planned performance, analyzes causes of variance and make actionable recommendations to product owner.
  • Create and articulate a story based off multiple data points.

    

    Other

   

  • Build relationships across teams and departments, work as part of a team.
  • Manage time effectively including ability to handle multiple projects and prioritize workload.

   

   

  So, what are the essential criteria to apply?

   

  • All candidates must evidence an existing right to work in the UK'
  • A minimum of 2 years’ related experience in development/writing analytics programs.
  • Knowledge with relational databases and data warehouses (Oracle, Microsoft SQL Server, Dremio)

   

  The successful candidate must also demonstrate competencies in:

   

  • Microsoft Excel skill (ex. sum function, charts, sorting, filters)
  • Applies knowledge of analytical procedures to reconcile, manipulate, and recognize patterns of data
  • Ability to problem solve and prepare reports for analysis, with strong focus on attention to detail
  • Ability to mentor and develop others as well as review code for efficiency

   

   

  We also have some desirable criteria

   

  • Bachelors degree in related field
  • Business Objects Experience
  • Business Intelligence, including strong understanding of corporate structure
  • Knowledge of Claims data available in ADW is a plus.

   

  What we offer

   

  As Digital DNA’s Workplace of the Year 2020 & 2022 winners, we offer a generous benefits package that includes flexible annual leave entitlement, dental and healthcare insurance, an attractive pension package and discounts on gym memberships, public transport and parking.

   

  Allstate invests heavily in your development, as an employee you will have access to multiple world-class learning platforms and courses from our award-winning in-house Learning & Development team.

   

  We pride ourselves in providing clear career paths and opportunities for internal mobility allowing you to further develop within the organisation.

   

  We encourage a better work life balance and you’ll have the opportunity to apply for various flexible working arrangements.

   

   

  Apply Here: https://bit.ly/3xieVeH 

   

   

   

  Statement on Fair Employment and Equal Opportunities

   

  Allstate NI wishes to ensure equal opportunity is given to all job applicants.  This company will not discriminate on the grounds of race, gender (including gender reassignment status), sexual orientation, religious belief, political opinion, marital status, age or disability.

   

  We are an equal opportunities employer. We welcome applications from all suitably qualified persons. However, as women are currently under-represented in our workforce, we would particularly welcome applications from women. All appointments will be made on merit.

   

  Applicants should note Allstate NI complete AccessNI background checks on all candidates offered a position.

   

   

  The closing date for receipt of applications is Wednesday 22nd June 2022