Senior Application Support Engineer

HANNON Transport; Aghalee; On-site; GBP 45,000 - 55,000; Full time

Job summary

A leading logistics company in Aghalee is seeking a Senior Application Support Engineer to oversee data integrations and improve operational systems. This role requires strong expertise in SQL, Python, and AWS, where you will drive automation and integrate AI into workflows. Ideal candidates will have over 5 years of experience in relevant technologies and a proactive approach to problem-solving in a dynamic environment.

Benefits

Professional development opportunities

Competitive salary

Company benefits

Qualifications

• 5+ years professional experience with SQL and BI/data platforms.
• Experience with AWS analytics tools like S3, Glue, and Athena.
• Familiarity with API integrations and operational systems.

Responsibilities

• Design and implement data architectures in AWS.
• Provide Level 3 application support.
• Integrate AI services to augment BI functionalities.

Skills

SQL (TSQL preferred)

AWS analytics (S3/Glue/Athena/Redshift)

Power BI

Stakeholder engagement

Problem-solving

Education

5+ years in SQL and application support

AWS certifications

Microsoft certifications

Tools

Git

Terraform

CloudFormation

Job description

About the job Senior Application Support Engineer

Job Information

Job Title

Department

IT

Reports To

Head of IT

Location

Aghalee (base location, travel expected)

Salary Range

£45k to £55k depending on experience

Job Purpose

Were hiring a senior, hands-on engineer to own data and application integrations across the group. Youll combine strong TSQL and Python to support and improve our operational systems (TMS/WMS/FMS), design and build a scalable BI/data platform (AWS + Microsoft), and drive automation that removes spreadsheet based, siloed processes. You will also help integrate AI into BI and operational workflows, working closely with stakeholders across Logistics, Operations, Finance, and Compliance.

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, inmemory acceleration, RLS/columnlevel security).
• 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).
• Create dimensional models (star/snowflake), conformed dimensions, and robust SQL/Python transformations with strong testing and documentation.
• 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.
• Build and maintain systems integrations via REST/SOAP APIs, EDI (XML/JSON) schemas, and flatfile interfaces (SFTP/AS2).
• Author integration runbooks, errorhandling/retry patterns, and observability (dashboards/alerts) for data/app interfaces.

SQL & Python Engineering

• Write highquality TSQL (procedures, functions, views), optimize queries/indexes, and manage release/change control.
• Develop Python services and utilities (ETL jobs, API clients, data quality checks, automation tools), packaged and containerised where suitable.
• 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, naturallanguage Q&A, intelligent alerting) using platforms such as AWS Bedrock (and/or Azure equivalents), embedding safely into apps/dashboards.
• 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.
• Build lightweight internal tools (portals, scripts, APIs) to streamline business workflows; document and train users.

Security, Governance & DR

• Enforce leastprivilege, 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.

Knowledge, skills and experience required

• 5+ years professional experience across SQL (TSQL preferred), application support, and BI/data platforms.
• Handson 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 problemsolving; able to translate business needs into data solutions.
• Experience supporting and integrating operational systems (TMS/WMS/FMS) and working with APIs/EDI/XML/JSON.
• 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, experience with Purview, Azure Data Factory, Kafka/Kinesis, or message brokers.
• Familiarity with bedrockhosted 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
• 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.