ESSENTIAL DUTIES AND RESPONSIBILITIES
Following is a summary of the essential functions for this job. Other duties may be performed, both major and minor, which are not mentioned below.
Specific activities may change from time to time.
- Gathers, reviews, analyzes, profiles, validates and maps system data into the data warehouse to meet reporting and analytical business needs.
- Performs data analysis and troubleshooting on data-related issues reported by production support and other teams.
- Develops solutions and recommendations for improving data integrity issues. Analyzes data issues and works with development teams for problem resolutions.
Identifies problematic areas and conducts research to determine the best course of action to correct the data, identify, analyze and interpret trends and patterns in complex datasets.
- Determines and analyzes line of business requirements, use system data, and provide input needed by various departments and senior management to produce business reports.
- Works with extract, transform and load (ETL) developers to test and validate data attributes and with other business analysts to ensure data is integrated consistently, regardless of the source system.
- Works with business analysts and project teams to provide accurate documentation of data related project and support deliverables.
And with source system business analysts to understand system nuances and resolve data issues. Takes ownership of issues through resolution including close coordination between business analysts.
- Creates data quality metrics and scorecards. Performs regular audits of data. Understands data governance principles and how they apply.
- May instruct, direct, and mentor other members of the team.
QUALIFICATIONS
Required Qualifications :
The requirements listed below are representative of the knowledge, skill and / or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- Bachelor's degree in information technology, information systems, computer science or business-related field, eight years of experience in a role of data analysis, statistical analysis, data transformation, data reconciliation and / or sophisticated data presentation or equivalent education and related training or experience
- Experience in ETL Development using standard tools
- Understanding of Enterprise Data Warehouse concepts and prior experience applying that understanding to query data in a Very Large Database (VLDB) environment
- Familiarity in using a query analysis tool
Preferred Qualifications :
- Experience with Banking or Financial Services data including loans, deposits, and investments.
- Experience with Liquidity and Regulatory Reporting (LCR, NSFR, FR-2052A, Y9C)
- Experience with SAP applications
- Experience with SAP HANA
OTHER JOB REQUIREMENTS / WORKING CONDITIONS
Sitting
Constantly (More than 50% of the time)
Visual / Audio / Speaking
Able to access and interpret client information received from the computer and able to hear and speak with individuals in person and on the phone.
Manual Dexterity / Keyboarding
Able to work standard office equipment, including PC keyboard and mouse, copy / fax machines, and printers.
Availability
Able to work all hours scheduled, including overtime as directed by manager / supervisor and required by business need.
Travel
Minimal and up to 10%
General Description of Available Benefits for Eligible Employees of Truist Financial Corporation : All regular teammates (not temporary or contingent workers) working 20 hours or more per week are eligible for benefits, though eligibility for specific benefits may be determined by the division of Truist offering the position.
Truist offers medical, dental, vision, life insurance, disability, accidental death and dismemberment, tax-preferred savings accounts, and a 401k plan to teammates.
Teammates also receive no less than 10 days of vacation (prorated based on date of hire and by full-time or part-time status) during their first year of employment, along with 10 sick days (also prorated), and paid holidays.
Advisory Financial Services Risk, Data & Regulatory, Liquidity - Senior Consultant
Deloitte Risk and Financial Advisory's Financial Services Industry (FSI) Risk, Data and Regulatory professionals help organizations identify the regulatory changes impacting their business and implement effective and efficient processes to manage regulatory, capital, liquidity and interest rate risk...
Fraud Analytics and Innovation Senior Analyst
Data Analysis: Leverage data analytics tools and techniques to analyze large datasets, identify patterns, and uncover indicators of money mule activity. We hire individuals with a broad range of backgrounds and experiences and invest heavily in our teammates and their families by offering competitiv...
Senior, Accounting and Financial Reporting
Ability to analyze data to ensure the quality and accuracy of that data and present it in ways that are insightful to leadership. The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets; ex...
Senior GIS Analyst - FEMA Support
The Senior GIS Analyst is primarily responsible for FEMA Flood Insurance Rate Map (FIRM) production and quality end user adoption for GIS technologies, including tasks such as data collection and development, data QA/QC, map production, and training users on GIS software. Independently lead and coor...
Tax Senior-Federal Tax Svcs-DART (Depreciation Analysis and Reporting Tool)
Leveraging and utilizing advanced global tax depreciation data analytics and visualizations to help identify tax planning considerations, potential tax risks related to Client's fixed asset data, and identify potential cash tax savings. Do you have excellent tax compliance and consulting skills and ...
Senior Data Analyst
Implement data management and/or data sourcing capabilities and operations management as outlined in data management & reporting framework, policy and standards. Collaborates with the Data Stewards, Architecture, and Information Technology to prioritize and resolve: data sourcing, business rules...
Senior Analyst, Sales Performance & Compensation Reporting
Reporting to the Executive Director, Commercial Analytics & Performance Management Optimization, the Principal Analyst, Sales Performance and Compensation Reporting will serve as a central resource, partnering with various stakeholders to develop insights that will guide leadership, strategy, an...
Senior Regulatory Reporting Analyst - Regulatory Policy (Hybrid)
Qualifications Bachelor's Degree and 6 years of experience in GAAP Accounting, Regulatory Reporting, Financial Reporting OR High School Diploma or GED and 10 years of experience in GAAP Accounting, Financial Analysis, Financial Reporting Preferred Education: Advanced Degree Preferred Area of Experie...
Senior Audit Manager – Financial Regulatory Reporting
Performs scoping for individual regulatory report audits by risk assessing individual sub-schedules, line items, and attributes; and designing a comprehensive audit approach to execute controls testing and substantive end-to-end testing from the report to data capture. Experiencing in evaluating the...
Senior Data Analyst
Collabera is seeking a skilled and experienced Senior Data Analyst to join our team in Charlotte NC, Des Moines IA, Minneapolis MN, Chandler AZ or Irvine TX. Conduct data analysis and impact analysis using Hadoop and Google Cloud Platform (GCP). Cleanse, reformat, and store data using tools like Uni...