Analytics Engineer (008-00877)

Looking for Philippines-based candidates Job Role: Analytics Engineer Compensation range: $2,000 AUD - $3,000 AUD / Monthly Engagement type: Independent Contractor Agreement Work Schedule: This role is expected to align with the AU business hours (approx. 9 AM - 5 PM, Monday to Friday) for collaboration, but as a contractor, you’ll have flexibility in how you manage your time. Who We Are: At Hunt St, we help Australian companies hire top remote talent in the Philippines. For this role, you will be engaged directly by the client as an independent contractor. We are not an outsourcing agency. All of our roles are 100% remote so you'll be able to work from home. Who The Client Is: Our client is an independent technology consulting firm with over 15 years of experience helping organizations improve their systems, data, and workflows across industries such as manufacturing, healthcare, research, and laboratory environments. Rather than selling software, they provide unbiased consulting focused on system implementations, data migration, workflow optimization, and regulatory compliance. Their collaborative approach helps businesses modernize legacy systems, improve operational efficiency, and maximize the value of their existing technology so they can scale with confidence. Role Overview: The analytics engineer builds the Gold layer and dbt Semantic Layer for each dataset phase. Where the senior data engineer builds the pipeline plumbing, the analytics engineer builds the business metrics — translating the metrics register definitions into governed, tested Gold models and MetricFlow metric definitions. This role sits closes to the business, requiring both technical depth and the ability to work directly with business stakeholders during metric validation sessions. The analytics engineer must be able to explain metric calculation choices in plain English, not just write the SQL. In Run steady state the analytics engineer role will take on support with AI monitoring responsibilities. New Gold model build volume drops significantly post go-live, freeing capacity for NLQ quality monitoring, LLM agent uptime, and Cortex ML model maintenance. Candidates should be comfortable with this evolution and ideally have some exposure to LLM API integration or ML monitoring. Key Responsibilities: 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. Required Skills and Qualifications: 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. AI Tooling & Data Platform Experience 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. Run Steady State Scope Manage metric change requests by updating Gold models and Semantic Layer definitions as business rules and KPI definitions evolve. Monitor AI agent performance, including NLQ answer quality, identifying model drift, escalating issues to the lead engineer, and updating AI system prompt context as new datasets are introduced. Oversee Cortex ML maintenance by monitoring forecast accuracy and triggering retraining processes when performance falls below agreed thresholds. Build and maintain new Gold model additions as the organization expands the Gold layer and introduces additional business metrics. What Good Looks Like Demonstrates genuine enthusiasm for building a modern data platform from the ground up. Can independently translate plain-English metric definitions (e.g., “net sales excluding shipping, gift cards, and staff purchases”) into dbt Gold model SQL and MetricFlow YAML. Has prior experience in stakeholder-facing environments, including presenting data findings, answering questions from non-technical users, and defending calculation methodologies. Brings curiosity and adaptability when working with emerging AI technologies, semantic layers, and modern analytics engineering practices. Work Arrangement & Expectations: This is a remote role that will be set up as an independent contractor engagement. To ensure alignment and transparency, successful candidates will be expected to: Disclose any existing ongoing roles or client work Reflect this engagement on their LinkedIn profile (clearly marked as “Independent Contractor”)