Senior Data Analyst: SQL Tuning & Data Quality Lead

Capgemini; New York (NY); On-site; USD 95,000 - 130,000; Full time

Benefits offered by this job

Benefit package

In-office work 3 days a week

Compensation and benefits

Job summary

Capgemini in New York City is seeking a Senior Data Engineer to optimize SQL queries across Oracle and Snowflake and ensure data quality within financial data models. You will collaborate with Universal Client Manager technology teams to translate business requirements into functional designs and use cases, and guide end-to-end data solutions.

Onsite from Day 1, 3 days/week in the office. Experience with denormalization, dimensional modeling, and star/snowflake schemas is required, along with

Qualifications

• Proven expertise in SQL performance analysis and tuning across Oracle and Snowflake environments.
• Handson experience investigating and remediating data quality issues including root cause analysis and corrective preventive actions
• Demonstrated ability to elicit and document business requirements and translate them into functional specifications use cases and technical designs
• Familiarity with operational architecture systems integration and cross functional application implementation
• Proficiency with requirements management practices change control traceability and participation in testing test plans UAT defect triage
• Strong stakeholder management and communication skills with the ability to consult and influence across business and technology teams

Responsibilities

• Analyze optimize and benchmark SQL queries across Oracle and Snowflake diagnose and resolve highly complex performance and data quality issues through rigorous root cause analysis
• Collaborate with Universal Client Manager technology teams to define specifications design documents and functional use cases for system enhancements and integrations
• Elicit challenge and prioritize business requirements using standard processes and templates translate requirements into clear functional designs user stories and use case documentation
• Develop project scope objectives constraints and assumptions for large strategic multiyear initiatives ensure alignment to business outcomes and operational architecture
• Provide consultation to IT and business management on applying technology to business opportunities plan and guide implementation of cross functional applications and systems
• Participate in and provide guidance on technical design reviews test planning and user documentation ensure end-to-end traceability from requirements through testing and release
• Manage scope changes and dependencies using formal requirements management principles including change control traceability and stakeholder signoffs
• Gather and analyze quantitative and qualitative data to develop recommendations addressing strategic objectives across multiple global business and technology areas
• Engage in industry forums to maintain current domain knowledge incorporate best practices into solution design and process improvements
• Apply experience with software systems development processes to design and implement improved methodologies actively influence continuous improvement in SDLC and data practices
• May allocate and coordinate work within a team or project ensuring delivery quality and timeline adherence

Skills

SQL performance analysis

SQL tuning

Explain Plans

Denormalization techniques

Dimensional Data Modeling

Star schemas

Snowflake schemas

Data Quality Analysis

Data Profiling

Data Validation and Reconciliation

Tools

Oracle

Snowflake

Job description

Capgemini in New York City is seeking a Senior Data Engineer to optimize SQL queries across Oracle and Snowflake and ensure data quality within financial data models. You will collaborate with Universal Client Manager technology teams to translate business requirements into functional designs and use cases, and guide end-to-end data solutions.

Onsite from Day 1, 3 days/week in the office. Experience with denormalization, dimensional modeling, and star/snowflake schemas is required, along with