Overview
On Site
Depends on Experience
Contract - W2
Contract - 1 Year(s)
Skills
Agile
Cloud Computing
Continuous Delivery
Continuous Integration
Data Migration
Data Modeling
Data Quality
Data Structure
Database
Debugging
Functional Requirements
Legacy Systems
Management
Normalization
Performance Tuning
Query Optimization
Release Management
SQL
Scalability
Scripting
Snow Flake Schema
Sprint
Testing
Job Details
Job Title: SQL Developer
Location: NY/NJ
Type: W2 Only
The Opportunity
As part of the Data Modelling and Entitlements team, you will leverage the latest technology stack to develop and implement innovative data solutions. You ll be responsible for gathering and delivering both functional and non-functional requirements aligned with Pershing-X standards and project timelines. Your work will include reviewing existing requirements, designing robust data architectures, and enabling effective project deployment.
Key Responsibilities
- Design, implement, and manage SQL queries for consumption across multiple stakeholders.
- Detect and resolve data quality and integrity
- Develop or enhance logical and physical data models to meet evolving business needs.
- Apply data modelling techniques ensuring high performance and scalability.
- Conduct testing and debugging of code to ensure accuracy and reliability.
- Create data mappings from legacy systems to new structures.
- Perform data migration using industry-standard tools and best practices.
- Optimize SQL using explain plans, trace files, indexing, and partitioning
- Collaborate with business stakeholders and Agile teams to define, document, and implement application and data structures.
- Ensure all deliverables adhere to quality standards and are completed within each sprint cycle.
Skills for Success
- 5+ years of experience with diverse database technologies.
- Strong expertise in SQL development, query optimization, and tuning.
- Proficient in data modelling with knowledge of normalization, ER diagrams, and schema design.
- Experience in query plan analysis, performance tuning, and schema refinement.
- Familiar with CI/CD practices, including Liquibase (a plus).
- Exposure to cloud platforms (Snowflake preferred).
- Ability to write, manage, and deploy database scripts efficiently.
- Experience working with change and release management
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.