ETL COE Developer
Allstate Insurance Company
Belfast, United Kingdom
4d ago

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.

    Job Description

    We are pleased to announce a new senior ETL developer opening within Information Services Group (ISG).

    This is an opportunity to join the ISG ETL COE team as a senior ETL (Ab Initio) developer. This team provides a number of delivery services for Allstate including

  • Supporting the ETL Policy processes
  • Providing ETL COE guidelines for all client areas in Allstate and providing consultancy for new projects
  • Delivering ETL Support and Ab Initio development for projects.
  • The specific role that will be filled is multi-functional, requiring a blend of Ab-I / Unix skills but support experience is also important.

    As mentioned above, the core ETL product used is Ab Initio which runs on Linux with the Data Warehouse database located on an Oracle Exadata Appliance.

    As a senior developer, you would be expected to take technical ownership of one or more of the teams’ applications and be responsible for delivering changes, either as an individual or leading a small team of junior developers.

    You would also design, build, deploy and maintain new applications.

    Responsibilities include (but aren't limited to) :

  • Strong understanding of Data Warehousing, ETL concepts.
  • Strong troubleshooting experience in Ab Initio.
  • Experience in performance tuning of both ab initio, UNIX and Oracle database environments
  • Knowledge of ab initio code migration activities
  • Strong knowledge of design and building new ETL applications in order to support developers, QC engineers and to populate the Enterprise Data Warehouse, based on customer requirements.
  • Must be able to lead and enforce defined technical standards, as well as contributing to and creating new standards.
  • Need to be able to work independently without significant supervision and you must be a team-oriented individual with a results-driven attitude.
  • Be able to work cross functionally with a variety of internal IT organizations, DBA team, Testing team, other developers, external vendors / consultants and the management team in a fast-paced environment.
  • Professionally deliver status updates to both the management team as well as other project resources.
  • Creates and improves technical processes within project under direction.
  • Provides expert technical input to project risk, dependency, and assumption, change control and query / issue resolution discussions.
  • Carries out any other duties that may reasonably be required from time to time.
  • Lead development teams containing junior developers.
  • Mentor junior team members.
  • 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.

  • 3+ years Software Development / Full Life Cycle Development Process experience, with at least two of these using Ab Initio ETL toolset.
  • At least 2 years relational database experience programming in SQL
  • At least 2 years NIX experience (i.e. shell scripting)
  • Excellent communication skills
  • Strong analytical and problem-solving skills
  • Self-starter who is able to work unsupervised
  • Full lifecycle Data Warehouse experience including star schema, dimensional data models and ETL.
  • Desirable Criteria

  • Oracle RDBMS, PL / SQL.
  • Hadoop, Impala, Scala, Hive and Python skills a plus
  • Closing Date : Tuesday 21st January 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.

    Add to favorites
    Remove from favorites
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Application form