Acumed
is hiring
Data Analyst, BI
About Our Company
What started as a small family business in 1988 has since evolved into a global market leader, providing orthopaedic and medical solutions that improve patient care around the world. https://www.acumed.net/products/osteomed-hand-wrist/
Our story begins in Butler, NJ, where Mary and Randy Huebner founded Accurate Machine and Design, also known as Acumed. With only one machinist on staff, Acumed was contracted to engineer implant prototypes for some of the biggest names in the industry.
After relocating to Oregon in 1991, we launched our first line of arthroscopy screws intended for ACL ligaments and haven’t looked back since. The successes of the Oregon Fixation Screw allowed Acumed to research, design, and manufacture the majority of our products while adding new lines each year. In 1999, Colson Associates, a division of The Marmon Group, purchased Acumed and provided the capital to purchase new equipment and a new facility to step up our production efforts.
Currently Headquartered in Hillsboro, Oregon, with a global distribution network and offices worldwide Acumed is a multi-award-winning company, dedicated to innovative and quality medical device solutions. We are committed to the highest standards of manufacturing and proudly produce over 90% of our implants in the U.S.
Throughout our history, Acumed has remained focused on the founders’ original vision of providing innovative solutions to meet the needs of the whole healthcare community, including hospitals, surgeons and patients.
Job Description & Responsibilities
Business Intelligence Data Analyst
The Business Intelligence Data Analyst (BIDA) will be an integral member of the worldwide FP&A team and will support the Global Senior Finance Director, this position will support the existing reporting structure for Sales, Finance and Accounting, assist with the transitions/architect/document to an EDW environment and develop advanced MS Excel/Power BI reporting within the finance function. As a key FP&A resource, this role will provide data governance to critical reporting fields, aggregate/realign various data sources into a consumable reporting table to provide in-depth detailed analytics, and cross functionally support other departments within the organization. Various analyses include but are not limited to: Volume/Mix, Cost Analysis, ASP/Pricing Actions and Sales & Volume trend/regression planning/forecasting/reporting. This position is well suited for a highly organized and self-motivated individual with strong attention to detail. This role is highly visible with senior leadership and is tasked with various ad hoc/what-if analysis with quick turnaround times.
Duties & Responsibilities:
- Drive the reporting transition to EDW via Microsoft SQL Server. Create consumable reporting tables for Power BI.
- Create new Power BI reporting dashboards mirroring existing reporting and identified reporting from senior leadership.
- Review/validate data for accuracy and consistency and work with any other teams necessary to improve accuracy and reliability of data
- Prepare internal management daily/weekly/monthly/quarterly reporting and analysis to support senior leadership and sales - such as the Daily Sales Report, ABC Customer analysis, Logistical Heat Maps and Key Customer reporting.
- Assist with the budget and forecasting analysis/templates for FP&A by leveraging trend analysis. Load the final approved Volume, Revenue, and Cost budgets into SAP.
- Experience with SAP (ERP system) and the ability to query and directly access transactional level data tables strongly preferred
- Collect and analyze geo fields, key attributes, and industry & general economic data to support longer-term strategic planning
- Passion for reporting excellence thru process improvements, technological efficiencies, and transparency.
Requirements
Qualifications:
- Bachelor’s degree in Finance, Accounting, Economics, Mathematics, Statistics, Computer Science, or Data Analytics required
- Advanced/Expert-level Excel skills and demonstrable ability to efficiently create advanced/dynamic data modeling
- Microsoft SQL Server, SQL, MS Access, and Power BI considered a must
- 3+ years of experience (non-manager role) with data analysis & FP&A is preferred
- Strong interpersonal skills with a desire to work in a fast-paced environment, meet deadlines, and complete time-sensitive duties with detailed data and inputs across the organization.
- Demonstrable ability to effectively communicate at all levels of the organization.
- This is a hands-on position; and a successful candidate will have to roll up their sleeves to succeed.
What we offer
Target Compensation: $86,525 - $105,752
Benefits: Medical, Dental and Vision insurance, 401k matching, + more