Summary
Written in English from the original postingAnalytics Engineer role focused on building dbt models, semantic layers, and governed data marts on Google BigQuery. The position also supports Amazon QuickSight dashboards, natural-language querying, reconciliation, and metadata documentation. It is a part-time remote role based in the Philippines with US Pacific timezone coverage.
Job description
About the Role:
We are looking for an Analytics Engineer who is an analyst first, with real data-engineering skills and in- depth AI experience.
In this role, you will be working with the team to gather, analyze, evaluate, and organize client data from various sources and systems. The qualified candidate will turn governed data marts into the metrics, dashboards and natural-language answers our clients' executives use every day.
The ideal candidate possesses a strong technical background, a good track record with data analysis and data engineering methodologies, and a drive to contribute and work with the team to achieve team goals in a fast paced environment.
Responsibilities:
In this role you'll get to…
- work with client operators, controllers and analysts to turn business questions into clear metric definitions
- build and refresh Amazon QuickSight dashboards on governed marts
- reconcile dashboard and NLQ numbers against the client's source-of-truth reports, and document the results for client sign-off
- build and maintain mart and report models in each client's dbt project on Google BigQuery
- define and tune metrics, dimensions and joins in the Cube.dev semantic layer so Natural-language querying (NLQ) answers business questions accurately
- write and run unit tests as well as UAT cases for dashboards and NLQ answers
- use AI tools (Claude Code and agent skills) every day to speed up analysis, SQL, dbt work and documentation
- keep metric and model descriptions current in the OpenMetadata business glossary so people and AI agents read the data the same way
- watch data freshness and test alerts for your clients, and flag issues early
- collaborate and train other team members
- perform other duties as required by the role
Requirements:
On day one we'll expect you to...
- have 4+ years of experience in data analysis and dashboard design
- have 2+ years of hands-on data engineering work
- have 2+ years of hands-on AI experience, including Claude Code or another AI coding agent, and be able to show what was built with them
- have strong knowledge of working with data from databases and source systems, including manipulating and analyzing large datasets
- write strong, production-quality SQL (joins, window functions, CTEs), ideally on Google BigQuery (Snowflake, Redshift or equivalent is acceptable)
- have expertise with a BI tool (QuickSight, Power BI, Looker Studio or Tableau)
- have solid experience with a semantic layer (Cube.dev, dbt Semantic Layer or LookML)
- have hands-on experience with dbt (Core or Cloud): building models, writing tests and documenting them
- understand dimensional modeling (facts, dimensions, grain) well enough to design reporting marts
- be able to reconcile numbers against a client’s source reports and explain any variance clearly
- have experience with Git, GitHub or GitLab: branches, pull requests and code reviews
- have excellent problem-solving and analytical skills, with a keen eye for detail
- have experience in at least one of these industries: Sales, Marketing, Finance, Media
- have strong communication skills, with the ability to present complex data and insights clearly and concisely
- be able to work independently and collaborate with business and IT teams in a fast-paced, dynamic environment
- be open to project-based tasks with client deadlines
- have a fully functional and up-to-date computer with which to perform duties
- be willing to install next-generation endpoint protection on the computer
- be a current resident of the Philippines and legally able to perform work from there
- be willing to work in US Pacific Timezone up to 20 hours a week
- be willing to undergo a 90-day probationary period upon initial hire
Preferred background:
- strong knowledge of Excel or Google Sheet (formulas and pivot table)
- Bachelor's degree in Computer Science, Statistics, Mathematics, or a related field
- data project portfolio
- working knowledge of QuickBooks, NetSuite, or Datacor financial data
- working knowledge of CRM data (Salesforce, HubSpot)
- work experience setting up or testing natural-language querying (NLQ)
Notes
- This is a remote (work from home) job.
- This is a part-time role. Opportunity to transition to full time if project volume grows.
The weekly Digest
The week's most transparent data engineering jobs in your inbox once a week.
Once a week, a few new jobs that state their salary, location and stack, plus links to the rest. No open tracking; clicks are counted per issue, not per person. Unsubscribe with one click.