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
Job Location Rahway, NJ Remote ok (Yes / No) Y Project Duration 6+Months Project Start date Asap Mode (TP / FTE) TP No of positions 1 Job Title Oracle PL / SQL Lead Client Interview Needed for Selectio...Show moreLast updated: 30+ days ago
Strong SQL background with understanding of TrackWise data structure.Analyzes detailed business, functional and high-level technical requirements.
Configuration and customization of TrackWise system...Show moreLast updated: 30+ days ago
W2 candidates only , or open to visa transfers - Sr.Please email resume with current location details.Your Current location (City & State).
Would you need visa transfer in future.Must have some fina...Show moreLast updated: 30+ days ago
Genesis10 is currently seeking an Oracle Developer with SSIS with our client in the financial industry located in Pennington, NJ.
This is a 12+ month contract position.Responsibilities include desig...Show moreLast updated: 30+ days ago
Duration : 11 Months On Contract.Note : This is a Hybrid position - 3 Days On-Site, 2 Days Remote.Under the direction of an IT Supervisor, gather business requirements, design, build and deploy BI so...Show moreLast updated: 24 days ago
Location - Iselin, NJ (Hybrid Onsite 2x per week.The right candidate needs to have people management experience.They are still doing all the tech work, but they will be leading people and...Show moreLast updated: 15 days ago
Months Contract (High Possibility of Extension).The NoSQL DBA will be responsible for designing, deploying, and maintaining NoSQL database clusters in Linux environments.
This includes supporting mu...Show moreLast updated: 30+ days ago
US citizen and those authorized to work in the US are encouraged to apply.Skills : 8 years' experience Technical Skills - SQL Queries Technical Skills - SQL Performance Tuning Technical Skills - PL / ...Show moreLast updated: 3 days ago Position Type : Contract to Hire.Analysis, design, coding, performance tuning, and implementation of BI and database solutions.
Evaluation, maintenance, and enhancement of existing processes.Analysis...Show moreLast updated: 3 days ago Job Title : SQL and SAS Reporting Consultant.SQL and SAS Reporting "Proficiency with SAS programming, including SAS Visual Analytics or Viya visualizations.
Strong SQL Server development utilizing Ma...Show moreLast updated: 30+ days ago 
Technology Lead | SQL SSIS | SQL Server.Work Location & Reporting Address : Livingston, NJ 07039.Contract duration (in months) : 6.
Target Start Date : 19 Mar 2018.Does this position require Visa indep...Show moreLast updated: 3 days ago
E •Pro Consulting service offerings include contingent Staff Augmentation of IT professionals, Permanent Recruiting and Temp-to-Hire.
In addition, our industry expertise and knowledge within financia...Show moreLast updated: 3 days ago
Location : Princeton, NJ - Onsite.Skillset Primary Skills RDBMS Oracle PLSQL.Secondary Skills ETL, Data Warehousing.Additional database competency is an added advantage.
Diverse Lynx LLC is an Equal ...Show moreLast updated: 30+ days ago US Citizen and Green Card preferred- No Third Party C2C Candidates.One of our clients is looking for minimum 4 years of experience on Tableau with Agile experience.Show moreLast updated: 3 days ago Maximum Salary 115K / Annum + Benefits.Having minimum 8+ years of IT experience with minimum 4 year experience in PL / SQL and ESP / IRD.
Good to have Jasper experience.Show moreLast updated: 3 days ago 
Be among the first 25 applicants.LTIMindtree is an equal?opportunity employer committed to diversity in the workplace.Our employment decisions are made without regard to race, color, creed, religio...Show moreLast updated: 3 days ago Should have strong Tableau knowledge and leading in various types of charts in dashboards, identifying KPIs which improve business operations for clients.
Providing support to reports and Tableau ap...Show moreLast updated: 3 days ago
SQL Database Administrator
DEW Softech, IncTrenton, NJ, New Jersey, USA- Promoted
Oracle PL / SQL Lead
Tekfortune IncRahway, NJ, United StatesFull-time
- Promoted
PLSQL Developer
Syntricate TechnologiesShort Hills, NJ, United StatesFull-time
- Promoted
W2 ONLY - opening for Sr Oracle Developer
Mitchell MartinPennington, NJ, United StatesFull-time
- Promoted
Oracle Developer with SSIS
Genesis10Pennington, NJ, United StatesTemporary
Tableau Developer
Sunrise SystemsTrenton, New Jersey, United StatesFull-time
Quick Apply
Lead SQL, DBA
Direct Recruit AgencyMiddlesex, New Jersey, United StatesFull-time
Quick Apply
NoSQL DBA, NJ
Career Mentors, LLCPennington, NJ, USTemporary
- Promoted
Oracle PL SQL Developer - Pennington, NJ
Staffing the UniversePennington, NJ, United StatesFull-time
- Promoted
BI / SQL Developer - Bedminster, NJ
Staffing the UniverseBedminster, NJ, United StatesFull-time
- Promoted
SQL and SAS Reporting Consultant
Syntricate TechnologiesEwing Twp, NJ, United StatesFull-time
- Promoted
Technology Lead | SQL SSIS | SQL Server
ClifyXLivingston, NJ, United StatesFull-time
- Promoted
Oracle Developer
E-ProHopewell, NJ, United StatesPermanent
- Promoted
Oracle PL / SQL Developer
Diverse LynxPrinceton, NJ, United StatesFull-time
- Promoted
Tableau Developer - Skillman, NJ
Staffing the UniverseSkillman, NJ, United StatesFull-time
- Promoted
Oracle Pl / SQL Developer, - Princeton, NJ.
Staffing the UniversePrinceton, NJ, United StatesFull-time
- Promoted
Oracle PLSQL Developer
Jobs via DiceEdison, NJ, United StatesFull-time
- Promoted
tableau Application developer
ClifyXRaritan, NJ, United StatesFull-time