Technical Architect

Dentsu Global Services

Pune District

On-site

INR 3,500,000 - 6,500,000

Full time

2 hours ago

Be an early applicant

Application generator

Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.

Get past ATS filters

Job summary

Dentsu Global Services, Pune, seeks a Technical Architect to lead data architecture and delivery. You will own technical designs, mentor teams, and govern delivery across Azure-based data solutions. Strong DW, ETL, and cloud expertise are essential for success.

The role requires 10 years of experience, hands-on SQL/ETL, and collaboration with global teams to drive scalable data platforms. IST hours and US overlap apply.

Qualifications

Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Engineering, or related field.

Responsibilities

Design data solutions using Azure cloud architecture.
Understand DW, data mart, data modelling and data ingestion/transformation.
Guide ETL and SQL development and review designs.
Collaborate with global teams and leadership.
Translate requirements into ETL/ SQL code and documents.
Lead 1–2 projects with team size 2–3.
Engage with PMs, BAs, and DBAs to implement ETL solutions.
Support data scientists and analytical consultants on marketing solutions.

Skills

SQL databases

Data warehousing

ETL tools

Azure Cloud

Python

Pyspark

UNIX shell

Project management

Git/Jira

Education

Bachelor’s or Master’s degree in Computer Science/Information Systems/Data Engineering

Tools

Azure Data Factory

Databricks

Airflow

Tidal

Git

Jira

Job description

Data Warehouse (one or more of Synapse Analytics, SnowFlake,etc.)
ETL tool (two or more of Azure Data Factory, Databricks, etc.)
Experience in Cloud platforms - Azure
Python, Pyspark, UNIX shell scripting, Project & resource management
SVN, GIT, JIRA, Automation workflow (Azure Data Factory, Apache Airflow, Tidal, Tivoli or similar)

Details

Business Title

Technical Architect

Years Of Experience

10 years

Must Have Skills

Database ( SQL server / Oracle / MySQL / Azure SQL etc)
Data Warehouse (one or more of Synapse Analytics, SnowFlake,etc.)
ETL tool (two or more of Azure Data Factory, Databricks, etc.)
Experience in Cloud platforms - Azure
Python, Pyspark, UNIX shell scripting, Project & resource management
SVN, GIT, JIRA, Automation workflow (Azure Data Factory, Apache Airflow, Tidal, Tivoli or similar)

Good To Have Skills

UNIX shell scripting, SnowFlake, Reshift, Familiar with NoSQL such as MongoDB, etc
ETL tool (Databricks / AWS Glue / AWS Lambda / Amazon Kinesis / Amazon Firehose / Cloud Data Fusion / Dataflow / Dataproc / Pub/Sub / Composer / Cloud Functions / Cloud Run / DBT / Talend, Informatica, IICS (Informatica cloud) )
Experience in Cloud platforms - AWS / GCP
Client-facing skills
Familiarity with AI/ML integration into data architectures.

Job Descreption

The Technical Architect is a core role and focal point of the project team responsible for the whole technical solution and managing the day to day delivery. The role will focus on the technical solution architecture, detailed technical design, coaching of the development/implementation team and governance of the technical delivery. Technical ownership of the solution from bid inception through implementation to client delivery, followed by after sales support and best practise advice. Interactions with internal stakeholder’s and clients to explain technology solutions and a clear understanding of client’s business requirements through which to guide optimal design to meet their needs.

Key responsibiltes

Ability to design simple to medium data solutions for clients by using cloud architecture using Azure
Strong understanding of DW, data mart, data modelling, data structures, databases, and data ingestion and transformation.
Working knowledge of ETL as well as database skills
Working knowledge of data modelling, data structures, databases, and ETL processes
Strong understand of relational and non-relational databases and when to use them
Leadership and communication skills to collaborate with local leadership as well as our global teams
Translating technical requirements into ETL/ SQL application code
Document project architecture, explain detailed design to team and create low level to high level design
Create technical documents for ETL and SQL developments using Visio, PowerPoint and other MS Office package
Will need to engage with Project Managers, Business Analysts and Application DBA to implement ETL Solutions
Perform mid to complex level tasks independently
Support Client, Data Scientists and Analytical Consultants working on marketing solution
Work with cross functional internal team and external clients
Strong project Management and organization skills. Ability to lead 1 – 2 projects of team size 2 – 3 team members.
Code management systems which includes Code review, deployment, cod
Work closely with the QA / Testing team to help identify/implement defect reduction initiatives
Work closely with the Architecture team to make sure Architecture standards and principles are followed during development
Performing Proof of Concepts on new platforms/ validate proposed solutions
Work with the team to establish and reinforce disciplined software development, processes, standards, and error recovery procedures are deployed
Must understand software development methodologies including waterfall and agile
Distribute and manage SQL development Work across the team
The candidate must be willing to work during overlapping hours with US-based teams to ensure effective collaboration and communication, typically between [e.g., 6:00 PM to 11:00 PM IST], depending on project needs.