Financial Systems Administrator @ Dropbox

Financial Systems Administrator

Posted on 2/21/2023

INACTIVE

1,001-5,000 employees

Smart workspace & storage solutions

Company Overview

Dropbox’s mission is to design a more enlightened way of working with their custom-built storage infrastructure designed for a variety of needs. The company is committed to keeping life organized and keep work moving with their secure file sharing, collaboration, and storage solutions.

Locations

Oregon, USA • Washington, DC, USA • Los Angeles, CA, USA • Texas...

Experience Level

Entry

Junior

Mid

Senior

Expert

Desired Skills

Data Analysis

Groovy

Management

REST APIs

Tableau

Python

CategoriesNew

Software Engineering

Requirements

5+ years of progressive finance systems experience with a strong understanding of end-to-end planning processes
Direct experience as a functional administrator for Oracle PBCS (covering Operating Expenses, Workforce, and CapEx with SmartView implementation), with ability to write calculation scripts and maintain business rules in Planning and/or Essbase
Extensive knowledge in data sourcing strategies using ETL, REST API calls, Google Big Query, etc., using tools like ODI, Informatica, OneCloud, Dell Boomi, or similar tools
Development experience in scripting with Python/Groovy, setting up data integrations using APIs, and using EPM Automate and Batch Scripting
Experience building metadata, designing web forms, conducting data reconciliation, and building dashboards, preferably in Tableau or Oracle Analytics Cloud
Strong team player who is willing to teach others, as well as the ability to work independently and be accountable for individual results

Responsibilities

Own and aggressively drive forward the technology architecture of our Financial Planning systems by leading process improvement initiatives and collaborating with partners on ad-hoc systems projects and reports
Interact effectively with Finance and Accounting stakeholders to define leading business processes in Budgeting, Forecasting, and Performance Management functional areas
Provide Architectural assessments, strategies, and roadmaps for Oracle EPM Products like Budgeting & Planning (PBCS), Enterprise Data Management (EDM), Cloud Data Management (CDM), Account Reconciliation (ARCS), Financial Consolidation & Close (FCCS), Profitability & Cost Management (PCMCS), and Enterprise Narrative Reporting
Act as the first line of defense for production issues and a go-to resource for all financial systems, including the ability to assist in data reconciliations to maintain data integrity
Support the monthly forecast and outlook cycles and act as the functional administrator for Dropbox's planning and reporting systems, including monthly COA management using Oracle EDMCS
Support and enhance current state automation jobs (using Dell Boomi or OneCloud) and reports and dashboards (using Oracle Analytics Cloud and Tableau)

Role Description

Dropbox is looking for a Senior FP&A Systems Analyst to join our Corporate FP&A Systems team.As the senior systems analyst, you will play a critical role in supporting the FP&A function by reducing “work about work” and enabling the team to focus on high-level value-adding efforts. You will support monthly forecast cycles, work on high impact projects, and troubleshoot any systems-related issues — all while becoming a trusted and strategic partner for the broader FP&A team.

You will also provide best-fit architectural solutions for our current state and help lead us into the future of more automated processes and better reporting packages. Since this role is embedded into Dropbox’s FP&A team, you should also be able to understand and decipher financial statements (Income Statement, Balance Sheet, Cash Flow Statement, etc.) as well as have a solid understanding of common financial processes (including financial close cycles, budgeting and planning processes, and recurring reporting requests). The ideal candidate is independent and accountable, is always looking to leverage their technical skills to improve processes and analyses, and is naturally inclined to troubleshoot issues and resolve challenges.

Responsibilities

Own and aggressively drive forward the technology architecture of our Financial Planning systems by leading process improvement initiatives and collaborating with partners on ad-hoc systems projects and reports
Interact effectively with Finance and Accounting stakeholders to define leading business processes in Budgeting, Forecasting, and Performance Management functional areas
Provide Architectural assessments, strategies, and roadmaps for Oracle EPM Products like Budgeting & Planning (PBCS), Enterprise Data Management (EDM), Cloud Data Management (CDM), Account Reconciliation (ARCS), Financial Consolidation & Close (FCCS), Profitability & Cost Management (PCMCS), and Enterprise Narrative Reporting
Act as the first line of defense for production issues and a go-to resource for all financial systems, including the ability to assist in data reconciliations to maintain data integrity
Support the monthly forecast and outlook cycles and act as the functional administrator for Dropbox’s planning and reporting systems, including monthly COA management using Oracle EDMCS
Support and enhance current state automation jobs (using Dell Boomi or OneCloud) and reports and dashboards (using Oracle Analytics Cloud and Tableau)

Requirements

5+ years of progressive finance systems experience with a strong understanding of end-to-end planning processes
Direct experience as a functional administrator for Oracle PBCS (covering Operating Expenses, Workforce, and CapEx with SmartView implementation), with ability to write calculation scripts and maintain business rules in Planning and/or Essbase
Extensive knowledge in data sourcing strategies using ETL, REST API calls, Google Big Query, etc., using tools like ODI, Informatica, OneCloud, Dell Boomi, or similar tools
Development experience in scripting with Python/Groovy, setting up data integrations using APIs, and using EPM Automate and Batch Scripting
Experience building metadata, designing web forms, conducting data reconciliation, and building dashboards, preferably in Tableau or Oracle Analytics Cloud
Strong team player who is willing to teach others, as well as the ability to work independently and be accountable for individual results

Total Rewards

For candidates hired in the following locations: Austin (TX) metro, Chicago metro, Colorado, Massachusetts, Maryland, Oregon, Washington D.C. metro, California (outside SF metro), the expected salary/On-Target Earnings (OTE) range for the role is currently $106,300 - $125,100 - $143,900.

For candidates hired in the following locations: Arizona, Florida, Georgia, Illinois (outside Chicago Metro), North Carolina, Tennessee, Texas (outside Austin Metro), Virginia (outside D.C. Metro), the expected salary/On-Target Earnings (OTE) range for the role is currently $94,500 - $111,200 - $127,900.

Range(s) is subject to change. Dropbox takes a number of factors into account when determining individual starting pay, including job and level they are hired into, location/metropolitan area, skillset, and peer compensation. Dropbox uses the zip code of an employee’s remote work location to determine which metropolitan pay range we use.

Salary/OTE is just one component of Dropbox’s total rewards package. All regular employees are also eligible for the corporate bonus program or a sales incentive (target included in OTE) as well as stock in the form of Restricted Stock Units (RSUs).