Previous Job
Previous
VBA / Access Developer
Ref No.: 18-02314
Location: Boca Raton, Florida
Job Purpose:
Primary responsibility, Data Management and Business Intelligence using Salesforce.com analytics, and Power BI. Experience with VBA and Access to develop automated processes to upload data into a standardized format. This position builds reports and dashboards in Salesforce.com and Power BI by pulling from various sources such as Access, SQL Server, Hyperion, and sales management systems. Receives and uploads the sales production data into a centralized Enterprise Sales and Compensation Systems. This responsibility will also include the plan and system architecture creation which will allow the Sales Effectiveness Team to receive and report on the sales productivity capacity and financial data globally across different business units Job Level Summary Information Scope: Supports the Sales Effectiveness Team as well as supporting projects across the Enterprise. Impact : Responsible for creating dashboards and reports as well as the data integrity and accuracy for the Enterprise Sales and Compensation Systems Knowledge: Power BI, Salesforce.com, and Data Analytics, using SQL VBA, Excel, and Access. Will be experienced in the process for creating data management and business intelligence as well as receiving and loading of data through various ETL (Extract, Transform, Load) processes
Problem Solving: Able to solve high degree of complex data challenges for auditing and reporting purposes People/Function Management: Will report into the Sr. Operations Manager Supervision Received: Has the ability to make decision that impacts how data is presented, structured and processed. Customer Focus: Internal (Executive Management, Sales and P&L Leaders, Sales Compensation Design team, Enterprise) Interpersonal Skills: Ability to understand and translate Enterprise desired reporting requirements that can provide insightful decision making capabilities for the business
Preferred Education:
College Degree in IT related field preferred Minimum Preference Experience: 8-10 years working with data and analysis. Includes creating operational processes regarding ETL Travel Requirements: Up to 5%; Ability to travel to company locations