Azure Data Engineer

Job description

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:** Arcadisis looking for an 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, all the way for empowering Arcadians to harnessing power of data and AI/ML for sensors, IIOT and Advanced Drones, the technology teams are Dreaming Big and Delivering on future. **Role accountabilities:** - Collaborating with and across Agile teams to design, develop, test, implement, and support technical solutions in Microsoft Azure Data Platform - Leading and designing solutions on MS Fabric /Azure data platforms - Very strong on database concepts, data modelling, stored procedures, complex query writing, performance optimization of SQL queries. - Mentor peers to gain expertise on Azure data platform solutions skills. - 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 Data Bricks with Python/Scala - Experience in building end to end solution using Azure data analytics platform. - Experience in building Azure data analytics solutions with DevOps (CI/CD) approach. **Qualifications & Experience:** - Bachelor’s degree with 12+ years of relevant professional experience, including at least 8 years of hands-on experience working with Azure Data Platform technologies. - **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. - Good communication and ability to understand 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. We believe that by working together diverse people with different experiences develop the most innovative ideas. Equality, diversity and inclusion is at the heart of how we improve quality of life and we work closely with our people across six ED&I Workstreams: Age, Disability, Faith, Gender, LGBT+ and Race. A diverse and skilled workforce is essential to our success. #LI-SR3