Data Architect

Company Description

About Merkle

Merkle, a Dentsu company, is a leading data-driven customer experience management (CXM) company that specializes in delivering unique, personalized customer experiences across platforms and devices. For more than 30 years, Fortune 1000 companies and leading non-profit 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 unparalleled 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 over 14,000 employees, Merkle is headquartered in Columbia, Maryland, with more than 50 additional offices throughout the Americas, EMEA, and APAC. For more information, contact Merkle at
1-877-9-Merkle or visit .

Job Description

Key Responsibilities:

Roles & Responsibilities

• Ability to design simple to medium data solutions for clients using cloud architecture with AWS/Azure
• Understanding of DW, data mart, data modeling, data structures, databases, and data ingestion and transformation.
• Understanding of ETL as well as database skills
• Understanding of data modeling, data structures, databases, and ETL processes
• 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
• Document project architecture, explain detailed design to team and create low to high level designs
• Perform mid to complex level tasks independently
• Support Client, Data Scientists and Analytical Consultants working on marketing solutions
• 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 include code review, deployment

Qualifications

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

Additional Information

Job timing : 5:00 PM to 2:00 AM IST