Dentsu International 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.

Part of Dentsu International, Dentsu Creative is a Global Creative Network that transforms brands and businesses through the power of Modern Creativity. Led by Global Chief Creative Officer Fred Levron, 9,000 experts across the globe work seamlessly together to deliver ideas that Create Culture, Shape Society and Invent the Future. Dentsu Creative was launched in June 2022 to address a client need for simplicity and will be Dentsu International’s sole creative network by the end of 2022.

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.

The Data Engineer candidate must be a dynamic contributor, passionate about platform integration automation and committed to making a difference in an organization filled with smart, creative people. The incumbent will be part of a team responsible for the development and support of various SaaS (Software as a Service) integration solutions (Microsoft Dynamics D365, Salesforce, Workday, Workfront, etc).  We seek a candidate experienced in integrating SaaS based solutions, data transformations, query / database optimization, and consuming web services applications using .Net and other iPaaS (Integration Platform as a Service) solutions. 

Key Responsibilities

• Review Business Requirements to identify ETL requirements and design, develop and test complex integration solutions
• Reverse engineer and understand complex integrations
• Design and develop workflows in Snaplogic or other iPaaS (Integration Platform as a Service) solution a plus
• Design, develop, and support .NET applications to consume web services from our cloud systems
• Working proficiency with Object Oriented Development in C#
• Strong ETL proficiency using MS SQL Server
• Develop and maintain data mappings between source and destination data stores
• Document project specific processes and data flows, data dependencies, data definitions and relevant business rules. Establish data dictionaries to support the buildout of a data governance infrastructure
• Must demonstrate strong problem-solving ability, logic and analytical skills
• Participate in data modelling initiatives
• Perform quality assurance and testing at the unit level
• Ability to manage multiple projects in a fast-paced environment
• Ability to work independently and collaborative with other team members
• Troubleshoots production issues, identifying root cause and implementing sound technical resolutions in a timely manner

Experience: 

• Excellent communication skills
• Over 5 years of experience in Data warehousing and Business Intelligence 
• Strong experience using ADF for data warehousing 
• Integration tool experience in SSIS, SnapLogic, Nintex, etc.
• B.A./B.S. degree (or comparable knowledge) in computer science (or a related field)
• Hands on experience developing and maintain integrations between cloud based services
• 5-10+ years experience C# development
• Experience of different WebAPI protocols including but not limited to SFTP, FTS, HTTP/HTTPS, Web Services, REST endpoints, and other APIs
• Working in a complex matrixed, international, and cross-cultural organization
• Broad technical expertise combined with strong leadership and communication capabilities to drive innovation and change
• Integration experience with financial, sales, and HRIS platforms including D365, Salesforce, ServiceNow, Workfront, and/or Workday a plus

Other key Competencies:

• Strong communications skills and ability to turn business requirements into technical solutions
• Experience in developing data lakes and data warehouses using Microsoft Azure
• Strong database design skills, including an understanding of both normalized form and dimensional form databases.
• In-depth knowledge and experience of data-warehousing strategies and techniques e.g., Kimble Data warehousing 
• Experience in Cloud based data integration tools like Azure Data Factory 
• Experience in Azure Dev Ops or JIRA is a plus
• Familiarity with agile development techniques and objectives

The anticipated salary range for this position is $94,000-146K. Salary is based on a wide range of factors that include relevant experience, knowledge, skills, other job-related qualifications, and geography.  A range of medical, dental, vision, 401(k) matching, paid time off, and/or other benefits also are available. For more information regarding dentsu benefits, please visit https://dentsubenefitsplus.com/.  

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 [email protected] 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.

#LI-AJ1

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 your recruiter 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.