At a Glance
- Tasks: Design and develop data models, ETL processes, and reporting solutions using SQL and SSIS.
- Company: Join a leading tech firm in London with a focus on data engineering.
- Benefits: Competitive salary, flexible work arrangements, and opportunities for professional growth.
- Other info: Immediate start with potential for contract extensions in a dynamic environment.
- Why this job: Make an impact by optimising data solutions and collaborating with diverse teams.
- Qualifications: Strong SQL, SSIS, and ETL experience; data modelling skills required.
The predicted salary is between 72000 - 88000 £ per year.
Location
- London - 3 days work from office- Mandatory
- Fixed term contract/ Contract inside IR 35 with possible extensions
- Immediate start
Technology
SQL Server, SSIS, ETL, Data Modelling, Reporting Platforms
Role Overview
We are looking for an experienced
Senior Data / Reporting Developer to join our client team responsible for data modelling, ETL and reporting solutions supporting Seismic and similar reporting platforms.
The role requires strong hands-on technical expertise in SQL, SSIS, ETL and data modelling, together with experience developing and supporting enterprise reporting solutions.
The successful candidate will work closely with business analysts, product owners, reporting teams and other technology stakeholders to deliver robust, scalable and high-quality data solutions..
Key Responsibilities
- Design, develop and maintain data models supporting reporting and analytics requirements.
- Develop robust
ETL processes using SQL Server Integration Services (SSIS).
- Write complex and optimised SQL queries, stored procedures and data transformation logic.
- Develop and maintain data pipelines feeding Seismic and/or similar reporting tools.
- Analyse existing reporting solutions and identify opportunities for optimisation and automation.
- Work with business and reporting teams to understand data requirements and translate them into technical solutions.
- Perform data mapping, transformation and reconciliation across multiple source systems.
- Ensure data quality, accuracy, completeness and consistency across reporting outputs.
- Troubleshoot production issues and provide root-cause analysis and permanent fixes.
- Support testing, deployment and release activities across development and production environments.
- Produce technical documentation covering data models, ETL processes and reporting interfaces.
- Work collaboratively with onsite and offshore technology teams.
Essential Technical Skills
- Strong SQL Server / T-SQL development experience.
- Strong hands-on experience with SSIS and ETL development.
- Solid understanding of relational database design and data modelling.
- Experience designing and implementing data transformation and integration processes.
- Experience with enterprise reporting tools/platforms, preferably Seismic or comparable products.
- Ability to analyse complex datasets and troubleshoot data-quality issues.
- Good understanding of data warehousing concepts and reporting architectures.
- Experience with performance tuning of SQL queries and ETL processes.
- Strong software-development lifecycle and Agile delivery experience.
Desirable Skills
- Previous Seismic experience.
- Experience with other enterprise reporting platforms comparable to Seismic.
- Knowledge of financial-services data and reporting standards.
- If interested, please apply with your updated CV for an immediate consideration
- #UST
ETL, Data Modeling, SQL Server Integration Services, Reporting and Analytics, Microsoft SQL Server, Seismic, Data Validation, Agile, Data Mapping, Performance Tuning, Issue Analysis
Senior Data / Reporting Developer (Lead II - Data Engineering) in London employer: UST
As a Salesforce Delivery Lead in London, you will join a dynamic and innovative team within the Financial Services sector, where your expertise will drive impactful technology initiatives. Our hybrid work culture promotes flexibility while fostering collaboration, and we are committed to your professional growth through continuous learning opportunities and mentorship. With a focus on Agile practices and high-performance teams, we offer a rewarding environment that values your contributions and encourages meaningful engagement with stakeholders.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Data / Reporting Developer (Lead II - Data Engineering) in London
✨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 UST 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 UST.
✨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 UST.
We think you need these skills to ace Senior Data / Reporting Developer (Lead II - Data Engineering) in London
Some tips for your application 🫡
Highlight Your Data Projects:When applying for a temporary data science role at UST, 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 UST, 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 UST’s attention and show the tangible impact of your work.
How to prepare for a job interview at UST
✨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 UST.
✨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 UST.
✨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 UST.
