Job Title

Specialist – Consumer Insights

Department/ BU

IT and Digital Development

Location

Mumbai - Head Office (Sion)

Reporting To

Lead – Consumer Insights

Organizational Description

Bajaj Electricals Limited (BEL), a globally renowned and trusted company, with a turnover of ₹4813 crores (FY 21-22), is a part of "Bajaj Group". Our business includes Consumer Products (Appliances, Fans, Lighting), Exports, Illumination and Transmission & Distribution (Transmission Line and Power Distribution). Our strong presence in premium range of home appliances and cookware with brands like Morphy Richards and Nirlep makes us one of the most lovable brands for our consumers.

While we are known for our innovative consumer products, other businesses such as Illumination and Power Distribution & Transmission have contributed significantly towards nation building. With a rich legacy of nearly 8 decades, we have perfected our business model and at the same time continue to transform ourselves with a culture built on ethics & integrity, agility, straight talking, teamwork and aiming for the best.

It is an exciting time to join Bajaj Electricals as we are creating a future-ready organisation based on key pillars of customer centricity, robust governance, and best talent. 

If it sounds like the place for you, Welcome Onboard! An exciting journey awaits!

Job purpose & Scope

Looking for a Business Intelligence (BI) Lead with strong knowledge of Business data analytics including Microsoft Power BI to create and manage BI and advanced analytics solutions that turn business data into user friendly, actionable reports, insights & dashboards.

Major Areas of Responsibilities

• Translate business needs to technical specifications
• Designing, developing, and maintaining business intelligence solutions using Power BI desktop and services.
• Working on full suite of Power BI products (embedded, Reporting Services, Paginated Reports)
• Efficiently handle large sets of data and be able to confidently process them into required formats. Crafting and executing queries upon request for data.  Creating data structured & models to store data
• Ingesting data from a variety of corporate data sources and performing required transformations in the Power BI
• Developing calculations in DAX which are accurate and performant on large datasets.
• Designing effective layouts using Data Visualization best practices.
• Prototyping, testing, build, and launch of Power BI solutions
• Utilizing effectively the navigation features in Power BI (e.g. bookmarks, drill-through) to guide readers through a compelling data-driven story
• Develop production-ready Reports, Dashboards and deploy to corporate platform
• Quality Check of Data Migration routines, reviewing outputs against quality standards and continually looking for process improvement
• Develop user manual / training documentation
• Work in Dev-Ops environment for solution delivery Skills
• Establish and maintain clear communication with the clients and stakeholders project scopes, timelines, issue resolution and deliverables
• Accountable for clear requirement documentation, analysis/ development plans, on time delivery of projects, timely communication to Business Units, and quality of project deliverables
• Proactively looking for project opportunities across teams/departments within organization where either cost or human effort can be reduced

Person Specifications

Educational Qualification : B.Tech., Statistics, MCA/MBA in Business Analytics / Business Intelligence or related discipline

Experience :

3-5 years of relevant experience in analytics and Business Intelligence

At least 3-year experience in Dashboard/ Report creation using Power BI

Experience with Azure could platform, SQL Server

Experience with AWS could platform

Competent in developing engaging and effective data visualizations

Competent in Power BI embedded skills & Row level security

Knowledge of latest Power BI features and functionality

Strong data analysis skills

Proficient in writing SQL, DAX, and M

An in-depth understanding of how the Power BI Service works

Knowledge of SSAS (Tabular and Multi-dimensional), Flow and Power Apps beneficial

Hand on experience of using R & Python with Power BI would be a plus

Experience with SAP S4HANA or SAP C4C would be a plus.

Other Requirements :

Should have excellent communication & Interpersonal skills

Ability to take client requirements, understand them and turn them into a powerful story told through engaging visuals in Power BI

Confident communicating with stakeholders of all levels including the ability to advise, train and support staff and clients where necessary

Self-starter/able to work independently

Ability to organize and manage own time according to agreed project priorities and deadlines

Experience in working at all stages of the project lifecycle

Functional Knowledge & Skills:

Functional Knowledge & Skills (5 pt. scale)

Basic (1-2)

Intermediate (3)

Advance (4-5)

R

*

Python

*

AWS or Azure Datawarehouse

*

Power BI

*

Data Analysis Expressions (DAX)

*

Oracle SQL

*

Excel

*