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
Valuable 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
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.