Avanade Inc. Consultant, Data Engineering, Minneapolis/Chicago in Minneapolis, Minnesota

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

Qualifications

  • 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 - 52757

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.

Category: Analytics

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.

The EEO is the Law poster is available here:

http://www1.eeoc.gov/employers/upload/eeocselfprint_poster.pdf

and here:

http://www.dol.gov/ofccp/regs/compliance/posters/pdf/OFCCPEEOSupplementFinalJRFQA508c.pdf.

The Pay Transparency Policy is available here:

http://www.dol.gov/ofccp/pdf/EO13665PrescribedNondiscriminationPostingLanguageJRFQA508c.pdf.

Avanade is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation due to a disability for any part of the employment process, please send an e-mail to Avanade at careers@avanade.com or call (206) 239-5610 and let us know the nature of your request and your contact information.

By using this site, you agree that we can place Cookies on your device. See our Job Applicant Data Privacy Statement and Cookies statement.