Azure Data Engineer

Arcadis is the worlds leading company delivering sustainable design engineering and consultancy solutions for natural and built assets.

We are more than 34000 people in over 30 countries dedicated toimproving quality of life. Everyone has an important role to play. With the power of many curious minds together we can solve the worlds most complex challenges and deliver more impact together.

Role description:

ARCADISis looking for Azure Data Engineer with a passion to drive and execute Digital to the core of everything we do. We firmly believe in Everything Digital Digital Everything. We are transforming we are reimagining the industry and we are reimagining how communities and nations can help become more sustainable places to live for today and future generations.

Technology is the core and integral part of what we do from empowering Arcadians to harnessing the power of data and AI/ML for sensors IIoT and advanced drones. The technology teams are Dreaming Big and Delivering on the future. As part of our Technology drive we are looking for on-board talented and passionate Azure data engineers across multiple locations in North America.

Role accountabilities:

• Possess excellent design and coding skills and a zeal for owning the complete SDLC of building applications in a DevOps environment
• You are excited about working with Azure Data Platform
• challenges while building the next wave of software engineering solutions
• Collaborating with and across Agile teams to design develop test implement and support technical solutions in Microsoft Azure Data Platform
• Leading the craftsmanship security availability resilience and scalability of your solutions
• Very strong on database concepts data modelling stored procedures complex query writing performance optimization of SQL queries.
• Strong experience in
• T-SQL SSIS SSAS SSRS
• Azure Data Factory
• Azure Data Lake Store
• Azure Data Lake Analytics (Good to have not mandatory)
• Azure SQL DB
• Azure SQL DW
• Azure Analysis Services DAX
• Azure Data Bricks with Python/Scala
• Experience in building end to end solution using Azure data analytics platform.
• Experience in building generic framework solution which can be reused for upcoming similar use cases.
• Experience in building Azure data analytics solutions with DevOps (CI/CD) approach.
• Experience in using TFS Azure Repos.
• Mentor peers to gain expertise on Azure data platform solutions skills.
• Experience in developing maintaining publishing and supporting dashboards using Power BI.
• Strong experience in publishing dashboards to Power BI service using Power BI gateways Power BI Report Server & Power BI Embedded

Qualifications & Experience:

Basic Qualifications:

• Bachelors in Engineering/Math/Statistics/Econometrics or related discipline
• Should have 3-8 years of experience in MSBI with relevant hands-on experience in Azure Data Platform (must) for a minimum of 3 years.

Required Skills & Experience

• Intermediate-level hands-on experiencewith Microsoft Fabric:
  PipelinesDataflows Gen2 ADLS Gen2 Notebooks Lakehouse Warehouse Delta tables.
• Expertise in SQL(complex transformations joins across modules optimization indexing strategies).
• Strong hands-on experience in PySpark Delta Lake operations and scalable distributed processing.
• Ability to build scalable and optimizeddatapipelines following bestengineering practices.
• Experience with performance tuning query optimization and pipeline runtime improvement.
• Strong understanding of incremental load vs. full load mechanisms including change detection Delta merge operations surrogate key handling anddatareconciliation.
• Experience working with Fabric notebooks merging/joining largedatasets and handling incremental vs full loads.
• Strong communication skills and the ability to understand the business logic behind systems.

Why Arcadis

We can only achieve our goals when everyone is empowered to be their best. We believe everyones contribution matters. Its why we are pioneering a skills-based approach where you can harness your unique experience and expertise to carve your career path and maximize the impact we can make together.

Youll do meaningful work and no matter what role youll be helping to deliver sustainable solutions for a more prosperous planet. Make your mark on your career your colleagues your clients your life and the world around you.

Together we can create a lasting legacy.

Join Arcadis. Create a Legacy.

Our Commitment to Equality Diversity Inclusion & Belonging

We want you to be able to bring your best self to work every day which is why we take equality and inclusion seriously and hold ourselves to account for our actions. Our ambition is to be an employer of choice and provide a great place to work for all our people.