At a Glance
- Tasks: Design and implement modern data architectures and build reliable data pipelines.
- Company: Join HANNON Transport, a leader in logistics focused on innovation and sustainability.
- Benefits: Enjoy a competitive salary, professional development, and training opportunities.
- Why this job: Be part of large-scale digital transformation projects that make a real impact.
- Qualifications: 5+ years in SQL, application support, and strong Python skills required.
- Other info: Dynamic environment with opportunities for growth and collaboration.
The predicted salary is between 45000 - 55000 £ per year.
Overview of the 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
- 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/column-level 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), optimise 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.
Senior Application Support Engineer employer: HANNON Transport Ltd.
Contact Detail:
HANNON Transport Ltd. Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Application Support Engineer
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, attend meetups, and connect with people on LinkedIn. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Prepare for those interviews! Research HANNON Transport and understand their tech stack, especially around AWS and data platforms. Be ready to discuss how your experience aligns with their needs and showcase your problem-solving skills.
✨Tip Number 3
Show off your projects! If you've built any cool data pipelines or applications, make sure to highlight them during your conversations. Having tangible examples of your work can really set you apart from other candidates.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you're genuinely interested in joining the team at HANNON Transport.
We think you need these skills to ace Senior Application Support Engineer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Senior Application Support Engineer role. Highlight your experience with SQL, Python, and AWS analytics tools like S3 and Glue. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about this role and how your background makes you a perfect fit. Don’t forget to mention any relevant projects or achievements that showcase your expertise.
Showcase Your Problem-Solving Skills: In your application, give examples of how you've tackled challenges in previous roles. We love candidates who can think on their feet and come up with innovative solutions, especially when it comes to data platforms and application support.
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way to ensure your application gets into the right hands. Plus, it shows us you’re serious about joining our team at HANNON Transport!
How to prepare for a job interview at HANNON Transport Ltd.
✨Know Your Tech Inside Out
Make sure you brush up on your SQL and Python skills, as well as your experience with AWS analytics tools like S3, Glue, and Redshift. Be ready to discuss specific projects where you've implemented these technologies, as this will show your hands-on experience.
✨Prepare for Scenario-Based Questions
Expect questions that ask how you would handle real-world problems, such as troubleshooting application issues or optimising data pipelines. Think of examples from your past work where you successfully resolved similar challenges, and be prepared to explain your thought process.
✨Showcase Your Communication Skills
Since stakeholder engagement is key in this role, practice articulating complex technical concepts in simple terms. You might be asked how you would explain a technical issue to a non-technical audience, so have a few examples ready to demonstrate your ability to bridge that gap.
✨Demonstrate Your Problem-Solving Approach
Be ready to discuss your analytical mindset and how you approach problem-solving. Prepare to share specific instances where you identified a problem, developed a solution, and implemented it effectively. This will highlight your proactive and innovative nature, which is crucial for the role.