What are the responsibilities and job description for the Business Analyst position at Caplugs?
At Caplugs, we work to identify and develop talent, continuously focusing on innovation, learning and improvement to deliver on our promise to be the product protection partner our customers need to solve their challenges. Are you ready to be a part of our team?
SUMMARY: The Business Analyst primarily supports Sales & Marketing with potential outreach to other areas of the business through data analysis, reporting, and consults on business challenges to then capture, retrieve, organize and analyze data. Experience/proficiency reading and writing SQL are highly desired.
ESSENTIAL DUTIES AND RESPONSIBILITIES: include the following. Other duties may be assigned. Responsible for all Sales and Marketing reporting inclusive of:
o Ownership of all reporting creation, regular update maintenance, and training in Power BI
o Weekly update and distribution of Open Order Reporting
o Completion of monthly Operating Review Report elements and organization into a PowerPoint presentation
- Planning and coordination of monthly Sales and Marketing team meetings reviewing any necessary, detailed analysis of business performance supporting monthly and quarterly business reviews
- Gather, organize, analyze data and prepare PowerPoint slides for the quarterly business review cycles
o Ad hoc support for a range of reporting and business analytics needs
· Responsible for monthly and quarterly market forecast modeling, research and analysis:
- Manage third party data subscription services by serving as key contact and developing expertise over platform content and inputs
- Manage database updates, both BI and offline reporting outputs, and support process improvements and automations
· Support of the revenue build-up during the budget annual planning process, including template/tool maintenance, deployment, stewardship, and coordination w/ Finance Analytics
- Support of annual and 3-yr strategy development, and other initiatives with reporting and data analysis
- Analysis of CRM generated data, preparation of findings and presentation of that information to management
- Maintain needed modifications to customer chaining within ERP systems
- Monitor, document, maintain and project plan improvement opportunities around data integrity by priority
· Support project plans for data integration of any new business acquisitions and the preparation of monthly reports for new companies/product lines on an as-needed basis
· Support various ad-hoc reporting, data extraction and preparation needs around the business, as well as special projects assigned by the sr. mgmt. team.
· Collaborate and communicate effectively with a wide variety of functional areas such as sales, engineering, marketing, manufacturing, quality, information systems and operations on a variety of initiatives
EDUCATION and/or EXPERIENCE: Bachelor’s Degree especially in Data or Computer Science, Information Technology or Systems, Marketing, or Business and 0-5 years of relevant business analytics experience. SQL experience a strong plus.
Salary : $65,000 - $70,000
