Data Solution Architect

Ascendion Engineering; Pune District; Hybrid; INR 3,500,000 - 6,500,000; Full time

Job summary

Ascendion Engineering in Pune is seeking a Data Solution Architect to lead the data platform for a global payments/SaaS client. You will own architecture across SQL Server, Snowflake, Power BI and Power Platform, and guide the delivery team.

You will design a cloud data warehouse on Snowflake with dbt, define CI/CD for data workloads, and mentor engineers while engaging stakeholders to translate business needs into roadmaps and estimates.

Qualifications

• Experience with SQL Server/Azure SQL and Snowflake data architecture.
• Proficient in dbt and dimensional modelling.
• Experience with Power BI (paginated reports and dashboards).
• CI/CD for data platforms (Azure DevOps or GitHub).
• Excellent client-facing communication and documentation.

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.

Skills

SQL Server/Azure SQL

Snowflake

dbt

Dimensional modelling

SCD/snapshot patterns

Tools

Power BI

CI/CD (Azure DevOps or GitHub)

Job description

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