Principal Analytics Engineer (Hiring Immediately)

JOB SUMMARY 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: I ntegrity – Create an Environment of Trust C ollaboration – Innovate Through the Sharing of Ideas A ccountability – Own the Process and the Outcome R espect – Recognize the Value in Everyone E nthusiasm – Find a Sense of Purpose in Work