Data Management Consultant

We are seeking a Consultant - Data Management with strong hands-on expertise in Oracle, Snowflake, SQL performance tuning, data quality, and financial data models. This is a pure relational database role and is not suitable for candidates whose recent experience is primarily focused on AWS Glue, Databricks, Hadoop, or PySpark-based data ingestion., * Analyze, optimize, and tune SQL queries in Oracle and Snowflake environments.

• Perform SQL performance analysis using Explain Plan and other optimization techniques.
• Troubleshoot complex data and system issues through root cause analysis.
• Identify and resolve data quality and data profiling issues.
• Design and review relational database models, including normalization (2NF/3NF), denormalization, and dimensional modeling.
• Understand and work with Financial Data Models, including Party and Party Relationship structures.
• Gather, analyze, and document business requirements.
• Translate business requirements into functional specifications, use cases, and technical designs.
• Participate in technical design reviews, testing, UAT, and release planning.
• Manage requirement traceability, scope changes, and change control.
• Collaborate with business stakeholders and technology teams on enterprise data initiatives.
• Contribute to SDLC improvements and enterprise data management best practices.

The ideal candidate will have experience optimizing SQL performance, analyzing complex data quality issues, working with Collibra, and partnering with business and technology teams to define functional requirements and implement enterprise data solutions., * 6+ years of hands-on SQL development and optimization.

• Strong Oracle SQL expertise.
• Strong Snowflake SQL expertise.
• SQL Performance Tuning.
• Explain Plan analysis.
• Query optimization.
• Data Quality and Data Profiling.
• Collibra.
• Financial Data Model knowledge.
• Party & Party Relationship data models.
• Requirements gathering and documentation.
• Functional specifications and use case development.
• Strong stakeholder communication.

Preferred Skills

• Data Modeling.
• Banking Data Structures.
• Artificial Intelligence exposure.
• Enterprise Data Analytics.
• SDLC best practices.
• Agile methodologies.
• Operational Architecture.
• Systems Integration.