Financial Systems Analyst - Morristown, NJ, United States

Description · As a technical systems thinker with excellent analytical, critical-thinking, and problem-solving skills as well as a proven ability to assess complex business processes and identify tactical and strategic optimization and automation opportunities, the team member ov ...

Job description

Description

As a technical systems thinker with excellent analytical, critical-thinking, and problem-solving skills as well as a proven ability to assess complex business processes and identify tactical and strategic optimization and automation opportunities, the team member oversees and provides enterprise-wide support to business teams and individuals alike.

In addition to leveraging a solid foundation of a familiarity with accounting and finance concepts and principles, the team member is well-versed on the usage of Oracle ERP, Oracle FCCS, Oracle EDM, Narrative Reporting, ARCS, data transformation methodologies, as well as the administration and usage of Strata's Axiom Healthcare Suite, SQL, and MS Office Suite.

Responsibilities:

• Lead and develop sustainable data driven solutions with current data technologies to meet the needs of the enterprise's executive leadership and management.
• Provide ongoing enterprise-wide support from general staff to executive-level management.
• Serve as liaison between Finance team and other departments including external vendors.
• Master new technologies rapidly as needed to progress varied data-centric initiatives.
• Develop processes to analyze, convert and integrate unstructured data, potentially from external sources.
• Lead and/or contribute to the development and review of test procedures where applicable.
• Assist and advise in the streamlining and automation of business processes in support of efforts to improve productivity and efficiency.
• While employing PoLP, oversee, assist, and advise in providing and maintaining access to pertinent information for team members in support of the enterprise's productivity and efficiency.
• Design, create, and code SQL stored procedures and periodically troubleshoot pre-existing procedures and processes as required.
• Understand complex multi-tier, multi-platform systems.
• Analyze, break down, debug, and resolve complex data issues.
• Work collaboratively with business and technical teams to develop or improve reports in order to support the best data-driven, data-supported business decisions.
• Design, implement, and maintain complex database schema objects with respect to user requirements, access methods, security, and statistical methodologies.
• Meet with executive leadership and stakeholders to gather and determine business and data requirements to produce the necessary results to meet the business needs and deadlines.
• Provide technical expertise for the production of detailed data and reporting designs, design documentation, including data models and data flow diagrams.
• Determine file organization, indexing methods, and security procedures to make enterprise data available to executive leadership.
• Plan and coordinate the conversion and migration of existing or legacy data from various data sources (internal/external databases, flat file, etc.)
• Serve as a data-specific SME, as needed, for ERP applications.
• In support of Finance, identify and resolve issues during software application implementations throughout the assessment, design build, testing, training, and implementation phases.
• Conduct Report Authoring operations on an ongoing basis using various tools including Oracle Financial Reporting Web Studio, Oracle Smart View, Management Reporting, Narrative Reporting, Axiom Reporting
• Author reports to enable management decision-makers to perform ad hoc multidimensional pivot analysis with full spreadsheet functionality, drilldowns, analysis of detail balances, journal lines, and subledger transactions, actual, budget, and forecast information.

Qualifications

• Associate or bachelor's degree in related field preferred or at least 2 years experience
• Relevant Oracle University training preferred.
• Strong, demonstrable knowledge and understanding of the following:
  • Oracle Enterprise Data Management (EDM)
  • Oracle Enterprise Resource Planning (ERP)
  • Oracle Financial Consolidation & Close Service (FCCS)
  • Strata's Axiom Healthcare Software Suite
  • Financial and productivity reporting
  • Visual Basic for Applications
  • Extremely Strong Excel (formulas, pivots etc.)
• Advanced knowledge of and proficiency with Microsoft Office (Word, Excel, PowerPoint, Outlook), Power BI
• Demonstrable ability to communicate effectively verbally as well as in writing.
• Ability to communicate clearly and concisely with executive-level management, staff, and consulting resources.
• Ability to problem-solve with strong attention to detail.
• Proficiency in data analysis and interpretation with the ability to leverage data to drive process improvements.
• Ability to create and develop written procedures.
• Ability to effectively work independently.
• Demonstrable understanding of data extract and data transformation concepts.
• Ability to optimize databases and applications for best possible user experience.
• Demonstrates a firm understanding of the overall architecture required to support common schema-based objects used to store data and implement business logic.
• Demonstrable aptitude for debugging problems in complex unfamiliar code.
• Experience with relational database technologies, such as Microsoft SQL and Oracle SQL
• Provide guidance and direction to other technical resources as required.
• Healthcare experience, experience with HIPPA regulations
• Understanding and experience with Mergers and Acquisitions, especially with regards to data migrations, data integrations, and data conversions
• Ability to integrate and reconcile disparate external data; integrate and transform data in order to align and comply with standardized corporate data for reporting and decision-making purposes.