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
Location:
DGS India - Pune - Indiqube OrchidBrand:
MerkleTime Type:
Full timeContract Type:
PermanentSkills Required
- 10+ years of professional experience
- Bachelor's or master's degree in Computer Science, Information Systems, Data Engineering, or a related field
- Database experience with SQL Server, Oracle, MySQL, Azure SQL, or equivalent
- Data warehouse experience with Synapse Analytics, Snowflake, or equivalent
- Experience with at least two ETL tools, including Azure Data Factory or Databricks
- Experience with Azure cloud platforms
- Python, PySpark, and UNIX shell scripting
- SVN, Git, Jira, and automation workflow tools
- Project and resource management experience
- Professional certification in cloud technologies; Azure Data Engineer certification
- Experience with AWS or GCP cloud platforms
- Snowflake, Redshift, NoSQL databases such as MongoDB, and additional ETL tools
- Client-facing skills
- Familiarity with AI/ML integration into data architectures
dentsu Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about dentsu and has not been reviewed or approved by dentsu.
-
Parental & Family Support — Paid parental leave at full pay and caregiver supports (including backup care) are emphasized as standout elements. Feedback suggests family-oriented benefits are a strong part of the package.
-
Leave & Time Off Breadth — Flexible or unlimited PTO, extensive paid holidays, and a year-end office closure are established components. Feedback suggests time-off policies are generous and add meaningful flexibility.
-
Retirement Support — A large, established 401(k) plan with employer matching is clearly documented. Feedback suggests retirement benefits feel competitive and straightforward.
dentsu Insights
What We Do
We are dentsu. We team together to help brands predict and plan for disruptive future opportunities and create new paths to growth in the sustainable economy. We know people better than anyone else and we use those insights to connect brand, content, commerce and experience, underpinned by modern creativity. We are the network designed for what’s next
