Tech Architect - Data

Quantiphi Analytics Solutions Private Limited; Mumbai; On-site; INR 2,500,000 - 4,500,000; Full time

Job summary

Quantiphi Analytics Solutions Private Limited is seeking a Technical Architect for Data with 8–10+ years of experience. Location options include Mumbai or Bangalore.

The role focuses on designing and delivering scalable data engineering and analytics platforms, including data warehouses, data lakes, and complex ETL/ELT pipelines, while ensuring governance, security and compliance. You will collaborate with cross-functional teams to translate business needs into robust technical solutions and

Qualifications

• Data Engineering & Database skills with strong experience in Data Warehousing, Data Engineering and Data Integration projects.
• Proficiency in ETL/ELT frameworks, OLAP, Data Lakes and enterprise data platforms.
• Solid SQL programming and query optimization; knowledge of API, XML and JSON data integration.

Responsibilities

• Design, develop and maintain scalable data engineering and analytics solutions for enterprise data platforms.
• Build and optimize ETL/ELT pipelines for ingestion, transformation and processing of large-scale data.
• Architect data warehouse and data lake solutions and define architecture standards and blueprints.
• Collaborate with Product Owners, BA, Data Architects, Data Scientists and BI teams to translate requirements into technical solutions.

Skills

Data Warehousing

Data Engineering

Data Integration

ETL/ELT

SQL

Cloud Platforms

Agile/Scrum

Tools

Informatica

PowerExchange

Azure Data Factory

Databricks

BigQuery

Airflow

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: Technical Architect- Data Experience: 8-10+ Years Work Location: Bangalore / Mumbai Timings: 11AM - 7PM IST

Key Responsibilities

• Design, develop, and maintain scalable data engineering and analytics solutions for enterprise data platforms.
• Build and optimize ETL/ELT pipelines for ingestion, transformation, and processing of large-scale structured and unstructured data.
• Develop conceptual, logical, and physical data models including metadata, lineage, and technical definitions.
• Architect and implement data warehouse and data lake solutions.
• Define architecture standards, blueprints, accelerators, and interoperability patterns.
• Work closely with Product Owners, Business Analysts, Data Architects, Data Scientists, and BI teams to translate business requirements into technical solutions.
• Design and implement dimensional models, fact tables, and data transformation/cleansing processes.
• Develop scalable and high-performance data processing pipelines for enterprise reporting and analytics.
• Ensure data governance, data quality, security, privacy, and lifecycle management standards are implemented.
• Provide production support for ETL processes and ensure data availability and integrity.
• Create technical documentation, data flow diagrams, and architecture artifacts.
• Conduct solution reviews and ensure compliance with enterprise architecture standards.
• Mentor and guide data engineers and technical teams across multiple locations.
• Support evaluation and implementation of emerging technologies and lead proof-of-concept initiatives.

Required Skills & Experience

• Data Engineering & Database Skills Strong experience in Data Warehousing, Data Engineering, and Data Integration projects.
• Expertise in ETL/ELT frameworks, OLAP systems, Data Lakes, and enterprise data platforms.
• Strong SQL programming and query optimization skills.
• Experience with: Oracle PL/SQL MS SQL Server PostgreSQL MySQL Strong understanding of database design, data modeling, and architecture principles.
• Cloud & Big Data Technologies Hands-on experience with: Google Cloud Platform (GCP) BigQuery Cloud SQL Composer (Airflow) Dataflow Dataproc Cloud Functions Google Cloud Storage (GCS)
• Experience with Azure technologies including: Azure Data Factory (ADF) Azure Data Lake Storage (ADLS) Databricks Knowledge of AWS cloud services is a plus.
• Integration & Data Tools Experience with Informatica and PowerExchange integrations.
• Experience integrating data from Mainframe, Salesforce, ERP, CRM, HRIS, and other enterprise systems.
• Strong knowledge of APIs, XML, JSON, and modern data integration techniques.
• Good to have: SQL Server Reporting Services (SSRS) SQL Server Integration Services (SSIS) Dremio Architecture & Governance Experience defining enterprise data architecture and reference frameworks.
• Knowledge of data governance, metadata management, master/reference data, and data quality practices.
• Experience implementing security controls and privacy standards for sensitive data.
• Ability to perform sizing, estimation, and costing for data solutions.

Soft Skills

• Strong analytical and problem-solving abilities.
• Excellent communication and stakeholder management skills.
• Experience working in Agile and Scrum environments.
• Ability to lead distributed teams and mentor engineers across locations.
• Strong organizational and multitasking capabilities.

If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us! Thank you for your interest in Quantiphi! We are a team that dreams together and collaborates to ensure success. We are currently looking for exceptional individuals who can join us and contribute to a fun, diverse and hybrid work culture. As a part of the Quantiphi family, you will get ample opportunities to learn, grow and interact with colleagues from varied experience and backgrounds around the globe. Quantiphi is an award-winning AI-first digital engineering company driven by the desire to reimagine and realize transformational opportunities at the heart of business. We solve the toughest and most complex business problems with the latest and cutting-edge technologies and to make this happen, we have a vibrant, diverse and talented set of professionals we proudly refer to as the Quantiphi family. Our culture is built on transparency, diversity, integrity, learning and growth. We are committed to provide our teams with an environment that helps them to learn, grow and flourish in their professional as well as personal lives.