Data Solution Architect

Location: Pune (Hybrid – 3 days in office)

Experience: 10–14 years

About The Role

We are seeking a Data Solution Architect to spearhead the data platform for a global payments and SaaS client. In this role, you will own architecture across SQL Server, Snowflake, Power BI, and Power Platform. You will serve as the client’s technical advisor, and you will provide guidance to the delivery team throughout design, implementation, and ongoing evolution of the platform.

Key Responsibilities

• Design and continuously improve a cloud data warehouse on Snowflake using dbt, including layered modelling, history/snapshot strategy, and ingestion from operational databases.
• Lead technical discovery activities such as scope validation, impact analysis, data profiling, and end-to-end solution design.
• Establish 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 practices for data, reporting, and Power Platform workloads.
• Assess and recommend tools, and determine build-vs-buy approaches while balancing cost, licensing, and security requirements.
• Drive AI-assisted delivery using knowledge bases, agent-assisted development, and testing practices.
• Ensure production stability by reviewing designs and code, and mentoring engineers.
• Collaborate with stakeholders and convert business requirements into delivery roadmaps and estimation plans.
  
  

Must Have

• Strong experience in data architecture 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)
• Exceptional 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