Snowflake Data Platform Architect

Riveron; Pune District, Bengaluru; Hybrid; INR 3,200,000 - 5,200,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

401(k) with company match

Paid time off

Job summary

Riveron is seeking a Snowflake Data Platform Architect in Pune to own the architecture, design, and modernization of Riveron’s enterprise data foundation. You will build scalable, governed data infrastructure across Snowflake, Power BI, Salesforce, and APIs, while championing durable enterprise patterns.

The role requires hands-on expertise and leadership to guide data engineers, BI developers, and AI engineers, aligning data models, governance, and AI readiness with Riveron’s future-state

Qualifications

• 6–9 years of experience in data architecture, data engineering, cloud data platforms, or analytics engineering.
• Deep hands-on experience with Snowflake, SQL, data modeling, ELT/ETL, and enterprise data warehouse design.
• Experience with Power BI semantic models; Microsoft Fabric or similar BI platform is a plus but not required.
• Strong understanding of data governance, security, role-based access, data quality, and lifecycle management.
• Experience integrating data from SaaS platforms, APIs, finance systems, Salesforce, and flat-file sources.
• Ability to design scalable architecture while still contributing hands-on when needed.

Responsibilities

• Own the architecture and technical roadmap for Riveron’s enterprise data platform.
• Lead Snowflake datawarehouse/lakehouse design, including data modeling, ingestion, transformation, access controls, performance tuning, and cost optimization.
• Design reusable data models, semantic layers, and governed datasets for enterprise reporting and AI-enabled use cases.
• Partner with reporting and analytics teams to modernize Power BI models and reduce dependency on manual reporting processes.
• Support Alteryx modernization and migration by replacing manual workflows with scalable data pipelines.
• Design data integration patterns across Salesforce, SharePoint, finance systems, operational platforms, APIs, and third-party data sources.
• Establish data quality, lineage, reconciliation, documentation, and observability standards.
• Partner with AI product engineers to make Riveron’s data architecture AI-ready for pilots and retrieval-augmented generation.
• Provide technical leadership to data engineers, BI developers, analysts, and AI engineers.

Skills

Snowflake

SQL

Data modeling

ELT/ETL

Data architecture

Power BI

Python

Airflow

Azure Data Factory

Fivetran

Matillion

AI readiness

Tools

Power BI

Azure Data Factory

Fivetran

Matillion

Job description

Role Summary

Snowflake Data Platform Architect will own the architecture, design, and modernization of Riveron’s enterprise data foundation. This role will be responsible for building scalable, governed, and AI-ready data infrastructure across Snowflake, Power BI (Microsoft Fabric experience a plus), Salesforce, Alteryx migration, APIs, and shared data access patterns.

This role is central to Riveron’s future-state data strategy. The person should be both a hands-on architect and a platform owner who can create durable enterprise patterns rather than one-off reporting solutions.

Key Responsibilities

• Own the architecture and technical roadmap for Riveron’s enterprise data platform.
• Lead Snowflake datawarehouse / lakehouse design, including data modeling, ingestion, transformation, access controls, performance tuning, and cost optimization.
• Design reusable data models, semantic layers, and governed datasets for enterprise reporting and AI-enabled use cases.
• Partner with reporting and analytics teams to modernize Power BI models (Microsoft Fabric experience a plus) and reduce dependency on manual or fragmented reporting processes.
• Support Alteryx modernization and migration where appropriate, replacing manual workflows with scalable data pipelines.
• Design data integration patterns across Salesforce, SharePoint / Microsoft 365, finance systems, operational platforms, spreadsheets, APIs, and third-party data sources.
• Establish data quality, lineage, reconciliation, documentation, and observability standards.
• Partner with AI product engineers to make Riveron’s data architecture AI-ready for pilots, agents, retrieval-augmented generation, and natural language analytics.
• Provide technical leadership to data engineers, BI developers, analysts, and AI engineers.

Required Experience

• 6-9 years of experience in data architecture, data engineering, cloud data platforms, or analytics engineering.
• Deep hands‑on experience with Snowflake, SQL, data modeling, ELT / ETL, and enterprise data warehouse design.
• Experience with Power BI semantic models required; Microsoft Fabric or similar enterprise BI platform experience a plus but not required.
• Strong understanding of data governance, security, role-based access, data quality, and lifecycle management.
• Experience integrating data from SaaS platforms, APIs, finance systems, Salesforce, and flat-file sources.
• Ability to design scalable architecture while still contributing hands-on when needed.

Preferred Experience

• Experience with SQL, Python, Airflow, Azure Data Factory, Fivetran, Matillion, or similar tools.
• Experience modernizing Alteryx or spreadsheet-heavy processes.
• Exposure to AI / ML data readiness, vector databases, semantic search, RAG architecture, or LLM application patterns.
• Experience in finance, consulting, professional services, or Office of the CFO analytics.

About Riveron:

At Riveron, we partner with clients—from global multinationals to high-growth private entities—to solve complex finance challenges, guided by our DELTA values: Drive, Excellence, Leadership, Teamwork, and Accountability. Our entrepreneurial culture thrives on collaboration, diverse perspectives, and delivering exceptional outcomes. We are committed to fostering growth, both for our clients and our people, through mentorship, integrity, and a client-centric approach. This inclusive environment offers flexibility, progressive benefits, and meaningful opportunities for impactful work that supports well-being in and out of the office.

Want to stay connected with Riveron? Join our Talent Community to learn more about our growing firm and be considered for future opportunities.

Riveron Consulting is an Equal Opportunity Employer and believes that we are stronger together through our diversity. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, disability status, protected veteran status, sexual orientation, gender identity or any other characteristic protected by law.

Full time roles are eligible for a full range of benefits including medical, dental, and vision insurance, 401(k) with company match, and PTO. A complete description of all available benefits can be found at Riveron's Benefits page at https://riveron.com/riveron-life/. Contract roles are not eligible for benefits.