Overview
Senior Application Support Engineer role at HANNON Transport Ltd. Location: Aghalee (base location, travel expected). Salary range: £45k to £55k depending on experience.
Job Information
Job Title Senior Application Support Engineer
Department IT
Reports To Head of IT
Location Aghalee (base location, travel expected)
Duties And Responsibilities
* Data Platform & BI (AWS)
Design and implement modern data architectures: S3 data lake, Glue Data Catalog/ETL, Athena, Redshift (or equivalent), Lake Formation (governance), and QuickSight (or equivalent BI tool) (datasets, in memory acceleration, RLS/columnlevel security).
* Data Pipelines & Automation
Build reliable data pipelines (batch/stream) using Glue/Lambda/Step Functions, event-driven patterns (SQS/SNS/EventBridge), and CI/CD for data (IaC with Terraform/CloudFormation).
* Data Modeling & QA
Create dimensional models (star/snowflake), conformed dimensions, and robust SQL/Python transformations with strong testing and documentation.
* Monitoring & Governance
Implement monitoring, lineage, and cost optimisation; define and track RPO/RTO for analytics platforms.
* Applications & Integrations (TMS/WMS/FMS)
Provide Level 3 application support across transport, warehouse, and fleet systems; triage incidents, tune SQL, and deliver permanent fixes.
* System Integrations
Build and maintain systems integrations via REST/SOAP APIs, EDI (XML/JSON) schemas, and flatfile interfaces (SFTP/AS2).
* Runbooks & Observability
Author integration runbooks, error handling/retry patterns, and observability (dashboards/alerts) for data/app interfaces.
* SQL & Python Engineering
Write high-quality TSQL (procedures, functions, views), optimize queries/indexes, and manage release/change control.
* Development & CI/CD
Develop Python services and utilities (ETL jobs, API clients, data quality checks, automation tools), packaged and containerised where suitable.
* Version Control
Use Git and CI pipelines for versioning, testing, and releases.
* AI in BI & Operations
Integrate AI services to augment BI (e.g., automated insights, anomaly detection, natural-language Q&A, intelligent alerting) using platforms such as AWS Bedrock (and/or Azure equivalents), embedding safely into apps/dashboards.
* Governance & Safety
Implement RAG/semantic search on approved datasets; enforce guardrails, access controls, and auditability.
* Automation & Process Improvement
Replace spreadsheet/offline processes with governed datasets, apps, or workflows; standardise master data and reference tables.
* Internal Tools
Build lightweight internal tools (portals, scripts, APIs) to streamline business workflows; document and train users.
* Security, Governance & DR
Enforce least privilege, RBAC, and secrets management (KMS/SSM Parameter Store/Key Vault); apply data governance (naming, cataloguing, classification, retention), access reviews, and audit logging across AWS/Microsoft estates; contribute to backup/restore strategies and DR tests for data platforms and critical applications.
Essential
* Bachelors degree in Computer Science/Information Systems (or equivalent experience).
* 5+ years professional experience across SQL (TSQL preferred), application support, and BI/data platforms.
* Strong Python skills; proven experience delivering production ETL/ELT pipelines.
* Hands-on with AWS analytics (S3/Glue/Athena/Redshift), and experience with a mainstream BI platform Power BI currently in use; QuickSight.
* Solid understanding of data modelling, performance tuning, and testing; comfortable with Git/CI and infrastructure as code.
* Excellent stakeholder engagement, documentation, and problem solving; able to translate business needs into data solutions.
* Experience supporting and integrating operational systems (TMS/WMS/FMS) and working with APIs/EDI/XML/JSON.
Desirable
* AWS: Data Analytics Specialty, Solutions Architect, Developer or SysOps; QuickSight Author/Admin.
* Microsoft: DP203 (Data Engineering), PL300 (Power BI), Fabric Analytics Engineer.
* Databases: Microsoft SQL Server (MCSA/DP300), PostgreSQL, MySQL experience beneficial.
* Integration/Security: ITIL v4, Purview, Azure Data Factory, Kafka/Kinesis, or message brokers.
* Familiarity with bedrock-hosted LLMs (e.g., Claude) or Azure OpenAI, and vector databases.
Personal Attributes
* Analytical mindset with a solutions-focused approach
* Strong communication and collaboration skills
* Ability to manage multiple tasks and deliver to deadlines
* Proactive, innovative, and adaptable in a changing environment
Why join Hannon Transport
* Join a company focused on innovation, sustainability and growth
* Exposure to large-scale digital transformation projects in a leading logistics organisation
* Professional development and training opportunities
* A competitive salary and company benefits are available for the right candidate
Note: This description is intended to be a guide of what duties are most likely to be but should not be taken as a definitive list. Hannon may adapt duties as deemed necessary.
#J-18808-Ljbffr