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

    Healthcare Data Analyst: Insights & Dashboards

    Intermountain HealthTrenton, New Jersey, United States
    A tiempo completo

    A leading healthcare organization is seeking a Data Analyst-Technical-Staff to contribute to data analytics development and support strategic initiatives.This role involves collaborating with clini...Mostrar más

     • Oferta promocionada

    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 Senior SQL Engineer - AI Trainer

    SuperAnnotateLevittown, Pennsylvania, US
    Teletrabajo
    A tiempo completo

    As a Senior SQL Engineer, you will work remotely on an hourly paid basis to review AI-generated SQL queries, database designs, and data-processing logic, as well as generate high-quality reference ...Mostrar más

    Business Developer

    BrightView LandscapesHamilton, NJ, US
    A tiempo completo

    The Best Teams are Created and Maintained Here.The Business Developer (BD) works to improve BrightView’s market position and achieve profitable financial growth.This role helps to achieve long-term...Mostrar más

    Dynamic CRM Architect

    Diligent Tec IncPrinceton, NJ, New Jersey, USA
    A tiempo completo +1

    Job Title: Dynamic CRM Lead / Architect Location: Remote Type: Full Time Permanent Experience: Minimum 12+ years of experience Job ...Mostrar más

    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

    Data & Analytics / Enterprise Architecture

    Raas InfotekWarren, NJ, United States
    A tiempo completo

    Data & Analytics / Enterprise Architecture.Need candidates with strong P&C insurance domain experience.Platform Implementation & Configuration.Lead end-to-end design, configuration, and deployment ...Mostrar más

     • Oferta promocionada

    Remote Econometric Data Analyst (Stata SE)

    Micro1Fort Dix, New Jersey, 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

    Salesforce Developer - Remote

    Kanak Elite Services IncPrinceton, NJ, United States
    Teletrabajo
    A tiempo completo

    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...Mostrar más

     • Oferta promocionada

    Senior Principal Enterprise Data & AI Architect

    UKG (Ultimate Kronos Group)Trenton, NJ, United States
    A tiempo completo

    At UKG, the work you do matters.The code you ship, the decisions you make, and the care you show a customer all add up to real impact.Today, tens of millions of workers start and end their days wit...Mostrar más

     • Oferta promocionada

    Chief Real-Time Software Architect - Radar & EW Systems

    Technology Service Corporation Defense ServicesBedminster Township, NJ, United States
    A tiempo completo

    A leading defense technology firm is seeking a Chief Software Architect to lead software engineers and develop sustainable architectures.This role requires a strong background in real-time software...Mostrar más

     • Oferta promocionada

    Camstar Opcenter Developer

    Teamware SolutionsRaritan, NJ, United States
    A tiempo completo

    Essential Skills: Camstar Opcenter Developer.Skills: Camstar (Siemens Opcenter).Mostrar más

     • Oferta promocionada

    Senior BA with Data and Analytics

    Globalpoint IncRaritan, NJ, United States
    A tiempo completo

    Senior Business Analyst With Data And Analytics.Location: Raritan, NJ Duration: 6 Months+ Locals needed Need to work onsite in Raritan, NJ 3 days per week.Mostrar más

     • Oferta promocionada

    Software Developer

    OutlierTrenton, NJ, United States
    A tiempo completo

    Outlier helps the world’s most innovative companies improve their AI agents by providing human feedback.We collaborate with leading AI organizations to train Large Language Models (LLMs) to functio...Mostrar más

     • Oferta promocionada

    Online Casino Tester

    ReeledgeLevittown, Pennsylvania, United States
    A tiempo completo

    Join our distributed team and help evaluate online platforms through interactive testing assignments.This is a flexible, remote opportunity with full training provided and no prior experience requi...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

    Adobe Analytics Developer-remote

    FIRST SOFTSOLUTIONS INCPrinceton Junction, NJ, United States
    Teletrabajo
    A tiempo completo

    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...Mostrar más

     • Oferta promocionada

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

    Syncreon ConsultingLevittown, PA, United States
    Teletrabajo
    A tiempo completo

    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 , ...Mostrar más