Azure Data Engineer

About the position

Skanska is searching for a dynamic Azure Data Engineer. This is a great opportunity to start a career with a company that builds things that matter and values its team. We are proud to share our culture of diversity and inclusion. This is a hybrid role, requiring a minimum of two days in-person at the Charlotte, North Carolina or Durham, NC office. Our work makes a clear contribution to society and the environment around us. We build in many different verticals. Whether we are building schools to provide inspiring spaces for learning, roads to connect communities, or hospitals to care for patients, it all contributes to our purpose - we build for a better society. Skanska's values -Be Better Together, Act Ethically and Transparently, Commit to Customer, and Care for Life-are deeply engrained in how we work, which is why our values support and drive our D&I efforts. The Data Engineer will help build, optimize, and maintain data pipelines that support our data analytics and business intelligence initiatives. Data Engineers design, develop, and maintain scalable ETL/ELT pipelines using Azure Data Factory (ADF), SSIS, and other Azure services (Azure Data Lake, Azure SQL Database, etc.). They optimize SQL queries and ensure effective data storage, performance and retrieval strategies. Data Engineers are also responsible for automating data integration processes, including data cleansing, transformation, and loading across systems.

Responsibilities

• Build, optimize, and maintain data pipelines that support data analytics and business intelligence initiatives.
• Design, develop, and maintain scalable ETL/ELT pipelines using Azure Data Factory (ADF), SSIS, and other Azure services.
• Optimize SQL queries and ensure effective data storage, performance, and retrieval strategies.
• Automate data integration processes, including data cleansing, transformation, and loading across systems.

Requirements

• 3+ years of hands-on experience in data engineering or related roles with a focus on Azure Cloud technologies.
• 1+ years experience with data modeling, schema design, and best practices for relational, NoSQL, and data warehouse technologies in Azure.
• Advanced level of experience with SQL queries from scratch with good understanding of RDBMS concepts to optimize queries as per requirements.
• 1+ years of experience in Microsoft Azure, including key components like Azure Data Lake, Azure Data Factory, Azure Blob Storage, Azure Synapse and Azure SQL.
• Demonstrated experience designing, developing, migrating, and maintaining scalable data pipelines and ETL/ELT processes in SSIS and Azure Data Factory, and utilizing Azure data and analytics resources.
• Bachelor's Degree - Computer Science, Data Engineering, or a related field; or equivalent experience and minimum 7 years prior relevant experience.

Benefits

• Medical, dental, and vision insurance plans.
• Expert guidance and always-on tools personalized to meet needs.
• Competitive base salary and excellent bonus program.
• 401k and Employee ownership program.
• Support for whole health and peace of mind through inclusive and personalized total rewards.
• Career growth and development opportunities.