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.

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