onsite
Data Architect, NHM Unlocked - Natural History Museum
Software Engineer
Design and implement scalable data architectures for the NHM Unlocked programme, leveraging SQL, Python, ETL pipelines, and cloud‑based data warehousing to support research and public engagement initiatives.
About the role
Key Responsibilities
- Define and build robust data models that support the museum's research, visitor analytics, and digital outreach.
- Design, develop, and maintain ETL pipelines to ingest, transform, and load data from diverse sources, including collections databases, sensor feeds, and web analytics.
- Implement and optimise data warehousing solutions on cloud platforms, ensuring high performance, scalability, and security.
- Collaborate with scientists, curators, and digital teams to translate domain requirements into technical specifications.
- Establish data governance standards, metadata management, and documentation to ensure data quality and compliance.
Requirements
- Proven experience in data architecture, data modelling, and database design (relational and NoSQL).
- Strong SQL proficiency and hands‑on experience with Python for data processing and automation.
- Expertise in building ETL workflows and data pipelines using tools such as Airflow, dbt, or similar.
- Experience with cloud data services (e.g., AWS Redshift, Google BigQuery, Azure Synapse) and big‑data technologies like Spark or Hadoop.
- Excellent communication skills and ability to work cross‑functionally with research and digital teams.