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
    Database Developer

    Database Developer

    VirtualVocationsElizabeth, New Jersey, United States
    Full-time
    A company is looking for a Database Developer to design, develop, and maintain secure databases in a remote setting.Key Responsibilities Design, develop, deploy, and maintain relational databases...Show moreLast updated: 30+ days ago
    SQL Server developer with AWS Cloud Migration Upgrade experience

    SQL Server developer with AWS Cloud Migration Upgrade experience

    IT EBusiness Consulting Services, IncPiscataway, NJ, United States
    Full-time +2
    Quick Apply
    Position : SQL Server developer with AWS Cloud Migration Upgrade experience Location : Piscataway, NJ Overview : &l...Show moreLast updated: 4 days ago
    • Promoted
    Senior SAS Developer

    Senior SAS Developer

    VirtualVocationsToms River, 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
    Collibra Developer

    Collibra Developer

    VirtualVocationsToms River, 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
    Oracle Developer

    Oracle Developer

    VirtualVocationsNewark, New Jersey, United States
    Full-time
    A company is looking for an Oracle Developer, Enterprisewide Applications.Key Responsibilities Lead a five-year implementation project for the Oracle EBS suite across multiple locations Mentor j...Show moreLast updated: 30+ days ago
    • Promoted
    Senior SQL Server DBA

    Senior SQL Server DBA

    Shulman Fleming & PartnersIselin, NJ, US
    Full-time
    Hybrid – NYC or Iselin, NJ (Local Only).We're looking for a hands-on SQL Server DBA with at least 5+ years of experience to join our hybrid team. You'll support critical SQL environmen...Show moreLast updated: 30+ days ago
    • 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: 3 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
    Oregon Licensed Epic Developer

    Oregon Licensed Epic Developer

    VirtualVocationsElizabeth, New Jersey, United States
    Full-time
    A company is looking for an Epic Caboodle & Healthy Planet Developer (Application Engineer, Sr.Key Responsibilities Ensure data integrity and validity of the Epic application and define system st...Show moreLast updated: 3 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
    • Promoted
    MuleSoft Developer

    MuleSoft Developer

    VirtualVocationsNewark, New Jersey, United States
    Full-time
    A company is looking for a MuleSoft Developer (Remote).Key Responsibilities Design, develop, and maintain integration solutions using MuleSoft Anypoint Platform Create and manage APIs and micros...Show moreLast updated: 30+ days ago
    Oracle eBS Technical Application Developer

    Oracle eBS Technical Application Developer

    Vezita Healthcare Inc / DBA - Vezita ConsultingNJ, United States
    Full-time
    Quick Apply
    MessageBody"> Oracle eBS Technical Application Developer Remote Rate : : $85 / hr IBM Internal &...Show moreLast updated: 3 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
    • Promoted
    Oracle Database Developer

    Oracle Database Developer

    VirtualVocationsNewark, New Jersey, United States
    Full-time
    A company is looking for an Oracle Database Developer to join their database migration and optimization team.Key Responsibilities : Lead complex Oracle database migrations from legacy systems to m...Show moreLast updated: 2 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
    SQL Server Database Administrator

    SQL Server Database Administrator

    VirtualVocationsElizabeth, New Jersey, United States
    Full-time
    A company is looking for a SQL Database Administrator to manage and maintain Microsoft SQL Server database environments.Key Responsibilities : Administer and maintain SQL Server environments acros...Show moreLast updated: 30+ days ago
    • Promoted
    Oracle Cloud Developer

    Oracle Cloud Developer

    VirtualVocationsElizabeth, New Jersey, United States
    Full-time
    A company is looking for a Cloud Developer.Key Responsibilities Design, develop, and implement integrations for various Oracle modules using Oracle Integration Cloud and REST API Manage procurem...Show moreLast updated: 30+ 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