We help Aussie companies find top 3% remote talent in the Philippines & Nepal for a single finder's fee.
Analytics Engineer
Location
Philippines
Posted
14 days ago
Salary
$2K - $3K / month
Seniority
Senior
Job Description
Analytics Engineer
Hunt St
• Build Gold layer dbt models, including metric-level aggregations, KPI tables, and denormalized summary tables optimized for BI consumption in Sigma. • Author dbt Semantic Layer metric definitions using MetricFlow, including sell-through, out-of-stock (OOS) rate, conversion rate, average order value (AOV), weeks cover, and other metrics defined in the business metric register. • Populate and maintain the business glossary for each completed dataset, including metric definitions, calculation notes, known caveats, ownership, and data lineage. • Participate in business validation sessions with the onshore team and business stakeholders to ensure Gold metrics align with agreed metric register definitions prior to handover to Run operations. • Author and maintain dbt Explorer documentation, including model descriptions, column descriptions, and metric definitions to ensure the semantic layer remains fully self-documenting. • Support ongoing Run operations by managing metric change requests, implementing new Gold model additions, monitoring Cortex ML models, maintaining Claude NLQ context updates, and tracking AI agent uptime and performance. • Collaborate with stakeholders and cross-functional teams to validate business requirements, clarify KPI logic, and ensure consistent metric governance across the platform.
Job Requirements
- Advanced experience with dbt Semantic Layer and MetricFlow, including metric definitions, dimensions, entities, measures, and time spines.
- Advanced SQL expertise, including metric calculation logic, window functions, ratio metrics, and period-over-period comparisons.
- Basic Python scripting skills for automation and monitoring-related tasks.
- Intermediate experience with Power BI or other self-service BI platforms, with the ability to validate Gold layer outputs within BI environments.
- Intermediate experience with Atlan or similar data cataloguing platforms, including catalogue administration, glossary authoring, and lineage review.
- Strong retail domain knowledge, with a clear commercial understanding of metrics such as sell-through, OOS rate, clearance percentage, return rate, and AOV.
- Strong communication and stakeholder management skills, with the ability to clearly present metric validation findings to non-technical business stakeholders.
- Experience using Claude API or similar AI tooling to translate business metric register rules into dbt Gold model SQL.
- Familiarity with Cortex Analyst YAML generation for scaffolding Semantic Layer definitions aligned with metric register requirements.
- Experience monitoring Cortex ML models, including Forecasting and Anomaly Detection performance, and triggering retraining workflows when necessary.
- Understanding of NLQ (Natural Language Query) context management, including maintaining governance and semantic layer context that supports AI-powered business user interfaces.
- Exposure to LLM APIs, Snowflake Cortex, or similar AI-driven analytics platforms, whether in production, prototype, or personal project environments.
Related Guides
Related Categories
Related Job Pages
More Analytics Engineer Jobs
Senior Data Analytics Engineer
DotmaticsFounded in 2005, Dotmatics is self-described as the world’s largest research and development scientific software platform, used by leading researchers in biopharma, academia, and
• Develop high-impact reporting and analytics providing visibility into business operations, lead efforts to scale reporting through automation • Partner with internal stakeholders (Sales, Product, Marketing, Finance, etc.) to increase the understanding, visibility and use of business metrics, encourage self-service analytics • Perform ad hoc data exploration and analysis to answer immediate business needs. • Identify opportunities to improve data quality, performance, and observability • Help develop standards for analytics engineering best practices
Senior Data Analytics Engineer – Hospitality Tech
Truelogic SoftwarePremium boutique software development company that helps brands with big ideas to make a difference in people’s lives.
• Design and implement a multi-tier SaaS reporting infrastructure to support diverse client levels and brand campaign requirements. • Lead the GA4 and Google Tag Manager strategy, overseeing implementation, QA, and the definition of event tracking standards for QR scans, lead captures, and promo engagement. • Architect and manage GA4 data exports into BigQuery, building robust models that join event data with account, venue, and subscription datasets. • Integrate data from diverse sources including Sanity CMS, Mailchimp, SMS platforms, and POS systems to create a unified view of the consumer journey. • Develop reusable reporting templates and automated dashboards for client recaps, monthly summaries, and real-time campaign performance. • Evaluate and deploy reporting automation tools such as Looker Studio Pro, AgencyAnalytics, or Whatagraph to enhance scalability. • Establish data governance and access control protocols to ensure secure, account-specific reporting views. • Partner with product and engineering teams to ensure tracking requirements are seamlessly integrated into the development lifecycle. • Translate complex analytics into actionable business insights for internal stakeholders, venues, and brand partners. • Maintain comprehensive documentation including tracking plans, data dictionaries, and architectural workflows.
• Deliver well-architected data solutions in partnership with data platform engineers, data governance, data science, and data analytics/visualization peers. • Partner with business teams to design data solutions with the ability to mentor early career data engineers. • Lead build-out and deployment of data pipelines. • Ensure reliability, scalability and governance of data pipelines.
• The Analytics Engineer sits at the heart of IEM's modern data stack, turning raw source data into the clean, well-modeled, business-ready datasets that power Tableau dashboards, executive decisions, and self-service analytics across Finance, Production, Supply Chain, and Engineering. • Working primarily in dbt and Snowflake, you own the transformation layer between ingestion and the BI surface: staging models, intermediate logic, dimensional models, tests, and documentation. • This is a hands-on individual contributor role with real ownership of production data models and a clear path into senior and principal analytics engineering as the team grows. • Partner with cross-functional stakeholders and the Business Intelligence team (Finance, Production, Supply Chain, Engineering) to translate operational needs into scalable data models and reliable metrics. • Author and maintain dbt tests, monitor freshness, investigate data quality issues end-to-end, and own resolution through to root cause. • Design, build, test, and document dbt models that turn raw Snowflake data into clean, reliable, analytics-ready datasets across Finance, Production, Supply Chain, and Engineering. • Build conformed dimensions, fact tables, and reporting models that balance performance, maintainability, and business user accessibility for Tableau dashboards and ad-hoc analysis.




