Technical Architect - SQL Implementation

Roles & Responsibilities

• Ability to design simple to medium data solutions for clients by using cloud architecture using AWS/Azure
• Understanding of DW, data mart, data modelling, data structures, databases, and data ingestion and transformation.
• Understand ETL as well as database skills
• Understand of data modelling, data structures, databases, and ETL processes
• 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
• Document project architecture, explain detailed design to team and create low level to high level design
• 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 inlcudes Code review, deployment, cod

Mandatory skills (top 5)

• Database ( SQL server / SnowFlake / Teradata / Redshift /Vertica / Oracle / Big query / Azure DW etc)
• ETL tool (Talend, Informatica, SSIS, Datastage)
• Python, UNIX shell scripting, Project & resource management
• SVN, JIRA, Tidal (Automation workflow)

Preferred (top 5)

• Experience in Cloud computing (one or more of AWS, Azure, GCP)
• Tivoli
• Matillion (ETL)
• MS Office
• Client-facing skills

Merkle, a dentsu company, is a leading data-driven customer experience management (CXM) company that specializes in the delivery of unique, personalized customer experiences across platforms and devices. For more than 30 years, Fortune 1000 companies and leading nonprofit organizations have partnered with Merkle to maximize the value of their customer portfolios. The company’s heritage in data, technology, and analytics forms the foundation for its unmatched skills in understanding consumer insights that drive hyper-personalized marketing strategies. Its combined strengths in consulting, creative, media, analytics, data, identity, CX/commerce, technology, and loyalty & promotions drive improved marketing results and competitive advantage. With more than 14,000 employees, Merkle is headquartered in Columbia, Maryland, with 50+ additional offices throughout the Americas, EMEA, and APAC. For more information, contact Merkle at