Data Integration and Reporting Analyst

The Data Integration and Reporting Analyst will support the ZSL 200 plan by ensuring high-quality data integration and reporting across the organisation. The role is crucial for maintaining the integrity and accessibility of data, enabling informed decision-making that drives our conservation efforts. The analyst will collaborate with multiple business units, including HR, marketing, and operations, to deliver tailored data solutions that align with ZSL's strategic objectives.
Key responsibilities:
Data warehouse development:

- Design and develop data warehouse schema and OLAP cubes to extend organisational reporting capabilities.
- Implement testing regime to ensure data consistency, accuracy and efficient to use.
- Have curiosity to stay informed about emerging technologies and provide recommendations to improve existing processes.

Data Integration:

- Seamlessly integrate data from various sources into the data warehouse.
- Utilize ETL tools, scripting languages (SQL, Python), and APIs for data integration.
- Data cleaning and preparation

Data Quality Assurance:

- Implement and manage processes to ensure data accuracy and integrity.
- SaveUse SQL Server, SSIS, and other tools to monitor and resolve data quality issues.

Maintenance and Optimization:

- Maintain and optimize the data warehouse, including performance tuning and routine backups.
- Monitor and proactively improve existing data pipelines
- Implement best practices for database configuration and backup/recovery processes.

Documentation and Standards:

- Develop and maintain comprehensive documentation for all data warehouse processes.
- Standardize processes to ensure consistency and ease of onboarding for new team members.

Collaboration with Stakeholders:

- Work with business units to understand data needs and provide tailored reporting solutions.
- Facilitate effective communication and collaboration to meet organizational data requirements.

Report Development:

- Design, develop, and maintain reports and dashboards using Power BI and other tools.
- Ensure reports are accurate, relevant, and support data-driven decision-making.

The duties and responsibilities described are not a comprehensive list and additional tasks may be assigned from time to time that are in line with the level of the role.

Proven experience in data analysis and integration
- Schema Design (for OLAP and OLTP type systems)
- Experience in developing dataflows with ETL tools, particularly SSIS
- Experience in data quality management and assurance

Knowledge and skills

- Advanced MS SQL
- Knowledge of PowerBI data modelling
- Understand and be able to implement data quality assurance concepts
- Advanced data warehousing skills
- Ability to work independently and as part of the team
- Information security concepts including GDPR and Data protection

This post is a blended role for office and home working; some travel to Zoo sites will be required.
- Ability to work occasional flexible hours, including evenings and weekends, as required.
- Commitment to promoting ZSL's values and a strong interest in wildlife conservation.

This role is subject to standard pre-employment checks, including the candidate's right to work in the UK.
We strongly encourage applications from all backgrounds and celebrate the value of having a team of employees with diverse skills, experiences, and heritage. We are committed to ensuring our teams can bring their authentic selves to work without fear of discrimination. ZSL has active equality networks for our staff with lived experience and those who provide active allyship in Race and Culture, Team Pride, Disability Network, and Menopause Network, complemented by our strategic EDI Steering Group.
About ZSL
We're ZSL, an international conservation charity. Through our unrivalled animal experts in our two zoos (London Zoo and Whipsnade Zoo), the work of our pioneering scientists, our dedicated conservationists, our purpose is to inspire, inform and empower people to stop wild animals going extinct. Our vision is a world where wildlife thrives and we're working every day to achieve this. From investigating the health threats facing animals, to helping people and wildlife live alongside each other, we are committed to bringing wildlife back from the brink of extinction.
What do we offer?
At ZSL, we are proud of our approach to employee benefits. Our benefits include:

- Our vision and purpose - you'll work alongside colleagues who are passionate about science-led conservation, knowing that you will help us to inspire, inform and empower people to stop wildlife going extinct
- Pension scheme - we offer a generous pension scheme with up to 12% contributory pension
- Flexible working - talk to us about your flexible working requirements and we will do everything we can to make sure you work in a way that suits you
- Holidays - 25 days annual leave allowance, plus UK bank holidays
- Wellbeing - access to a blended programme of wellbeing initiatives, including confidential access to our 24/7 Employee Assistance Programme
- Life assurance - eligible employees will be enrolled in ZSL's life assurance scheme from their first day
- Complimentary tickets - annual allocation of Whipsnade Zoo and London Zoo tickets, with a 30% discount in online and retail shops
- Cycle2Work - our cycle to work scheme enables you to lease a bicycle
- Season ticket loan - we offer an interest free loan for eligibly London-based employees to buy a season ticket for travel between home and work
- Family friendly policies - we offer enhanced maternity, paternity, and adoption packages