Corporate Financial Analyst

Job Description

Analyzes, verifies, tracks, reconciles, and reports on department related databases and software. Serves as a liaison between department's analytical needs and technical data storage systems and files; collaborates with stakeholders to document requirements for reporting. Develop analytic reports for payment reconciliations utilizing various databases and data files from banks and other departments. Ability to plan, prioritize, and make decisions on multiple time-sensitive projects in a fast-paced environment. Develop, own, and modify detailed Access and Excel models to conduct reconciliations and what-if analyses. Ensures overall optimized department productivity by implementing scheduled or automated processes.

Job Responsibility

• Analyzes, verifies, tracks, reconciles, and reports on department related databases and software.
• Identifies strategies for evaluation of key data drivers and outcomes.
• Develops technical and functional specifications based on business requirements and analysis of technical workflows.
• Identifies issues in data quality that would impact reporting (i.e., duplicate records, missing data, etc.).
• Identifies methods of data integrity validation to ensure efficiency of all related daily processes.
• Maintains trends and tracks various measures to fully utilize the capabilities of databases and data files.
• Integrates add-on programs to eliminate or streamline back-end processes.
• Serves as a liaison between department's analytical needs and technical data storage systems and files.
• Operates under general guidance and work assignments are varied and require interpretation and independent decisions on course of action.

* Ensures overall optimized department productivity by implementing scheduled or automated processes.

* Finds solutions to reduce and avoid issues.

* Support efforts to identify leading practices, improve processes, enhance systems, and support the Finance organization to realize opportunities.

• Will be a key member of the team, gathering and analyzing information, formulating, and testing hypotheses, and developing actionable recommendations.
• Develop, own, and modify detailed Access and Excel models to conduct reconciliations and what-if analyses and perform other analytical tasks.

* Performs related duties as required. All responsibilities noted here are considered essential functions of the job under the Americans with Disabilities Act. Duties not mentioned here, but considered related, are not essential functions.

Preferred:

• Proficient in Microsoft Office Suite products including Access, Excel, Word, PowerPoint, and Outlook.
• Experience with a scripting language (preferably Python, VBScript)
• Knowledge in SQL and Relational Database Management Systems.
• Demonstrated strong analytical, project management, organizational skills, and with extremely high attention to detail.
• Comfort with ambiguity along with the ability to assist in logically structuring issues and resolutions while having strong commitment to data integrity.
• Demonstrated ability to work independently and collaboratively with a team, but also be a self-starter.
• Ability to plan, prioritize, and make decisions on multiple time-sensitive projects in a fast-paced environment.
• Strategic thinker with the ability to make connections across work streams.
• Ability to effectively communicate process changes and issues resolutions while building long-term trusted advisor relationships with Finance counterpart.

Job Qualification

• Bachelor's Degree required, or equivalent combination of education and related experience.
• 1-3 years of experience in database management, MS Excel proficiency and data analytics highly preferred.