Data Engineer – Business Intelligence & Dashboards,AWS,BI tools (Power BI, QuickSight)

Key Responsibilities

Requirements Gathering & Stakeholder Engagement

• Partner with business units across the organization to understand their data and reporting needs

• Facilitate requirements workshops and interviews to document data requirements, KPIs, and reporting use cases

• Translate business requirements into clear data specifications for the data engineering team

• Act as the primary liaison between business stakeholders and the technical data platform team

Data Transformation & Modelling

• Design and develop data transformation logic to prepare curated datasets for reporting and analytics consumption

• Build and maintain data models in Amazon Redshift or the curated/consumption zone of the Data Lake

• Ensure data accuracy, consistency, and completeness for all reporting datasets

• Apply data quality checks and validation rules to support trust worthy business insights

Dashboard & Visualisation Development

• Design, develop, and maintain interactive dashboards and reports in Tableau(connected via Amazon Redshift or S3)

• Create near-real-time operational dashboards, ad-hoc analysis views, and scheduled reports tailored to business unit needs

• Ensure dashboards are intuitive and accessible for non-technical end users

• Iterate on dashboard designs based on user feedback and evolving business requirements

Data Catalogue & Documentation

• Document data definitions, business glossary terms, and dashboard logic in the AWS Glue Data Catalogue

• Maintain clear documentation of data sources, transformation logic, and report specifications

• Support self-service analytics by enabling business users to discover and access data independently

________________________________________

Requirements

Essential

• Minimum 3 years of experience in a data engineering, business intelligence, or data analyst role

• Proficiency in SQL for data querying, transformation, and modelling

• Hands-on experience with Tableau or equivalent BI tools (Power BI, Quick Sight) for dashboard development

• Experience working with cloud data platforms (AWS preferred — Amazon Redshift, S3, AWS Glue)

• Strong stakeholder engagement and communication skills, with the ability to translate business needs into technical requirements

• Experience in data modelling for analytics (star schema, dimensional modelling)

Preferred

• Familiarity with Python for data transformation and automation

• Experience with AWS Glue Data Catalogue or similar metadata management tools

• Exposure to Salesforce or other SaaS data sources

• Prior experience working in a government, or public sector environment