Analytics Engineer, Data Platform (Remote | WFH)

MicroSourcing International; Manila; Remote; PHP 1.200.000 - 1.600.000; Vollzeit

Benefits dieser Stelle

Healthcare coverage on day one

Performance bonuses

Paid time-off with cash conversion

Group life insurance

Flexible work arrangements

Zusammenfassung

MicroSourcing International seeks an Analytics Engineer (Data Platform) to build and govern Snowflake data models and a centralized semantic layer. You will craft Power BI reports, dashboards, and automated board reports for Customer Experience and Product teams, while ensuring data quality through CI/CD, testing, and governance.

You will optimize data pipelines, ingest data from CRM and SaaS tools, and collaborate with global teams to deliver data-driven insights.

Qualifikationen

• 4+ years of experience in analytics engineering, BI development, or data engineering.
• Advanced SQL skills; Snowflake experience with warehouses, roles, and performance tuning.
• Strong knowledge of dimensional modelling, data warehousing, star schemas, facts and dimensions, 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.
• Strong analytical and communication skills; ability to translate requirements into data models; collaborate across time zones.

Aufgaben

• Build and maintain Snowflake data models using medallion architecture; transform raw data into cleansed, conformed datasets.
• Develop and govern a centralized semantic layer for consistent metrics, KPIs, and rules (ARR, MRR, revenue, churn).
• Create and maintain Power BI datasets, automated board reports, and dashboards for CX and Product teams.
• Implement automated testing, data quality checks, and CI/CD to ensure data model accuracy and performance.
• Optimize Snowflake queries and compute efficiency to improve platform performance.
• Build and support data ingestion pipelines from core systems (CRM, HubSpot, MYOB, Zendesk).
• Monitor pipeline health; manage schema changes; ensure reliable customer ID matching across sources.
• Apply data governance, metadata management, RBAC, and data security across Snowflake and Power BI.
• Collaborate with stakeholders to gather requirements and deliver data solutions for data-driven decisions.
• Prepare curated datasets for Snowflake Cortex, Snowflake Intelligence, and AI analytics tools.
• Leverage approved AI tools to accelerate SQL development, data modelling, testing, and documentation while validating outputs.
• Support data privacy, security, and compliance including SOC 2 and PCI DSS.

Kenntnisse

Advanced SQL

Snowflake

Dimensional modelling

Power BI

Data governance

dbt

CI/CD

ELT pipelines

AI tools

Communication skills

Ausbildung

Bachelor's degree in a relevant field

Tools

dbt

Git

Snowflake Cortex

Airbyte

Fivetran

AWS DMS

Jobbeschreibung

MicroSourcing International seeks an Analytics Engineer (Data Platform) to build and govern Snowflake data models and a centralized semantic layer. You will craft Power BI reports, dashboards, and automated board reports for Customer Experience and Product teams, while ensuring data quality through CI/CD, testing, and governance.

You will optimize data pipelines, ingest data from CRM and SaaS tools, and collaborate with global teams to deliver data-driven insights.