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
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
Position : SQL Server developer with AWS Cloud Migration Upgrade experience Location : Piscataway, NJ Overview : &l...Show moreLast updated: 4 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 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 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 
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
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: 3 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 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 
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 
MessageBody"> Oracle eBS Technical Application Developer Remote Rate : : $85 / hr IBM Internal &...Show moreLast updated: 3 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 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 
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 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 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 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
- Promoted
Database Developer
VirtualVocationsElizabeth, New Jersey, United StatesFull-time
SQL Server developer with AWS Cloud Migration Upgrade experience
IT EBusiness Consulting Services, IncPiscataway, NJ, United StatesFull-time +2
Quick Apply
- Promoted
Senior SAS Developer
VirtualVocationsToms River, New Jersey, United StatesFull-time
- Promoted
Collibra Developer
VirtualVocationsToms River, New Jersey, United StatesFull-time
- Promoted
Oracle Developer
VirtualVocationsNewark, New Jersey, United StatesFull-time
- Promoted
Senior SQL Server DBA
Shulman Fleming & PartnersIselin, NJ, USFull-time
- Promoted
DBA
MondoPhiladelphia, PA, USPermanent
- Promoted
Database Architect SME
VirtualVocationsNewark, New Jersey, United StatesFull-time
- Promoted
Senior SQL Server Developer
VirtualVocationsToms River, New Jersey, United StatesFull-time
- Promoted
Oregon Licensed Epic Developer
VirtualVocationsElizabeth, New Jersey, United StatesFull-time
Oracle PL / SQL Developer
DEW Softech, IncPhiladelphia, PA, Pennsylvania, USA- Promoted
MuleSoft Developer
VirtualVocationsNewark, New Jersey, United StatesFull-time
Oracle eBS Technical Application Developer
Vezita Healthcare Inc / DBA - Vezita ConsultingNJ, United StatesFull-time
Quick Apply
- Promoted
PostgreSQL Database Administrator
VirtualVocationsToms River, New Jersey, United StatesFull-time
- Promoted
Domino Database Developer
Black Rock Solutions CorporationPennington, NJ, USFull-time
- Promoted
Oracle Database Developer
VirtualVocationsNewark, New Jersey, United StatesFull-time
PostgreSQL Database Developer
CGSPhiladelphia, Pennsylvania, United States, 19102Full-time
- Promoted
SQL Server Database Administrator
VirtualVocationsElizabeth, New Jersey, United StatesFull-time
- Promoted
Oracle Cloud Developer
VirtualVocationsElizabeth, New Jersey, United StatesFull-time
Tableau Developer
Core Software Technologies Inc.Trenton, New Jersey, United StatesFull-time
Quick Apply