Analytics Engineer (Data Platform)

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 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

Terms & conditions apply.