dentsu international

Manager

12 November 2024
Apply Now
Deadline date:
£54000 - £101000 / year

Job Description

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 practice advice. Interactions with internal stakeholders 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.

Job Description:

Must-Have Skills:

•    Database ( SQL server / SnowFlake / Teradata / Redshift / Vertica /  Oracle / Big query / Azure DW  etc)                
•    ETL tool (Talend, Informatica, IICS (Informatica cloud) )    
•    Experience in Cloud computing (one or more of AWS, Azure, GCP)        
•    Python, UNIX shell scripting, Project & resource management            
•    SVN, JIRA, Automation workflow (Apache Airflow, Tidal, Tivoli or similar)                

Good to have Skills: 
•    PySpark, Big Query, Familiar with NoSQL such as MongoDB, etc            
•    Client-facing skills

Key Responsibilities:

  • Ability to design simple to medium data solutions for clients by using cloud architecture using AWS/GCP
  • Strong understanding of DW, data mart, data modeling, data structures, databases, and data ingestion and transformation.​
  • Working knowledge of ETL as well as database skills
  • Working knowledge of data modeling, data structures, databases, and ETL processes​
  • Strong understanding 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 the detailed design to the 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 Clients, Data Scientists, and Analytical Consultants working on marketing solution
  • Work with cross-functional internal teams 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 include 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/validating 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

Qualifications:

  • Bachelor’s or Master’s Degree in Computer Science with >= 7 years of IT experience
  • Database (Oracle / SQL server / Teradata / Vertica /  Redshift / Big query / Azure DW etc)
  • ETL tool (Talend, Informatica, Datastage), Python, UNIX shell scripting, Project & resource management, SVN, JIRA

Location:

Bangalore

Brand:

Merkle

Time Type:

Full time

Contract Type:

Permanent