SQL Developer

Job Title: SQL Developer


Location: Pittsburgh, PA


Job Type: Contract/Full Time


Job Description:

Your key responsibilities
• Design, implement and manage the SQL queries to be consumed by multiple stakeholders.
• Detect and resolve data quality and integrity issues in the dataset.
• Enhance or create new logical and physical data model to meet business needs, applying data modeling standards and naming conventions.
• Apply data modeling techniques to ensure development and implementation meets performance expectations.
• Test and debug the deliverable code to ensure they function correctly.
• Develop data mapping from existing systems to the new data structures.
• Experience in data migration using the industry standard tools.
• Experience in SQL tuning and optimization using explain plan and trace files.
• Partitioning and indexing strategy for optimal performance
• Must have a good verbal and written communication skill with strong interpersonal, analytical, and problem-solving abilities.
• Experience in understanding complex source system data structures preferably in Financial Services
• Ability to work with minimal guidance in a time critical environment.
• Work with business stakeholders and Agile scrum teams on design, definition, documentation, and implementation of features for new applications and data structure


Skills for success
• 8+ years of experience working in different database technologies
• Strong hands on knowledge of SQL
• Apply data modeling techniques to ensure development and implementation meets performance expectations.
• Run query plans, query tuning and schema refinement.
• Help with database migrations and building database scripts
• Work with change and release management teams
• Experience with CI/CD and Liquibase is a plus
• Experience with cloud platforms (Snowflake) is a plus


What we look for
• Strong analytical and problem solving skills.
• A self-starter, independent thinker with ambition and passion
• Excellent inter-personal, communication, collaboration and presentation skills
• Takes responsibility for continuous self-learning.
• Takes the lead and make decisions in critical times and tough circumstances.
• High level of integrity and honesty.
• Ensure deliverables are up to a quality standards at the end of each sprint