dentsu Logo

dentsu

Technical Architect

Posted Yesterday
Be an Early Applicant
In-Office
New Delhi, Delhi, IND
Expert/Leader
In-Office
New Delhi, Delhi, IND
Expert/Leader
Leads technical architecture and delivery for cloud-based data solutions. Designs data warehouses, data models, ETL pipelines, databases, and technical integrations; translates business requirements into SQL and ETL development; guides implementation teams; manages project delivery, technical governance, documentation, quality processes, and client communications. Requires hands-on Azure data engineering, architecture, development, and project leadership experience.
The summary above was generated by AI

Job Description:

Job Description


Details


Business Title

Technical Architect

Years of Experience

 + 10 years

Must have skills

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

Good to have skills

1. UNIX shell scripting, SnowFlake, Reshift, Familiar with NoSQL such as MongoDB, etc
2. 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) )
3. Experience in Cloud platforms - AWS / GCP
4. Client-facing skills
5. 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.


Education Qulification

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

Certification If Any

 - Professional certification in cloud technologies , Azure Data Engineer must

Shift timing

12 PM to 9 PM IST




The resource will be responsible for building and developing the solution, not just gathering requirements.

Previous work had already been carried out by Gene P on the business requirements and story definition side. The new person would need to:

Take those requirements,

Create or contribute to the technical design,

Carry out the development/build work

Skills/profile sought

Engineering/development capability.

Able to translate business requirements into a technical solution.

Able to perform both technical design and development activities


Location:

DGS India - Pune - Indiqube Orchid

Brand:

Merkle

Time Type:

Full time

Contract Type:

Consultant

dentsu Gurugram, Haryana, IND Office

Gurugram, India

dentsu New Delhi, Delhi, IND Office

New Delhi, India

Similar Jobs

15 Hours Ago
In-Office or Remote
India
Expert/Leader
Expert/Leader
Information Technology
Provides technical architecture direction, assessments, strategies, and roadmaps for client projects. Designs best-fit solutions, guides technology migrations, collaborates with technical and business stakeholders, leads workstreams, mentors team members, and supports consulting sales pursuits. Requires extensive programming, enterprise architecture, technology consulting, agile development, technical leadership, client relationship, and project delivery experience. Travel is required, and the role involves working with distributed and offshore teams.
15 Hours Ago
In-Office or Remote
India
Expert/Leader
Expert/Leader
Information Technology
Designs and leads scalable Adobe Experience Manager Forms solutions, including architecture, integrations, development, deployment, cloud services, and migration initiatives. Establishes technical standards, security, performance, and scalability practices; leads architecture reviews, client workshops, estimations, and governance. Collaborates with stakeholders and engineering teams, mentors developers, and supports enterprise integrations with SAP, Salesforce, CRM, ERP, and third-party platforms.
Top Skills: Adaptive FormsAdobe Document ServicesAdobe Experience Manager (Aem)Aem FormsAem WorkflowsApache SlingCRMErpForm FragmentsHtlJavaOsgiRest ApisSalesforceSAPSoap ApisXdp Forms
15 Hours Ago
In-Office or Remote
India
Expert/Leader
Expert/Leader
Information Technology
Designs and leads scalable Adobe Experience Manager Forms solutions, including architecture, development, integrations, deployments, cloud migration, and upgrades. Establishes technical standards for security, performance, and scalability; leads architecture reviews, client workshops, estimations, and governance. Partners with business and engineering stakeholders, mentors development teams, and supports enterprise integrations with SAP, Salesforce, CRM, ERP, and third-party platforms.
Top Skills: Adaptive FormsAdobe Document ServicesAdobe Experience ManagerAem FormsAem WorkflowsCRMErpForm FragmentsHtlJavaOsgiRestSalesforceSAPSlingSoapXdp Forms

What you need to know about the Delhi Tech Scene

Delhi, India's capital city, is a place where tradition and progress co-exist. While Old Delhi is known for its rich history and bustling markets, New Delhi is defined by its modern architecture. It's clear the region places a strong emphasis on preserving its cultural heritage while embracing technological advancements, particularly in artificial intelligence, which plays a central role in shaping the city's tech landscape, fueled by investments in research and development.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account