Data & BI Analyst

Data & BI AnalystLocation: Mohali, PanchkukaExperience : 3+ yearsNotice Period: Immediate to 15 daysThe Data & BI Analyst is responsible for managing data integrity and creating analytical dashboards using business intelligence toolsResponsibilities 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