Skip to main contentA logo with &quat;the muse&quat; in dark blue text.
Avanade

Consultant, Data Engineering (Chicago)

About the role

The Analytics Consultant focuses on building impactful data visualization and solutions to support business decisions at Avanade and for Avanade clients. Its goal is to support the use of data-driven insights in business performance, opportunities for improvement and identification of root cause problem analysis.

Day-to-day, you will:

  • Gather requirements for business analysis from end users and document the same.
  • Understand business objectives of analyses and document the same
  • Rationalize and Identify use cases for developing data visualization, including identifying different personas for each use case
  • Undertake data analysis and collaborate with analytics team to shape data to meet data visualization needs
  • Profile data and identify data quality issues. Collaborate with project team to identify options to address data quality and make appropriate recommendations
  • Develop data models, data shaping logic and data visualizations using Excel, PowerPivot, Power BI
  • Use PowerBI, Excel, Power Query and DAX to develop Power BI Models/Solutions.
  • Publish and support roll out of Power BI and Excel solutions as part of project deliverables
  • Travel to client location as needed.

Want more jobs like this?

Get Software Engineer jobs delivered to your inbox every week.

By signing up, you agree to our Terms of Service & Privacy Policy.

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 T-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.
  • Experience working with statistical and data visualization tools and techniques.
  • Experience in structured problem solving assignments.
  • Experience working with PowerBI or Tableau and Excel

You likely have a Bachelor's Degree in Mathematics, Statistics, Economics with a passion for analyzing data to delivery business insights.

About Avanade

Avanade leads in providing innovative digital services, business solutions and design-led experiences for its clients, delivered through the power of people and the Microsoft ecosystem. Our professionals combine technology, business and industry expertise to build and deploy solutions to realize results for clients and their customers. Avanade has 29,000 digitally connected people across 23 countries, bringing clients the best thinking through a collaborative culture that honors diversity and reflects the communities in which we operate. We welcome all, and seek talented individuals who can bring their whole self to work, build inclusive teams and encourage diversity inside and outside the organization. Majority owned by Accenture, Avanade was founded in 2000 by Accenture LLP and Microsoft Corporation. Learn more at www.avanade.com

Qualifications

  • 1+ years' experience as a business / data analyst responsible for supporting business functions by performing analysis to prepare insights, reports and dashboards
  • In depth experience with Excel and creating reports/dashboards using Excel Pivot tables
  • Experience of working with business users & leaders to gather, document and prioritize requirements
  • Demonstrated ability to analyze data to gather insights to solve business problems and/or identify business opportunities
  • Ability to establish rapport within the business community
  • Strong interpersonal and communications skills
  • Experience working with statistical and data visualization tools and techniques.
  • Experience in structured problem solving assignments.

Preferred Qualification:

  • Building data visualizations using a business intelligence tool such Tableau, QlikView, PowerBI, Cognos, SAS
  • Developing solution using PowerPivot for Excel including writing DAX calculations.
  • Writing SQL queries to retrieve and analyze data form a database such as Oracle, SQL Server, MS Access, MySQL.

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 - 46288

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.

Job ID: a40c2d7f7b683270505d52320aa459f6
Employment Type: Other

Perks and Benefits

  • Health and Wellness

    • Health Insurance
    • Dental Insurance
    • Vision Insurance
    • Life Insurance
  • Work Flexibility

    • Flexible Work Hours
    • Remote Work Opportunities
    • Hybrid Work Opportunities
  • Office Life and Perks

    • Happy Hours
    • Snacks
    • Holiday Events
  • Vacation and Time Off

    • Paid Vacation
    • Paid Holidays
    • Personal/Sick Days
    • Volunteer Time Off
  • Financial and Retirement

    • 401(K) With Company Matching
    • Stock Purchase Program
  • Professional Development

    • Leadership Training Program
    • Mentor Program
  • Diversity and Inclusion

    • Woman founded/led
    • Black founded/led
    • Latinx founded/led
    • Asian founded/led
    • LGBTQ+ founded/led
    • Employee Resource Groups (ERG)
    • Diversity, Equity, and Inclusion Program

This job is no longer available.

Search all jobs