• Reporting to the Director, FP&A, the Senior Business Analyst will be responsible for leading and completing commission calculations for the Sales and Customer Success teams
• Leveraging Power BI, build and manage the end-to-end sales commission calculation process
• Serve as the subject matter expert on sales commission plans, policies and rationale.
• Ensure data integrity between systems involved in the commission payroll process – Salesforce, NetSuite and PowerBI
• Build sales compensation analytics and maintain monthly reporting for sales teams
• Support the implementation & documentation of new sales quotas and commission plans, leveraging key metrics to make recommendations for necessary changes to commission structures
• Support the overall organization with value-add PowerBI dashboards built to the specific needs
• Lead collaborative sessions with various business groups to gather and document BI project requirements
• Load and manage data collections within the Power BI data inventory to ensure seamless data integration and accessibility
• Design and implement guidelines for creating dashboards, reports, and visualizations that effectively communicate data insights
• Develop and maintain complex reports, dashboards, and visualizations for both internal teams and external public stakeholders
• Create and manage a secure archive of reports for historical reference
• Transform data received from various sources into formats that meet both business and technical specifications for end users
• Properly document BI processes
• Document data sources, report specifications, and data transformation procedures
• Train, coach and mentor junior staff Business Analyst

• Bachelor's degree in a technical field such as: Economics, Accounting, Finance, Computer Science, Statistics, Applied Mathematics
• Minimum of 3 years of hands-on PowerBI experience
• Knowledge of Salesforce.com preferred
• Expert data visualization skills (PowerBI, Tableau)
• Demonstrated experience with enterprise data, especially ERP systems (NetSuite, SAP, JD Edwards)
• Knowledge of relational databases (e.g. MS SQL Server, Snowflake, Oracle)
• Demonstrated ability to tackle problems across the full data stack, from data wrangling (leveraging SQL or other methodologies) to stakeholder consumption at scale
• Ability to communicate technical concepts to non-technical audiences
• Detail-oriented with a high level of precision in data analysis

Propio is an Equal Opportunity Employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.

All applicants must be able to complete pre-employment onboarding requirements (if selected) which may include any/all of the following: criminal background check, drug screen, education, and employment verification.