Data Engineer - BI Developer

Raleigh, NC, United States

Applications have closed

dentsu international

At dentsu, innovation is our strength, and your growth is our mission. We help you keep up with technological changes in the digital economy.

View company page

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.

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.

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 MS SQL, PowerBI, and data warehousing techniques. This is a unique opportunity to be involved in delivering leading-edge business analytics using the latest and greatest cutting-edge BI tools, such as cloud-based databases, self-service analytics and leading visualization tools enabling the company’s aim to become a fully digital organization.

Key Responsibilities

  • Collaborate with the BI Dev team members to evaluate, design, develop BI reports and dashboards according to functional specifications while maintaining data integrity and data quality
  • Deliver Technical Design Document capturing specific processes and data flows, data definitions and relevant business rules  
  • Apply best practices of data integration for data quality and automation 
  • Work with business analysts to understand business requirements and use cases to write and assign technical stories and tasks 
  • Work independently within guidelines, responsible for initiating, planning, executing, controlling, and implementation of projects using a formal project management and agile methodology 
  • Work collaboratively with key stakeholders to translate business information needs into well-defined data requirements to implement the BI solutions 
  • Work with team to provide support for existing analytics and PowerBI reporting platforms
  • Coaching, mentoring, and providing technical direction and training to other IT personnel 
  • Working with BI & Analytic teams to develop and establish BI road Map/Vision

Qualifications

Experience: 

  • Excellent communication skills
  • Over 7-10 years of experience in Data warehousing and Business Intelligence 
  • Over 5 years’ experience in a Business Intelligence Analyst or Developer roles
  • Over 4 years’ experience using ADF for data warehousing 
  • Experience in designing and performance tuning data warehouses and data lakes.
  • 2+ years experience in developing data models and dashboards using Power BI within an IT department
  • Being delivery-focused with a can-do attitude in a sometimes-challenging environment is essential.
  • Experience using Power BI to visualize data held in SQL Server
  • Experience working with finance data highly desirable

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
  • Demonstrable experience designing high-quality dashboards using Power BI
  • 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 power bi data modelling and DAX is preferred
  • Experience in Azure Dev Ops or JIRA is a plus
  • Familiarity with agile development techniques and objectives

Additional Information

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

 

#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. 

Tags: Agile Azure Business Analytics Business Intelligence Data quality Data Warehousing Finance Jira MS SQL Power BI SQL

Perks/benefits: Career development Health care Startup environment

Region: North America
Country: United States
Job stats:  9  0  0

More jobs like this

Explore more AI, ML, Data Science career opportunities

Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.