Associate Architect - Data

While technology is the heart of our business, a global and diverse culture is the heart of our success. We love our people and we take pride in catering them to a culture built on transparency, diversity, integrity, learning and growth.

If working in an environment that encourages you to innovate and excel, not just in professional but personal life, interests you- you would enjoy your career with Quantiphi!

Role: Associate Architect - Data (Snowflake)

Experience Level: 6 + Years

Work location: Mumbai, Bangalore & Trivandrum

Notice Period: Looking for 0-15 days joiners

Role & Responsibilities:

Data Warehouse Design: Design and develop data warehouse solutions using the Snowflake Data Platform on Azure.

Pipeline Orchestration: Lead the development of data pipelines using Azure Data Factory (ADF), implementing robust error handling, alerting, reset/retry logic, and monitoring.

Data Loading & Integration: Implement incremental data loading using CDC and watermark-based methods, alongside SFTP and REST API integrations.

Snowflake Administration: Apply best practices for Snowflake optimization and security, utilizing Snowpipe, Snowpark, RBAC, Data-Masking, Stored Procedures, UDFs, and Streams & Tasks.

Technical Leadership: Translate detailed business requirements into technical data solutions, conduct code reviews, and mentor junior data engineers.

DevOps Integration: Implement CI/CD pipelines using Azure DevOps, utilizing Git and branching models for deployments.

Financial Domain Alignment: Apply an understanding of core financial concepts and reporting (GAAP/IFRS, P&L, Balance Sheet) to build data solutions supporting Sage Intacct GL, SkyGen, and ClearWater.

Data Quality: Lead requirement gathering with stakeholders and assist in developing automated testing for data pipelines and data quality.

Skills expectation:

Snowflake Expertise: Strong hands-on experience with Snowflake on Azure, including RBAC, administration, optimization, and secure data governance.

Data Pipeline & ETL/ELT: Expertise in ADF for data ingestion and transformation, including advanced error handling and CDC/watermark methods.

Azure Ecosystem: Proficiency with Azure Data Lake Storage (ADLS), Azure Key Vault, and Azure DevOps CI/CD pipelines.

Technical Core: Strong SQL skills, Python proficiency, and solid Data Modeling capabilities for Data Warehouses and Data Marts.

Financial Acumen: Experience with financial reporting and processes. Familiarity with Sage Intacct GL, SkyGen, or ClearWater data structures is highly preferred.

Team Leadership: Ability to lead technical execution, gather stakeholder requirements, and mentor junior engineers.

If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!