About this role
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!