What are the responsibilities and job description for the Senior Data Analyst position at State of Delaware?
Zealtech Inc Partnered with CAI for Job opening with State of DE -DOF.
Worksite flexibility
Hybrid
Job Summary
Client: State of DE - DOF
Hybrid (3 days/week in Wilmington, DE) - Candidate must be local
Great communication skills is a must
Candidate cannot have additional vendor layers
USC or GCH - Candidate must willing to move to full time with CAI after 6 months
Job Description
We are looking for a Senior Data Analyst to gather and validate requirements, validate designs, and develop database solutions. This position will be full-time and hybrid.
What You’ll 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 on-premise 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 You'll 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 data-oriented 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 problem-solving skills
Physical Demands
- Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state and local standards
- Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.
- Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor
Target End Date:
2028-09-30
Contact : raj@zealtechus.com call 5103779165
