Jobs

Apply Now

Applications processed via employer's online application form

Job Details

Location

Other

Closing Date

2022-08-18 23:00:00

Share

Lead SSIS 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. 

     

     

    Location

     

     

    Belfast/ Derry - Londonderry/ Strabane/ Remote GB

     

     

    Your role in the team

     

     

    We are excited to announce a Lead Insights Engineer role opening within Allstate Business Insurance (ABI) at Allstate Northern Ireland to join our rapidly expanding team.

     

    The successful candidate will have the opportunity to work on the new ABI Transformative Growth product Project Midway.

     

    ABI has created a new auto product to focus on small businesses with less than five vehicles by creating a new and modern user experience for customers and agents on a new platform using Duck Creek Technologies to allow customers and agents to quote, bind and service in a simple yet engaging way.

     

    You will be provided in-depth training in the new platform courtesy of the Duck Creek University Virtual training program.

     

     

    • Accountable for overall code quality for this product.  Ensure it delivers the functions it needs to deliver, ensure high quality, ensure high performance.  ATSV quality and availability KPI's, product KPI's.
    • Ensures that other engineers on the team are working on the highest priority items in any given sprint as defined in sprint planning, or as a result of the triage of any production issues
    • Collaborates with the Product Owner to refine the backlog and apply appropriate priority to technical debt resolution
    • Understands the details of Downstream Data flows supporting this product.
    • Understands the details of how those Downstream Data flows connect back into any Allstate or other vended components.
    • Guides other engineers on the product team to ensure that there is a cohesive and efficient approach to how the product functions.
    • Develops code to deliver functionality that align with Allstate's security and compliance standards
    • Collaborates with Product Owner, SCRUM master, and lead QC engineer to constantly improve quality, availability, KPI's, and velocity of the product team.
    • Develops goals and understands the overall goals from the Engineers and QC engineers’ managers for the engineers and QC engineers on the product team.
    • Provides quarterly feedback on the engineers on the team to their manager

     

     

     

    So, what are the essential criteria to apply?

     

    • All candidates must evidence an existing right to work in the UK
    • Minimum of 5 years’ experience in a development role and
    • Knowledge of Agile methodologies and
    • Experience of ETL development, including use of MS SSIS to move data between systems and automate load processes and
    • Solid Experience in MS SQL Server – Querying, Views, Functions, Stored Procedures and
    • Experience of SQL Server Agent

     

     

    We also have some desirable criteria

     

    • Be able to demonstrate a passion for learning and learning agility;
    • Team player focusing on success of the team with excellent communications skills.
    • Knowledge of SQL Server TSQL
    • Knowledge of SQL Performance Tuning

     

     

    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.

     

     

     

    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 19th August 2022

Apply Now

Applications processed via employer's online application form