SQL Developer
Core Software Technologies Inc.Trenton, New Jersey, United States30+ days ago
Job type
- Full-time
- Quick Apply
Job descriptionWrite 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. 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. 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. Schedule and automate dbt runs to keep data models up-to-date and synchronized with source systems. Implement data orchestration and scheduling as needed. 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. Optimize dbt models and queries for performance, identifying and addressing bottlenecks. Analyze and fine-tune data processing pipelines to meet performance requirements. 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. Ensure data security and compliance with relevant data protection regulations (e.g., GDPR, HIPAA) through appropriate data handling practices. 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. 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.
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 :
Version Control :
Testing and Documentation :
Automation :
Data Quality Assurance :
Performance Optimization :
Collaboration :
Security and Compliance :
Knowledge Sharing :
Qualifications :
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
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
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
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 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 
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
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
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
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 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 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 
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
MessageBody"> Job Title : Tableau Developer (Onsite) Location : &...Show moreLast updated: 4 days ago
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 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 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 
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 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 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
- Promoted
DBA
MondoPhiladelphia, PA, USPermanent
- Promoted
Database Architect SME
VirtualVocationsNewark, New Jersey, United StatesFull-time
Oracle E-Business Database Administrator
DEW Softech, IncPhiladelphia, PA, Pennsylvania, USA- Promoted
Senior Teradata Developer
Resource Informatics Group IncPhiladelphia, PA, USFull-time
- Promoted
Senior SQL Server Developer
VirtualVocationsToms River, New Jersey, United StatesFull-time
- Promoted
Database Engineer
Tegra118 Wealth Solutions, Inc.Warren, NJ, USFull-time
Oracle Architect
Signature ConsultantsUSA, New Jersey, NJ OR DallasFull-time
Quick Apply
Oracle PL / SQL Developer
DEW Softech, IncPhiladelphia, PA, Pennsylvania, USA(DOE-027-25) Tableau Developer (Project Specialist)
New Jersey Department of EducationTrenton, NJ, USFull-time
Quick Apply
- Promoted
Application Developer
Robert HalfPhiladelphia, PA, USFull-time
- Promoted
Senior SAS Developer
VirtualVocationsNewark, New Jersey, United StatesFull-time
- Promoted
PostgreSQL Database Administrator
VirtualVocationsToms River, New Jersey, United StatesFull-time
- Promoted
Domino Database Developer
Black Rock Solutions CorporationPennington, NJ, USFull-time
Tableau Developer (Onsite)
GSK SolutionsTrenton, NJ, United StatesFull-time
Quick Apply
PostgreSQL Database Developer
CGSPhiladelphia, Pennsylvania, United States, 19102Full-time
- Promoted
Collibra Developer
VirtualVocationsNewark, New Jersey, United StatesFull-time
- Promoted
Senior ERP Developer
VirtualVocationsNewark, New Jersey, United StatesFull-time
Tandem Developer
Codetech IncNJ, United StatesFull-time +3
Quick Apply
Tableau Developer
Core Software Technologies Inc.Trenton, New Jersey, United StatesFull-time
Quick Apply
db architect
Purple DrivePISCATAWAY, New Jersey, USAFull-time