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

    Retail Scan Associate (Hainesport, NJ 08036)

    ScanScapeHainesport, NJ, United States
    Part-time +1

    This is a permanent PART-TIME role.ScanScape Retail Scan Associates visit a designated selection of stores each week to scan all product barcodes on displays and in aisle locations, including aisle... Show more

     • Promoted

    Senior Business Analyst Oracle FLEXCUBE Corporate Banking ewing, NJ

    ESR HealthcareTrenton, NJ, United States
    Full-time

    Senior Business Analyst Oracle FLEXCUBE Corporate Banking.Experience level: Mid-senior Experience required: 10 Years Education level: Bachelors degree Job function: Information Technology Industry:... Show more

     • Promoted

    Billing Analyst

    TRAC IntermodalPrinceton, NJ, United States
    Full-time

    Job Category: Finance Requisition Number: ANALY001722.Hybrid - Princeton | Hybrid - Princeton Plainsboro Twp, NJ 08540, USA.Assist with entering alpha/numeric information into the company database.... Show more

     • Promoted

    Project Estimator (Construction) - Boston

    SyscoMount Holly, NJ, United States
    Full-time

    This Project Estimator is responsible for project estimation, quotes, AutoQuotes proposals, expediting orders, and coordinating multiple projects.This role will collaborate directly with sales, pro... Show more

     • Promoted

    Tableau Developer

    Sunrise SystemsTrenton, New Jersey, United States
    $66.66 hourly
    Full-time
    Quick Apply

    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 more

    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

    Decision Analytics Consultant - Evidence Generation

    ZS AssociatesPrinceton, NJ, United States
    Full-time

    Decision Analytics Consultant/h2pZS is a place where passion changes lives.As a management consulting and technology firm focused on improving life and how we live it, we transform ideas into impac... Show more

     • Promoted

    Database Engineer - Bold Cape

    Delta Point Family of CompaniesRaritan, New Jersey, US
    Full-time

    Job DescriptionJob DescriptionDescription:.The Database Engineer will support the ESCAPE program and broader enterprise data initiatives by designing, implementing, and maintaining scalable, secure... Show more

     • Promoted

    www.brightviewcareers.com

    BrightViewTrenton, NJ, United States
    Full-time

    The Best Teams are Created and Maintained Here.Business Developer works to improve BrightView's market position and achieve profitable financial growth.This role helps to achieve long-term organiza... Show more

     • Promoted

    Data Financial Reporting Analyst

    Horizon Blue Cross Blue Shield of New JerseyHopewell, NJ, United States
    Full-time

    Data Financial Reporting Analyst.Horizon Blue Cross Blue Shield of New Jersey empowers our members to achieve their best health.For over 90 years, we have been New Jersey's health solutions leader ... Show more

     • Promoted

    SQL DBA-Remote

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

    Job Title :SQL DBARemoteDuration :1 yearInterview Method :WebsitePosition Overview :The SQL DBA will be responsible for database analysis, development, and administration - including data modeling,... Show more

     • Promoted

    OpenText Exstream Developer

    Purple Drive TechnologiesWarren, NJ, United States
    Full-time

    Business Analyst -Artificial Intelligence.Senior Business Analyst with AI.Leverage generative AI tools to accelerate requirements creation, user story development, and documentation while maintaini... Show more

     • Promoted

    Remote Medical Coding Consultant | AHIMA/AAPC Certified

    United Cerebral Palsy of GeorgiaTrenton, New Jersey, United States
    Remote
    Full-time

    Datavant is looking for a Medical Coding Consultant to join their team.This role involves providing consulting services and educational support to enhance medical coding practices in healthcare env... Show more

     • Promoted • New!

    Business Development Analyst - CIS (Cloud Infrastructure & Security Services)

    CognizantBridgewater, NJ, United States
    Full-time

    Business Development Analyst - CIS.Cognizant Technology Solutions is seeking a qualified Business Development Analyst - CIS professional to develop and maintain relationships with potential and exi... Show more

     • Promoted

    Sr Lead Business Analyst - Onsite

    The Dignify Solutions, LLCRaritan, NJ, United States
    Full-time

    Collaborating with IT teams to ensure seamless integration of data from various sources and systems.Ensuring compliance in data management and analysis processes.Suggesting innovative approaches fo... Show more

     • Promoted

    Sr. Tableau Developer

    Sunrise SystemsTrenton, New Jersey, United States
    Full-time
    Quick Apply

    Location: Trenton, NJ (Hybrid position - 3 Days On-Site, 2 Days Remote.Duration: 11 months of contract.Need a very Senior, technically in depended, Tableau developer to gather business requirements... Show more

    Tableau Developer

    Core Software Technologies Inc.Trenton, New Jersey, United States
    $50.00 hourly
    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 more

    Specialist, Maintenance Data

    AbbVieNeshanic Station, NJ, United States
    Full-time

    Provide support to the department utilizing multiple software platforms with purpose of entering and maintaining accurate records within MAXIMO, Cognos, SAP and KRONOS.Also Provide front line audit... Show more