Analytics Engineer-PH at Pandoblox
Job details
Use AI to assess how you fit
About this role
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. : 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.
Originally posted on Himalayas