Consultant, Data Engineering - New York City

The Analytics talent community at Avanade is responsible for designing and developing analytics solutions for our clients. From infrastructure to architecture to engineering to end-user reporting and collaboration, our team enables organizations to make use of data-driven insights to understand context, make better decisions, and ultimately realize direct value from their data assets.

As an Analytics Architecture Consultant, you will work on client solutions involving the design, planning, development, and support of enterprise-grade analytics infrastructure and architecture. You will help gather requirements, conduct proofs of concept and pilots, engineer and deploy solutions, and provide support and training to our clients. You will also serve in an advisory capacity to our clients, providing thought leadership and best practices on modern analytics architectures, data strategy, and digital transformation.

Day-to-day, you will:

Gather client requirements and deliver logical and physical solution architectures, following industry best practices

Understand business objectives, and maintain a focus on business outcomes

Establish governance protocols, support systems, and training materials to support solutions within clients' internal BI and Analytics organizations

Conduct proofs of concept and technologies to educate clients and assess their needs

Develop data storage and modeling solutions using tools such as SQL Server, Azure SQL Data Warehouse, Azure Data Lake, and Hadoop

Engineer data pipelines using ETL tools including SSIS, Azure Data Factory, U-SQL, and Polybase

Profile data, understand and improve data quality, and bring best practices in data management to our clients

Support complex event processing, streaming, and IoT client solutions using tools such as Azure Event Hubs and Azure IoT Hub, Azure Streaming Analytics, and Azure Functions

Deliver data to end user experiences using tools such as SQL Server Analysis Services, Microsoft PowerBI, and downstream applications and REST Services

Travel as needed.

About you

You are a problem solver and you believe in data's power to enable better decision making. You know your way around current database technology and data reporting tools, and you like to experiment with new technologies to see what new capabilities they unlock. 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 best practices in data infrastructure, modeling, integration, warehousing, performance optimization, security, governance, and analytics

Knowledge of using the SQL Server platform

Knowledge of Azure Data Platform services and capabilities

Knowledge of IoT data architectures

Knowledge of Big Data technologies such as Hadoop, Spark, Storm, and Hive

Strong interpersonal, teamworking and communications skills

Avanade® Is An Equal Opportunity Employer. Avanade prohibits discrimination and harassment against any employee or applicant for employment because of race, color, age, religion, sex, national origin, gender identity or expression, sexual orientation, disability, veteran, military or marital status, genetic information or any other protected status.

Requisition ID - 50994

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

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.

Beth H.

Executive, Delivery Management

Beth oversees all delivery projects within a region for Avanade, ensuring that project teams have the tools and resources they need to achieve total client satisfaction.

Back to top