Sr. Data Analyst

CAI

CAI is searching for a skilled Senior Data Analyst to join their team. This role involves gathering and validating requirements, as well as designing and building database solutions. The successful candidate will collaborate with business users to transform reporting requests into high-quality outputs, supporting business objectives.

In this role you can expect to have the responsibilities:

• Create, maintain, and optimize complex SQL scripts.
• Manage existing SQL-based custom reports.
• Maintain intricate data models.
• Build data interfaces and maintain ETL processes.
• Develop Oracle Data Marts and related ETL procedures.
• Handle data export/import between SQL Server/Oracle XML and CLOB Queries.
• Design database queries, reports, and data operations logically.
• Sustain and enhance SQL queries and procedures.

This role requires you to have:

• 7 years of experience as a Senior Database Analyst/Architect.
• BS/MS degree in Computer Science, Engineering, or a related field.
• Extensive Oracle SQL programming expertise.
• Proficiency with MS SQL Server databases.
• Experience with large data sets and data quality assurance.
• Strong query tuning abilities.
• Proficiency in translating business requirements into data solutions.
• Excellent communication skills.
• Critical thinking and problem-solving capabilities.

You would benefit from having:

CAI upholds non-discrimination policies, ensuring equal employment opportunities across various demographics. They emphasize affirmative action to promote diversity and protect against harassment and retaliation.