Data & Analytics Engineer

Responsibilities

•Design and build data pipelines and ETL processes to move and transform data reliably across Hickory's systems

•Develop and maintain data models that support reliable, well-structured reporting and analytics

•Write and optimise SQL across data pipelines, reporting layers, and ad hoc analysis

•Build and maintain Power BI dashboards and reports that give stakeholders clear, accurate visibility into business performance

•Apply data structures and algorithms thinking to design efficient, scalable data processes

•Apply version control and CI/CD practices to data pipeline and analytics code, ensuring changes are tested and deployed safely

•Apply AI tools and literacy to accelerate data engineering, analysis, and reporting work

•Contribute to data warehouse design, database administration, or solution architecture where relevant

•Work closely with stakeholders across the business to understand reporting needs and translate them into reliable data solutions

Requirements

• 3 to 5 years relevant experience

•Strong SQL skills, comfortable writing and optimising complex queries across large datasets

•Solid experience with data modelling, structuring data for reliable and maintainable reporting

•Hands-on experience building data pipelines and ETL processes

•Experience building data visualisations and dashboards, ideally in Power BI

•Good grounding in data structures and algorithms

•Practical experience with version control (e.g. Git) and CI/CD pipelines

•Working AI literacy - comfortable using AI-assisted tools to support data engineering and analysis

•Exposure to Azure, data warehousing, database administration, or solution architecture is an advantage, not a requirement

•Analytical and curious, detail-oriented, a strong problem solver who communicates well and can work independently

Good to have

• SQL

• Data modelling

• Data pipelines / ETL

• Data visualisation

• Power BI

• Data structures and algorithms

• AI literacy

• Version control and CI/CD

• Azure

• Data warehouse

• Database administration

• Programming / scripting

• Solution architecture

Soft skills

• Analytical and curious

• Strong problem solver

• Good communicator

• Detail oriented

• Self starter who can work independently