Apex Systems
Data Analyst
Apex Systems, Richmond, Virginia, United States, 23214
Job#: 2049412Job Description:Apex Systems is hiring for a Data Analyst in Richmond, VA! Apply today and send your most updated resume to Chelsea at ccorley@apexsystems.com.12 month contract with potential to extend. Must be in RICHMOND, VA and go onsite.MUST HAVE experience with SQL, Excel, Tableau and Confluence!Position Summary
This role engages with business and tech teams to understand and document data that is being used within the authorized data sources. Documentation includes identifying data elements which are used in reports, and tracing the data flow back to the originating system which produces the data. As these elements are identified, required metadata names and definitions of each element will be written and stored in the local metadata repository. Data Quality rules will be required for each element to ensure that the underlying data is meeting business requirements. Data Lineage flows will be gathered manually and through automated tools where available. Data Quality metrics will be applied to the authorized data source for monthly reporting to Executives.While performing this function, meeting with business and tech managers will be a critical function of the success of this role. Developing relationships with these partners will provide insight into the data that is critical for reporting, as well as provide seamless engagement opportunities within the teams for working relationships with developers and analysts. Assisting with technical aspects, including understanding SQL and high level database structures will drive the success in completing the end to end data requirements of the Data Quality and Control Executive function.Required Skills
Advanced Excel Skills, including VLOOKUP, Pivot Tables, Data Analysis, Calculations, formatting and operational functionality of data.Proficient in MS Products such as Word and PowerPoint.Strong analytical and organizational skills; ability to collect, organize, and analyze information.Excellent oral, written, and presentation skills, including the ability to work in person, virtually, and in a globally-staffed environment.Ability to understand, apply, analyze, evaluate, and create processes and flows to help reduce risk to the bank.Must be able to bridge gap between technology and business and clearly articulate requirements and solutions.Adept at handling multiple tasks and adapt to daily changing requirements.Desired Skills
Understanding of Data Management fundamentals, including metadata, data quality, and data governance.Relational database expertise, including SQL expertise.Experience with Visio.Knowledge of Retail, Preferred, Small Business, Wealth business and technology environments.
#J-18808-Ljbffr
This role engages with business and tech teams to understand and document data that is being used within the authorized data sources. Documentation includes identifying data elements which are used in reports, and tracing the data flow back to the originating system which produces the data. As these elements are identified, required metadata names and definitions of each element will be written and stored in the local metadata repository. Data Quality rules will be required for each element to ensure that the underlying data is meeting business requirements. Data Lineage flows will be gathered manually and through automated tools where available. Data Quality metrics will be applied to the authorized data source for monthly reporting to Executives.While performing this function, meeting with business and tech managers will be a critical function of the success of this role. Developing relationships with these partners will provide insight into the data that is critical for reporting, as well as provide seamless engagement opportunities within the teams for working relationships with developers and analysts. Assisting with technical aspects, including understanding SQL and high level database structures will drive the success in completing the end to end data requirements of the Data Quality and Control Executive function.Required Skills
Advanced Excel Skills, including VLOOKUP, Pivot Tables, Data Analysis, Calculations, formatting and operational functionality of data.Proficient in MS Products such as Word and PowerPoint.Strong analytical and organizational skills; ability to collect, organize, and analyze information.Excellent oral, written, and presentation skills, including the ability to work in person, virtually, and in a globally-staffed environment.Ability to understand, apply, analyze, evaluate, and create processes and flows to help reduce risk to the bank.Must be able to bridge gap between technology and business and clearly articulate requirements and solutions.Adept at handling multiple tasks and adapt to daily changing requirements.Desired Skills
Understanding of Data Management fundamentals, including metadata, data quality, and data governance.Relational database expertise, including SQL expertise.Experience with Visio.Knowledge of Retail, Preferred, Small Business, Wealth business and technology environments.
#J-18808-Ljbffr