Senior Business Intelligence Engineer
Location
Mumbai | India
Job description
Business Intelligence Engineer
We are looking for people like us; hardworking, motivated, driven and of course fun!
This is an exciting opportunity for a motivated BI Analyst to be part of National Pen’s Global BI team and be a dedicated member supporting Global Finance leveraging data / BI products in a dynamic, fast paced, global organization.
The successful candidate will have a solid work experience coupled with 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.
What you will do:
-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 sub-modules (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.
-Build reporting for inventory lifecycle management (Excess & Obsolete Reporting).
-What we need from you:
Degree or proven experience in
Computer Science or a related technical field
-4+ years work experience including 2+ years experience in Business Intelligence role.
-A rigorous, organized and analytical mind
-Experience with SQL working across different database platforms.
-Experience with BI tools, preferably Looker.
-Experience with building dashboards to support various Finance functions.
-Preferably experienced 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
About National Pen
National Pen’s personalized promotional products are created for and inspired by small businesses. With more than 50 years of experience and serving 23 countries worldwide, National Pen 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 and Africa.
To learn more, visit:
pens
National Pen is a Cimpress brand (Nasdaq: CMPR).
Job tags
Salary
