Talent.com
SQL Developer

SQL Developer

Core Software Technologies Inc.Trenton, New Jersey, United States
job_description.job_card.30_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
  • serp_jobs.filters_job_card.quick_apply
job_description.job_card.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.

    serp_jobs.job_alerts.create_a_job

    Sql Developer • Trenton, New Jersey, United States

    Job_description.internal_linking.related_jobs
    • serp_jobs.job_card.promoted
    Database Developer

    Database Developer

    MondoPhiladelphia, PA, US
    serp_jobs.job_card.full_time +1
    Apply now : Database Developer, location is Hybrid (Philadelphia, PA).The start date is 7 / 21 for this permanent position. Hybrid (Center City Philadelphia, PA – 1 day / week onsite).Develop and m...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Database Developer

    Database Developer

    VirtualVocationsNewark, New Jersey, United States
    serp_jobs.job_card.full_time
    A company is looking for a Database Developer (Postgres / AWS).Key Responsibilities Design, develop, and implement cloud-based database architectures Manage and optimize Postgres / AWS Aurora en...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    SQL Server Replication DBA

    SQL Server Replication DBA

    GovServicesHubWoodbridge, NJ, us
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Job Title : SQL Server Replication DBA.Location : Woodbridge, NJ – 4 days / week.SQL Server Replication DBA (with Oracle, AWS, Python & Grafana). Looking for a seasoned SQL Server Replicati...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Data Architect

    Data Architect

    Novocure IncPhiladelphia, PA, United States
    serp_jobs.job_card.full_time
    We are seeking an experienced and innovative Data Architect to lead the design, development, and optimization of our enterprise data architecture. This individual will play a critical role in aligni...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Senior SQL Performance Engineer (T-SQL) (Morristown)

    Senior SQL Performance Engineer (T-SQL) (Morristown)

    Beacon HillMorristown, NJ, US
    serp_jobs.job_card.part_time
    Responsible for data performance enhancements to the production server environment.Have an interest in data and business logic. Ability to provide insights into software solutions and identify failu...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Data Developer / Architect

    Data Developer / Architect

    VirtualVocationsElizabeth, New Jersey, United States
    serp_jobs.job_card.full_time
    A company is looking for a Data Developer / Architect responsible for designing, building, and optimizing data systems and solutions. Key Responsibilities : Design, develop, and maintain scalable d...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Oracle Database Developer

    Oracle Database Developer

    VirtualVocationsElizabeth, New Jersey, United States
    serp_jobs.job_card.full_time
    A company is looking for an Applications Development Engineer.Key Responsibilities Develop and optimize Oracle databases, including advanced PL / SQL programming and procedure design Manage and mo...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Senior SQL Database Administrator

    Senior SQL Database Administrator

    InteProsPhiladelphia, PA, US
    serp_jobs.job_card.full_time
    Senior SQL Server Database Administrator – Performance Tuning Specialist.We are seeking a highly skilled Senior SQL Server DBA with deep expertise in performance tuning, query optimization, a...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    NoSQL DBA, NJ

    NoSQL DBA, NJ

    Career Mentors, LLCPennington, NJ, US
    serp_jobs.job_card.temporary
    Months Contract (High Possibility of Extension).The NoSQL DBA will be responsible for designing, deploying, and maintaining NoSQL database clusters in Linux environments. This includes supporting mu...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Tableau Developer

    Tableau Developer

    VirtualVocationsPhiladelphia, Pennsylvania, United States
    serp_jobs.job_card.full_time
    A company is looking for a Revenue Cycle Analyst (Tableau) to work remotely.Key Responsibilities Translate existing reports into Tableau Dashboard visualizations Develop new Tableau dashboards t...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Senior Database Developer

    Senior Database Developer

    VirtualVocationsElizabeth, New Jersey, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Analyst / Database Developer to enhance data analytics capabilities in the pharmaceutical industry. Key Responsibilities Design, develop, and maintain the DATAstrea...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    Technical Lead - PostgreSQL

    Technical Lead - PostgreSQL

    smart folks incPennington, NJ, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Job Title Technical Lead - PostgreSQL Location - : PENNINGTON , NJ (3 Day...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Data Developer

    Data Developer

    VirtualVocationsPhiladelphia, Pennsylvania, United States
    serp_jobs.job_card.full_time
    A company is looking for a Data Developer / Architect for a remote position supporting the Department of Veterans Affairs (VA) Health Connect program. Key Responsibilities : Design, develop, and ma...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Oracle APEX Programmer

    Oracle APEX Programmer

    VirtualVocationsPhiladelphia, Pennsylvania, United States
    serp_jobs.job_card.full_time
    A company is looking for an Oracle APEX Programmer II.Key Responsibilities Collaborate with technical leads, developers, and internal business customers Design, develop, maintain, and test PL / SQ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Senior SQL Performance Engineer (T-SQL)

    Senior SQL Performance Engineer (T-SQL)

    Beacon Hill07961, NJ, US
    serp_jobs.job_card.full_time
    Responsible for data performance enhancements to the production server environment.Have an interest in data and business logic. Ability to provide insights into software solutions and identify failu...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Tax Expert - Onsite - 2+ Yrs Paid Tax Experience Required

    Tax Expert - Onsite - 2+ Yrs Paid Tax Experience Required

    IntuitCHESTERFIELD, New Jersey, United States
    serp_jobs.job_card.full_time
    Intuit is seeking highly motivated individuals to join our dynamic team as dedicated TurboTax Live Seasonal Local Service Experts in one of our new TurboTax locations across the United States on a ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    Sr. Tableau Developer

    Sr. Tableau Developer

    Sunrise SystemsTrenton, New Jersey, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.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...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    Tableau Developer

    Tableau Developer

    Core Software Technologies Inc.Trenton, New Jersey, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.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...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30