Big Data Engineer, Consultant

Avanade Inc   •  

Chicago, IL

Industry: IT Consulting/Services


Less than 5 years

Posted 291 days ago

This job is no longer available.

Job Description

As part of a Big Data and Analytics project team, the Big Data Engineering Consultant focuses on building big data solutions using Azure cloud services to support data visualization and advanced analytics needs for Avanade clients. This role helps with the design and development big data solutions using Azure PaaS Services.

  • Participate in trainings to gain proficiency with design and development of modern big data and analytics solutions using Azure PaaS Services.
  • Gather and document data requirements as part of the big data and advanced analytics team.
  • Understand business objectives of analyses and document the same
  • Undertake data analysis and collaborate with analytics team to shape data to meet data visualization needs
  • Analyze, design and build Modern data solutions using Azure PaaS service to support visualization of data, including but not limited to
    • Extract, Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL and U-SQL [Azure Data Lake Analytics]
    • Data Ingestion to one or more Azure Services – (Azure Data Lake, Azure Storage, Azure SQL, Azure DW)
  • Profile data and identify data quality issues. Collaborate with project team to identify options to address data quality and make appropriate recommendations
  • Work with our Solution Architects to design big data architecture, develop data models, data shaping logic and validate with tools such as Excel and Power BI.

About you

You are an experienced technology professional with a passion for emerging technologies and a desire to innovate. You can work with cross-functional teams and diverse clients. You have knowledge in the common skills of database development including data models and SQL, report development and business intelligence terminology.

Your background and skills likely include:

  • Demonstrable experience working with database, storage, collection and aggregation models, techniques and technologies, with the ability to apply such methods to solve business problems.
  • Have a basic understanding of modeling and transforming data for reporting & data visualization needs using structured query language (SQL) and .Net programming languages such as VB, C# etc.
  • Experience in structured problem-solving assignments.
  • You enjoy tinkering, solving problems and building creative solutions.

You likely have a Bachelor's Degree in Computer Science, Software Engineering, and/or Information Systems


  • 1+ years' experience as a data analyst and/or engineer responsible for supporting the visualization team by performing analysis, designing and building data & reporting solutions.
  • 1+ years’ experience with writing SQL queries to retrieve and analyze data form a database such as Oracle, SQL Server, MS Access, MySQL.
  • 1+ years’ experience programming languages: C, C++, C#
  • Experience of working with business users to gather, document and prioritize requirements
  • Strong interpersonal and communications skills
  • Experience in structured problem-solving assignments.

Preferred Qualifications:

  • Experience working with dimensional data warehouse is preferred
  • Knowledge of dimensional modelling is preferred
  • Knowledge of Azure (Azure Data Lake, Azure SQL, Azure Data Factory) data management experience is preferred.
  • Experience working with R, Machine Learning, Python, JSON, and XML

Requisition ID - 50939