Data Analyst
- Employer
- Mindlance
- Location
- Charlotte, North Carolina
- Salary
- Competitive
- Posted
- Nov 04, 2024
- Closes
- Nov 09, 2024
- Ref
- 2844856592
- Focus Area
- Auditing, Data Analytics, Records & Reporting
- Role Type
- Analyst
- Role Level
- Intermediate
- Education Level
- Bachelor's Degree
- Certifications
- CISA – Certified Information System Auditor
- Work Mode
- Hybrid
- Employment Type
- Full Time
- Organization Type
- Corporate
Business Initiative/Purpose: (Goal, Business Impact, Accomplishments from the work)
Data Analytics support for ADT work to complete PY 2024 & 2025.
Bachelor Degree: (Required, Preferred or Not Required)
Preferred.
Role Responsibilities: (what they will be doing)
Gather, analyze, document and maintain all data requirements related to the business applications, interfaces and reporting environments. Apply standards and best practices to ensure the Bank's data is accurate, complete, current, understandable and accessible. Work closely with internal clients, Audit Delivery Teams, business analysts and development project teams to resolve information flow and content issues.
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.
Must Have Skills/Prior Experiences: (Vendor should not submit any candidate that does not have these skills/prior experience.)
The requirements listed below are representative of the knowledge, skill and/or ability required.
Bachelor's degree in information technology, information systems, computer science or business-related field, six 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.
Knowledge of SQL Queries.
Experience with SAS.
Experience with Python.
Plus/Nice to Have Skills/Prior Experiences: (Hiring Manager DOES NOT require these skills/ prior experience. However candidates with any of these will be looked at first.)
Preferred Qualifications:
Banking or financial services experience.
Experience working with Informatica.
Audit experience.
EEO
Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.
Data Analytics support for ADT work to complete PY 2024 & 2025.
Bachelor Degree: (Required, Preferred or Not Required)
Preferred.
Role Responsibilities: (what they will be doing)
Gather, analyze, document and maintain all data requirements related to the business applications, interfaces and reporting environments. Apply standards and best practices to ensure the Bank's data is accurate, complete, current, understandable and accessible. Work closely with internal clients, Audit Delivery Teams, business analysts and development project teams to resolve information flow and content issues.
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.
Must Have Skills/Prior Experiences: (Vendor should not submit any candidate that does not have these skills/prior experience.)
The requirements listed below are representative of the knowledge, skill and/or ability required.
Bachelor's degree in information technology, information systems, computer science or business-related field, six 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.
Knowledge of SQL Queries.
Experience with SAS.
Experience with Python.
Plus/Nice to Have Skills/Prior Experiences: (Hiring Manager DOES NOT require these skills/ prior experience. However candidates with any of these will be looked at first.)
Preferred Qualifications:
Banking or financial services experience.
Experience working with Informatica.
Audit experience.
EEO
Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.