At a Glance
- Tasks: Join a data modernisation programme, developing and optimising data pipelines in Azure.
- Company: Public sector client focused on innovative data solutions.
- Benefits: Remote work, competitive pay, and potential for permanent position.
- Other info: Opportunity for career growth in a dynamic, collaborative environment.
- Why this job: Make a real impact by transforming data architecture and improving management.
- Qualifications: Experience with SQL Server, Azure Data Factory, and strong communication skills.
The predicted salary is between 50000 - 70000 £ per year.
We are supporting a public sector client in hiring a Data Engineer to join a data modernisation programme already underway. The programme is migrating an existing on-premises database environment to Azure, and this role has arisen due to an urgent need to address data management challenges and improve data architecture across the organisation.
This is a hands-on engineering role spanning on-premises SQL Server environments and Azure cloud infrastructure, requiring someone who can operate confidently across both. The successful candidate will contribute across multiple phases of delivery, from data ingestion and staging through to cloud loading and pipeline development, working within an established programme team from day one.
This role suits an experienced Data Engineer with strong SQL, SSIS and Azure Data Factory credentials, comfortable joining a mid-delivery programme and contributing immediately. Candidates who also bring data modelling experience are particularly encouraged to apply.
Key Responsibilities- Understand and document existing business application databases and BI and data warehouse systems, contributing to programme knowledge and continuity.
- Develop and maintain data pipelines to ingest and stage data into an on-premises SQL Server 2022 environment, ensuring existing Qlik and SSRS reports continue to operate.
- Write and optimise SQL and T-SQL scripts and SSIS packages to support data movement, transformation and staging activity.
- Load and transfer data from the on-premises SQL Server environment to Azure SQL Database, using Azure Data Factory and Python Notebooks.
- Contribute to Azure Databricks workstreams as required across later programme phases.
- Work within Azure DevOps for backlog management, CI/CD pipeline activity and Git-integrated source control.
- Collaborate with Data Architects and wider programme teams to ensure data engineering activity aligns with the broader architecture and delivery roadmap.
- Hands-on experience with SQL Server 2022 or equivalent, including T-SQL development and SSIS for data ingestion and transformation.
- Proven experience loading and moving data between on-premises and Azure environments.
- Working knowledge of Azure SQL Database and Azure Data Factory for cloud-based data pipeline development.
- Experience working within Azure DevOps including backlog management and CI/CD pipeline activity.
- Comfortable operating within a mid-delivery programme, picking up existing work and contributing quickly.
- Strong communication skills with the ability to collaborate across engineering and architecture teams.
- Data modelling experience, including logical and physical data model design.
- Experience with Azure Databricks and Python Notebooks for data processing and transformation.
- Familiarity with TOAD Data Modeler or equivalent data modelling tooling.
- Experience supporting existing BI reporting environments including Qlik or SSRS during migration activity.
Data Engineer (SC Cleared) in England employer: Montash
Join a forward-thinking public sector organisation as a Data Engineer, where you will play a pivotal role in a transformative data modernisation programme. Enjoy the flexibility of remote work with occasional travel to our vibrant offices in Cumbria or London, and benefit from a collaborative work culture that prioritises employee growth and development. With opportunities for contract-to-permanent positions and a focus on innovative cloud solutions, this is an excellent chance to make a meaningful impact while advancing your career in a supportive environment.
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineer (SC Cleared) in England
✨Tap into Online Data Science Communities
Join online communities focused on data science like Kaggle, LinkedIn groups, or Reddit threads. These are goldmines for temporary gigs, as you can network with professionals and potentially hear about opportunities at companies like Montash before they're even advertised!
✨Show Off Your Skills With Projects
Got some cool data science projects? Showcase them on platforms like GitHub or create a personal portfolio website. This visibility is crucial for landing temporary roles—let recruiters see your actual skills in action, which can set you apart from the crowd.
✨Check Out Specialist Job Boards
For temp roles, hit up job boards dedicated to tech and data science, like Stack Overflow Jobs or DataJobs. These platforms often feature openings that you won’t find on general job sites, including contracts with companies like Montash.
✨Leverage University Resources
If you're currently at uni or recently graduated, tap into your school's career services. They often have connections with companies looking for temporary data science interns or contract workers, and they might even host job fairs with employers like Montash.
We think you need these skills to ace Data Engineer (SC Cleared) in England
Some tips for your application 🫡
Highlight Your Data Projects:When applying for a temporary data science role at Montash, make sure to showcase any relevant projects you've worked on. Whether it's a personal project, an academic undertaking, or contributions to an open-source initiative, detailing these experiences can really set you apart and demonstrate your practical skills.
Emphasise Your Analytical Skills:In your CV and cover letter, focus on the specific analytical skills that are key to data science. Mention any experience with statistical tools, programming languages like Python or R, and data visualisation software. Don't forget to include any certifications that may bolster your expertise!
Show Your Flexibility:Since this is a temporary role, it's important to convey your adaptability and willingness to learn. In your cover letter to Montash, emphasise how quickly you can get up to speed with new tools or projects. Highlight any previous experiences where you've had to adjust to new environments or challenges.
Craft a Unique Data-Driven Cover Letter:Instead of the usual generic cover letter, spice it up with some data! Maybe you’ve improved a process by 20% in a past role or cleaned a dataset with over a million entries. Use these stats to your advantage to grab Montash’s attention and show the tangible impact of your work.
How to prepare for a job interview at Montash
✨Showcase Your Analytical Skills
For a data science gig, it's crucial to demonstrate your analytical abilities. Be ready to discuss previous projects and the methodologies you used. Think about how you can quantify your impact—did your analysis improve efficiency or save costs? These are the stories that will stick with interviewers at Montash.
✨Brush Up on Technical Skills
You might face technical questions on tools relevant to data science, like Python, R, or SQL. Prepare to solve a problem live—perhaps they'll ask you to write a simple query or code snippet. It’s cool to talk about them, but we need to show we can do it in practice, especially in a temporary role where quick results matter.
✨Highlight Your Adaptability
Since this is a temporary position, emphasise your ability to learn quickly and adapt to new tools or workflows. Share examples of how you've thrived in fast-paced environments before, and how you can hit the ground running at Montash.
✨Prepare a Portfolio of Your Work
Bring your portfolio to the table—showcase projects where you've leveraged data science techniques to solve problems. Whether it’s a GitHub repository or a set of case studies, having tangible examples of your work will help you stand out and show what you bring to the team at Montash.
