Finding the best job has never been easier
Share
Regular or Temporary:
English (Required)
1st shift (United States of America)
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.
1. Gathers, reviews, analyzes, profiles, validates and maps system data into the data warehouse to meet reporting and analytical business needs.
2. Performs data analysis and troubleshooting on data-related issues reported by production support and other teams.
3. 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.
4. Determines and analyzes line of business requirements, use system data, and provide input needed by various departments and senior management to produce business reports.
5. 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.
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.
1. Bachelor's degree in information technology, information systems, computer science or business-related field, four 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
2. Familiar with ETL Development using standard tools
3. Working knowledge of Enterprise Data Warehouse concepts and experience applying that understanding to query data in a Very Large Database (VLDB) environment
4. Familiarity in using a query analysis tool
1. Banking or financial services experience.
2.Master’s degree in a quantitative field such as Finance, Mathematics, Analytics, Data Science, Computer Science, or Engineering
3. Prior internship experience in applied analytics and/or data sciences, preferably (but not limited to) banking or finance
4. 3+ years of relevant work experience if candidate lacks a graduate degree
6. Experience with developing, analyzing, and customizing data visualizations in Tableau, QlikSense, Power BI, or similar tool
7. Working knowledge of Enterprise Data Warehouse concepts and experience applying that understanding to query data in a Very Large Database (VLDB) environment
8Must have an understanding of various database environments (IBM DB2, Oracle), technical programming skills (SAS, SQL, Toad), exposure to applied data science tools (R, Python, SAS E-Miner), familiarity with data visualization and BI tools (Tableau, MicroStrategy), and demonstrated proficiency in Microsoft Office Suite (Excel, PowerPoint, Word)
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.Able to work standard office equipment, including PC keyboard and mouse, copy/fax machines, and printers.Able to work all hours scheduled, including overtime as directed by manager/supervisor and required by business need.
These jobs might be a good fit