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.

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

*Additional Salary Detail
The salary range and/or hourly rate listed is a good faith determination of potential base compensation that may be offered to a successful applicant for this position at the time of this job advertisement and may be modified in the future. When determining a team member's base salary and/or rate, several factors may be considered as applicable (e.g., location, specialty, service line, years of relevant experience, education, credentials, negotiated contracts, budget and internal equity).