BI Engineering Senior Analyst

 About The Role  

Skill required: Data Management - Microsoft Power Business Intelligence (BI)

Designation: BI Engineering Senior Analyst

Qualifications:BE/BTech

Years of Experience:5 to 8 years
Accenture is a global professional services company with leading capabilities in digital, cloud and security.Combining unmatched experience and specialized skills across more than 40 industries, we offer Strategy and Consulting, Technology and Operations services, and Accenture Song"” all powered by the world's largest network of Advanced Technology and Intelligent Operations centers. Our 699,000 people deliver on the promise of technology and human ingenuity every day, serving clients in more than 120 countries. We embrace the power of change to create value and shared success for our clients, people, shareholders, partners and communities.Visit us at www.accenture.com
What would you do? Accenture is a global professional services company with leading capabilities in digital, cloud and security. Combining unmatched experience and specialized skills across more than 40 industries, we offer Strategy and Consulting, Technology and Operations services, and Accenture Song"” all powered by the world's largest network of Advanced Technology and Intelligent Operations centers. Our 699,000 people deliver on the promise of technology and human ingenuity every day, serving clients in more than 120 countries. We embrace the power of change to create value and shared success for our clients, people, shareholders, partners and communities. Visit us at www.accenture.com.We are looking for a Reporting Sr. Analyst who specialize in gathering and analyzing data, preparing report by understanding the right representation technique for a given data set, create and implement process improvements throughout the reporting process. He/she will be liaising with business and technology teams to generate the reports. Expertise in Power BI is expected from the potential candidate.Experience developing reports and dashboard with - Microsoft Power BI. Working experience in commercial & regulatory reporting- Experience with connecting multiple data sources in Power BI to implement working reports- Advanced SQL writing skills, strong understanding of relational and dimensional data models - Extensive knowledge in various reporting objects and it include Facts, Attributes, Hierarchies and Transformations.

What are we looking for?

1+ years of experience for the desired candidate who need to be excellent in writing DAX in MS Power BI Desktop

Need to have experience in creating calculated measures and columns with DAX in MS Power BI Desktop

Strong domain knowledge in Retail Industry domain

Excellent communication and inter-personal skills, accustomed to work in a team environment with tight schedules and capable of working efficiently under pressure. Do POCs to showcase the capabilities of Microsoft Power BI to customer

Very strong SQL skills in at least one DB technology i.e. Teradata or any other database like Oracle, UDB. Teradata skills are preferred

Understanding of ETL process- good database knowledge and experience, should be able to write complex SQL queries

Good hands-on Azure Stack – Azure SQL Datawarehouse, Azure Data Factory (ADF), Azure Analysis Services (AAS)

Roles and Responsibilities:

Minimum overall 4-6 years of experience in leading Analytics projects for large Retail clients

Experience in creating dashboards, volume reports, operating summaries, and presentations and graphs

SSRS Integration to Power BI

Power BI, to create dashboards and reports using Power BI Desktop

Good Knowledge of DAX, Creating Calculated Columns, Measures and Calculated Tables

Using DAX in data modelling and be able to write complex DAX queries

Scheduled Refreshing using Power BI Gateway

DAX functions (Aggregation, Filter, Time Intelligence, Data & Time, Logical, Statistical)

Creating Tables, Stored Procedures, View and User Defined Functions as per business

Good knowledge on MS Excel and analyzing data on it. Also have good hands-on power pivot, Power query

Working in Agile methodology

Experience in Data Gateway for data refreshing, content Pack Library

Expert in publishing reports to app.powerbi.com and setting up the necessary connection details and scheduling

Excellent knowledge connecting Microsoft Power BI Desktop to various data sources. SQL Server is desirable

Proficient at data visualization using Power BI and a strong application development

Implementation of Row Level Security by defining various constraints for each defined role

1+ years of experience on SQL Server 2012 or advanced versions. SQL Server 2016 is an added advantage

Good SQL knowledge and code optimization skills to improve performance of the reports for faster performance

Expert knowledge using advanced calculations using MS Power BI Desktop (Aggregate, Date, Logical, String, Table)

Ability to showcase complete dashboard implementations that demonstrate visual best practices e g color themes visualization layout interactivity drill down capabilities filtering etc

Experience in gathering and translating end user requirements into effective efficient dashboards

Experience working with relational data sources like Oracle SQL Server and flat files good experience with cloud-based data sources e g Salesforce, Google, Azure
 Qualification BE,BTech