Data Delivery Architect

**Data Delivery Architect**

- All Openings

Location: City, Arkansas. Company Description: Merkle is a leading data-driven, technology-enabled, global performance marketing agency 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 agencys heritage in data, technology, and analytics forms the foundation for its unmatched skills in understanding consumer insights that drive people-based marketing strategies. Its combined strengths in performance media, customer experience, customer relationship management, loyalty, and enterprise marketing technology drive improved marketing results and competitive advantage. With 9,600+ employees, Merkle is headquartered in Columbia, Maryland, with 50+ additional offices throughout the US, EMEA, and APAC. In 2016, the agency joined the Dentsu Aegis Network. For more information, contact Merkle at 1-877-9-Merkle or visit .

Job Description: Development Delivery Architects create the overall data integration architecture and design of multi-terabyte marketing solutions that integrate and optimize our client's data across numerous sources. Merkle's solutions enable our clients to better communicate to their customer and prospects across a number of marketing channels and media. Delivery Architects will be immersed in the development and maintenance of marketing database solutions to meet client business objectives. You will have an opportunity to work with a cross-disciplinary team across various divisions of the MS group.

**Key Responsibilities:**

- Lead CRM platform development programs and roadmapData warehouse architecture and ETL design

- Build and maintain SQL procedures and ETL processes

- Manage resource allocaiton and release planning

- Lead and mentor an implementation team in a matrix organization

- Manage hardware infrastructure SLAs, capacity planning, performance and procurement

- Design and implement technical vision for client project

- Own overall project architecture and technical delivery of multiple solutions

- Interact with client on regular basis

- Assist in requirements gathering and data analysis as needed

- Estimate work effort and assist the Project Manager with task planning and LOE (level of effort) estimates

- Provide technical leadership and oversight of a project development team

- Review work product of others for compliance with development standards

- Provide guidance and mentoring in database marketing development best practices

- Conduct design reviews

- Audit existiing platform implementations and recommend enhancements

Qualifications: **You'll have the following to succeed in this role:**

- Bachelor's degree from a four-year college or university in Computer Science or related IT field, or relevant professional experience

- Possess the Merkle attributes of being smart, curious, committed to vision, passionate, fun/pleasant, an achiever, and having a sense of urgency

- Ability to be a team player

**Skills**:

- Exceptional understanding of ETL concepts, processes, and tools - Talend, Informatica, SSIS, or DataStage

- Exceptional understanding of relational and dimensional database concepts

- Strong understanding of SQL and database programming

- Strong understanding of file management concepts, processes, and tools - sFTP, PGP Encryption, Sterling

- Strong understanding of scheduling/automation concepts, processes, and tools - Tidal

- Strong understanding of common IT offerings - e.g. Operating systems, storage, backups

- Strong understanding of database platforms - SQL Server, Netezza, Oracle, BigQuery, Snowflake

- Understanding of cloud technologies and/or big data platforms - AWS, GCP, Azure, Hadoop

- Strong knowledge of software engineering and development methodologies, techniques, and tools, including SVN, Issue Tracking (Jira), and Software Development Lifecycle (waterfall, agile)

- Ability to serve as technical point of contact for the solution both internally to Merkle and in interactions directly with the client

- Ability to hand off work to other development resources - both US and off shore

- Excellent communication skills - both verbal and written

- Ability to present, both verbal and written, to team members, capability members, portfolio members, and clients at the appropriate technological level

- Working knowledge of at least one BI tool, such as Tableau, Cognos, Business Objects or Microstrategy. Experience with a campaign tool, such as Adobe Campaign, Unica, Alterian

**Experience**:

- 6-8+ years experience with ETL tool(s) - Talend, Informatica, SSIS, DataStage

- 6-8+ years experience with Microsoft SQL Server, Oracle or other major RDBMS

- 10+ years experience leading CRM solution implementations

- 5+ years leading multi-functional development teams

- Experience with Customer Data Integration or Master Data Management preferred

- Experience in database marketing preferred

- Experience with cloud technologies AWS, GCP, Azure and/or Hadoop is a preferred

- Significant experience designing and implementing large databases and data warehouses utilizing both relational and dimensional design concepts

- Technical consulting experience a plus

- Well-versed in the CRM technology and tools landscape

- Strong willed, creative thinker with history of strong problem solving

- Articulate, effective communication skills with both technical and business audiences

Additional Information: At Merkle, we believe that a diverse environment improves us as a community and as a business. We want to foster an environment of growth, where all ideas and contributions are encouraged. We need this culture of courage to continue to thrive in our fast-paced industry. We embrace differences of opinion. We value diversity of experience and thought, which help us to challenge and define industry-leading solutions, and support our goal of being a great place to work.

Merklefosters a diverse environment that encourages original thinking about our business and empowers us to communicate with a global world of customers. We embrace differences of opinion and diversity of thought as they help us challenge and refine our solutions. Merkle, as a best-in-class marketing agency, welcomes big ideas, and believes they can come from anywhere.

All your information will be kept confidential according to EEO guidelines.

#LI-SP1