Job Description

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 : [email protected] call 5103779165

Job Tags

Similar Jobs