Senior Data Analyst - Architect

Job: Senior Data Analyst - Architect

Employment Type:

Full time - Contract

Worksite flexibility

Hybrid

Hybrid (3 days/week in Wilmington, DE) - Candidate must be local
Great communication skills is a must

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