Analytics Engineer

Discover your 100% YOU with MicroSourcing

Position: Analytics Engineer (Data Platform)

Location: Philippines

Work setup & shift: Work from Home (WFH) | Day Shift

Why join MicroSourcing?

You’ll Have

• Competitive Rewards: Enjoy above-market compensation, healthcare coverage on day one, plus one or more dependents, paid time-off with cash conversion, group life insurance, and performance bonuses.
• A Collaborative Spirit: Contribute to a positive and engaging work environment by participating in company-sponsored events and activities.
• Work-Life Harmony: Enjoy the balance between work and life that suits you with flexible work arrangements.
• Career Growth: Take advantage of opportunities for continuous learning and career advancement.
• Inclusive Teamwork: Be part of a team that celebrates diversity and fosters an inclusive culture.

Your Role

As an Analytics Engineer, you will:

• Build and maintain Snowflake data models using medallion architecture, transforming raw data into cleansed, conformed, and business-ready datasets.
• Develop and govern a centralized semantic layer to ensure consistent definitions of business metrics, KPIs, and rules, including ARR, MRR, revenue, and churn.
• Create and maintain Power BI datasets, automated board reports, management reporting, and dashboards for Customer Experience and Product teams.
• Implement automated testing, data quality checks, and CI/CD processes to ensure the accuracy, reliability, and performance of data models and reporting assets.
• Optimize Snowflake queries and compute efficiency to improve platform performance and resource utilization.
• Build and support data ingestion pipelines from core business systems, including customer databases, HubSpot, MYOB, and Zendesk.
• Monitor pipeline health, manage schema changes, troubleshoot failures, and maintain reliable customer ID matching across data sources.
• Apply data governance standards, metadata management, documentation, role-based access controls, and data security policies across Snowflake and Power BI.
• Collaborate with stakeholders and cross-functional teams to gather requirements, deliver data solutions, and support data-driven decision‑making.
• Prepare curated and well‑documented datasets for Snowflake Cortex, Snowflake Intelligence, and AI-powered analytics tools.
• Leverage approved AI tools to accelerate SQL development, data modelling, testing, and documentation while validating all AI-generated outputs before implementation.
• Support data privacy, security, and compliance requirements, including SOC 2 and PCI DSS controls.

What You Need

Non-negotiables

• At least 4 years of experience in analytics engineering, BI development, or data engineering.
• Advanced SQL skills and hands‑on experience with Snowflake, including warehouses, roles, and performance tuning.
• Strong knowledge of dimensional modelling, data warehousing, star schemas, fact and dimension tables, and slowly changing dimensions.
• Experience with Power BI data modelling, including Power Query and DAX.
• Experience building and maintaining governed semantic or metrics layers.
• Hands‑on experience with data transformation tools such as dbt, Git‑based version control, automated testing, code reviews, and CI/CD.
• Practical experience with ELT pipelines, data ingestion, and orchestration.
• Working knowledge of AI tools for SQL development, modelling, and analysis, with the ability to validate and verify generated outputs.
• Strong analytical and communication skills, with the ability to translate business requirements into data models and explain technical concepts to non-technical stakeholders.
• Ability to collaborate with global teams across different time zones.

Preferred Skills / expertise

• Python experience for data pipelines, automation, or lightweight data applications.
• Experience with Fivetran, Airbyte, or AWS-native ingestion services such as DMS, Glue, and Lambda, including CDC patterns.
• Experience working with multi‑tenant SaaS data environments.
• Familiarity with Snowflake Cortex, Snowflake Intelligence, or other AI‑powered and natural language analytics tools.
• Knowledge of data governance, metadata management, and row‑level and column‑level security.
• Working knowledge of GDPR, the Australian Privacy Act, SOC 2, or PCI DSS compliance requirements.
• Experience working with SaaS business metrics, including ARR, MRR, NRR, and churn.
• Exposure to the hospitality or travel industry.
• Snowflake SnowPro certification.

About MicroSourcing

With over 9,000 professiona