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 dataHaving used a BI Tool (Power BI, Tableau, or equivalent) to build analysis and visualizationsExperience 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 plusSkills Required
Power Bi, Tableau, Bi Tool, Crm, Data Analysis, data reconciliation , Data Visualization