Snowflake Data Engineer / Analyst

Data & Analytics / Business Intelligence - Full-time

Job Brief

Required Skills :

- Snowflake expertise (required) :Advanced administration, performance tuning, role-based access control (RBAC), virtual warehouse management, and cost optimisation.
- Hands-on experience with: ◦ Snowflake features: Time Travel, Fail-protected, Data Sharing, Streams, Tasks, and Dynamic Tables

◦ Snowflake integration with cloud platforms: AWS (S3, Glue, Lambda), Azure (Data Factory, Blob), or GCP (BigQuery, Dataflow)

◦ Snowpark for Python / Java-based data transformations

◦ dbt (data build tool) or equivalent transformation framework — strongly preferred

- SQL development :Complex query writing, query optimisation, window functions, CTEs, stored procedures, and advanced analytics functions.
- Data pipeline design, development, and maintenance: ◦ ELT/ETL pipeline architecture using tools such as Fivetran, Airbyte, Matillion, or custom Python-based pipelines

◦ Orchestration tools: Apache Airflow, dbt Cloud, Azure Data Factory, or equivalent

◦ Handling structured, semi-structured (JSON, Parquet, Avro), and streaming data sources

◦ Data modelling: star schema, snowflake schema, and dimensional modelling best practices

- Marketing & digital analytics experience :Analysing marketing, digital, call center, and CRM data to generate actionable business insights.
- Google Analytics 4 (GA4): ◦ GA4 implementation, event tracking configuration, and custom dimension / metric setup

◦ GA4 BigQuery export and downstream Snowflake pipeline integration

◦ Funnel analysis, attribution reporting, and audience segmentation

- Marketing attribution modelling :First-touch, last-touch, linear, time-decay, and data-driven attribution models; multi-channel attribution strategy.




- MarTech platform experience: ◦ Iterable: campaign data extraction, event tracking integration, and analytics support

◦ Experience with other marketing automation platforms (HubSpot, Klaviyo, Salesforce Marketing Cloud, or similar)

◦ CRM data integration: Salesforce, HubSpot, or equivalent

- A/B testing and experimentation analytics: ◦ Experimental design, sample size calculation, and statistical significance testing

◦ Building experimentation frameworks and reporting pipelines for ongoing test-and-learn programs

- Power BI (required) :Dashboard and report development, DAX measures, data model design, Row-Level Security (RLS), and scheduled refresh configuration.
- Additional BI / visualisation tools: ◦ Tableau, Looker, or Google Data Studio / Looker Studio — a plus

◦ Executive dashboard design: KPI summary slides, scorecard views, and presentation-ready outputs

◦ Supporting leadership with data presentations and summary slide preparation

- Data quality, validation, and documentation: ◦ Implementing data quality checks, anomaly detection, and alerting workflows

◦ Maintaining data dictionaries, lineage documentation, and asset catalogues (Alation, Collibra, or dbt Docs)

◦ Ensuring data governance standards and PII handling best practices

- Bonus Skills: ◦ Snowflake SnowPro Core or Advanced certification

◦ Python scripting for data engineering and automation tasks

◦ Experience with Reverse ETL tools (Census,



Hightouch) for syncing data back to MarTech platforms

◦ Familiarity with call center data platforms (Five9, Genesys, Talkdesk, or similar)

◦ ServiceTitan or other field service management platform data integration experience

- US market experience (required) :Demonstrated experience supporting US-based clients or business units, with strong written and verbal English communication skills aligned to US business standards.

Responsibilities :

- Design, build, and maintain scalable data pipelines and ELT/ETL workflows within Snowflake and connected cloud data warehouses.
- Write, optimise, and maintain complex SQL queries, stored procedures, and transformation logic to support downstream analytics and reporting.
- Administer and optimise the Snowflake environment including virtual warehouse sizing, query performance, RBAC, cost governance, and security configurations.
- Analyse marketing, digital analytics, call center, and CRM data to produce timely, accurate, and actionable business insights.
- Support preparation of executive dashboards, KPI presentations, and summary slides that translate complex analysis into clear, decision-ready outputs.
- Configure and maintain GA4 tracking — including event definitions, custom dimensions, data stream settings, and BigQuery integration pipelines.
- Develop, maintain, and iterate on multi-touch marketing attribution models across paid, organic, and direct channels.
- Integrate and extract data from MarTech platforms including Iterable and other marketing automation and CRM tools into the centralised data warehouse.
- Design and execute A/B testing frameworks; calculate statistical significance, analyse results, and communicate findings to marketing and product

📌 Snowflake Data Architect & BI Analyst (India)
🏢 Itvan Tech
📍 India