Dentsu Creative Logo

Dentsu Creative

Technical Architect

Posted 7 Hours Ago
Be an Early Applicant
In-Office
Industrial Estate, Kharadi, Pune, Maharashtra, IND
Expert/Leader
In-Office
Industrial Estate, Kharadi, Pune, Maharashtra, IND
Expert/Leader
Owns end-to-end technical solution architecture and delivery for cloud-based data projects. Designs data warehouses, data marts, databases, ETL pipelines, and technical solutions primarily on Azure. Translates business requirements into technical designs and development work, leads implementation teams, reviews code, supports testing, governs architecture standards, performs proofs of concept, and collaborates with clients, project managers, analysts, DBAs, data scientists, and global teams. Manages one to two projects and provides technical coaching and post-delivery support.
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

Similar Jobs

7 Hours Ago
In-Office
Industrial Estate, Kharadi, Pune, Maharashtra, IND
Expert/Leader
Expert/Leader
AdTech • Marketing Tech
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.
Top Skills: Amazon FirehoseAmazon KinesisApache AirflowAws GlueAws LambdaAzureAzure Data FactoryAzure SqlAzure Synapse AnalyticsCloud FunctionsCloud RunComposerDatabricksDataprocDbtGitGoogle Cloud DataflowIicsInformaticaJIRAMS OfficeMongoDBMySQLOraclePowerPointPub/SubPysparkPythonRedshiftSnowflakeSQL ServerSvnTalendTidalTivoliUnix Shell ScriptingVisio
14 Days Ago
In-Office
Pune, Mahārāshtra, IND
Expert/Leader
Expert/Leader
AdTech • Marketing Tech
Designs and leads enterprise-scale cloud data platforms and analytics solutions using Snowflake, Python, SQL, and Azure technologies. Responsibilities include data architecture, migration, governance, optimization, and technical leadership. The role also architects generative AI, LLM, and RAG solutions, mentors engineering teams, conducts design reviews, develops roadmaps, and translates business requirements into secure, scalable technical solutions.
Top Skills: Ai AgentsAzure Ai ServicesAzure Data FactoryAzure DatabricksAzure DevopsAzure OpenaiCi/CdData LakehouseData ModelingData PipelinesData SharingData WarehousingDockerDynamic TablesEtl/EltGitKubernetesLangchainLlmsAzureMicrosoft FabricNumpyOpenai ApisPandasPower BIPrompt EngineeringPysparkPythonRagSemantic KernelSnowflakeSnowparkSnowpipeSQLStreams & TasksTableauTerraformVector Databases
14 Days Ago
In-Office
Pune, Mahārāshtra, IND
Expert/Leader
Expert/Leader
AdTech • Marketing Tech • Software
Design and lead enterprise-scale data and AI architectures centered on Snowflake and Microsoft Azure. Responsibilities include data platform modernization, cloud migration, data governance, Snowflake optimization, Python and SQL development, and GenAI solutions using LLMs and RAG. The role leads technical teams, conducts architecture reviews, mentors engineers, translates business requirements into solutions, creates roadmaps and governance documentation, and ensures security, compliance, performance, and cost optimization.
Top Skills: Ai AgentsAzure Ai ServicesAzure Data FactoryAzure DatabricksAzure DevopsAzure OpenaiCi/CdData LakehouseData ModelingData SharingData WarehousingDockerDynamic TablesEltETLGitKubernetesLangchainLarge Language ModelsAzureMicrosoft FabricNumpyOpenai ApisPandasPower BIPrompt EngineeringPysparkPythonRetrieval-Augmented GenerationSemantic KernelSnowflakeSnowparkSnowpipeSQLStreams And TasksTableauTerraformVector Databases

What you need to know about the Pune Tech Scene

Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account