Senior Lead, DWH & BI Architect in London

Senior Lead, DWH & BI Architect in London

London Full-Time 63000 - 77000 £ / year (est.) Home office (partial)
S

At a Glance

  • Tasks: Lead the design and delivery of innovative data solutions for impactful projects.
  • Company: Join Save the Children, a global leader in child welfare.
  • Benefits: Flexible working options, competitive salary, and a chance to make a difference.
  • Other info: Collaborative environment with opportunities for personal and professional growth.
  • Why this job: Shape the future of data technology while helping children worldwide.
  • Qualifications: Experience in data architecture and strong analytical skills required.

The predicted salary is between 63000 - 77000 £ per year.

Save the Children International has an exciting opportunity to join our global team. The purpose of the team is to lead on the strategic planning, design and delivery of digital and data technology solutions used across SCA. The team will be key to defining the Technology strategy including roadmaps for product developments, ensuring our systems remain fit for purpose, maximising the value they deliver and enabling our organisation to achieve impact for children.

This role will be responsible for the architecture, design, development and enhancement of Data warehouse, Analytics & Business Intelligence (BI) solutions within the organisation, with varied leading-edge technologies. This role will partner with business stakeholders to understand their requirements and ensure effective delivery of analytical capabilities to meet their needs, utilising best practices and state of the art technologies.

The role holder will contribute to the definition of Data Warehousing, Business Intelligence and Data Analytics strategy & roadmap for SCI, leading measurable improvements in providing the stakeholders with timely and accurate information in order to effectively implement our strategy.

Principal Accountabilities

  • Architect and design data warehouse, analytics and reporting solutions that meet business needs, ensuring implementations follow established architectural principles and are extensible and scalable for future needs.
  • Own the data models that underpin these solutions: logical and physical warehouse models, conformed dimensions and the semantic/reporting layer, selecting the appropriate modelling approach for each use case and ensuring core business entities and measures are defined once and reused consistently.
  • Contribute technical input, options and feasibility analysis to inform the DWH/BI strategy and roadmap.
  • Create and maintain architectural and design artefacts so that up-to-date documentation for the relevant programmes and projects is readily available, and ensure knowledge is disseminated across technical and business teams.
  • Ensure deliverables are subject to the required governance and approvals, with appropriate version control and availability.
  • Engage business stakeholders across member and country offices to understand analytical needs, agree priorities and build shared understanding of the target architecture, translating and negotiating non-technical requirements into detailed technical specifications.
  • Support feasibility studies, planning and estimation for transformation projects and initiatives.
  • Ensure total cost of ownership is fully understood, including support costs, and that there is a clear view of the costs of wider rollout across the movement.
  • Provide technical mentorship and design guidance to developers, analysts and designers, applying tried-and-tested patterns and industry best practice.
  • Provide technical estimates for project tasks and proactively surface technical risks and issues for prioritisation.
  • Recommend, schedule and perform improvements and upgrades to existing solutions.
  • Provide architectural input to the evaluation and oversight of technology suppliers and implementation partners, assessing platform and product options, reviewing partner designs against agreed architecture and standards, and informing procurement decisions.
  • Proactively identify new and innovative solutions that deliver clear business value and build proofs of concept to demonstrate them.
  • Partner with the Data Governance function to ensure data warehouse and BI solutions align with the enterprise data model and the organisation's common (canonical) data model.
  • Ensure solutions are designed and operated in line with regulatory requirements, data protection obligations and charity policies, with particular care for the sensitivity of programme and beneficiary data.

Experience and Skills

Essential

  • Proven experience designing, building and deploying data warehouse, data platform, analytics and BI solutions in large, complex organizations.
  • Strong grounding in data modelling, relational, dimensional and class modelling.
  • Strong knowledge of data transformation and common ETL/ELT patterns and strategies.
  • Experience with cloud-based data platform delivery.
  • Working knowledge of data governance, data quality, security and access control.
  • Experience shaping large reporting and analytics programmes.
  • Experience acting as the lead technical authority on data platform and BI initiatives.
  • Ability to build credibility and influence across teams.
  • Good interpersonal and communication skills in written and spoken English.

Desirable

  • Hands-on experience with Microsoft Fabric or a track record of moving a platform towards it.
  • Experience with the wider Microsoft data and analytics stack.
  • Experience working on enterprise or business architecture strategies.
  • Experience of agile project delivery.
  • Experience of working in a global team with offshore project team members.

Education and Qualifications

Essential

  • Computing degree - BSc, BA or equivalent experience.

Desirable

  • Microsoft Certified (e.g. MCSD) TOGAF or other Enterprise/ Business/ Solution Architecture certifications.

Working at Save the Children International

Save the Children is the world's leading organisation for children, employing ~25,000 staff. We save children's lives. We fight for their rights. We help them fulfil their potential. Through our work in 116 countries, we put the most deprived and marginalised children first.

Diversity, Equity and Inclusion and Equal Opportunities DEI is core to our vision, values and global strategy. Save the Children is committed to creating a truly diverse, equitable and inclusive organisation.

Application Information

Please attach a copy of your CV and cover letter with your application. Applications will be reviewed on a rolling basis and the job advert may be closed earlier than advertised subject to the volume of suitable applicants.

Senior Lead, DWH & BI Architect in London employer: Save the Children Fund

Save the Children International is an exceptional employer, offering a meaningful and rewarding career dedicated to improving children's lives globally. With a collaborative and inclusive work culture, employees are empowered to innovate and drive impactful change while enjoying flexible working options and opportunities for professional growth. Joining our team means being part of a passionate community committed to diversity, equity, and inclusion, ensuring that every child's voice is heard and valued.

S

Contact Details:

Save the Children Fund Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Senior Lead, DWH & BI Architect in London

Get Involved in Data Science Meetups

Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Save the Children Fund!

Show Off Your Projects

Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Senior Lead, DWH & BI Architect at Save the Children Fund.

Leverage Professional Networks

Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Save the Children Fund.

Apply Directly through Our Website

When you find a suitable opening like Senior Lead, DWH & BI Architect at Save the Children Fund, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!

We think you need these skills to ace Senior Lead, DWH & BI Architect in London

Data Warehouse Architecture
Business Intelligence Solutions
Data Modelling
ETL/ELT Patterns
Cloud-Based Data Platforms
Data Governance
Data Quality Management

Some tips for your application 🫡

Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!

Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!

Craft a Tailored Cover Letter:For a full-time role at Save the Children Fund, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.

Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Save the Children Fund. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!

How to prepare for a job interview at Save the Children Fund

Brush Up on Your Statistics

For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!

Showcase Your Projects

Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!

Get Comfortable with Python and R

Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Save the Children Fund!

Prepare for Case Studies

Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.