Associate Architect - Data

Job description

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* *!*