Senior Reporting and Data Analyst - Atlanta, United States - FHLBank Atlanta

FHLBank Atlanta Atlanta, United States

1 week ago

Full time

Description

Compensation Grade:

OUR 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:

Under limited supervision, represents the division in reporting-related project activities pertaining to report development, automation of reporting and information distribution and quality assurance. Reporting often includes complex requirements and requires a high level of skill and expertise. Monitors the efficiency and effectiveness of reporting and proactively initiates and implements improvements. Serves as a liaison between the division's reporting and analysis function, the Information Technology division, and other areas of the Bank affected by the division's data and reports.
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.

MINIMUM REQUIREMENTS

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.

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.

Data - Data Analyst

3 days ago

Progression, Inc. Atlanta, United States

Data Analyst · Atlanta, GC (100% remote but must be local) · MUST: · Experienced Data Analyst · 4 - 7 years of experience as a Data Analyst · 4+ years Python Scripting · 4+ years Power BI · 4+ years UAT Testing · 4+ years Complex SQL Querying · Bachelor's degree in computer sc ...
Data Analyst

1 week ago

Teall Properties Group Atlanta, United States

Job Description Summary: · We are seeking a skilled Data Analyst to join our team. The ideal candidate will turn data into information, information into insight, and insight into business decisions. You will conduct full lifecycle analysis to include requirements, activities, an ...
Data Analyst

1 week ago

Oxenham Group Atlanta, United States

Data Analyst · One of our clients is looking to bring on an Analyst who brings around 5 years of experience analyzing data and pulling actionable insights for the business. The role will be responsible for managing a team of analysts: Bachelor's degree or equivalent experience i ...
Data Analyst

2 days ago

Viva USA, Inc. Atlanta, United States

Title: Data Analyst - 1st Shift - Remote · Description: · Sr. Data Analyst, Commercial Analytics · Job Overview: · As a Sr. Analyst, Commercial Analytics at client, your key role will be to deliver commercial insights through the monthly publication of commercial analytics pac ...
Data Analyst

1 week ago

Flexton Atlanta, United States

The Sr Data Analyst is responsible for ingesting, mining, transforming, and reporting on data. The Data Analyst will work with stakeholders to provide insights into our data for new product offerings and trends in the automotive. · Duration: 6 m contract · Pay rate:$70-$75 · No H ...
Data Analyst

1 week ago

Careerbuilder-US Atlanta, United States

we're proud to stand at the forefront of the Big Data revolution. Using the latest analytics tools and processes, we're able to maximize our offerings and deliver unparalleled service and support. To help carry us even further, we're searching for an experienced data analyst to j ...
Data Analyst

1 week ago

Quest Financial Atlanta, United States

We are seeking recent graduates with an interest in building a career in Data Analytics for a Data Analytics Coordinator opening in the Perimeter area. · Highlights: · will work on the Data Analytics team of a global logistics company · is a hybrid remote position with 2 WFH days ...
Data Analyst

1 week ago

Diverse Lynx Atlanta, United States

Job Title: Data Analyst · Location: Atlanta GA · Duration: Full Time-Only · Job Description : · Job Title Data Analyst · Relevant Experience (in Yrs) 5-7 Years · Technical/Functional Skills · Good banking domain background with Advanced SQL knowledge is a MUST · Expert in Advan ...
Data Analyst

1 week ago

Quest Financial Atlanta, United States

We are seeking recent graduates with an interest in building a career in Data Analytics for a Data Analytics Coordinator opening in the Perimeter area. · Highlights: · will work on the Data Analytics team of a global logistics company · is a hybrid remote position with 2 WFH d ...
Data Analyst

5 days ago

Centurion Health Atlanta, United States

Job Details · Job Location · GA, Atlanta - Atlanta Regional Office - Atlanta, GA · Position Type · Full-Time · Education Level · Graduate Degree · Travel Percentage · None · Job Shift · Day · Job Category · Corporate · Description · Centurion is proud to be the provid ...
Data Analyst

3 days ago

New Georgia Project Inc Atlanta, United States

· New Georgia Project (NGP) is a non-partisan, 501c3 nonprofit organization formed to register the unregistered people of color in the state of Georgia. Our work is based in registering and advocating for Georgians of color (Black, Latinos, Asian-Americans) while engaging them i ...
Data Analyst

5 days ago

New Relic Atlanta, United States Regular, Full time

· Data Analyst · Data Analyst · Data Analyst · Req ID · FY25|S&M|#6368 · Location(s) · Atlanta, Georgia, USA; Austin, Texas, USA; Baltimore, Maryland, USA; Boise, Idaho, USA; Boston, Massachusetts, USA; Charleston, South Carolina, USA; Chicago, Illinois, USA; Cincinnati, Ohio, U ...
Data Analyst

3 days ago

Syntricate Technologies Atlanta, United States

Data Analyst · Location: Atlanta, GA (Onsite) · Job type: Fulltime only · Relevant Experience (in Yrs) 5-7 Years · Technical/Functional Skills · Good banking domain background with Advanced SQL knowledge is a MUST · • Expert in Advanced Excel functions used for data analysi ...
Data Analyst

1 week ago

Abbtech Professional Resources Atlanta, United States

This program requires US Citizenship · Worker Location: This position is 100% remote. · Public Trust- Active · JOB DESCRIPTION/SCOPE : Designs and develops methods, processes, and systems to consolidate and analyze structured and unstructured, diverse sources including big dat ...
Lifecycle Marketing Data Analyst

6 days ago

Autodesk Atlanta, United States

Job Requisition ID # · 24WD78191 · French job description to follow/La description de poste en français se trouve plus bas · Position Overview · Join our Growth Marketing Innovation and Lifecycle (ILM) Team, a dynamic group spearheading data-led engagements across the full custom ...
Data Analyst

6 days ago

Diverse Lynx Atlanta, United States

Job Title Data Analyst · Relevant Experience (in Yrs) 5-7 Years · Technical/Functional Skills · Good banking domain background with Advanced SQL knowledge is a MUST · Expert in Advanced Excel functions used for data analysis · bility to Understand Physical and Logical Data Model ...
Data Analyst

1 week ago

SCAN Atlanta, United States

We're , the digital health scale-up that gives patients and physicians simpler, faster access to medical imaging. · At the heart of lies a different way of doing things: empowering patients to make financially smart decisions, enabling live scheduling for patients and providers ...
Data Analyst

1 week ago

The Judge Group Inc. Atlanta, United States

Location: REMOTE · Salary: $27.00 USD Hourly - $29.00 USD Hourly · Description: Our client is currently seeking a Data Analyst Performs complex data analysis in support of ad-hoc and standing management or customer requests. · Develops programs, methodologies, and files for a ...
Data analyst

3 days ago

Southern Company Atlanta, GA, United States

The position is responsible for quantitative analysis on structured pricing products and developing tools and models for forecast and valuation. This role maintains the existing quantitative models and provides detailed report on model results timely and accurately. The position ...
Data Analyst

1 week ago

Emory Healthcare/Emory University Atlanta, United States

Discover Your Career at Emory University · Emory University is a leading research university that fosters excellence and attracts world-class talent to innovate today and prepare leaders for the future. We welcome candidates who can contribute to the diversity and excellence of o ...