Lead SQL/ETL Database Developer

Company Description

Dentsu is a modern marketing solutions company. Our mission is to help clients navigate, progress and thrive in a world of change. Businesses rely on our integrated network of agencies and specialized practices to champion meaningful progress through creative, media, commerce, data and technology. Part of Dentsu Group, our global network comprises 66,000 diverse people in 143 countries, who are dedicated to teaming for growth and good. Some of our award-winning agencies include 360i, Carat, dentsumcgarrybowen, DEG, dentsuX, iProspect and Merkle. Follow us on Twitter @DentsuUSA and visit dentsu.com/us.

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.

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,00-$174,500. Salary is based on a range of factors that include relevant experience, knowledge, skills, other job-related qualifications, and geography.  

#LI-TE1

About dentsu international

Part of Dentsu Group, Dentsu International is a network designed for what’s next, helping clients predict and plan for disruptive future opportunities and create new paths to growth in the sustainable economy. Dentsu delivers people-focused solutions and services to drive better business and societal outcomes. This is delivered through five global leadership brands - Carat, Dentsu Creative, dentsu X, iProspect and Merkle, each with deep specialisms.

Dentsu International’s radically collaborative team of diverse creators unifies people, clients and capabilities through horizontal creativity to help clients create culture, change society, and invent the future.

Powered by 100% renewable energy, Dentsu International operates in over 145 markets worldwide with more than 46,000 dedicated specialists, and partners with 95 of the top 100 global advertisers.
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 dentsurecruiting@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.