Azure Data Engineer

2 Hours ago • 7 Years + • $68,000 PA - $110,400 PA

Job Summary

Job Description

The Azure Data Engineer will design and deploy scalable data solutions using Azure technologies like Azure Data Factory, Azure SQL Data Warehouse, Azure Databricks, Power BI, Fabric, and Azure Synapse Analytics. The engineer will create data pipelines, integrations, and transformations for efficient data processing and storage, create dimensional models, perform data profiling and cleansing, conduct unit tests, and review code. The engineer will also identify process improvements, automate manual processes, and collaborate with business analysts and partners.
Must have:
  • 7+ years of experience in Data Warehousing and BI.
  • 5+ years of experience in BI Analyst or Developer roles.
  • 4+ years of experience using Azure Data Factory (ADF).
  • Advanced proficiency in T-SQL and data warehousing principles.
  • Excellent programming skills in SQL and Python.
  • Experience with Azure DevOps & Git for CI/CD pipelines.
  • Knowledge of Azure cloud services and database design.
  • Expertise in database performance analysis and tuning.
  • Experience using Power BI to visualize data for analytics.
Good to have:
  • Experience of data warehousing strategies and techniques.
Perks:
  • Medical, vision, and dental insurance
  • Life insurance
  • Short-term and long-term disability insurance
  • 401k
  • Flexible paid time off
  • At least 15 paid holidays per year
  • Paid sick and safe leave
  • Paid parental leave

Job Details

Job Description:

The Data Engineer is a new role within our Business Platforms Americas team. We are looking for a well-rounded Senior BI Developer with knowledge of SQL, Python, PowerBI, and data warehousing techniques. You will help us 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 digital organization. This is a remote position, reporting to Lead Solutions Architect.

Responsibilities:

  • You will design 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 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.
  • 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).

Additional information

The annual salary range for this position is $68,000 - $110,400. Placement within the salary range is based on a variety of factors, including relevant experience, knowledge, skills, and other factors permitted by law.

Benefits available with this position include:

• Medical, vision, and dental insurance,

• Life insurance,

• Short-term and long-term disability insurance,

• 401k,

• Flexible paid time off,

• At least 15 paid holidays per year,

• Paid sick and safe leave, and

• Paid parental leave.

Dentsu also complies with applicable state and local laws regarding employee leave benefits, including, but not limited to providing time off pursuant to the Colorado Healthy Families and Workplaces Act, in accordance with its plans and policies. For further details regarding Dentsu benefits, please visit www.dentsubenefitsplus.com.

#LI-Remote

#AJ-1

Location:

New York

Brand:

Dentsu

Time Type:

Full time

Contract Type:

Permanent

Dentsu is committed to providing equal employment opportunities to all applicants and employees. We do this without regard to race, color, national origin, sex , sexual orientation, gender identity, age, pregnancy, childbirth or related medical conditions, ancestry, physical or mental disability, marital status, political affiliation, religious practices and observances, citizenship status, genetic information, veteran status, or any other basis protected under applicable federal, state, or local law. 

 

Dentsu is committed to providing reasonable accommodation to, among others, individuals with disabilities and disabled veterans. If you need an accommodation because of a disability to search and apply for a career opportunity with us, please send an e-mail to ApplicantAccommodations@dentsu.com by clicking on the link to let us  know the nature of your accommodation request and your contact information. We are here to support you.  

Similar Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Similar Skill Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Jobs in New York, United States

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Similar Category Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

About The Company

For over 120 years, innovation has been a core tenet of our offering – exploring new ways to reach, engage and nurture relationships with audiences. Together we drive a multiplier effect for clients at a global scale, through the development of Integrated Growth Solutions that are underpinned by our promise to clients: innovating to impact. Read MoreBe a force for good. Sustainability is a vital part of our business and an important area of focus for our clients. We’re leading the way – helping to build a more sustainable planet. Dream loud. In this moment of transformation, we need our people to be fearless, embracing change and ambiguity, driven by the love for their work and excitement for the future. Team without limits. We create opportunities for connection and collaboration between our colleagues and clients, building a sense of belonging and having some fun along the way.

Arizona, United States (Remote)

Toronto, Ontario, Canada (On-Site)

San Francisco, California, United States (On-Site)

New York, United States (Remote)

New York, United States (Remote)

New York, United States (Hybrid)

Montreal, Quebec, Canada (On-Site)

Montreal, Quebec, Canada (On-Site)

Montreal, Quebec, Canada (On-Site)

Auckland, Auckland, New Zealand (Hybrid)

View All Jobs

Get notified when new jobs are added by Dentsu Aegis

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug