Analytics Engineer, Data Platform (Remote | WFH)
Posted Updated
Description
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.
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. 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. Healthcare coverage on day one Performance bonuses Paid time-off with cash conversion Group life insurance Flexible work arrangementsSkills
- AI
- Analytics
- CI/CD
- CRM
- Data Engineering
- Data Governance
- Data Ingestion
- Data Modeling
- Data Pipelines
- Data Quality
- Data Warehousing
- dbt
- Dimensional Modeling
- ELT
- Git
- HubSpot
- Medallion Architecture
- Metadata Management
- Pci Dss
- Power Query
- Power BI
- RBAC
- SaaS
- Snowflake
- SOC 2
- SQL
- Test Automation
- Version Control
- Zendesk
Sign in to read and join the discussion.