ETL Developer

• Title: ETL Developer

  Ref: 24/11/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 Developer within 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 developer position is for the UCV team that works with customer and marketing data in the AllCorp Data Warehouse (ADW). 

  As our ETL Developer you’ll help us to develop and test production-ready solutions that meet requirements and design and build automated processes that monitor ETL programs for data quality and governance issues. Working alongside a team of dedicated data professionals you will participate in design reviews, code reviews, and other parts of lifecycle project development while creating documentation and provide suggested improvements according to subject matter expertise of the built solutions.

  Here within the UCV team we believe in taking ownership and accepting responsibility for decisions which impacts your own work area. You will be a leader and provide guidance to others within team on development strategy and technical solutions.

  This is an opportunity to develop your career, in not just providing support in resolving data and technology issues or working effectively with Product Owners and other senior stakeholders, but in being the catalyst for change and finding new and improved ways of working.

   

  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; and
  • A minimum of 1 years’ experience with Ab Initio and SQL databases

   

  We also have some desirable criteria

  • Experience developing experience of building data pipelines
  • Knowledge of HDFS, Hadoop, Apache Hive, Cloudera or similar technologies.
  • Knowledge of Python / Scala
  • Experience with Business Objects Reports/Universe Development
  • 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/3pVZQL7 

   

  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 Tuesday 8^th December