Senior Data Analyst

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