Duration: Long Term Contract
Job Description
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.
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.
Key Responsibilities
- 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.
Required Skills
- 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.
SYSMIND LLC is an Equal Employment Opportunity employer. All qualified applicants will receive consideration for employment without any discrimination. We promote and support a diverse workforce at all levels in the company. All job offers are contingent upon completion of a satisfactory background check and reference checks. Additionally passing the drug test may also be required. All contractors intending to work on SYSMIND's W2 are "at will" employees.