Lead Technical Architect
Dentsu
5 - 10 years
Mumbai
Posted: 07/06/2025
Job Description
Job Description:
Business Title
Lead Technical Architect
Years of Experience
> 7 Years
Must have skills
1. Database ( SQL server / SnowFlake / Teradata / Redshift / Vertica / Oracle / Big query / Azure DW etc)
2. ETL tool (Talend, Informatica, IICS (Informatica cloud) )
3. Experience in Cloud computing (one or more of AWS, Azure, GCP)
4. Python, UNIX shell scripting, Project & resource management
5. SVN, JIRA, Automation workflow (Apache Airflow, Tidal, Tivoli or similar)
Good to have skills
1. PySpark, Big Query, Familiar with NoSQL such as MongoDB etc
2. Client-facing skills
Jod Descreption
The Technical Lead / Technical Consultant 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 AWS/GCP
• 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
Education Qulification
1. Bachelor’s or Master Degree in Computer Science
Shift timingGMT (UK Shift) - 2 PM to 11 PM
Location:
MumbaiBrand:
MerkleTime Type:
Full timeContract Type:
PermanentAbout Company
Dentsu is a global advertising and digital marketing agency headquartered in Tokyo, Japan. It is part of the Dentsu Group Inc., one of the largest advertising and communications groups in the world. Dentsu specializes in providing integrated marketing solutions, including digital marketing, media planning, content creation, data analytics, public relations, and customer experience management. The company operates across numerous industries and markets, serving clients with innovative strategies to drive brand growth and engagement. With a strong focus on technology and creativity, Dentsu aims to deliver impactful, data-driven campaigns tailored to modern consumer behavior.
Services you might be interested in
One-Shot Campaign
Reach out to ideal employees in one shot!
The intelligent campaign for reaching out to the ideal audience to whom you can ask for help (guidance or referral).