Job Title: Senior Snowflake Developer / Data Engineer

Location: Hybrid / Remote

Job Type: Full time

Experience: 8–12 Years

Company: Madiba Global Solutions (Madiba India)

About Us

Madiba Global Solutions (MGS) is a leading consulting firm focused on delivering client value and ROI through best-in-class SAP solutions. We are seeking a Senior Snowflake Developer / Data Engineer with SAP data experience to join our delivery team supporting data integration and reporting initiatives for global clients.

Position Overview

This role supports a data integration and reporting project involving SAP S/4HANA data extraction, JSON ingestion, Snowflake transformation, performance optimization, and Power BI reporting. The resource will work closely with the Solution Architect to validate, enhance, optimize, and productionize the Snowflake data layer. The Snowflake layer also serves as the ODS (staging area) feeding the OneStream consolidation and planning cubes: non-SAP sources land in Snowflake, are staged, curated, measured and logged, and are delivered pre-formatted to the cube layout for native load into OneStream with no ETL transformation.

Significant additional Snowflake work is planned for next year, so this is a long-term, high-impact role.

Key Responsibilities

SAP Data Ingestion & Integration

- Support ingestion of SAP S/4HANA data into Snowflake, including historical conversion loads and ongoing delta loads.
- Work with OData API-based JSON data ingestion into Snowflake.
- Transform semi-structured JSON data into structured, report-ready tables and views.
- Support flattened hierarchy reporting requirements for SAP master data and organizational structures.

Snowflake Development & Optimization

- Develop and optimize Snowflake objects for master data, transaction data, and reporting consumption.
- Optimize Snowflake performance for large-volume fact data (e.g., hundreds of millions of records).
- Evaluate and recommend optimal Snowflake performance patterns such as dynamic tables, materialized views, clustering, and persisted reporting tables.
- Prepare Snowflake data structures for Power BI consumption.
- Assist with data validation, reconciliation, performance testing, and technical documentation.

Reporting & Validation

- Support flattened hierarchy reporting requirements for SAP data structures including cost centers, profit centers, and GL hierarchies.
- Validate data accuracy and completeness across historical and delta load cycles in collaboration with functional teams.
- Collaborate with Power BI developers to ensure reporting layer meets business consumption requirements.
- Document data models, transformation logic, performance tuning decisions, and validation outcomes.

Collaboration & Documentation





- Work with the Solution Architect to validate, refine, and productionize the Snowflake data layer.
- Participate in design reviews and contribute to architecture decisions related to Snowflake performance and scalability.
- Maintain clear technical documentation for all Snowflake objects, transformation logic, and ingestion patterns.
- Support testing cycles including performance benchmarking, data reconciliation, and end-to-end validation.
- Own the technical design and delivery of the Snowflake ODS layer end to end, setting standards for data modeling, naming, security, and cost management.
- Lead technical discussions with client stakeholders and implementation partners, and translate business and cube requirements into feed specifications.
- Mentor and guide junior engineers, conduct code reviews, and establish best practices for the growing Snowflake practice.

OneStream Integration & ODS Layer

- Design and build the Snowflake ODS (staging area) with defined stage, curate, measure, and log layers for all data feeding OneStream.
- Ingest non-SAP planning and consolidation inputs (e.g., Kyriba, HCM, and lookup/reference sheets) into the ODS; every non-SAP source passes through the ODS.
- Produce curated datasets pre-formatted to the OneStream consolidation and planning cube layouts so OneStream can load natively with no ETL transformation.
- Implement logging, controls, and monitoring for each feed, including row-count and amount reconciliation, load audit trails, and exception reporting.
- Reconcile ODS data with SAP-sourced data delivered to OneStream through SAP Datasphere / SAP Business Data Cloud (SAP data does not flow through Snowflake).
- Support the supplemental custom area requirement by analyzing spreadsheet and macro-based calculations and recommending where the logic and data should reside (Snowflake or OneStream).
- Work with the OneStream implementation team (PwC), the SAP team, and Madiba architects on feed specifications, load schedules, and cutover.

Required Experience

Required Skills

- Strong hands-on Snowflake SQL development experience.
- Experience with Snowflake data engineering, transformation, and performance tuning.
- Experience working with JSON and semi-structured data using VARIANT and FLATTEN.
- Experience building scalable reporting layers for BI tools such as Power BI.




- Demonstrated experience with large-volume datasets and Snowflake performance optimization.
- Ability to take an existing solution design, challenge and refine it, and own it through to production.
- 8+ years of overall data engineering experience with at least 4–5 years of hands-on Snowflake development on production-grade, enterprise-scale projects.
- Proven ability to work independently, make sound technical decisions, and collaborate effectively with a Solution Architect and client stakeholders.
- Experience designing ODS / staging and curated data layers with multi-layer (stage/curate/publish) patterns, including data quality checks, audit logging, and monitoring.
- Ability to deliver data to fixed target layouts (e.g., finance cube or load-file specifications) with repeatable, automated pipelines.
- Hands-on experience building ingestion pipelines with Snowpipe, Streams, Tasks, and COPY INTO from cloud storage (Azure preferred).
- Experience developing stored procedures (Snowflake Scripting, JavaScript, or Python) for staging, curation, and logging workflows.
- Experience implementing data quality checks, reconciliation, audit logging, and monitoring natively in Snowflake.
- Working knowledge of Snowflake security and governance: RBAC, masking policies, and secure views for sensitive finance and HR data.
- Experience managing warehouse sizing, resource monitors, and query/cost optimization.
- Experience with dbt or similar transformation frameworks and Git-based CI/CD for Snowflake deployments.

Preferred

- SAP S/4HANA data experience — familiarity with SAP master data, transaction data, and hierarchy structures.
- Experience consuming SAP data through OData APIs.
- Experience with historical data conversion or migration projects.
- Understanding of delta load patterns and data reconciliation strategies.
- Exposure to additional Snowflake features such as dynamic tables, materialized views, and the Snowpark Python API.
- Exposure to finance systems data: consolidation, planning, or CPM tools (OneStream preferred), and sources such as Kyriba or HCM platforms.
- Familiarity with SAP Datasphere / SAP Business Data Cloud and ACDOCA-based financial data.
- Experience with Azure-hosted data platforms and orchestration tools (e.g., Azure Data Factory, Airflow).

Education & Certifications

Education: Bachelor's or Master's in Computer Science, Information Technology, Engineering, or a related discipline preferred.

Snowflake Certification: SnowPro Core is required; SnowPro Advanced (Data Engineer or Architect) is a strong advantage.

Experience: 8–12 years of overall data engineering experience; minimum 4–5 years of hands-on Snowflake development on production-grade projects, including ownership of design and delivery.

📌 Senior Snowflake Developer / Data Engineer (Bengaluru)
🏢 Madiba Global Solutions
📍 Bengaluru