Talent.com
SQL Developer

SQL Developer

Core Software Technologies Inc.Trenton, New Jersey, United States
30+ days ago
Job type
  • Full-time
  • Quick Apply
Job description

Strong SQL  Developer with an understanding of Data Build Tool (DBT)

Responsibilities :

Data Transformation and Modeling :

  • Design and implement data transformations and models using data to create structured, cleaned, and aggregated datasets.
  • Develop and maintain data models that accurately represent business logic and data requirements.

SQL Expertise :

  • Write and optimize SQL queries within dbt to extract, manipulate, and join data from various sources (e.g., databases, APIs, flat files).
  • Ensure SQL code follows best practices for readability, performance, and maintainability.
  • Version Control :

  • Use version control systems (e.g., Git) to manage dbt codebase, enabling collaborative development and tracking changes over time.
  • Collaborate with data engineers and analysts to coordinate code changes.
  • Testing and Documentation :

  • Implement unit tests within dbt to verify the accuracy and reliability of data transformations.
  • Document dbt models, data lineage, and transformations to facilitate understanding and collaboration.
  • Automation :

  • Schedule and automate dbt runs to keep data models up-to-date and synchronized with source systems.
  • Implement data orchestration and scheduling as needed.
  • Data Quality Assurance :

  • Develop and enforce data quality checks and validations within dbt to identify and rectify data issues.
  • Monitor data quality and integrity, responding to anomalies or discrepancies.
  • Performance Optimization :

  • Optimize dbt models and queries for performance, identifying and addressing bottlenecks.
  • Analyze and fine-tune data processing pipelines to meet performance requirements.
  • Collaboration :

  • Collaborate closely with data engineers, data analysts, and business stakeholders to understand data requirements and deliver data solutions.
  • Participate in cross-functional teams and contribute to data-related projects.
  • Security and Compliance :

  • Ensure data security and compliance with relevant data protection regulations (e.g., GDPR, HIPAA) through appropriate data handling practices.
  • Knowledge Sharing :

  • Share knowledge of dbt best practices and data modeling techniques with team members.
  • Provide training and support to data analysts and other users of dbt.
  • Qualifications :

  • Bachelor's or master's degree in computer science, data science, or a related field.
  • Strong proficiency in SQL and experience working with relational databases.
  • 3+ years of experience using dbt for data transformation and modeling in a data warehouse environment (e.g., Snowflake, BigQuery, Redshift).
  • 7+ years of experience building business rules using a business rules engine similar to dbt
  • Familiarity with version control systems (e.g., Git) and code collaboration workflows.
  • Excellent data analysis and problem-solving skills.
  • Strong attention to detail and a commitment to data quality.
  • Understanding of data warehousing concepts and best practices.
  • Knowledge of data governance and data security principles.
  • Effective communication and collaboration skills to work with diverse teams.
  • Experience with other data tools and languages (e.g., Python, R, Looker) is a plus.
  • About Core Software Technologies Inc. :

    Core Software Technologies has practical experience in giving best in class business innovation answers for associations. Since several years, we are empowering organizations with integrated technologies and to enable them to meet the advancing business requests.We cooperate with associations and create solid and long term relationships. Our evolution in thought-administration, very qualified and experienced business innovation specialists.

    Create a job alert for this search

    Sql Developer • Trenton, New Jersey, United States

    Related jobs
    • Promoted
    DBA

    DBA

    MondoPhiladelphia, PA, US
    Permanent
    Apply now : Database Administrator, location is Hybrid (Philadelphia, PA).The start date is 7 / 21 or 7 / 28 for this permanent position. Hybrid (Philadelphia, PA – 1 day / week onsite) (Usually on W...Show moreLast updated: 30+ days ago
    • Promoted
    Database Architect SME

    Database Architect SME

    VirtualVocationsNewark, New Jersey, United States
    Full-time
    A company is looking for a Database Architect, SME.Key Responsibilities Collaborate with stakeholders to design scalable database solutions based on business requirements Implement database stan...Show moreLast updated: 4 days ago
    Oracle E-Business Database Administrator

    Oracle E-Business Database Administrator

    DEW Softech, IncPhiladelphia, PA, Pennsylvania, USA
    Full-time
    Calibri,sans-serif"> <...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Teradata Developer

    Senior Teradata Developer

    Resource Informatics Group IncPhiladelphia, PA, US
    Full-time
    Comcast is expanding the Data Experience (dX) Team.The role of the Analyst, Data Governance is to partner with teams across the organization to document business and technical metadata inclusive of...Show moreLast updated: 30+ days ago
    • Promoted
    Senior SQL Server Developer

    Senior SQL Server Developer

    VirtualVocationsToms River, New Jersey, United States
    Full-time
    SQL Server Developer with Oracle (Production Support) - Remote.Key Responsibilities Develop, optimize, and troubleshoot database objects in SQL Server and Oracle Ensure smooth operations in prod...Show moreLast updated: 4 days ago
    • Promoted
    Database Engineer

    Database Engineer

    Tegra118 Wealth Solutions, Inc.Warren, NJ, US
    Full-time
    InvestCloud is looking for a practical, detail-focused Database Engineer with a passion for financial data and a desire to grow into a hands-on architecture or platform engineering role.This is a g...Show moreLast updated: 30+ days ago
    Oracle Architect

    Oracle Architect

    Signature ConsultantsUSA, New Jersey, NJ OR Dallas
    Full-time
    Quick Apply
    Jersey City, NJ OR Dallas, TX OR Tampa, FL (Hybrid Role).Seeking an Oracle Architect to lead data integration and analytics strategies across Oracle platforms. This hands-on role supports Finance an...Show moreLast updated: 25 days ago
    Oracle PL / SQL Developer

    Oracle PL / SQL Developer

    DEW Softech, IncPhiladelphia, PA, Pennsylvania, USA
    Full-time
    Aptos,sans-serif"> Oracle PL / SQL Developer ...Show moreLast updated: 30+ days ago
    (DOE-027-25) Tableau Developer (Project Specialist)

    (DOE-027-25) Tableau Developer (Project Specialist)

    New Jersey Department of EducationTrenton, NJ, US
    Full-time
    Quick Apply
    Notice of Vacancy Reference Number : .DOE-027-25 Title : Tableau Developer (Project Specialist) Range / Title Code : P98 / 60005 Salary : $88,529. Position Number : 105328 Issue Date : August 22, 2025 Clo...Show moreLast updated: 30+ days ago
    • Promoted
    Application Developer

    Application Developer

    Robert HalfPhiladelphia, PA, US
    Full-time
    We are seeking a talented and experienced Technical Developer to join our Legal Operations team.This role is ideal for someone passionate about technology, problem-solving, and collaborat...Show moreLast updated: 30+ days ago
    • Promoted
    Senior SAS Developer

    Senior SAS Developer

    VirtualVocationsNewark, New Jersey, United States
    Full-time
    SAS Developer - DW Decommissioning & Migration.Key Responsibilities Develop and migrate SAS data warehouse queries to GCP Identify gaps and guide requirements for GCP development teams Work wit...Show moreLast updated: 30+ days ago
    • Promoted
    PostgreSQL Database Administrator

    PostgreSQL Database Administrator

    VirtualVocationsToms River, New Jersey, United States
    Full-time
    A company is looking for a PostgreSQL Database Administrator with a strong background in data integration.Key Responsibilities Design, implement, and maintain PostgreSQL databases, ensuring high ...Show moreLast updated: 30+ days ago
    • Promoted
    Domino Database Developer

    Domino Database Developer

    Black Rock Solutions CorporationPennington, NJ, US
    Full-time
    Domino DB developer (need migration background).It’s a Migration project – taking out of Domino and store into html / pdf. Notes is the interphase with Domino.Project is to archive and mig...Show moreLast updated: 30+ days ago
    Tableau Developer (Onsite)

    Tableau Developer (Onsite)

    GSK SolutionsTrenton, NJ, United States
    Full-time
    Quick Apply
    MessageBody"> Job Title : Tableau Developer (Onsite) Location : &...Show moreLast updated: 4 days ago
    PostgreSQL Database Developer

    PostgreSQL Database Developer

    CGSPhiladelphia, Pennsylvania, United States, 19102
    Full-time
    Employment Type : Full Time, Experienced level.Department : Information Technology.CGS is seeking a PostgreSQL Database Developer to join our team supporting a rapidly growing Data Analytics and Busi...Show moreLast updated: 26 days ago
    • Promoted
    Collibra Developer

    Collibra Developer

    VirtualVocationsNewark, New Jersey, United States
    Full-time
    A company is looking for a Collibra Developer to join their Data Delivery and Governance team.Key Responsibilities Design, develop, and implement technical integrations and workflows within the C...Show moreLast updated: 3 days ago
    • Promoted
    Senior ERP Developer

    Senior ERP Developer

    VirtualVocationsNewark, New Jersey, United States
    Full-time
    A company is looking for a Senior ERP Developer to support and enhance their SQL-based Sage ERP system.Key Responsibilities : Lead the design and architecture of ERP customizations using.NET, SQL ...Show moreLast updated: 30+ days ago
    Tandem Developer

    Tandem Developer

    Codetech IncNJ, United States
    Full-time +3
    Quick Apply
    Job Description : Experience range from 7-15 years; strong experience on Authorization switches and products like BASE24, Connex.Should ...Show moreLast updated: 6 days ago
    Tableau Developer

    Tableau Developer

    Core Software Technologies Inc.Trenton, New Jersey, United States
    Full-time
    Quick Apply
    Develop interactive and visually appealing dashboards using Tableau.Design and implement charts, graphs, maps, and other visualization elements to effectively communicate data insights.Data Connect...Show moreLast updated: 30+ days ago
    db architect

    db architect

    Purple DrivePISCATAWAY, New Jersey, USA
    Full-time
    DB Architect Looking for a Database Architect with strong expertise in Oracle DB design, cloud-based database deployment, and data migration using AWS tools an...Show moreLast updated: 30+ days ago