Location: Pune (Hybrid – 3 days in office)

Experience: 10–14 years

About The Role

We're looking for a Data Solution Architect to lead the data platform for a global payments/SaaS client. You'll own architecture across SQL Server, Snowflake, Power BI and Power Platform, act as the client's technical advisor, and guide the delivery team.

Key Responsibilities
Design and evolve a cloud data warehouse on Snowflake with dbt: layered modelling, history/snapshot strategy and ingestion from operational databases.
Lead technical discovery: scope validation, impact analysis, data profiling and solution design.
Set engineering standards for ETL, stored procedures, migrations and multi-setting promotion.
Architect reporting solutions in Power BI (paginated reports and dashboards), including automated report testing.
Define CI/CD and ALM for data, reporting and Power Platform workloads.
Evaluate tools and build-vs-buy options, balancing cost, licensing and security.




Drive AI-assisted delivery (knowledge bases, agent-assisted development and testing).
Oversee production stability, review designs and code, and mentor engineers.
Engage stakeholders and translate business needs into roadmaps and estimates.

Must Have
Solid data architecture experience with SQL Server/Azure SQL and Snowflake
dbt, dimensional modelling, SCD/snapshot patterns
Power BI architecture (paginated reports and dashboards)
CI/CD for data platforms (Azure DevOps or GitHub)
Excellent client-facing communication and documentation

Positive to Have
Power Platform / Power Automate ALM
Fivetran, AWS (S3), PostgreSQL
Azure (Container Apps, Entra ID)
GenAI / agentic tooling for engineering
Payments or fintech domain experience

📌 Data Solution Architect Pune
🏢 Ascendion
📍 Pune