SQL Developer

6 days ago

Greenwich Twp, NJ, United States Zortech Solutions Full time
Role: SQL Developer (SQL Queries)

Location: Pittsburgh, PA, 240 Greenwich office, NYC, Lake Mary, FL-Onsite

Duration: W2/Fulltime

Job Description:

The Opportunity

As a part of Reference data modeling team, you will use the latest technology stack and will have an opportunity to develop and implement new solutions. Being responsible and accountable for gathering and delivery of functional and non-functional requirements in accordance with the Pershing-X standards and timeframe. Review existing business requirements and ensure they contain appropriate design and architectural components support the deployment of projects.

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

  • SQL and SAS Reporting Consultant

    2 weeks ago

    Ewing Twp, NJ, United States Syntricate Technologies Full time

    Job Title: SQL and SAS Reporting Consultant Location: Ewing, NJ Duration: Contract Job Description: SQL and SAS Reporting "Proficiency with SAS programming, including SAS Visual Analytics or Viya visualizations Strong SQL Server development utilizing Management Studio and Integration ServicesAbility to reverse engineer SQL Server Reporting Services...

  • SQL Database Engineer

    1 week ago

    Readington Twp, NJ, United States Georgia IT Inc Full time

    SQL Database Engineer Duration: 6+ Months CTH Location: Philadelphia, PA & Whitehouse Station, NJ (Hybrid) (3 Days in office & 2 Days Remote) Description: The Global Actuarial Systems team is a small, agile group of technology enthusiasts. We are tasked with solving the complex data needs of both US and International reserving and pricing actuaries. Our...

  • SQL Database Engineer

    2 weeks ago

    Readington Twp, NJ, United States Georgia IT Inc Full time

    SQL Database Engineer Duration: 6+ Months CTH Location: Philadelphia, PA & Whitehouse Station, NJ (Hybrid) (3 Days in office & 2 Days Remote) Description: The Global Actuarial Systems team is a small, agile group of technology enthusiasts. We are tasked with solving the complex data needs of both US and International reserving and pricing actuaries. Our...

  • Database Developer

    2 weeks ago

    Hamilton Twp, NJ, United States InterSources Full time

    Responsibilities Design and develop database systems that are efficient, scalable, and secure. Required to determine the appropriate database architecture, data storage, and indexing techniques. Hands-on experience in building new relational data models, tables, views, functions, grants, triggers, stored procedures, indexes Required. 2Work closely with...

  • Database Developer

    1 week ago

    Hamilton Twp, NJ, United States InterSources Full time

    Responsibilities Design and develop database systems that are efficient, scalable, and secure. Required to determine the appropriate database architecture, data storage, and indexing techniques. Hands-on experience in building new relational data models, tables, views, functions, grants, triggers, stored procedures, indexes Required. 2Work closely with...

  • Deltek Maconomy Extender Developer

    1 day ago

    Southampton Twp, NJ, United States 5 Star Global Recruitment Partners Full time

    About the job Deltek Maconomy Extender Developer Qualifications Deltek Maconomy Extender certified | Experience in JavaScript, Java, Mscript (proprietary language) for technical candidates. Fundamental understanding of in GL, AP, AR, FA of ERP Functions PL/SQL, Core Java Job Description : PL SQL and Core Java Deltek Maconomy Extender Developer & Certified...

  • Deltek Maconomy Extender Developer Southampton, NJ $$$ bonus

    1 week ago

    Southampton Twp, NJ, United States ESR Healthcare Full time

    About the job Deltek Maconomy Extender Developer (8238-1 Southampton, NJ $$$ bonus Experience in JavaScript, Java, Mscript (proprietary language) for technical candidates. Fundamental understanding of in GL, AP, AR, FA of ERP Functions If you post this job on a job board, please do not use company name or salary. Experience level: Mid-senior Experience...

  • Software Development Engineer

    1 day ago

    Bridgewater Twp, NJ, United States iconectiv Full time

    #Location - Hybrid - Bridgewater, NJ About iconectiv Your business and your customers need to confidently access and exchange information simply, seamlessly and securely. iconectiv's extensive experience in information services, digital identity and numbering intelligence helps you do just that. In fact, more than 5K customers rely on our data exchange...

  • Software Developer

    6 days ago

    Egg Harbor Twp, NJ, United States EVTKS Full time

    Benefits: 401(k) matching Dental insurance Health insurance Paid time off Job Summary You will support the NextGen Weather Processor (NWP) team, which transforms meteorological weather (forecast model data) into aviation-specific weather information for air traffic controllers to manage air traffic more efficiently around hazardous weather areas. You will...

  • Software Developer

    1 day ago

    Egg Harbor Twp, NJ, United States EVTKS Full time

    Benefits: 401(k) matching Dental insurance Health insurance Paid time off Job Summary You will support the NextGen Weather Processor (NWP) team, which transforms meteorological weather (forecast model data) into aviation-specific weather information for air traffic controllers to manage air traffic more efficiently around hazardous weather areas. You will...