Data Engineering Consultant, NYC

The Data Engineering team uses comprehensive data analytics to support business decisions at Avanade and for Avanade clients. It collects, aggregates and analyzes data from multiple internal and external sources and reports patterns, insights and trends to Avanade decision-makers. Its goal is to support the use of data-driven insights in business performance, opportunities for improvement and identification of root cause problem analysis.

As a Data Engineering Consultant, you will collect, aggregate, store, and reconcile data in support of Avanade business decisions. You will help design and build reporting tools, information dashboards, data generators and other end-user information portals and insight tools. You will be a critical part of the data supply chain, ensuring that stakeholders can access and manipulate data for routine and ad hoc analysis.

Day-to-day, you will:

Support the planning and implementation of data design services, providing sizing and configuration assistance and performing needs assessments, as well as the delivery of data warehouse and storage architectures

Develop and maintain data warehouse schematics, layouts, architectures and relational databases for data storage and data mining

Deliver data to end users using Microsoft SQL Server Reporting Services (SRSS), Microsoft Excel, PowerPivot and Microsoft SharePoint Performance Point

Customize data storage and extraction, data mining, database architecture, metadata and repository creation

Implement effective metrics and monitoring processes

Regional travel as needed. Must within a 60 mile radius of NYC.


About you

You are a data geek and proud of it. You know your way around current database technology and data reporting tools, but you also understand the point of it all—to produce solid insights to drive business decisions. You have a good analytical mind on top of excellent technical skills.

Your skillset likely includes:

Knowledge of database storage, collection and aggregation models, techniques and technologies and the ability to apply such methods to solve business problems.

Knowledge of structured problem-solving assignments

Strong project management and people management skills

Knowledge of Microsoft SharePoint, PowerPivot, SRSS, Excel (with embedded Pivot Tables and macros)

SQL skills, R, Machine Learning, Python preferred

Requisition ID - 46103

Avanade is the leading provider of innovative digital and cloud-enabling services, business solutions and design-led experiences, delivered through the power of people and the Microsoft ecosystem. Majority owned by Accenture, Avanade was founded in 2000 by Accenture LLP and Microsoft Corporation and has 30,000 professionals in 24 countries. Visit us at

Meet Some of Avanade's Employees

Kristin S.

Senior Analyst, Business & Technology Integration

Kristin interprets program requirements between the client and her project team to ensure clear communication and customer satisfaction.

Joshua C.

Manager, Experience Design

Joshua guides and supports Avanade’s junior employees in their paths to create exceptional experience designs for company clients—while also working with clients and stakeholders himself.

Back to top