Consultant, Data Engineering

Avanade Inc   •  

New York, NY

Industry: IT Consulting/Services


Not Specified years

Posted 299 days ago

This job is no longer available.

Job Description

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