Senior Analytics Engineer (Onsite/ Day Shift)
Description
Shore360 is a 100% Australian-owned BP firm based in the Philippines, providing customized staffing and administrative support for international companies, handling recruitment, HR, IT, and office facilities so clients can focus on core business, offering transparent pricing, dedicated teams, and flexible setups.
Position Overview
The Senior Analytics Engineer is a senior technical role within the Data and Analytics team, responsible for designing, developing, and governing the organization's enterprise data models and semantic layer using the Databricks Data Intelligence Platform.
This role bridges data engineering and analytics by translating complex business requirements into scalable data models, certified datasets, and governed business metrics. These will serve as trusted data sources for reporting, dashboards, integrations, and AI-driven applications.
Working with a high degree of autonomy, the Senior Analytics Engineer will establish data modelling standards and best practices while ensuring consistency, scalability, and reliability across the organization's data environment. The role will collaborate closely with Data Engineers, Data Analysts, AI Engineers, and business stakeholders to deliver trusted and well-structured data solutions.
Key ResponsibilitiesData Modelling and Architecture
- Lead the design and development of enterprise and domain data models across business systems, applying dimensional modelling principles to create conformed dimensions and fact tables within the Gold layer.
- Develop scalable, entity-agnostic data models that support both consolidated and individual legal entity reporting.
- Establish and maintain data modelling standards, including medallion architecture conventions, naming standards, slowly changing dimensions, and historical data management.
- Collaborate with Data Engineers to ensure Silver layer structures support efficient downstream data modelling and analytics.
- Translate business requirements into effective data models and metric definitions by working closely with stakeholders to establish business rules, definitions, and data requirements.
- Design, develop, and manage Unity Catalog metric views as the centralized and governed source of business metrics.
- Maintain metric definitions through version control, certification, and resolution of conflicting business definitions across different domains.
- Collaborate with the Senior Data Analyst to align Power BI semantic models with governed metric views and promote consistency in business logic.
- Work with the AI Engineer to provide well-documented data models and metric views that support Genie, AI applications, and automated workflows.
- Develop and maintain data transformation pipelines using Lakeflow Declarative Pipelines and Databricks SQL.
- Apply software engineering best practices, including Git-based version control, code reviews, automated testing, and CI/CD through Databricks Asset Bundles.
- Implement data quality rules, validation processes, and automated testing to ensure data accuracy, consistency, and reliability.
- Optimize data models and pipeline performance through efficient materialization, incremental processing, and table design.
- Manage and maintain certified datasets in Unity Catalog, ensuring proper documentation, metadata, tagging, and data lineage.
- Support data governance practices, including access controls, data classification, and the responsible handling of sensitive information.
- Ensure datasets are well-documented, accessible, and understandable for both business users and AI applications.
- Provide technical guidance and mentorship to team members through knowledge sharing, documentation, and peer reviews.
- Establish and promote best practices in data modelling, governance, and the consumption of trusted data across the organization.
- At least 5 years of experience in Analytics Engineering, Data Engineering, Data Modelling, or Business Intelligence.
- Minimum of 2 years of experience designing and delivering data models within a cloud-based lakehouse environment.
- Proven hands-on experience developing and managing production data models using Databricks.
- Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field, or equivalent professional experience.
- Databricks certifications, such as Data Engineer Associate or Professional, or Data Analyst Associate, are highly regarded.
- Advanced hands-on experience with the Databricks platform, particularly Unity Catalog, Databricks SQL, Lakeflow Declarative Pipelines, and medallion architecture.
- Expert-level SQL skills and strong proficiency in Python and PySpark, with the ability to develop clean, maintainable, and well-tested transformation code.
- Strong expertise in dimensional data modelling, including conformed dimensions, slowly changing dimensions, and multi-entity or consolidated reporting.
- Proven experience designing and governing business metrics within a semantic layer. Experience with Unity Catalog metric views is highly desirable.
- Experience integrating Power BI with Databricks, including semantic model development and selecting appropriate storage and connectivity modes.
- Strong understanding of data quality frameworks, automated testing, Git-based version control, and CI/CD practices for data pipelines.
- Knowledge of how data models, metadata, and semantic definitions support AI and LLM applications, including Databricks Genie and retrieval-based solutions.
- Excellent stakeholder management and communication skills, with the ability to translate complex and ambiguous business requirements into practical technical solutions.
- Demonstrated ability to establish technical standards, influence best practices, and provide technical leadership through expertise and collaboration.
- Strategic and analytical thinking
- Strong technical leadership and problem-solving
- Data architecture and modelling expertise
- Stakeholder engagement and collaboration
- Attention to detail and data quality
- Knowledge sharing and mentoring
- Ability to work independently and take ownership of technical outcomes
- Fixed Weekends Off – Enjoy a guaranteed work-life balance with Saturdays and Sundays off
- Join our Social Passion Clubs to connect with like-minded peers and bring your whole self to work every day
- Photography Club, Dance Club, Fitness Club, Book Club, Music Club
- Engaging Monthly Events – Experience a vibrant culture with regular team activities and celebrations with amazing prizes and rewards
- Bronze Referral Incentives – Get rewarded for bringing top talent to the team via our referral program.
- Statutory Benefits: Maternity, Paternity, and Solo Parent Leaves, Magna Carta for Women, OT, and Premium Pays
- Onsite
- Monday - Friday, 6:30AM - 5:30PM
Skills
- AI
- Analytics
- Business Intelligence
- CI/CD
- Cloud
- Data Engineering
- Data Governance
- Data Lineage
- Data Modeling
- Data Pipelines
- Data Quality
- Data Science
- Databricks
- Dimensional Modeling
- Git
- Lakehouse
- LLM
- Medallion Architecture
- Power BI
- PySpark
- Python
- SQL
- Stakeholder Management
- Test Automation
- Unity
- Unity Catalog
- Version Control
Sign in to read and join the discussion.