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.

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.
• Teamwork driven. Collaborate and assist team members, ensuring collective success through shared knowledge and support in various tasks.
• Excited about learning, pushing technical limits and finding new solutions.
• Strong communication skills to effectively collaborate with various stakeholders and team members within the organisation.
• Best practices focused. Implement, enforce, and follow best practices in order to ensure efficiency of production processes.
• Commitment to ongoing professional development and staying current with the latest industry trends in IT analytics.

• Ability to work under pressure.
• Proficiency in documenting processes.
• Passion for managing and growing a team
• Coaching and mentoring
• Standards and governance mindset
• Cross-functional collaboration
• Ambition to grow into a management role
• Ability to effectively manage context switching across multiple concurrent initiatives.