Senior Data Analyst
Location: Wilmington DE (Hybrid)
Duration: 6 Months (CTH)
Note: Only USA GC
Job Description
We are looking for a Senior Data Analyst to gather and validate requirements validate designs and develop database solutions.
What Youll Do
- Create maintain and tune complex SQL scripts
- Create and maintain existing SQL based custom reports
- Maintain complex data models
- Create and maintain data interfaces (scripted ETL) between our onpremise Oracle environment and MS SQL Server on the Azure based platform
- Build and maintain Oracle Data Marts and associated ETL processes
- Import / Export data from SQL Server/Oracle XML and CLOB Queries and convert data to standard Oracle tables
- Accurately develop database queries reports data loads/extracts in a logical manner from scratch
- Create new and maintain/tune existing SQL queries and procedures
- Create and maintain existing SQL based custom reports
What Youll Need
Required:
- 7 years of experience as a Senior Database Analyst/Architect
- BS/MS degree in Computer Science Engineering or a related subject
- Extensive experience in all aspects of Oracle SQL programming and query manipulation
- Experience working with MS SQL Server databases
- Extensive experience working with large sets of data and resolving dataoriented issues
- Extensive experience with data profiling and data quality assurance. This includes the understanding of creating an audit trail for peer review of work completed
- Extensive experience in tuning queries for optimal performance
- Ability to work directly with business users to quickly translate business reporting requests/requirements and produce a work product that has been vetted for quality and meets requirements as stated
- Strong communication skills both written and oral
- Ability to investigate and identify query performance related issues
- Critical thinker and problemsolving skills
MS SQL Server,ETL,SQL scripts