ETL Support Analyst (remote)

• Title: ETL Support Analyst

  Ref: 12/2/ETL

   

  About Us

  At Allstate Northern Ireland, we believe it’s more than just a job.  We believe in allowing our people to choose the direction of their careers.  It’s about you, your future and where you want to get to.

  Opportunity is the hallmark of the Allstate career experience.  We invest heavily in our employees, offering long term career development, personal growth and investment in new technologies.  Every day is different, with new ideas, challenges, and rewards — no matter which team you join.

  We believe that inclusive diversity is crucial to creating a culture of mutual respect where the strengths and talents of each individual are recognised.  We like to leave things better than we found them and deliver results.  We do all of this while having fun and exploring personal passions.

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

   

  Location

  Belfast/Derry/Londonderry

   

  Your role in the team

  We are pleased to announce a new role for an ETL Operational Support Analyst within the UCV (Unified Consumer View) team in the Data & Intelligent Systems (D&IS) area of Allstate Northern Ireland

  Our Unified Consumer View Technology Solutions (UCV-TS) team is responsible for delivering new functionality to support the Consumer Data platform and providing a 360 view of customer information across all channels.

  This ETL Operational Support Analyst position is for the UCV team that works with customer and marketing data in the AllCorp Data Warehouse (ADW). 

   

  • Second level support for batch job
  • Incident tickets (INC’s) – Pick up and work Incidents within SLA
  • Problem Tickets (PRB’s) – Ability to identify Root cause and correct.
  • Data Research Questions
  • Life Cycle tasks (EG, setting up jobs on new servers due to end-of-server-life server migrations)
  • Related Life cycle validation tasks (EG, validating batch job functionality after an Oracle version upgrade)
  • Disaster Recovery exercises
  • Ability to partner closely with the team and key business stakeholders
  • Provide technical assistance
  • Takes ownership and accepts responsibility for decisions which impacts own work area
  • Identifies, clarifies and resolves complex problems within own work area
  • Provide support in resolving data and technology issues

   

  So, what are the essential criteria to apply?

  • All candidates must be able to demonstrate their right to work in the UK
  • A minimum of 2 years + experience with ETL based systems
  • 1+ years’ experience with Ab Initio AND SQL databases
  • Knowledge of data warehousing techniques
  • Strong written and verbal communication skills including the ability to effectively collaborate with multi-disciplinary groups and all organizational levels
  • Must be self-motivated with the ability to accomplish tasks independently
  • Ability to effectively work with a globally distributed cross-functional team

   

  We also have some desirable criteria

  • Previous Production Support experience
  • Knowledge of HDFS, Hadoop, Apache Hive, Cloudera or similar technologies.
  • Knowledge of Python / Scala
  • Understanding of relational databases and database structures preferably ORACLE
  • Good understanding of consumer data
  • Good collaboration skills across multiple levels and function

   

  What we offer

  As Digital DNA’s Workplace of the Year 2020 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/3rGLT49  

    

  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 Friday 26^th March2021