- Microsoft SQL Server
Location: Fareham, UK
You’ll join a fairly new Data Analytics and Architecture team, 3 years to be exact, that has grown from strength to strength, achieving its initial objectives and winning a few industry awards along the way. We are continuing to enhance our data platform, delivering more business value whilst preparing for the future by shoring up our infrastructure in the Cloud.
Rather than a general “can you develop in X, Y and hopefully, Z set of requirements”. You’ll use SQL technologies to revoluntionise data and analytics across the business by consolidating and conforming all data across its legacy systems into a new data platform providing a single, consistent format that is accurate and reconciles to the main financial system.
You’ll have the opportunity to transform data across Zurich General Insurance UK. You will be working with a variety of complex datasets to tell a story about our business and our customers from designing new data solutions & developing new analytical pipelines. You will closely collaborate with our business stakeholders, leaders and colleagues to understand the business problems and opportunities and translate them into analytical and data solutions.
We understand that training is a vital tool to any employee no matter how much experience you have. Therefore as part of this role you will have the opportunity to enhance existing skills and learn new ones through a variety of on-site and external learning offerings.
If you have a ‘can-do‘ attitude, enjoy tasks varying from one day to the next and are able to make commercially sensible judgements then you may be exactly what we’re looking for.
You’ll improve the way our people spend their working days. On a global-scale.
This role is available part-time, job-share or full time. This is because we want the best people for our roles, and we recognise that sometimes those people aren’t available full-time.
Develop, maintain and support data pipeline processes from a variety of data sources such as databases, data files, XML, JSON & Hadoop.
Implement, maintain and enhance data pipeline processes for Data Warehouse and Data Mart solutions.
Design and document data integration technical specifications & processes.
Ensuring unit tests on development work is planned and carried out across the time.
Diagnosing and solving production issues.
Assist with Cloud migration strategy, using tools such as Azure Data Factory etc.
Your skills and experience:
Excellent problem-solving skills and able to deal with ambiguity.
Ability to work under pressure and shift priorities depending on business need.
Good communication and time management skills.
Able to work autonomously and as part of a team.
Good understanding of Relational Databases & Data Warehouse methodology such as Kimball, Inmon & Data Vault is essential.
Microsoft SQL Server experience.
Developing SSIS solutions ideally using BIML.
Experienced in ETL techniques such as change control, audit logging etc.
Good understanding of Relational Databases & Data Warehouse methodology such as Kimball, Inmon & Data Vault.
Knowledge of various architectures and methodologies like metadata, performance management and handling data quality issues.
Knowledge of some of the following languages & technologies would be advantages: C#, F#, Python, Spark, Hadoop, R, Apache Kafka, Attunity Compose, Scala, Java, .Net, NodeJS, JSON, XML.
Experience working in a DevOps environment including Agile, Scrum or Kanban project management methodology.
Experience with GIT source control or equivalent.
Continuous Integration/Deployment experience such as Azure DevOps, Jenkins, Bamboo etc.
Developing solutions in the Cloud desirable.
As well as a competitive salary we also offer an excellent lifestyle benefits package which includes –
25 days holiday plus an additional 3 volunteering days
Annual company bonuses
Contribution to medical cover
Discounted technology offers
Virtual GP appointments
Discounted gym membership,
Free flu jab
Discounted gadget insurance
At Zurich we will consider requests for flexible working on hiring. Many of our employees work flexibly in many different ways, including part-time, flexible hours, job share, an element of working from home or compressed hours. Please talk to us at interview about the flexibility you may need.
Who we are:
With about 55,000 employees serving customers in more than 170 countries we aspire to become the best global insurer as measured by our shareholders, customers and employees. If you're interested in working in a dynamic and challenging environment for a company that recognises and rewards your creativity, initiatives and contributions - then Zurich could be just the place for you. The success of our business is built on the contributions of our highly talented employees - people who work every day to position us at the forefront of the insurance industry. We therefore look to hire great people and we encourage those people to give their best.
You’ll feel the support of being part of a strong and stable company. A long-standing player in the insurance industry, we make every effort to address the career development needs and plans of our employees to ensure their success in the future.
At Zurich, we aim to have a diverse mix of employees that reflects our customers and the communities in which we live and work. Zurich is a workplace that values different opinions, respects personal needs, and provides equal opportunities for all, regardless of age, sex, race, religion or belief, disability, marriage/civil partnership, gender reassignment, pregnancy/maternity status and sexual orientation. Our approach ensures that Zurich is a place that values different opinions, respects personal needs, and provides equal opportunities for all. We are committed to continuous improvement and we offer access to a comprehensive range of training and development opportunities. Zurich is passionate about supporting employees to help others by getting involved in volunteering, charitable and community activity through the Zurich Community Trust.
So make a difference. Be challenged. Be inspired. Be supported, Love what you do. Work for us.
Primary Location United Kingdom-England-Fareham
Job Posting 09/01/20
Unposting Date Ongoing