• Competitive
  • Edinburgh, Scotland, United Kingdom
  • Permanent, Full time
  • M&G Prudential
  • 2019-05-25

ETL & BI Platform Engineer

  • Full time
  • Edinburgh, Scotland, United Kingdom
  • 25 May 19

ETL & BI Platform Engineer

ETL and Business Intelligence Engineer

Edinburgh, Reading

Working with M&GPrudential as a ETL and Business Intelligence Platform Engineer means becoming part of a brand with a global reputation and an exciting vision: to become the best loved and most successful savings & investments business.

The forthcoming planned de-merger of M&GPrudential from the Prudential Group PLC provides a terrific opportunity to create a truly international and integrated savings and investments firm. A firm built on a rich and long history and with a commitment to an innovative future centred on the needs of customers and clients. There is a genuine opportunity to drive competitive advantage with value creation through the formation of this new organisation.

If you're inspired to join us, and have the necessary qualities, then this could be the opportunity you've been looking for.

The Role:

An exciting opportunity has arisen for a number of ETL and BI Platform Engineers to join our Transformation and Innovation Team.

The Transformation & Innovation team joins up our capabilities, processes and governance across Change and IT to provide both a strategic capability plus a leading edge technology footprint to support the transformation of M&GPrudential and delivery of our Vision for 2020 and beyond. The role of the function is to collaborate across the business to initiate, design and manage strategic change for M&GPrudential in a holistic manner. The function will also focus on providing affordable and reliable technology solutions and services that will very much be at the heart of Prudential's business success.

Our Platform teams, are looking for highly motivated Enterprise Security engineers with strong technical skills, problem solving abilities, deep customer affinity and strong communications skills to join our Platform operations teams.

Key Responsibilities:

  • Develop and Operate efficient ETL design and development principles to "Extract, Transform and Load" data in-line with best practice and DLG framework standards.
  • Analyse existing jobs, code and associated mechanism to establish a suitable migration approach, potentially using traditional and agile ways of working
  • Create necessary code and data integration jobs to process large volumes of complex data
  • Perform unit testing, system testing and UAT, using automated devOps practices
  • Design MI layout in conjunction with business analysts and business partners
  • Drive the continuous improvement of the standard design framework and data architecture principles
  • Support the platform and business operations teams to produce and maintain training/user guides, data dictionary and report libraries
  • Collaborate with Data Team teams to resolve queries and provide help to other team members to deal with complex queries
  • Provide assistance to other areas of the Data Team as required
  • Create a repeatable process to support continuous delivery, optimization, monitoring, release management of large scale ETL an BI capability within a wider cloud ecosystem
  • Work alongside Platform Engineers to stay up to date on the latest updates to the Wealth Agile Studio.
  • Develop and extend tools for continuous integration, automated testing and release management including adoption of tools like Git, JIRA, VSPS, Code Quality, Automated Testing tools etc.
  • Build and execute scripts to automate packaging and deployments
  • Prototype and pilot new tools and features to help deliver faster, with less manual intervention
  • Promote SAFe agile principles and methodology, follow various engineering practices and approaches

You will have:

  • BS in Computer Science or related field, or equivalent work experience.
  • At lesst 3+ years of developing and supporting Informatica suite of tools including: PowerCenter, Change Data Capture, Data Quality
  • At least 2 years of Oracle RDBMS technology including: SQL coding, Partitioning, Indexing, Performance tuning
  • Experience of cloud & container technologies and solutions(particularly Microsoft Azure, Kubernetes) and other SaaS/PaaS technologies
  • Able to succeed in a fast paced, high growth work environment. Experience of operating in agile working practices and exposure to Atlassian products (Jira and Confluence), Github
  • Exposure to continuous integration/ continuous development related systems and techniques (e.g. Azure DevOps (VSTS) / Jenkins)
  • Excellent verbal and written interpersonal skills, a phenomenal teammate with strong analytical, problem solving, debugging and troubleshooting skills
  • Beneficial if you have exposure to Azure databricks and other big data technologies
  • Intermediate/advanced level of understanding of excel
  • Beneficial if exposure to other technologies such as shell scripting, Java, Python.
  • Track record of use to manipulate management & operational systems
  • Track record of interacting with all levels of management
  • Track record in data analysis (through work)
  • The ability to drive decisions and be hands on.

People who work at M&GPrudential agree that ours is a great place to work with a brilliant team spirit. It's also an innovative, high-performing, commercial environment that's totally focused on customers. As an M&G Prudential colleague you'll get all the support you'd expect, including full training and professional development. You'll receive a competitive salary and reward package. And in a fast-changing world, you'll join an organisation that's leading the way in helping customers achieve their long-term financial goals.

M&GPrudential is committed to a diverse and inclusive workplace. Our role as an employer is very simple - to provide the right environment for talented people to do their best work, by respecting, understanding and valuing individual differences.

We welcome applications from individuals who have taken an extended career break, and we are willing to consider flexible working arrangements for all of our roles.

Recruiter: Beth Eckersley
Location: Edinburgh or Reading