Senior Reporting and Data Analyst
Estimated Pay | $25 per hour |
---|---|
Hours | Full-time, Part-time |
Location | Atlanta, Georgia |
Compare Pay
Estimated Pay We estimate that this job pays $25.43 per hour based on our data.
$18.46
$25.43
$36.83
About this job
Compensation Grade:
13OUR VISION FOR DIVERSITY AND INCLUSION:
FHLBank Atlanta contributes to our members' success through a diverse, inclusive, and engaged culture that enables all individuals to work together to fulfill our purpose.
BASIC PURPOSE:
Validates data, compiles reports used for credit underwriting, collateral eligibility and valuation and other management decisions, and provides diversified database support for the division's management and teams.
ESSENTIAL FUNCTIONS:
- Understands, executes and provides oversight of data warehouse reporting requirements and inter-relationships of requirements for various entities, such as SEC 10-K/10Q reporting, Federal Housing Finance Agency, Credit and Collateral Committee, board of directors reports, Office of Finance, etc. Manages workload and collaboration with others to ensure strict reporting deadlines are met.
- Manages projects pertaining to automation of reporting and information distribution for the division and other areas of the Bank affected by this data.
- Provides expertise and quality control review of data placed in the Bank's electronic data warehouse (EDW) and end user reporting system (EURS) environments.
- Monitors the change control process to ensure effective and accurate change management, and proper documentation of changed requirements and testing results.
- Performs and documents balancing-related controls to ensure data is loaded and validated properly. Researches and resolves discrepancies as needed.
- Partners with business units, product owners, and technology stakeholders to translate potential data driven ideas into fully developed data and analytic solutions.
- Makes recommendations and maintains policies and procedures regarding departmental and bank-wide usage of the data warehouse as well as bank-wide usage and necessary controls over data.
- Monitors the data warehouse and related reporting activity for control deficiencies or gaps. Performs root cause analysis and tracks data processing and reporting control issues to make recommendations for process improvements.
- Serves on departmental and enterprise working groups and projects, such as data governance, systems implementations and upgrades, and new initiatives.
- Develops and fine-tunes solutions, including coding, testing, debugging, designing, optimizing and implementing dashboards and reports used on Oracle and SQL server platforms.
- Implements business intelligence best practices, guidelines for reporting and repeatable processes.
- Works closely with stakeholders and technology to design solutions that meet the Bank's warehousing needs while leveraging industry standards and best practices, and meet data requirement needs.
- Continuously develops and maintains an understanding of business intelligence technology and architecture, including dimensional modeling, reporting tools, and other methods of information delivery.
- Manages and oversees the Collateral Verification Review system (CVR) reporting process and data management process, or serves as a backup for these functions, including:
- Works closely with Collateral management to translate data needs into reporting solutions.
- Creates reporting solutions to identify data anomalies, and work with vendor to provide effective solutions to maintain the reliability of data and databases.
- Optimizes SQL queries to provide fast and efficient rendering of reports via the system front-end.
- Works closely with the end users and management during testing and after implementation to production to ensure reports function properly.
- Manages the development and ongoing maintenance of all reports on the SQL reporting server.
- Develops, maintains, and modifies a Manual Operations spreadsheet used to enable continued operations during business continuity/disaster recovery scenarios.
- Maintains accurate and thorough procedures for reporting portfolio and other processes.
- Stays current on other functions of the team and provides backups when required.
KNOWLEDGE, SKILLS, ABILITIES:
- Advanced understanding of SQL query language.
- Advanced skills in Microsoft Excel.
- Proficiency with Word and PowerPoint.
- Strong systems orientation and technical foundation.
- Proficiency with reporting tools such as Crystal Reports, SSRS (SQL Server Reporting Services) or Power BI.
- Strong understanding of and related experience with internal controls and process improvement.
- Ability to work on multiple, unrelated projects simultaneously under limited supervision.
- Project management skills, including strong team-building skills and excellent problem-solving skills.
- Excellent verbal and written communication skills.
- Exhibits a growth mindset and willingness to pursue continuing education and training in evolving technology and software and tools.
- A bachelor's degree in finance, accounting or information technology
- A minimum of five years' experience with automated systems and database experience, and a fundamental understanding of accounting and financial analysis and reporting
- Or the equivalent combination of education and experience is necessary.
WORK LOCATION:Onsite with an opportunity to work remote partially. This position may not be filled in California, either in-person or remotely.
We are an equal opportunity employer committed to , equity, and inclusion in the workplace.
You might also like
in Atlanta, GA
Arby's • 2h ago
Arby's • 2h ago
Sonic • 2h ago
$25
Sonic • 2h ago
Buffalo Wild Wings • 2h ago
Companies hiring business intelligence analysts
in Atlanta, GA
Nearby locations
Explore more business intelligence analyst jobs
in Atlanta, GA
Nearby Job Titles
Registered Nurse Jobs Truck Driver Jobs Physical Therapist Jobs Driver Jobs Radiologic Technologist JobsNearby Locations
Atlanta, GA Jobs Marietta, GA Jobs Roswell, GA Jobs Decatur, GA Jobs Georgia JobsNearby Companies
DoorDash Jobs U.S. Navy Jobs Lyft Jobs Uber Jobs Care.com JobsNearby Categories
Full-time Jobs Part-time Jobs Gig Jobs Posting ID: 895221022 Posted: 2024-05-01 Job Title: Senior Reporting Data Analyst