At a Glance
- Tasks: Lead the development and evolution of a critical data warehouse environment.
- Company: Join a forward-thinking company in Surrey with a hybrid working model.
- Benefits: Enjoy a competitive salary, flexible work arrangements, and professional growth opportunities.
- Other info: Dynamic role with opportunities to work on exciting projects in a supportive environment.
- Why this job: Make a real impact by designing innovative data solutions and collaborating with diverse teams.
- Qualifications: Experience in SQL data warehouses and strong technical leadership skills required.
The predicted salary is between 60000 - 80000 € per year.
We have an exciting opportunity for a 12-month assignment to be based in our clients’ offices in Surrey. The role will be Outside of IR35 with a hybrid 3 day/2 day working pattern.
Purpose of the Role
For an experienced Data Warehouse Technical Lead to develop, support and evolve a critical on-premise ‘common data environment’ (CDE) within a wider integrated solution. The role will involve designing, building, testing, supporting and evolving the CDE, ensuring it receives data from multiple Company systems and Client System sources.
Experience and Skills:
- Essential:
- Experience developing, deploying and supporting multi-data source SQL data warehouses in an on-premise environment.
- Experience of the full Microsoft Stack – SSIS, SSRS and SSAS.
- Experience creating, documenting and developing data models to deliver management information outcomes.
- Experience developing ETL procedures from multiple data sources to one data source.
- Adept at building collaborative technical and business working relationships to deliver outputs and outcomes.
- Experienced in authoring technical documentation, able to write clear and maintainable artefacts to support developments.
- Has demonstrated technical leadership: able to understand technical trends and convert into tactical and strategic advantages; able to explain and demystify technology to non-technical audiences.
- Experienced in a second-line technical resolver support environment, able to identify technical issues and manage from root cause to rectification.
- Experience of using Paginated Reports for Power BI to deploy paginated reports into Azure to management information consumers.
- Experience of creating on-prem data warehouse that provides data to a Cloud Azure instance/Power BI/SharePoint.
- Experienced in working with Project and Programme Management environment, assisting in creating detailed plans and ensuring these are accurate, viable and maintainable.
- Desirable:
- Experience working FM Integrator Environment, especially creating ETL routines from Concept Evolution to Data Warehouse.
- Experience of creating ETL routines from client data sources where data quality/integrity may be an issue.
- Experience of VBA and .BAT programming.
- Experience of scrum teams & sprint ceremonies.
- Experience of leading/contributing to technical and data governance.
- Understands Agile best practices (code reviews, unit tests, TDD).
- Experienced Continuous Integration & Continuous Delivery.
- Experience of collaborating in a MS Teams environment.
- Knowledge of the Facilities Management industry.
- Experience of delivering projects to or for public sector clients.
Core Responsibilities and Duties
Working within the FMI ITIM Team:
- Specifying high-level/low level data models, ETL plans and data warehouse designs.
- Building and unit testing data warehouses as part of wider integrated solution.
- Developing suite of paginated reports and dashboards to deliver multi-organisational management information requirements.
- Assisting project management activities in planning, effort estimating and progress reporting.
- Supporting and developing build solution as part of BAU service management.
- Working with the FMI BI/MI Lead.
- Agreeing MI Operating Model that ensures future MI requirements for stakeholders are captured, assessed, developed and delivered in a structured, auditable and repeatable manner.
- Working with the FMI Technical Product Owner.
- Advising on and contributing toward development of strategic Technical Product set, especially the data & reporting layer strategy.
- Supporting associated technical transformation/mobilisation projects through all phases from definition through development to close.
Data Warehouse Technical Lead in London employer: Evolve Technical Recruitment
Join a forward-thinking organisation in Surrey as a Data Warehouse Technical Lead, where you will thrive in a hybrid work environment that promotes flexibility and collaboration. Our company values innovation and offers extensive opportunities for professional growth, ensuring you can develop your skills while contributing to impactful projects. With a supportive work culture and a commitment to employee development, we provide a unique platform for you to excel in your career while making a meaningful difference.
Contact Detail:
Evolve Technical Recruitment Recruiting Team
StudySmarter Expert Advice🤫
We think this is how you could land Data Warehouse Technical Lead in London
✨Network Like a Pro
Get out there and connect with people in the industry! Attend meetups, webinars, or even just grab a coffee with someone who’s already in the role you want. Building relationships can open doors that a CV just can’t.
✨Show Off Your Skills
When you get the chance to chat with potential employers, don’t hold back! Share specific examples of your past projects, especially those involving SQL data warehouses and ETL procedures. Let them see how your experience aligns perfectly with what they need.
✨Be Ready for Technical Questions
Brush up on your technical knowledge before interviews. Be prepared to discuss the Microsoft Stack, data models, and any relevant tools like Power BI. Showing you know your stuff will give you a serious edge!
✨Apply Through Our Website
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Data Warehouse Technical Lead in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Data Warehouse Technical Lead role. Highlight your experience with SQL data warehouses and the Microsoft Stack, as these are key for us. Use specific examples that showcase your skills in developing ETL procedures and technical documentation.
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Explain why you're the perfect fit for this role and how your experience aligns with our needs. Don’t forget to mention your ability to build collaborative relationships and your technical leadership experience.
Showcase Your Technical Skills:In your application, be sure to highlight your technical skills, especially around data modelling and reporting. We want to see your familiarity with Paginated Reports for Power BI and your experience in an on-premise environment, so make those stand out!
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you don’t miss any important updates. Plus, it’s super easy to do!
How to prepare for a job interview at Evolve Technical Recruitment
✨Know Your Tech Inside Out
Make sure you’re well-versed in the Microsoft Stack, especially SSIS, SSRS, and SSAS. Brush up on your SQL skills and be ready to discuss your experience with multi-data source data warehouses. Being able to explain technical concepts clearly will impress your interviewers.
✨Showcase Your Leadership Skills
Prepare examples of how you've demonstrated technical leadership in past roles. Think about times when you’ve converted technical trends into strategic advantages or simplified complex tech for non-technical audiences. This will highlight your ability to lead and communicate effectively.
✨Be Ready to Discuss ETL Procedures
Since the role involves developing ETL procedures, come prepared to talk about your experience with this process. Share specific examples of how you’ve handled data quality issues and integrated multiple data sources. This shows you can tackle real-world challenges.
✨Understand the Business Context
Familiarise yourself with the Facilities Management industry and the specific needs of public sector clients. Being able to relate your technical skills to business outcomes will demonstrate that you understand the bigger picture and can contribute to the organisation's goals.
