Area of expertise:


Job Description

As an Analytics Power BI Lead, you will design and develop interactive and automated experiences using data and analytics tools and processes. Using emerging and established technologies, the Analytics Experience Consultant will consider and design for both business-driven requirements and optimized and scalable solutions to highlight insights discovered from data. Additionally, this role will play a meaningful role in enabling data discovery of core issues, trends, expected and actual outcomes for humans and machines consuming the data.

Be able to work in a hands-on role & guide high level initiatives and guide the team on all best practices related to PowerBI, including Data Modeling, Data Warehousing, Report Design, the PBI Tenant, external pbi tools & have a general understanding of the Azure stack.

Experience: 7-12 years overall experience and at least 5-7 years working as Dashboards and Reports developer using Power BI or equivalent BI tool 

Skills: Azure Data Platform tools, SQL, Power BI components, Analysis services  

Key Responsibilities / Skills: 

·       Understand business requirements in BI context and design data models to transform raw data into meaningful insights.

·       Demonstrable professional experience with data mining, analysis, modeling, of large scale, complex data sets that aid decision making.

·       Identify key performance indicators (KPIs) with clear objectives and consistently monitor those

·       Design and deliver enterprise level reporting and data governance solutions.

·       Convert business requirements into technical specifications and decide timeline to accomplish.

·       Create relationships between data and develop tabular and other multidimensional data models.

·       Chart creation and data documentation explaining algorithms, parameters, models, and relations.

·       Design, develop, test, and deploy Power BI scripts and perform detailed analytics.

·       Perform DAX queries and functions in Power BI

·       Analyze current ETL process, define and design new systems.

·       Redefine and make technical/strategic changes to enhance existing Business Intelligence systems.

·       Create customize charts and custom calculations as per requirements.

·       Work with users and team members at all levels for performance improvement and suggestions

Job Requirements: 

·       Masters/Bachelor’s in computer science/Engineering, Business Analytics, Information System, or other related disciplines.  

·       Proficiency in designing and delivering enterprise level reporting and data governance solutions.

·       In-depth knowledge and technical experience building visuals using data tools like Power B a

·       Advanced proficiency with SQL for the generation and extraction of data for use in analytics and reporting.

·       Proficient in Power BI components, Azure Data Platform  

·       Interpret results using a variety of techniques, ranging from simple exploratory data analysis to statistical modeling.

·       Excellent communication, relationship skills and a strong team player. 

·       Client consulting and project-leadership experience working with third-party clients preferred

·       In-depth knowledge of Data Warehousing & Data Modeling best practices

·       Experience with Version Control tools like Azure Dev Ops

·       Experience implementing data security with RLS & OLS

·       Experience with Power BI Admin APIs

·       Good to have: 

o   Understanding of statistical modelling, machine learning, or data mining, text mining concepts and a track record of solving problems with these methods. 

o   Experienced in big data techniques (such as Hadoop, MapReduce, Hive, Pig, Spark) is a plus. 

Preferred Certifications

·       PL-300: Microsoft Power BI Data Analyst

·       DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI

What we offer you
Come for the distinctive experiences you have helping forward-thinking corporations, non-profits, and governments push the boundaries of digital innovation. Stay for the limitless learning opportunities that encourage you to master Microsoft and pursue big ideas. Enjoy ambitious growth for yourself as part of Avanade’s people-first culture with benefits like employee share purchasing, flexible work arrangements, a commitment to diversity and inclusion, and competitive pay.
Apply now

Share this job:

Share Facebook Twitter

About Avanade

Avanade is the leading provider of innovative digital, cloud and advisory services, industry solutions and design-led experiences across the Microsoft ecosystem. Every day, our 59,000 professionals in 26 countries make a genuine human impact for our clients, their employees and their customers. 

We have been recognized as Microsoft’s Global SI Partner of the Year more than any other company. With the most Microsoft certifications (60,000+) and 18 (out of 18) Gold-level Microsoft competencies, we are uniquely positioned to help businesses grow and solve their toughest challenges.

We are a people first company, committed to providing an inclusive workplace where employees feel comfortable being their authentic selves. As a responsible business, we are building a sustainable world and helping people from underrepresented communities fulfil their potential. 

Majority owned by Accenture, Avanade was founded in 2000 by Accenture LLP and Microsoft Corporation. Learn more at