Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the Data Warehouse team in managing data loads, reporting, and database architecture.
- Company: Join Cornerstone, a leader in telecommunications, driving innovative data solutions.
- Benefits: Enjoy full-time employment with opportunities for remote work and professional development.
- Why this job: Be part of a dynamic team shaping the future of data management and business intelligence.
- Qualifications: Experience in team leadership, database design, and MSSQL stack is essential.
- Other info: This role offers a chance to mentor and develop a customer-centric team.
The predicted salary is between 43200 - 72000 £ per year.
Lead and support the Datawarehouse team in the production of BAU data loads, storage, DR, reporting, and outbound data. Be the authority and give guidance on database management, development, architecture, future design considerations, performance improvements, and monitoring. Develop and apply best practices in the above areas, creating and delivering a roadmap for the data warehouse's future. Work closely in collaboration with teams across Cornerstone and its third-party suppliers to ensure the efficient operation of the strategic information services and the delivery of the overall BI Team roadmap and project developments.
Key Responsibilities
- Team and task management
- Lead the data warehouse team, managing workload and expectations to the business.
- Develop/manage team and pipeline of work to deliver all aspects of issues, reporting, and development in a timely fashion.
- Work with the team to build objectives and plan in line with the BI roadmap.
- Lead, develop, and mentor a forward-looking customer-centric Data Warehouse Team.
- Work with the business and the rest of the BI team to understand future requirements and plan accordingly.
- Represent and promote the interests of the data warehouse team across the business through appropriate meetings around BAU and projects.
- Delivery manage and assist with BAU work and report production, including review and continual development of the daily and overall warehouse processes/controls to improve the performance and reliability of the system.
- Lead and manage the team to operate in and across specialist functions such as Data Engineering.
- Work with the team to deliver best practice database design to meet the requirements of the business.
- Manage and assist in the integration of new data sources into the data warehouse in a timely fashion to allow reporting and data storage.
- Drive the Data Warehouse team to deliver solutions that fulfill the Business information needs and align with the Data strategy and vision.
- Monitor Azure costs and proactively look for ways of optimizing the data warehouse to reduce spend.
- Be the authority on database architecture and design for current and future development.
- Implement and maintain access to the data warehouse and databases using Role Based Access Controls (RBAC) principles.
Required Qualifications
- Team leadership and development
- Database architecture and design including pros and cons of relevant schemas/structure
- All aspects of MSSQL stack: SSIS, SSRS, SSMS, etc.
- Database installation, configuration, maintenance, monitoring, backups, and recoveries
- Bulk Copy Program
- SQL Profiler
- Telecoms background
Seniority Level: Mid-Senior level
Employment Type: Full-time
Job Function: Information Technology
Industries: Telecommunications
Data Warehouse Manager employer: Cornerstone
Contact Detail:
Cornerstone Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Warehouse Manager
✨Tip Number 1
Familiarise yourself with the latest trends in data warehousing and database management. Being knowledgeable about current technologies and methodologies will help you stand out as a candidate who can lead and innovate within our Data Warehouse team.
✨Tip Number 2
Network with professionals in the telecommunications and data management sectors. Attend industry events or join relevant online forums to connect with potential colleagues and gain insights into what we value at StudySmarter.
✨Tip Number 3
Prepare to discuss your experience with team leadership and development. We’re looking for someone who can mentor and guide a team, so be ready to share specific examples of how you've successfully managed teams in the past.
✨Tip Number 4
Showcase your understanding of Azure and cost optimisation strategies. Since monitoring Azure costs is a key responsibility, demonstrating your ability to manage budgets effectively will make you a more attractive candidate for us.
We think you need these skills to ace Data Warehouse Manager
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience in data warehouse management, database architecture, and team leadership. Use specific examples that demonstrate your ability to lead a team and manage data processes effectively.
Craft a Compelling Cover Letter: In your cover letter, express your passion for data management and your vision for the future of data warehousing. Mention how your skills align with the responsibilities outlined in the job description, particularly in areas like performance improvements and collaboration with teams.
Showcase Technical Skills: Clearly list your technical skills related to the MSSQL stack, including SSIS, SSRS, and SSMS. Provide examples of how you've used these tools in past roles to improve data processes or reporting.
Highlight Leadership Experience: Emphasise your experience in leading and developing teams. Discuss specific instances where you have mentored team members or managed workloads effectively, as this is crucial for the role of Data Warehouse Manager.
How to prepare for a job interview at Cornerstone
✨Showcase Your Leadership Skills
As a Data Warehouse Manager, you'll be leading a team. Be prepared to discuss your leadership style and provide examples of how you've successfully managed teams in the past. Highlight any mentoring or development initiatives you've implemented.
✨Demonstrate Technical Expertise
Familiarise yourself with the MSSQL stack, including SSIS, SSRS, and SSMS. Be ready to discuss your experience with database architecture and design, as well as any specific projects where you've optimised performance or integrated new data sources.
✨Understand Business Needs
The role requires collaboration with various teams to understand future requirements. Prepare to discuss how you've previously aligned technical solutions with business objectives and how you plan to gather and implement feedback from stakeholders.
✨Discuss Cost Optimisation Strategies
Since monitoring Azure costs is part of the job, think about ways you've previously reduced operational costs in data management. Be ready to share specific strategies or tools you've used to optimise data warehouse performance while keeping expenses in check.
