At a Glance
- Tasks: Lead the development and support of SQL data warehouses, ensuring data quality and integrity.
- Company: Join Certain Advantage, a forward-thinking company in the Facilities Management sector.
- Benefits: Enjoy a hybrid work model, competitive pay, and opportunities for professional growth.
- Other info: Dynamic role with a focus on innovation and technical excellence.
- Why this job: Make a real impact by delivering critical data solutions for public sector clients.
- Qualifications: Experience with Microsoft Stack, ETL procedures, and collaborative team environments.
The predicted salary is between 60000 - 75000 £ per year.
Certain Advantage are hiring for a Data Warehouse Technical Lead for a 12-month assignment, based in Leatherhead, Surrey. The role is on a hybrid basis: 3 days in the office, 2 days remote.
Your responsibilities:
- Experience developing, deploying and supporting multi-data source SQL data warehouses in an on-premises 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 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.
The individual:
- 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.
- Experience of collaborating in a MS Teams environment.
- Knowledge of the Facilities Management industry.
- Experience of delivering projects to or for public sector clients.
Data Warehouse Manager in Leatherhead employer: Tatton Recruitment Group
Contact Detail:
Tatton Recruitment Group Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Warehouse Manager in Leatherhead
✨Tip Number 1
Network like a pro! Reach out to your connections in the data warehouse field and let them know you're on the hunt for a role. You never know who might have the inside scoop on opportunities that aren't advertised.
✨Tip Number 2
Get your LinkedIn game on point! Make sure your profile showcases your skills in SQL, ETL procedures, and the Microsoft Stack. Engage with relevant content and connect with industry professionals to increase your visibility.
✨Tip Number 3
Prepare for interviews by brushing up on your technical knowledge. Be ready to discuss your experience with data models, Paginated Reports, and any challenges you've faced in previous roles. Confidence is key!
✨Tip Number 4
Don't forget to apply through our website! We love seeing candidates who are proactive and take the time to submit their applications directly. It shows you're serious about landing that Data Warehouse Manager role!
We think you need these skills to ace Data Warehouse Manager in Leatherhead
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with SQL data warehouses and the Microsoft Stack. We want to see how your skills match up with what we're looking for, so don’t be shy about showcasing your relevant projects!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're the perfect fit for the Data Warehouse Manager role. Share specific examples of your past experiences that align with our needs, especially around ETL procedures and data governance.
Showcase Your Collaboration Skills: Since we value teamwork, make sure to mention any experiences where you've built collaborative relationships in a technical environment. Highlight your work in scrum teams or any cross-functional projects to show us you can thrive in our hybrid setup.
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it gives you a chance to explore more about us and what we do!
How to prepare for a job interview at Tatton Recruitment Group
✨Know Your Tech Inside Out
Make sure you brush up on your knowledge of the Microsoft Stack, especially SSIS, SSRS, and SSAS. Be ready to discuss your experience with SQL data warehouses and ETL procedures, as these are crucial for the role.
✨Showcase Your Problem-Solving Skills
Prepare examples of how you've identified and resolved technical issues in previous roles. Highlight your experience in a second-line support environment and how you managed root causes to ensure smooth operations.
✨Demonstrate Collaboration
Since building collaborative relationships is key, think of instances where you've worked effectively within scrum teams or with business stakeholders. Be ready to share how you’ve contributed to technical and data governance.
✨Familiarise Yourself with the Facilities Management Sector
If you have experience in the Facilities Management industry, make sure to mention it. If not, do some research to understand the sector's challenges and how your skills can help address them.