Data & BI Analyst--PJ

Job Description:

Position: Data & BI Analyst

Location: Mohali, Panchkuka

Experience : 3+ years

Notice Period: Immediate to 15 days

The Data & BI Analyst is responsible for managing data integrity and creating analytical dashboards using business intelligence tools

Responsibilities

Follow enterprise data management processes under supervision of Data Operations Manager to perform the following job duties.

Reconcile customer, product and contacts data between the CRM (Salesforce) and ERP (NetSuite) systems.

Perform transactional data analysis utilizing data from the CRM & ERP systems to identify process disconnects.

Build dashboards, using Power BI or similar BI tools, which help identify data hygiene gaps easily.

Assist with maintaining data hygiene & integrity in the Data Warehouse.

Build functional & operational analysis using Power BI or similar BI tools.

Requirements

Critical-Thinking, Problem-Solving, Team Collaboration

Microsoft Office/Microsoft 365

Intermediate skills in MS Excel (pivot tables, VLOOKUP etc.) to reconcile large sets of data.

Having used a BI Tool (Power BI, Tableau, or equivalent) to build analysis and visualizations.

Experience working with a database (create tables, views, joins etc.).

Knowledge of AWS RedShift will be a plus

Familiar with Salesforce navigation will be a plus

Familiar with Oracle NetSuite or other similar ERP systems will be a plus