Business Intelligence Analyst

Job Title:   Business Intelligence Analyst

Report to:   Technology Systems Controller

Location: US/Remote

Role Overview & Vision

This is an exciting opportunity for a motivated BI Analyst to be part of National Pen’s Finance team leveraging data / BI products in a dynamic, fast paced, global organization. The successful candidate will have a solid work experience coupled with some Business Intelligence background and should be comfortable working on their own, or as part of a larger group to deliver best in class data products.

·        Responsibilities:

•        GAAP Accounting and SOX compliance support: Liaison with the GL team by creating/updating

•        BI level reporting to assist during month-end close.

•        Build-out queries to pull from Oracle R12 to OneStream which includes E&O Inventory,Bad debt and R&A trends.

•        Build/update BI level reports to support SOX compliance, e.g., Revenue & Receivables

•        Cycle, liaison with Technology team to improve/validate shipping confirmation reports to reconcile to AR module during month-end close.

•        Liaison with Credit & Collections BI team in order to build/validate reports for credit

•        holds, refunds, order confirmations, etc.

•        Continue to validate BI data against the source data in Oracle General ledger submodules (one source of Truth).

•        Drive automation: Liaison with the Oracle Technology team in order to implement process

•        improvements.

•        Identify Oracle R12 functionalities not currently being utilized, e.g., streamline

•        Intercompany recording and monthly netting, eliminations mapping, and improve the set-up of allocations, etc.

•        Implement Oracle approval management engine (AME) in order to get invoice approvals

•        within Oracle.

•        Support Supply Chain Financing payment process.

•        FP&A: Liaison with the FP&A team to build Proforma & Budget reporting in OneStream.

•        Identify FP&A proforma requests to build in OneStream, e.g., net shipping, Logo, set-up fees costs per order at sales channel and country level (currently manual process using BI

•        and UF reports in Excel).

•        Create uniformed OneStream budget templates that will interface business owners

budget source documents into a OneStream loadable format and drive further

efficiencies in the budget input process.

•        Drive the implementation of product, customer, prospect, country and attributed P&Ls in OneStream to support FP&As business partnering initiative.

•        Income/VAT Tax reporting: assist TAX team with troubleshooting Matrix to OneSource

•        VAT/Sales tax rate variances.

•        Provide support that the Matrix/Oracle system will automatically calculate the applicable amount of state sales taxes or VAT taxes to be paid by the customers based on certain parameters (Customer billing address, shipping address, type of product & service sold).

•        Provide assistance to the Inventory management team.

•        Collaborate with the measurement of campaigns performances for Mail, Web and

Telesales channels.

•        Building reporting for inventory lifecycle management (Excess & Obsolete Reporting)

Requirements:

·        Degree or proven experience in Computer Science or a related technical field

·        4 years+ work experience including 2-year experience in Business Intelligence role

·        A rigorous, organized and analytical mind

·        Experience with SQL and experience with working across different database platforms.

·        Experience with BI tools, preferably Looker.

·        Prefer experience with OneStream EPM

·        Data preparation and data visualization expertise

·        A passion for delivering high quality work

·        A team player with strong analytic, communication & stakeholder relationship management skills

·        Ability to communicate findings, orally and visually, to a variety of audiences

This is a US Remote position. The California base annual salary/hourly range for this role is currently pendingA . Pay scales are determined by role, level, location and alignment with market data. Individual pay is determined through interviews and an assessment of several factors that that are unique to each candidate, including but not limited to, job-related skills, relevant education and experience, certifications, abilities of the candidate and pay relative to other team members. Our recruiters can share more information about our bonus program, benefits and equity during the hiring process. This job is also eligible for bonus/incentive pay.

National Pen’s personalized promotional products are created for and inspired by small businesses. With more than 50 years of experience and serving 22 countries worldwide, Pens.com provides personalized marketing solutions that help businesses connect with their customers through a personal brand experience. National Pen offers a broad range of personalized promotional products, including writing instruments, stationery, drinkware, bags, gifts, and trade show accessories, and operates via a network of more than 10 facilities across North America, Europe, Africa, and Asia.

To learn more, visit:  http://www.pens.com

National Pen is a Cimpress brand (Nasdaq: CMPR)

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation - no applicant will be penalized as a result of such a request.