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

SQL Developer

Core Software Technologies Inc. • Trenton, New Jersey, United States
Hace más de 30 días
Tipo de contrato
  • A tiempo completo
  • Quick Apply
Descripción del trabajo
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.

    Crear una alerta de empleo para esta búsqueda

    SQL Developer • Trenton, New Jersey, United States

    Ofertas similares

    Netcool Developer with AIOps Cloud Pak Expertise

    Purple DriveBasking Ridge, NJ, New Jersey, USA
    A tiempo completo

    We are seeking an experienced Netcool Developer with strong expertise in IBM Cloud Pak for AIOps (CP4AIOps) to support integration, migrat...Mostrar más

    Remote Econometric Data Analyst (Stata SE)

    Micro1Levittown, Pennsylvania, US
    Teletrabajo
    A tiempo completo

    Econometric Data Analyst (Stata SE).AI labs train foundational models and enterprises build AI agents.We provide frontier evaluations and reinforcement learning environments used to improve LLM cap...Mostrar más

     • Oferta promocionada

    ROLL TENDER

    Journal Register OffsetPrinceton, NJ, US
    A tiempo completo

    IT Professionals (Multiple Positions / Openings) Software Engineer: Research, analyze, design, test, implement & configure software apps using various techs.Computer Programmer: Write comp programs...Mostrar más

     • Oferta promocionada

    Data Entry Product Support - No Experience

    GLOCPAFalls township, Pennsylvania
    A tiempo parcial +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...Mostrar más

     • Oferta promocionada

    WebMethods Migration Lead – Cloud Carve-Out

    Quantum IntegratorsRaritan, New Jersey, US
    A tiempo completo

    Role: WebMethods Migration Lead – Cloud Carve-Out - (Onsite, Client-Facing).Location: Raritan, NJ – Onsite.You could be just the right applicant for this job Read all associated information and mak...Mostrar más

     • Oferta promocionada • Nueva oferta

    Make an Impact & Earn $60K–$115K — Surrogacy with Full Support & Fast Matching

    Alpha FidelisCountry Lake Estates, NJ, US
    A tiempo completo +1

    Earn While You Job Search — Become a Surrogate ✨.Searching for your next opportunity while supporting your family isn’t easy.What if you could earn meaningful income.Why This Opportunity Stands Out...Mostrar más

     • Oferta promocionada

    Get Paid for Surveys – $1000 CashApp

    The American SurveyFinderne, New Jersey, United States
    A tiempo completo

    Join The American Survey, complete short online surveys, and earn $1000 sent directly to your CashApp.It’s quick, easy, and can be done from anywhere.Sign up today and turn your voice into cash.Mostrar más

     • Oferta promocionada

    PL/SQL Developer

    Programmers.ioPrinceton, NJ, United States
    A tiempo completo
    Quick Apply

    Job Description - Strong knowledge and hands on engineering and development experience: Oracle data model and tables design, complex queries development and tuning Oracle PL/SQL and SQL queries dev...Mostrar más

    Senior Software Engineer - Radar Modeling and Simulation

    Bebee, Lockheed MartinLevittown, PA, United States
    A tiempo completo

    Job Description:Who We AreLockheed Martin is dedicated to shaping, developing, & advancing technologies & capabilities with a focus on our customers’ needs as part of our 21st Century Security visi...Mostrar más

     • Oferta promocionada • Nueva oferta

    Data Entry From Home

    Data Entry JobsRoebling, NJ
    A tiempo completo

    Data Entry Specialist (Remote).We're looking for a detail-oriented Data Entry Specialist to join our team from home.In this role, you'll be responsible for accurately inputting, updating, and maint...Mostrar más

     • Oferta promocionada

    Lead, Data Platform Engineer

    Johnson & JohnsonRaritan, New Jersey, NJ, United States
    A tiempo completo

    This job is with Johnson & Johnson, an inclusive employer and a member of myGwork – the largest global platform for the LGBTQ+ business community.Please do not contact the recruiter directly.At Joh...Mostrar más

     • Oferta promocionada • Nueva oferta

    Professional Lease Admin

    JLLBEDMINSTER, NJ, United States
    A tiempo completo

    This job is with JLL, an inclusive employer and a member of myGwork – the largest global platform for the LGBTQ+ business community.Please do not contact the recruiter directly.JLL empowers you to ...Mostrar más

     • Oferta promocionada • Nueva oferta

    County Meter Reader

    Meter ReaderBrowns Mills, NJ
    A tiempo completo

    Responsibilities The primary responsibility of this position is to read meters and record consumption of the water used, cleaning of meter boxes, and removal of vegetation impeding access to meters...Mostrar más

     • Oferta promocionada

    Assoc, Software Engineering (Camden, NJ)

    L3Harris TechnologiesFLORENCE, New Jersey, United States
    A tiempo completo

    L3Harris is dedicated to recruiting and developing high-performing talent who are passionate about what they do.Our employees are unified in a shared dedication to our customers’ mission and quest ...Mostrar más

     • Oferta promocionada • Nueva oferta

    Natural / Adabas Developer/DBA

    Crystal Data LLCTrenton, NJ, US
    A tiempo completo

    Role: Natural / Adabas Developer/DBA Location: Trenton, NJ Contract Role Summary The selected candidate must demonstrate Exceptional Natural programming skills The selected candidate must possess p...Mostrar más

     • Oferta promocionada

    Algebra Private Tutoring Jobs Levittown

    SuperprofLevittown, Pennsylvania, US
    A tiempo completo +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...Mostrar más

     • Oferta promocionada

    OTR Company Driver (CDL-A)

    J.S. Helwig & SonBordentown, NJ, US
    A tiempo completo

    OTR experience in last 3 years.Must be willing to be out for 3 weeks at a time.Safe driving record that meets our minimum requirements.Clean driving record in the past 3 years.Must be at least 22 y...Mostrar más

     • Oferta promocionada • Nueva oferta

    Sales Consultant

    Mattress FirmLevittown, PA, US
    A tiempo completo

    Bilingual preferred — Spanish or Russian.May provide support to the following locations as needed:.Street Road (Route 132), Bensalem, PA 19020.East Street Road, Feasterville-Trevose, PA 19053.Welsh...Mostrar más