Analytics Engineer (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 Aperture Cloud , 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 logic, window functions, ratio metrics, and period-over-period comparisons Basic Python scripting skills for automation and monitoring tasks Intermediate experience with Power BI / MS Fabric (or similar BI tools), including DAX, paginated reports, RLS/RBAC, performance tuning, large dataset handling, and validation of Gold layer outputs Intermediate experience with Atlan or similar data catalog tools, including glossary management, catalogue administration, and lineage review Strong retail domain knowledge, including key metrics such as sell-through, OOS rate, clearance %, return rate, and AOV Strong communication and stakeholder management skills, with the ability to clearly present metric validation findings to both technical and non-technical 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 performan