About this role
Data Solution Architect 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-environment 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
• Strong 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
Good 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