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

    Tableau QA Engineer

    Daiichi SankyoBasking Ridge, NJ, US
    $60.00 hourly
    Temporary

    Employment as a Contingent Worker aligns well with individuals seeking career flexibility and non-traditional work arrangements, while also being motivated to produce exceptional results in promine... Show more

     • Promoted

    Senior SQL Server Architect & Data Reliability

    Mbi LlcHamilton, NJ, United States
    Full-time

    A leading technology firm is seeking an experienced Database Administrator to design and implement complex database solutions.The ideal candidate will have over 8 years of SQL Server administration... 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

    Data Entry Product Support - No Experience

    GLOCPAFalls township, Pennsylvania
    $15.00 hourly
    Part-time +1

    Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet... Show more

     • Promoted

    Quantitative Developer

    SynechronPennington, NJ, United States
    Full-time

    At Synechron, we believe in the power of digital to transform businesses for the better.Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital ... 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

    Junior Cloud & Data Architect — Remote & ETL Focus

    Quantum Integrators GroupWest Windsor, NJ, United States
    Remote
    Full-time

    A leading IT solutions firm is looking for a Solution Architect to design and implement enterprise cloud solutions.You will work closely with the Enterprise Architecture team on tasks like architec... Show more

     • Promoted

    Telecommunication Research Engineer

    MacrosoftBedminster, NJ, United States
    Full-time

    Role: Analytical Software Engineer.Mode of Work: Onsite for 5 days.Must Have PhD Degree in related field of study.Research and develop intelligent solutions for.RAN performance and automation.Manag... Show more

     • Promoted

    Grant Data Architecture Lead (Hybrid Contract)

    Blockchain Technologies. LLCTrenton, NJ, United States
    Full-time

    A leading technology firm in Trenton, New Jersey is seeking a Data Analysis Architect for a full-time contract role.The position involves conducting requirements analysis and overseeing data manage... 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

    Senior Manager, Clinical Database Applications and Reporting (m/f/d)

    Daiichi Sankyo, Inc.Basking Ridge, NJ, US
    Full-time

    At Daiichi Sankyo, we are united by a single purpose, to improve lives around the world through innovative medicines.With a legacy of innovation since 1899, a presence in more than 30 countries, an... Show more

     • Promoted

    Remote Software Developer $60 - $120/hourpay

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

    Real-world expertise is turned into training data, evaluations, and feedback loops that improve how models perform.AI labs and enterprises use micro1 to train models and build reliable AI agents th... Show more

     • Promoted

    Senior Software Engineer — Distributed Data and Retrieval Platform

    BloombergPrinceton, NJ, United States
    Full-time

    Senior Software Engineer — Distributed Data and Retrieval Platform.Bloomberg runs on financial data.Every price, corporate action, benchmark, security master update, point-in-time view, and derived... 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

    Data Architect AI-Driven Analytics & Cloud Data Platform

    Compunnel, Inc.Trenton, NJ, United States
    Full-time

    A leading technology solutions provider is seeking an experienced Data Architect in Trenton, NJ to design and implement data solutions that support analytics and AI-driven initiatives.The ideal can... Show more

     • Promoted • New!

    Quantum Computing Co-Founder / CPTO (100 % remote) (m/f/d)

    EWORPrinceton, NJ, United States
    Remote
    Full-time

    Quantum Computing Co-Founder / CPTO (100 % remote) (m/f/d).Be among the first 25 applicants.We are looking to hire ambitious entrepreneurs to start and scale their own startups.We are serial entrep... Show more

     • Promoted • New!

    Solution Architect

    Quantum Integrators GroupWest Windsor, NJ, United States
    Full-time

    Entry / Early Career (6 months – 1 year).The Solution Architect will design and implement enterprise cloud solutions, working closely with the Enterprise Architecture team to plan, deploy, and main... Show more