Job description
Senior Data Engineer (SQL / BI) – Contract Daily Rate Position - Hybrid-Working Model (2 Days' On-site)
12-month initial contract term, this is a rolling / long-term contract position.
The Senior Data Engineer, will design, build, and deploy scalable data engineering solutions that enable data required to build and solve real business problems across underwriting, risk, and operations. They will be joining an established squad that has in flight work and commitments around moving, ingesting, and provisioning data not just from SQL databases but also from external sources such as CSV files or API’s. We need someone very comfortable in data processing particularly around ETL processes using Informatica (cloud) and SSIS. The successful candidate must be comfortable in moving/souring data between SQL-to-SQL databases along with SQL to Snowflake, utilising S3 storage to create centralised reusable data sets. Proficient in MS SQL to create stored procs, views and triage, optimise and update existing code as needed based on new or updated requirements.
Must be proficient in creating the required data sets/data products and in turn designing/building reports within Tableau/Power BI. Must be confident in communicating directly with business stakeholders and as part of an agile team to define requirements, enable the data needed and validate the outputs confidently/accurately. Beyond the technical build, they will collaborate closely with product owners, underwriters, business users, data scientists, and data engineers to translate real-world requirements into practical solutions.
Role:
- Design, develop, and maintain high-quality, scalable, and secure data and analytics solutions aligned with business goals
- Collaborate with business and IT teams to deliver data-informed strategies and solutions
- Lead full SDLC execution and continuous improvement using Agile practices
- Build and maintain advanced, testable, and reusable data products
- Perform data analysis, solution design, development, testing, and integration
- Troubleshoot and enhance existing data systems
- Mentor team members and incorporate external data to enrich datasets
Preferred Skills & Qualifications:
- Requires a BS/BA degree or equivalent experience.
Technical Skills:
- 5+ years experience with SQL.
- 3+ Experience with R, Python
- Experience with ETL/ELT tools such as Informatica Cloud, SSIS etc.
- Experience with BI tools not limited to Tableau, SSRS, PowerBI, Quick sight Business Objects, LOGI etc.
- Experience with Snowflake would be preferred.
- Distinct advantage experience with Dataiku
- Experience with Web Application Development would be preferred
- Experience with AWS would be preferred
- Experience with DevOPS and Data pipelines would be preferred
** Live Role - Apply for immediate consideration**
If you are interested in this role please apply or contact suzanne@stelfox.com in strictest confidence.
Please note:
We have a number of similar positions currently, and in the future, which we would like to discuss with you should you indicate your interest in this role. When we receive your application for this role, we will contact you to advise you of our process for other similar positions.
Stelfox is fully compliant with GDPR regulations and you can read more in our privacy policy here: https://www.stelfox.com/privacy-policy-gdpr/
Your shared data will not be disclosed or transferred to a third party data controller or data processor located outside the EEA unless we have obtained your express consent.
We look forward to working with you.
