Data Architect, Analytics

Position Title: Data Architect

Our Story

Merkle is a global data-driven, technology-enabled performance marketing agency and the largest independent agency in the US for CRM, digital, and search. For more than 28 years, Fortune 1000 companies and leading nonprofit organizations have partnered with us to build and maximize the value of their customer portfolios. We work with brands like Dell, T-Mobile, Samsung, Geico, Regions, Kimberly-Clark, AARP, Lilly, Sanofi, NBC Universal, DIRECTV, American Cancer Society, Susan G. Komen, and many others to build and execute customer centric business strategies.

Role Purpose

Purpose: Lead the Client in designing scalable solutions for enterprise-wide reporting and analytics.

Duties To Include:

• Leads requirements gathering meetings to translate business requirements into technical specifications
• Designs solutions that may use Adobe Analytics, Google Analytics, WebTrends and other technologies, including Adobe Data Workbench
• Defines the overall analytics / data architecture that feeds into the clients technologies or Analytics technologies including (but not limited to) Adobe Data Workbench
• Ability to focus on automation, process improvement and documenting current environment in a fast paced environment
• Experience with setting-up, configuring, and managing Adobe Data Workbench On-Premise solution
• Effectively translates requirements within Adobe Data Workbench into specific configurations, transformations and dimensions to meet objectives
• Integrate web online and offline data structures within the Adobe Data Workbench platform for additional audience manager/segmentation
• Determine priorities, drive analytics development with effective solutions and manage change
• Works across the clients organization and within Merkle to ensure data models support the analytics needs of the client
• Provides technical and architectural guidance to projects and teams, ensuring that new initiatives enable effective data exploration, reporting, analysis and insights
• Collaborate with key business users to identify needs and opportunities for improved data management and delivery
• Collaborates with other Platform Architects – Analytics to develop reporting solutions as needed
• Provides technical knowledge and business support the team
• Ensures effective communication of client requirements
• Practical knowledge of various processes for stitching together different sets of data (eg. XML, API, etc.)
• Hands-on experience with PERL scripting
• Demonstrated ability with, and knowledge of, regular expressions (writing and reading)

Minimum Requirements:

• 1-2 years experience supporting and implementing solutions within an analyst environment
• Minimum of 2 – 4 years of Architect or Analyst-level experience with Adobe Data Workbench
• Bachelor’s degree in IT or related major
• Experience in the design and building of enterprise data warehouses
• Understanding of data modeling, SQL and ETL
• Experience in multiple database platforms, including SQL Server, Oracle and DB2
• Experience working with end users to gather requirements and build technical solutions from concept to implementation.
• Ability to facilitate meetings and drive solutions
• Available for travel to client location (as needed).