Analytical Engineer

Role Overview:

An Analytical Engineer at Lightstone is responsible for designing, developing, maintaining, and optimising scalable analytical data models and systems that enable data-driven decision-making across the organisation.

The role bridges data engineering and analytics by transforming raw data into reliable, well-modelled, and performance-optimised datasets suitable for reporting, business intelligence, and advanced analytics. This includes implementing data transformation logic, ensuring data quality and governance standards and automating workflows.

An Analytical Engineer applies strong problem-solving and systems-thinking capabilities to translate complex business requirements into structured, reusable data solutions. The role also drives scalability, automation, and continuous improvement while adhering to best-practice data modelling and engineering standards.

Furthermore, the role will provide acting Team Lead cover as required and is expected to develop into a Team Lead position over time, subject to performance and business needs.

Requirements

Qualification/ Experience:

• Bachelor or Master’s degree in Engineering, Computer Science, Mathematics, Statistics, or a related field.

• At least 7+ years working experience in relevant field

• Automation experience using SQL, Python and Power Automate

• Expert in process maintenance and process management

Technical Skills:

• Advanced SQL (Dynamic queries, query performance and optimisation)
• Advanced Python
• Knowledge of Agile Methodologies
• Relational Database Design
• SAS coding (Advantageous)
• Microsoft Azure Environment
• Advanced PowerBI & reporting
• Data modelling (Advantageous)
• SDLC methodologies
• Power Automate
• Documentation
• Git workflows & repositories
• Data warehousing
• Security principles
• Exposure to CI/CD

Non-Technical Skills:

• Analytical and critical thinking.

• Inquisitive and innovative mindset.

• Ability to take ownership of processes and projects.

• Structured approach to problem-solving, identifying problems and fixing the issue, must be excellent at troubleshooting and finding resolutions to issues as they arise.