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