Analyst - Data

• Lead the design, construction, and optimisation of SQL Server databases that support core business applications and reporting. 
• Own the database schema, data models, indexing strategies, and performance tuning. 
• Manage data ingestion pipelines and integrations, ensuring reliable, accurate, and high-quality data flow into the database. 
• Oversee database governance, documentation, security standards, and access controls. 

Data Engineering & Reporting 

• Build and maintain ETL/ELT pipelines using tools such as Azure Data Factory. 
• Develop and deploy SSMS and SSRS custom reports for operational and strategic insight. 
• Build robust data models for Power BI and support analysts with well-structured datasets. 
• Use Python, R and others as preferred or required, for automation, data transformation, and advanced analytics. 

Collaboration & Stakeholder Engagement 

• Act as the primary technical owner for the database (s) within multidisciplinary project teams. 
• Translate business and project requirements into scalable database solutions. 
• Troubleshoot issues and proactively improve performance, reliability, and usability. 
• Work closely with solution architects and technical development teams 

Desirable Geospatial & Domain Data 

• Manage and optimise spatial datasets within PostGIS or SQL Server spatial components. 
• Work with GIS teams to ensure high quality geospatial data feeds into applications and dashboards.