Data Analyst (Power BI - NetSuite or Salesforce)

Experience -

Location -

Job Summary

Mandatory experience required in NetSuite or Salesforce.

With the extreme growth rate of our company, teams, and customer base, we are looking for a Data Analyst to help our Business Intelligence team keep up with the needs of the business by providing data and reports to our various functional areas in a timely manner. As part of this team, you'll work with your team members, our Data Architect, as well as stakeholders throughout the company to build and maintain new reports and dashboards in PowerBI and Salesforce, providing better access and visibility to our business data. You'll be working within our CRM looking at Sales, Marketing, as well as with our billing data and product usage data.

This position requires a consistent work ethic, strong attention to detail, the ability gather requirements, and a customer-centric mindset.

• Responsibilities

  Design, Develop, and maintain reports and dashboards within Power BI and Salesforce in a timely manner based on the needs of the business.
• Build and maintain Power BI data models, including relationships, calculated columns, and measures.
• Automate data refresh schedules and ensure the reports are up-to-date with the latest information.
• Work with data sources such as SQL databases, Excel, SharePoint, and other external APIs to gather, transform, and load data for reporting.
• Work tickets assigned to you via Jira through our Analytics Sprint planning process. Providing visible progress and closed-loop communication through updates on the tickets.
• Work with stakeholders to solve through requirements and achieve a clear understanding on requests.
• Managing and manipulating data and views to meet the needs of the business
• W orking backwards through metrics and reports to understand filters for the purpose of recreating, improving upon and/or consolidating them
• Help maintain our data dictionary, reporting index, and any other internal documentation used to provide visibility to our reporting stack to our internal teams
• Provide feedback to our Data and Operations teams on the states of our data and data sources for opportunities to improve data integrity or gain efficiencies in gathering data.
• Conduct training sessions or provide support to end-users on using Power BI reports effectively.
• Stay updated on Power BI updates, best practices, and new features to improve the efficiency and effectiveness of reporting processes.
• Will be working various cloud software including Salesforce, NetSuite, Hubspot and more.

• Requirements

  Bachelor's degree in a relevant field (e.g., Computer Science, Mathematics, Statistics, Business Analytics).
• Familiarity with writing/reading SQL Queries and PostgreSQL Database.
• 1 year + with using AWS ETL tools, AWS Glue, AWS S3 and AWS RDS.
• At least 2- 3 year of experience building reports and dashboards in Power BI, using DAX, and PowerQuery.
• Experience 2 year of Python.
• 2 years + experience with data warehousing concepts and ETL (Extract, Transform, Load) processes.
• Experience building and delivering business metrics and key performance indicators
• Experience navigating a CRM in order to review and understand business cases for data and report requests
• Familiar with reading/updating Entity Relationship Diagrams (ERDs)
• Performs ongoing monitoring and improvements of reports and BI solutions
• Ability to work with stakeholders to understand problems, gather requirements, present rationale, and explain technical logic to the team
• Must be excellent at writing and contributing to the internal documentation and knowledge bases
• Excellent troubleshooting and research skills
• Excellent listening and communications skills, both verbal and written.
• Action-oriented, customer-focused, with effective prioritization, goal setting and time management skills.
• 1 Year + Experience in using Salesforce Reporting and Salesforce Objects
• 1 Year + Experience in using NetSuite Reporting and datasets.
• Outstanding interpersonal skills; projection of professional image and credibility; teamwork oriented and inclusive.
• Must be authorized to work in the United States
• Related Certifications is a plus
• At least 1 year of experience in IT or managed services is preferred
• Experience working at or with Managed Service Providers or MSP channel products is a big plus