TechnoGen
Data Analyst Job at TechnoGen in Richfield
TechnoGen, Richfield, MN, United States
Please Note: As of July 22, 2021, our team will require that all candidate submissions include a LinkedIn profile. Please do not submit any candidates that do not have a LinkedIn."
As part of Union Bank acquisition by U.S Bank, we are responsible for ensuring required data is archived in appropriate platform that business lines can access and utilize. There is 50 data warehouse and data marts that we are responsible to determine appropriate treatment plan and executing on it.
Required Skills : - SQL: 7 years - Hadoop Distributed File Systems: 3 years - Hive, Presto: Years - Quick Learner Analysis, and on-going support of internally developed processes to support business initiatives. Automation of processes using existing tool set, including Microsoft BI Stack (SSRS, SSIS, SSAS, Excel Services, Performance Point, and PowerPivot). Analysis and query writing to assist in supporting key business initiatives. COMMUNICATION SKILLS: This position requires good oral and written communication skills to interface with internal business clients - many having minimal technical knowledge. Ability to translate business requests into technical requirements. TECHNICAL SKILLS: Ability to write transact-sql code to extract correct data to answer business questions. SQL Development experience. Extensive experience with creating reports using Microsoft Sql Server Reporting Services. ADDITIONAL BENEFICIAL EXPERIENCE: use and construction of Microsoft Sql Server Analysis Services; Sharepoint (using the BI Stack). Strong attention to detail for validation of all queries constructed. Ability to visualize data into a form that effectively answers the business question.
Basic Qualification :
Additional Skills :
Rank :C1
Requested Date :2023-02-14
As part of Union Bank acquisition by U.S Bank, we are responsible for ensuring required data is archived in appropriate platform that business lines can access and utilize. There is 50 data warehouse and data marts that we are responsible to determine appropriate treatment plan and executing on it.
- Understand requirements that drove the need to archive data.
- - Build Test data as needed.
- - Build Test Plans SQLs
- - Capture Test results.
- - Review data archival logs and controls. Ensure required metrics are captured.
- - Collaborate with existing Teams to build training/knowledge base for business lines to use the data.
Required Skills : - SQL: 7 years - Hadoop Distributed File Systems: 3 years - Hive, Presto: Years - Quick Learner Analysis, and on-going support of internally developed processes to support business initiatives. Automation of processes using existing tool set, including Microsoft BI Stack (SSRS, SSIS, SSAS, Excel Services, Performance Point, and PowerPivot). Analysis and query writing to assist in supporting key business initiatives. COMMUNICATION SKILLS: This position requires good oral and written communication skills to interface with internal business clients - many having minimal technical knowledge. Ability to translate business requests into technical requirements. TECHNICAL SKILLS: Ability to write transact-sql code to extract correct data to answer business questions. SQL Development experience. Extensive experience with creating reports using Microsoft Sql Server Reporting Services. ADDITIONAL BENEFICIAL EXPERIENCE: use and construction of Microsoft Sql Server Analysis Services; Sharepoint (using the BI Stack). Strong attention to detail for validation of all queries constructed. Ability to visualize data into a form that effectively answers the business question.
Basic Qualification :
Additional Skills :
Rank :C1
Requested Date :2023-02-14