Job Description

The Analytics Engineer plays a key role in connecting the enterprise data platform with business intelligence delivery. Operating within the organisation’s analytical data environment, they design and maintain the structures that make curated, high-quality data available for reporting and insight generation.

Working between Data Engineering and the Power BI development team, this role helps build and optimise data warehouses, marts, and modelled tables, ensuring the data layer is efficient, reliable, and accessible. They also lead the development and maintenance of the Enterprise Data Catalogue, providing visibility and governance of structured data assets across the organisation.

This is a hands-on technical role, requiring a deep understanding of data modelling, performance optimisation, and modern data engineering practices to enable trusted, scalable, and insight-ready data

Responsibilities:

Data Layer Development & Maintenance

• Design, build, and optimise data warehouses, marts, and modelled tables within the enterprise data platform.
• Create curated, analytics-ready data structures to support business intelligence and advanced analytics.
• Collaborate with Data Engineering on pipeline design and data architecture standards.
• Maintain schema documentation, data lineage, and metadata accuracy within the Enterprise Data Catalogue.

Cross-Team Collaboration

• Partner with Power BI Developers and Analysts to translate analytical needs into efficient, governed data structures.
• Align modelling and naming standards across the data platform and BI layers.
• Work with IT, architecture, and governance teams to ensure compliance with security and data management policies.

Performance & Monitoring

• Monitor the performance, accessibility, and integrity of the analytical data layer.
• Implement monitoring and validation frameworks to identify and resolve data or performance issues.
• Continuously optimise query performance, refresh cycles, and data architecture.

Governance & Documentation

• Own and maintain the Enterprise Data Catalogue as the authoritative reference for curated data assets.
• Document data lineage, ownership, and certification status to support governance and transparency.
• Contribute to metadata management and data lifecycle processes

Innovation & Continuous Improvement

• Recommend and implement modern data practices that enhance scalability, consistency, and automation.
• Support initiatives that prepare the platform for AI and Manufacturing Intelligence integration.
• Stay current with emerging tools, technologies, and approaches in cloud data engineering and analytics.

Qualifications:

• Bachelor’s degree in Computer Science, Information Systems, or related discipline.
• Demonstratable experience in analytics engineering, data engineering, or BI development.
• Proficiency in SQL and experience with data warehousing, schema design, and data modelling.
• Strong understanding of modern cloud-based data platforms and architectures.

Skills:

• Demonstrated problem solving and work prioritisation skills
• Hands-on experience with Snowflake or an equivalent enterprise data platform
• Familiarity with modern transformation frameworks (e.g., dbt, Data Factory, or equivalent)
• Experience supporting BI environments such as Power BI, Tableau, or Looker
• Understanding of metadata management, data governance, and CI/CD principles
• Exposure to data catalogue or lineage tools
• Strong collaboration and communication skills, working effectively across technical and business teams
• Ability to keep up to date with technology and apply it to the business strategic plan
• Ability to achieve results independently or while working with others
• Excellent interpersonal and communication skills, with the ability to communicate effectively with end-users, management, and staff
• Ability to handle multiple priorities involving internal customer requests and demands
• Ability to excel in a cross-organisational, cross-cultural, global team environment
• Ability to handle special assignments promptly and professionally
• Sets a high standard of ethics, professionalism, and competency

WORKING CONDITIONS

Working conditions typical of a climate controlled and professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers.

SAFETY REQUIREMENTS

All employees are required to follow the site EHS procedures and Coherent Scotland EHS standards.

QUALITY & ENVIRONMENTAL RESPONSIBILITIES

Depending on location, this position may be responsible for the execution and maintenance of the ISO 9000, 9001, 14001 and/or other applicable standards that may apply to the relevant roles and responsibilities within the Quality Management System and Environmental Management System.

CULTURE COMMITMENT

Ensure adherence to company’s values (ICARE) in all aspects of your position at Coherent:

Integrity – Create an Environment of Trust

Collaboration – Innovate Through the Sharing of Ideas

Accountability – Own the Process and the Outcome

Respect – Recognize the Value in Everyone

Enthusiasm – Find a Sense of Purpose in Work

Coherent is a global leader in lasers, engineered materials and networking components. We are a vertically integrated manufacturing company that develops innovative products for diversified applications in the industrial, optical communications, military, life sciences, semiconductor equipment, and consumer markets. Coherent provides a comprehensive career development platform within an environment that challenges employees to perform at their best, while rewarding excellence and hard-work through a competitive compensation program. It's an exciting opportunity to work for a company that offers stability, longevity and growth. Come Join Us!

Note to recruiters and employment agencies: We will not pay for unsolicited resumes from recruiters and employment agencies unless we have a signed agreement and have required assistance, in writing, for a specific opening.