About the role

The Data Engineering team supports business decisions at Avanade and for Avanade clients through comprehensive data analysis. It collects, aggregates and analyzes data from multiple internal and external sources and reports patterns, insights and trends to Avanade decision-makers. Its goal is to support data-driven insights into business performance, opportunities for improvement and identification of root cause problem analysis.

As a Data Engineering Analyst, you will collect, aggregate, store and reconcile data in support of Avanade business decisions. You will help design and build reporting tools, information dashboards, data generators and other end-user information portals and insight tools. You will be a critical part of the data supply chain, ensuring that stakeholders can access and manipulate data for routine and ad hoc analysis.

Day-to-day, you will:

• Plan and deliver data warehouse and storage architectures
• Support the planning and implementation of data design services, providing sizing and configuration assistance and performing needs assessments
• Develop and maintain data warehouse schematics, layouts, architectures and relational databases for data storage and data mining
• Deliver data to end users using Microsoft SQL Server Reporting Services (SSRS), Microsoft Excel, PowerPivot and Microsoft SharePoint Performance Point
• Customize data storage and extraction, data mining, database architecture, metadata and repository creation
• Implement effective metrics and monitoring processes
• Travel as needed.

About you

You have a good analytical mind on top of excellent technical skills. You are familiar with current database technology and data reporting tools, and more importantly, you understand the point of it all—to produce solid insights to drive business decisions.

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 structured problem-solving assignments
• Strong project management and people management skills
• Knowledge of Microsoft SharePoint, PowerPivot, SSRS, Excel (with embedded Pivot Tables and macros)
• Some SQL skills.
• Professional Skills:
• Strong business acumen
• Excellent interpersonal skills - "Customer Focus" Excellent communication skills, both written and oral
• Passion for learning
• Strong time management skills
• Willingness to travel (80%) of the work week
• Ability to excel in a team oriented, project based work
• Demonstrated leadership experience in an academic, extracurricular or professional setting
• Previous work, internship or co-op experience, preferably with customer-facing responsibilities
• Strong critical thinking skills, and the ability to think on your feet
• Ability to learn in a fast-paced environment

Minimum technical requirements

• Major GPA of a 3.0 or above. Cumulative GPA of 2.8 or above (3.0 or above highly desired).
• Experience with at least one key analytics tools (e.g., R, Revolution R, SAS, SPSS, MATLAB, MicroStrategy, Tableau)
• Knowledgeable of data mining, analysis, modeling, of large scale, complex data sets
• Knowledgeable of statistical analysis, quantitative analytics, forecasting/predictive analytics, multivariate testing (A/B testing), and optimization algorithms
• Capable of explaining complex analytical methodologies and concepts in non-technical language
• Years of Experience: 0-3 years experience
• Education: Bachelor's Degree in Computer Science, Computer Engineering, MIS or related field

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.

Think you can do more with Microsoft? So do we.

We believe in making a genuine human impact in everything we do. We transform businesses, uncover ways technology can improve the way we work and live, and change the world for the better. All this through the power of our people and cutting-edge Microsoft technology. If you want to build your skills, gain unrivaled experience and become the best at what you do, there’s no place better.

Opportunity is everywhere. We’ll help you find it.