Analytics Engineer Data Platform

MicroSourcing International; Manila; Remote; PHP 1,000,000 - 1,800,000; Full time

Benefits offered by this job

Healthcare coverage from day one

Paid time-off with cash conversion

Group life insurance

Performance bonuses

Job summary

MicroSourcing International is seeking an Analytics Engineer (Data Platform) to design and optimize data models in Snowflake, and to build centralized semantic layers and Power BI dashboards for Customer Experience and Product teams.

You will implement CI/CD, data quality checks, and governance across Snowflake and Power BI, while collaborating with global teams and leveraging AI tools for SQL development and analytics.

Qualifications

• At least 4 years in analytics engineering, BI development, or data engineering.
• Advanced SQL with Snowflake experience incl. warehouses, roles, performance tuning.
• Strong dimensional modelling, data warehousing, star schemas, fact and dimension tables, and SCDs.
• Experience with Power BI data modelling, including Power Query and DAX.
• Experience building governed semantic or metrics layers.
• Hands-on with data transformation tools such as dbt, Git-based version control, automated testing, CI/CD.

Responsibilities

• Build and maintain Snowflake data models using medallion architecture.
• Develop centralized semantic layer for metrics, KPIs, rules (ARR, MRR, revenue, churn).
• Create and maintain Power BI datasets and dashboards for CX and Product teams.
• Implement automated testing, data quality checks, and CI/CD for data models and reporting assets.
• Optimize Snowflake queries and compute efficiency.
• Build and support data ingestion pipelines from core systems (CRM, HubSpot, MYOB, Zendesk).
• Monitor pipeline health, manage schema changes, and maintain ID matching across sources.
• Apply data governance, metadata management, RBAC, and security policies across Snowflake and Power BI.
• Collaborate with stakeholders to gather requirements and deliver data solutions.
• Prepare datasets for Snowflake Cortex, Snowflake Intelligence, and AI analytics tools.
• Leverage approved AI tools to accelerate SQL development, data modelling, testing, and documentation with validation.
• Support data privacy, security, and compliance including SOC 2 and PCI DSS.

Skills

Analytics engineering

SQL

Snowflake

Dimensional modeling

Power BI

Semantic layer

dbt

ELT pipelines

CI/CD

Communication

Tools

dbt

Git-based version control

Snowflake Cortex

Snowflake Intelligence

Job description

Job Description:

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

• 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 professionals across 13 delivery centers, MicroSourcing is the pioneer and largest offshore provider of managed services in the Philippines.

Our commitment to 100% YOU

MicroSourcing firmly believes that our company's strength lies in our people's diversity and talent. We are proud to foster an inclusive culture that embraces individuals of all races, genders, ethnicities, abilities, and backgrounds. We provide space for everyone, embracing different perspectives, and making room for opportunities for each individual to thrive.

At MicroSourcing, equality is not merely a slogan – it's our commitment. Our way of life. Here, we don't just accept your unique authentic self - we celebrate it, valuing every individual's contribution to our collective success and growth. Join us in celebrating YOU and your 100%!

For more information, visit https://www.microsourcing.com/

Terms & conditions apply.