Data Engineer

Company Description

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.

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

The Data Engineer is a new key role within the Business Platforms Americas team. We are looking for a well-rounded Senior BI Developer expertise with strong knowledge of SQL, Python, PowerBI, and data warehousing techniques. You will help deliver leading-edge business analytics using the latest and greatest BI tools, such as cloud-based databases, self-service analytics and leading visualization tools allowing our aim to become a fully digital organization. This is a remote position, reporting to Lead Solutions Architect.  

Responsibilities:

• You will design, develop, and deploy scalable data solutions using Azure technologies such as Azure Data Factory, Azure SQL Data Warehouse, Azure Databricks, Power BI, Fabric, and Azure Synapse Analytics.
• You will create and maintain data pipelines, integrations, and transformations to ensure efficient data processing, storage, and retrieval.
• You will conduct complex business transformations to create dimensional models that serve as a foundation for analytical reporting by the analytics team.  
• You will perform data profiling, validation, and cleansing to maintain data integrity and accuracy.
• You will perform unit test and conduct reviews with other team members to ensure code is rigorously designed, elegantly coded, and tuned for performance.
• You will identify internal process improvements: automate manual processes, debug inefficient pipelines, and redesign infrastructure for performance and scalability.
• You will deliver Technical Design Documents that outline processes, data …