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.
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 www.avanade.com.
Meet Some of Avanade's Employees
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