Azure Data Engineer

Arcadis is the world's leading company delivering sustainable design, engineering, and consultancy solutions for natural and built assets. We are more than 34,000 people, in over 30 countries, dedicated to improving quality of life. Everyone has an important role to play. With the power of many curious minds, together we can solve the world’s most complex challenges and deliver more impact together. Role description: ARCADIS is 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: Bachelor's in Engineering/Math/Statistics/Econometrics or related discipline Should have 9-15 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 experience with Microsoft Fabric: Pipelines, Dataflows 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 optimized data pipelines following best engineering 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, and data reconciliation. Experience working with Fabric notebooks , merging/joining large datasets, 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 everyone's contribution matters. It’s 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. You’ll do meaningful work, and no matter what role, you’ll 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.