Duties:
Writes SQL reports for our global DSX Finance organizations across numerous operational and reporting systems. Supports the delivery of Daily and Month-End and Year-End reports. Configures and maintains automated reporting systems. Performs proper technical and procedural controls to prevent systemic and human error during process execution. Supports the Reporting Scrum team with defining tests for feature acceptance criteria. Executes User Acceptance Testing for the financial reporting solutions and billing applications. Innovates on existing business and system processes. Supports ad-hoc analysis and provides special project reports, as needed, such as new business development data, tax/compliance audit reports, and production bug triages. Supports the launch of new countries/regions into our reporting and billing ecosystems as they are launched. Duties may be performed remotely.
Requirements:
Bachelor's degree in Business, Finance, Information Systems, Information Science and Technology, or related field of study and 2 years of experience as a Reporting Analyst, Data Analyst, or related role. Two years of experience with: SQL Querying and Report authoring to perform data discovery, predictive modeling, simulation, and statistical analysis; Reporting concepts including data warehousing and dashboarding, and managing their tools including Cognos, Toad/SQL Developer, and Hive; Microsoft Excel and Microsoft Office software for Ad-hoc analysis and executive leadership reporting; Creating reporting test plans and reconciliation processes to work with key stakeholders on reporting requirements and automation through; Zuora Cloud Billing for interpreting and forecasting data, and translating metrics and business impact to Finance leaders; and Creating and executing Failure Mode and Effects Analysis (FMEA) related to the data correctness on interfaced operational and financial data between multiple systems.
Compensation:
- The expected base compensation for this role is $109,042.50 to $109,042.50 Annually.
- Actual base compensation within the identified range will vary based on factors relevant to the position.
- Bonus Potential: An incentive pay program offers payouts based on company performance, job level, and individual performance.
#LI-DNI