Azure Data Engineer

Avanade • Chicago, IL

2d

About The Position

Avanade Inc. seeks Azure Data Engineers in Chicago, Illinois, to deliver analytics and data engineering solutions to clients. The role involves designing and setting up projects that combine information from multiple sources to support analysis and decision-making, and planning and delivering data warehouse and storage solutions. The engineer will design, develop, adapt, and maintain data warehouse architecture and relational databases; customize storage, extraction, metadata, and information repositories; and create the building blocks for enterprise data solutions.

The position also includes designing and running project-specific data services, building modern data pipelines, data streams, and data service APIs, and creating and maintaining report formats, dashboards, reports, information portals, and other resources. The engineer will establish metrics and monitoring processes, monitor key performance indicators, and identify opportunities to improve operations and causes of problems. Periodic domestic travel to client sites is expected up to 60% of the time. The employee must live within reasonable commuting distance of Chicago, Illinois.

Requirements

• Bachelor’s degree, or foreign equivalent, in Computer Science, Mechanical Engineering, Applied Mathematics, Statistics, Machine Learning, or a closely related field.
• At least 5 years of experience as an Azure Data Engineer or in a similar role in a technology or consulting environment.
• At least 5 years of experience performing data engineering, warehousing, publishing, and visualization throughout the full data lifecycle.
• At least 3 years of experience performing data profiling, cataloguing, and mapping to enable the design and build of technical data flows.
• At least 3 years of experience defining ETL architecture and ETL process design.
• At least 3 years of experience performing end-to-end implementation of data warehousing analytics solutions built on Microsoft or Azure platforms.
• At least 4 years of experience working with Azure.
• At least 3 years of experience using DPM-specific tooling, including Spark, Python, Databricks, Azure Synapse, SQL Server, Azure Data Lake, and/or Azure Data Factory (ADF).
• Must live within reasonable commuting distance of Chicago, Illinois.

Responsibilities

• Design and set up projects that bring together information from a variety of sources for analysis and decision-making.
• Plan and deliver data warehouse and storage solutions.
• Participate in designing and running bespoke data services for individual projects.
• Design, develop, adapt, and maintain data warehouse architecture and relational databases to support data mining.
• Customize storage and extraction, metadata, and information repositories.
• Create and use effective metrics and monitoring processes.
• Monitor key performance indicators to identify where operations can be improved and determine causes of problems.
• Create building blocks for transforming enterprise data solutions.
• Design and build modern data pipelines, data streams, and data service APIs.
• Create and maintain report forms and formats, information dashboards, reports, and other information portals and resources.
• Travel periodically to domestic client sites, up to 60% of the time.

Benefits

• Medical coverage
• Dental coverage
• Vision coverage
• Life insurance
• Long-term disability coverage
• 401(k) plan
• Bonus opportunities
• Paid holidays
• Paid time off

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level