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.

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 flows, definitions, and business rules.
• You will collaborate with business analysts to understand requirements and use cases, translating them into technical stories and tasks.
• You will collaborate with partners to define data requirements and implement BI solutions.

Qualifications

• 7+ years of experience in Data Warehousing and Business Intelligence roles.
• 5+ years of experience in Business Intelligence Analyst or Developer roles.
• 4+ years of experience using Azure Data Factory (ADF) for data warehousing.
• 2+ years of experience developing data models and dashboards using Power BI within an IT department.
• Advanced proficiency in T-SQL, Azure Data Factory (ADF) Pipelines, SSIS packages, relational database design, data modelling, and data warehousing principles.
• Excellent programming skills in SQL, PL/SQL, Python etc.
• Demonstrated experience using and configuring Azure DevOps & Git for integrating cloud services and establishing CI/CD pipelines.
• Knowledge of Azure cloud services, relational database design principles, data warehousing, performance tuning, and optimization techniques.
• Expertise in performance analysis and tuning to ensure database performance.
• Ability to collaborate with developers and partners to gather and refine requirements.
• Experience using Power BI to visualize data for analytics.

• Experience of data warehousing strategies and techniques (e.g., Kimball Data Warehousing).
• Experience working with finance data is highly desirable.
• Experience in Py Spark, Onelake & Snaplogic is a plus.
• Familiarity with agile development techniques and objectives.

The anticipated salary range for this position is $68,000 - $110,400. Actual salary will be based on a variety of factors including relevant experience, knowledge, skills and other factors permitted by law. 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 dentsubenefitsplus.com

#LI-Remote

About dentsu
Dentsu is an integrated growth and transformation partner to the world’s leading organizations. Founded in 1901 in Tokyo, Japan, and now present in over 145 countries and regions, it has a proven track record of nurturing and developing innovations, combining the talents of its global network of leadership brands to develop impactful and integrated growth solutions for clients. Dentsu delivers end-to-end experience transformation (EX) by integrating its services across Media, CXM and Creative, while its business transformation (BX) mindset pushes the boundaries of transformation and sustainable growth for brands, people and society.

Dentsu, Innovating to Impact.

Find out more:
https://www.dentsu.com/
https://www.group.dentsu.com/en/

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.