Data Management Developer Lead

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 agency’s 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 www.merkleinc.com.

Job Description

Development Tech Leads contribute towards 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.  Development Tech Leads 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 Marketing Technology group.

Responsibilities:

•  Data warehouse architecture and ETL design
•  Build and maintain SQL procedures and ETL processes
•  Manage and mentor a team of developers in a matrix organization
•  Design and implement technical vision for client project
•  Own overall project architecture and technical delivery of solution
•  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
•  Write technical documentation
•  Deliver medium scale data integration solutions on time and on budget
•  Interact with clients
•  Effectively hand off work to developer level resources in the US and offshore
•  Manage and grow other designers and developers in a matrix organization
•  Grow client relationships through high quality work
•  Understand core Merkle marketing technology platforms

Relationships:

The position interacts regularly with a wide range of internal Merkle teams (including Quality Assurance, Campaign Management, Business Intelligence, Information Technology, Developers, Project Managers) to support the development and/or ongoing maintenance of the solution. 

•  Member of the Development Community 
•  Member of designated Capability
•  Member of account/project team(s)

Qualifications

• 4-6+ years' experience with ETL tools such as Talend, Informatica, SSIS and/or DataStage
• 4-6+ years' experience with Microsoft SQL Server, Oracle or other major RDBMS
•  2+ years' experience as a team lead
• Exceptional understanding of ETL concepts, processes, and tools - Talend, Informatica, SSIS, or DataStage
• Significant experience designing and implementing large databases and data warehouses utilizing both relational and dimensional design concepts
• Strong understanding of SQL and database programming
• Strong understanding of file management concepts, processes, and tools - sFTP, PGP Encryption
• Strong understanding of scheduling/automation concepts, processes, and tools
• Strong Knowledge of software engineering and development methodologies, techniques, and tools, including SVN, Issue Tracking (Jira), and Software Development Lifecycle (waterfall, agile)
• Strong understanding of common IT offerings - ex: Operating systems, storage, backups
• Knowledge of programing and/or scripting language such as: Python, Java, Bash, Perl
• Understanding of cloud technologies and/or big data platforms - AWS, GCP, Azure, Hadoop
• 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
• Strong project/task management skills
• 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

Preferred Skills:

•  Experience with cloud technologies AWS, GCP, Azure 
•  Experience with Database Marketing Solutions 
•  Experience with Business Intelligence tools:  Tableau, Power BI, Cognos, Business Objects or Microstrategy
•  Experience with Campaign tool:  Adobe Campaign, Unica, RedPoint  
•  Experience with Customer Data Integration or Master Data Management
•  Technical consulting experience

Additional Information

Dentsu (the "Company") is committed to a policy of Equal Employment Opportunity and will not discriminate against an applicant or employee of the Company, on the basis of age, sex, sexual orientation, race, color, creed, religion, ethnicity, national origin, alienage or citizenship, disability, marital status, veteran or military status, genetic information, or any other legally recognized protected basis under federal, state or local laws, regulations or ordinances. Applicants with disabilities may be entitled to reasonable accommodation under the terms of the Americans with Disabilities Act and/or certain state or local laws. A reasonable accommodation is a change in the way things are normally done that will ensure an equal employment opportunity without imposing an undue hardship on the Company. Please contact recruiting@dentsuaegis.com if you need assistance completing any forms or to otherwise participate in the application process or to request or discuss an accommodation in connection with a job at the Company to which you are applying.

The anticipated salary range for this position is $113,000-$130,000. Salary is based on a range of factors that include relevant experience, knowledge, skills, other job-related qualifications, and geography.  

#LI-DB2

About dentsu 
Dentsu is the network designed for what’s next, helping clients predict and plan for disruptive future opportunities in the sustainable economy. Taking a people-centered approach to business transformation, dentsu combines Japanese innovation with a diverse, global perspective to drive client growth and to shape society www.dentsu.com. 

We are champions for meaningful progress and we strive to be a force for good—for our people, for our clients, for the industry and for our society. We keep our people at the center, creating space for growth, understanding and learning so they can thrive. We embed diversity, in our mindset, in our solutions and in our teams to empower an inclusive, equitable and culturally fluent environment. Building this culture within our teams makes us better collaborators with each other and with our clients, driving better outcomes for all.

Dentsu (the "Company") is committed to a policy of Equal Employment Opportunity and will not discriminate against an applicant or employee of the Company, on the basis of age, sex, sexual orientation, race, color, creed, religion, ethnicity, national origin, alienage or citizenship, disability, marital status, veteran or military status, genetic information, or any other legally-recognized protected basis under federal, state or local laws, regulations or ordinances. Applicants with disabilities may be entitled to reasonable accommodation under the terms of the Americans with Disabilities Act and/or certain state or local laws. A reasonable accommodation is a change in the way things are normally done that will ensure an equal employment opportunity without imposing an undue hardship on the Company. Please contact recruitingops@dentsu.com if you need assistance completing any forms or to otherwise participate in the application process or to request or discuss an accommodation in connection with a job at the Company to which you are applying.