Apply Now

Applications processed via employer's online application form

Job Details



Closing Date

2021-09-20 23:00:00


ETL Developer (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. 





    Belfast/ Derry-Londonderry / Strabane


    Your role in the team


    This position will be part of a global State Privacy team within the Allstate Corporation, working specifically on the Data Ingestion team. This will involve support for two products – the OneTrust Consumer Portal and the Consumer Data Response Orchestrator (CDRO).


    These products are being developed to meet legal and regulatory compliance requirements around personal information (PI) deletion, consumer requests, privacy notices, and 3rd party relationships supporting Allstate’s Privacy standards and State Privacy Laws (SPL).


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


    • Critique and evaluate detailed business, functional, and high-level technical requirements
    • Design detailed technical components with high-level architecture
    • Ongoing environment support – updating host files/configs
    • Develop and test production-ready solutions that meet enterprise security and compliance standards
    • 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
    • Acts as an ab initio technical expert for other application developers, providing guidance 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



    So, what are the essential criteria to apply?


    • All candidates must evidence an existing right to work in the UK
    • A minimum of 4 years’ IT experience
    • 2+ years' experience Ab Initio 
    • 1+ years’ experience with SQL databases
    • Good communication skills especially on technical topic




    We also have some desirable criteria


    • 1+ years’ experience Unix
    • Experience in any of the following
      • Spark or PySpark
      • Scality or experience of any cloud-based technology.
      • Dremio
      • Scheduling Tools like Tivoli.



    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: 


    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 21st September 2021

Apply Now

Applications processed via employer's online application form