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