Apply Now

Applications processed via employer's online application form

Job Details


Belfast, Northern Ireland

Closing Date

2020-04-13 23:00:00


ETL Developer

  • Think Technology- Think Allstate

    We build solutions that touch 16 million customers on a daily basis.

    You will work alongside people as passionate as you, focused on delivering the best possible user experiences.

    You will work in a highly collaborative environment primed to adapt to an ever-changing landscape and which places technology solutions at its core.

    You will thrive, you will think differently, you will challenge convention and have the freedom to act with integrity, intention and speed; you will be at the forefront of developing capabilities in support of Allstate’s global business model; you will deliver results and you will leave things better than you found them.


    Belfast / Derry – Londonderry / Strabane

    Job Description

    We are pleased to announce a new role for an ETL Developer within Information Services Group (ISG).

    This position will be part of a global State Privacy team. This will involve support and development for two products – the OneTrust Consumer Portal and Consumer Data Response Orchestration (CDRO).

    These products were developed 2019 to meet legal and regulatory compliance requirements around personal information (PI) deletion, consumer requests, privacy notices, and 3rd party relationships.

    Going forward, the focus is to increase consumer-centricity, simplification, automation, centralization and scalability while continuing to meet our regulatory and legal requirements. 

    Responsibilities include (but aren't limited to):

    • Develop and test production-ready solutions that meet requirements
    • Design and build automated processes that monitor ETL programs for data quality and governance issues.
    • Participate in design reviews, code reviews, and other parts of dynamic Agile development
    • Create documentation and provide suggested improvements according to subject matter expertise of the built solutions.
    • Takes ownership and accepts responsibility for decisions which impacts own work area
    • Provides guidance to others within team on development strategy and technical solutions
    • Identifies, clarifies and resolves complex problems within own work area
    • Provide support in resolving data and technology issues
    • Work effectively with Product Owner and team members

    The successful candidate will have:

    • Proven track record of analysis into technical requirements and producing high quality solutions
    • Understanding of the Agile framework and Product Mindset
    • Desire to learn new tools / technologies and implement continuous improvement
    • Strong work management skills with the ability to drive forward your own projects
    • Innovative approach to projects, with strong desire to improve through efficiency and automation
    • Highly focused on paying attention to detail
    • Flexible attitude to work tasks, displaying an ability to work on multiple tasks simultaneously.
    • Ability to complete transition of new technical skills and application knowledge in a short time frame
    • Have strong communication skills and possess the ability to work independently when required but also as part of a team

    Essential Criteria

    • Must be an EU citizen or possess a current UK Tier 1 Visa or Tier 2 visa and eligible to take up full time, permanent employment. EU candidates must also demonstrate they are eligible to take up UK employment post-Brexit.
    • A minimum of 2 years + experience with ETL based systems 
    • 1+ years’ experience with SQL databases
    • Good communication skills especially on technical topics

    Desirable Criteria

    • Experience in privacy, data governance, risk management or related fields
    • Experience of working in an Agile environment
    • Knowledge of HDFS, Hadoop, Apache Hive, Cloudera or similar technologies.
    • Knowledge of Java / Tibco
    • Understanding of relational databases and database structures preferably SQL Server
    • Good understanding of consumer data
    • Good collaboration skills across multiple levels and function

    Apply Here: 

    Closing Date:  Tuesday 14th April 2020

    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.

Apply Now

Applications processed via employer's online application form