Technical Architect

dentsu; Pune District; Presencial; INR 3.000.000 - 6.000.000; Jornada completa

Descripción de la vacante

dentsu in Pune, India is seeking a Senior Technical Architect to design Azure-based data architectures, lead DW/ETL development, and collaborate with global teams. The role requires 10+ years in the field and strong SQL, data modelling, and cloud experience. The candidate will mentor juniors and coordinate with QA and architecture teams.

Work timing aligns with US overlap; full-time contract in India. The ideal professional will translate business requirements into scalable ETL/SQL solutions,

Formación

• Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Engineering, or related field.
• 10+ years of experience as Technical Architect or equivalent.
• Strong SQL, DW design, and ETL development skills.

Responsabilidades

• Design data solutions using Azure cloud architecture.
• Lead DW/Data modelling, ingestion and ETL processes.
• Collaborate with global teams and project managers.
• Translate requirements into ETL/SQL code.
• Ensure architecture standards are followed.
• Mentor 2–3 team members and manage small projects.
• Engage with QA and architecture teams.

Conocimientos

Database (SQL Server / Oracle / MySQL)

Data Warehouse (Synapse / SnowFlake)

ETL tool (Azure Data Factory / Databrn

Educación

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

Herramientas

Azure Data Factory

Databricks

SnowFlake

Descripción del empleo

Job Description

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.

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

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

About dentsu For over 120 years, innovation has been a core tenet of our offering – exploring new ways to reach, engage and nurture relationships with audiences. Together we drive a multiplier effect for clients at a global scale, through the development of Integrated Growth Solutions that are underpinned by our promise to clients: innovating to impact. Be a force for good. Sustainability is a vital part of our business and an important area of focus for our clients. We’re leading the way – helping to build a more sustainable planet. Dream loud. In this moment of transformation, we need our people to be fearless, embracing change and ambiguity, driven by the love for their work and excitement for the future. Team without limits. We create opportunities for connection and collaboration between our colleagues and clients, building a sense of belonging and having some fun along the way. Find out more about us Who we are Our Social Impact Our work