Talent.com
Core Software Technologies Inc.
SQL DeveloperCore Software Technologies Inc. • Trenton, New Jersey, United States
SQL Developer

SQL Developer

Core Software Technologies Inc. • Trenton, New Jersey, United States
30+ days ago
Salary
$50.00 hourly
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

    Similar jobs

    Senior Data Analyst with Guidewire- Remote

    André Global, Inc.Princeton, NJ, United States
    Remote
    Full-time

    Data Analyst with Guidewire platform experience for a long-term project with our Direct Client located in New Jersey.ROLES & RESPONSIBILITIESYou will be responsible for understanding business n... Show more

     • Promoted

    Network Real Estate Administrator/ Specialist

    TriOptusBedminster, NJ, United States
    Full-time

    Network Real Estate Administrator/Specialist.Location: Blue Bell, PA 19422 / Bedminster, NJ 07921.Duration: 24 months (possible extension).Shift: Normal Business Hours or 8:00 AM - 5:00 PM.Must Hav... Show more

     • Promoted

    Senior Full Stack Web Developer-Remote-Must be on W2 / 1099 only (No C2C)

    Apetan Consulting llcCrosswicks, NJ, United States
    Remote
    Full-time

    Fully Remotetime zone flexible maybe EST or central hours is good or if in PST- can start 7amSr.Full Stack Web Developer(React / Typescript / Next.Developer)We are seeking a REMOTE highly skilled S... Show more

     • Promoted

    Salesforce Developer - Remote

    Kanak Elite Services IncPrinceton, NJ, United States
    Remote
    Full-time

    Hello There,My name is Amit Kumar , and I serve as the Sr.Technical Recruiter at Kanak-IT INC.I am reaching out to share an excellent career opportunity for the role of Salesforce Developer with He... Show more

     • Promoted

    Oracle EDI Architect (with Gentran Experience) || Remote work

    AppLab Systems IncPrinceton, NJ, United States
    Remote
    Full-time

    Oracle EDI Architect (with Gentran Experience) Remote work 1 month ago Be among the first 25 applicants Please share profiles for the below role.Job Title :Oracle EDI Architect (with Gentran Experi... Show more

     • Promoted

    Testing Data Engineer, Remote EST

    Open Systems TechnologiesTrenton, NJ, United States
    Remote
    Full-time

    Testing Data EngineerFully Remote, Core hours 9am - 5pm ESTSkill set includes :Expertise on Mainframe SystemsTest ManagementData AnalyticsMainframe Database and Data StructureSkilled in DebuggingAg... Show more

     • Promoted

    Business Analyst-Trenton, NJ-(Remote & need only locals)

    Software Technology, Inc.Trenton, NJ, United States
    Remote
    Full-time

    Note: Position is remote and candidate is required to work onsite 1X / Week.The Business Systems Consultant serves as a business analyst for projects involving critical data processing systems for ... Show more

     • Promoted

    Dental Assistant

    Aspen DentalLevittown, PA, United States
    Full-time

    At Aspen Dental, we put You First, offering the security and job stability that comes with working with a world-class dental service organization (DSO).Our best-in-class training program, competiti... Show more

     • Promoted

    Senior BA with Data and Analytics

    Globalpoint IncRaritan, NJ, United States
    Full-time

    Senior Ba With Data And Analytics.Location: Raritan, NJ Duration: 6 Months+ Locals needed.Need to work onsite in Raritan, NJ 3 days per week.Able to work directly with the business and write proper... Show more

     • Promoted

    Sandbox UI Developer- US & Canada EST (Remote) Job at New Jersey Staffing in Tre

    New Jersey StaffingTrenton, NJ, United States
    Remote
    Full-time

    CrowdStrike Sandbox Team Position As a global leader in cybersecurity, CrowdStrike protects the people, processes and technologies that drive modern organizations.Since 2011, our mission hasn't cha... Show more

     • Promoted

    Psychiatrists for Central NJ

    Penn Medicine Princeton House Behavioral HealthNone, NJ, US
    Full-time

    About Princeton House Behavioral Health.At Princeton House Behavioral Health, we have a long-standing reputation as one of the regions leading mental health systems.We offer a full continuum of car... Show more

     • Promoted

    GFEBS Analyst

    Areli, Inc.Joint Base Mdl, NJ, United States
    Full-time

    Customer / Work Location: The USAR 99th RD, Fort Dix, NJ.Potential Position Start Date: June 21, 2026.This Position is Contingent Upon Contract Award.The General Funds Enterprise Business System (G... Show more

     • Promoted

    Remote Software Developer $60 - $120/hourpay

    Micro1Levittown, Pennsylvania, US
    $60.00 hourly
    Remote
    Full-time

    AI data lab for training frontier models and evaluating AI agents.Experts contribute their diverse subject matter knowledge across domains such as finance, healthcare, STEM engineering, and more.AI... Show more

     • Promoted

    Senior Statistical Programmer (Remote)

    Everest Clinical ResearchBridgewater, NJ, United States
    Remote
    Full-time

    Everest Clinical Research (Everest) is a full-service contract research organization (CRO) providing a broad range of expertise-based clinical research services to worldwide pharmaceutical, biotech... Show more

     • Promoted

    Senior Statistical Programmer (Remote)

    Everest Clinical Research Services IncLiberty Corner, NJ, United States
    Remote
    Full-time

    Everest Clinical Research (Everest) is a full-service contract research organization (CRO) providing a broad range of expertise-based clinical research services to worldwide pharmaceutical, biotech... Show more

     • Promoted

    Algebra Private Tutoring Jobs Levittown

    SuperprofLevittown, Pennsylvania, US
    Full-time +1

    Superprof is the leading tutoring platform in the USA, connecting passionate individuals with eager learners.We operate in over 41 countries, making education accessible to everyone, everywhere.Sup... Show more

     • Promoted

    ServiceNow Developer (W2 ONLY)

    TEKsystemsPennington, NJ, US
    Temporary

    Must be eligible to work in the US without sponsorship***.Senior ServiceNow ITSM Developer, 18 month contract.Expert level ServiceNow Developer with 5 + years of experience preferably in an enterpr... Show more

     • Promoted

    Cloud Software Engineer (100% Remote)

    Analytic Search Group, Princeton NJPrinceton, NJ, United States
    Remote
    Full-time

    Well established Healthcare Services company in Princeton NJ seeks a talented Cloud Software Engineer (100% Remote) to join an expanding team remote team.You'll have the opportunity to work with cu... Show more

     • Promoted

    Adobe Analytics Developer-remote

    FIRST SOFTSOLUTIONS INCPrinceton Junction, NJ, United States
    Remote
    Full-time

    We are Hiring Adobe Analytics Developer for my Client.Looking for W2 or 1099 candidates only.Below is the JD if you are comfortable then submit the resume along with DL and Visa copy.Job Title :Ado... Show more

     • Promoted

    Mid QA Engineer - Data & ETL Testing (100% Remote)

    Syncreon ConsultingLevittown, PA, United States
    Remote
    Full-time

    Job DescriptionRequirementsBachelor's or Master's degree in Computer Science or a related field.Strong understanding of Data Warehousing (DW) , ETL , and Data Quality concepts.Proficiency in SQL , ... Show more