SQL Developer

7 months ago

Trenton, United States Core Software Technologies Inc. Remote Work Freelance Full time $50 - $65
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.

  • SQL Database Administrator

    1 month ago

    Trenton, United States Insight Global Full time

    Title: AWS & SQL Database AdministratorLocation: West Trenton, NJ - hybrid 3 days per week onsite, 2 remoteJob DescriptionOne of our top insurance clients is looking to add an AWS Database Administrator to their team. This individual will be designing, developing, implementing, and configuring cloud databases and using AWS data services to build...

  • Java Developer

    1 month ago

    Trenton, United States JobRialto Full time

    Job Summary: We are seeking a skilled Java Developer to analyze, design, code, and test Java/HTML/CSS/SQL applications and web services. This full-time hybrid contract role involves developing and maintaining applications, collaborating with non-technical end users, and ensuring adherence to departmental standards. Ideal candidates will have a minimum of 6...

  • Senior Java Developer Position

    3 weeks ago

    Trenton, New Jersey, United States JobRialto Full time

    Job SummaryWe are seeking a skilled Full Stack Java Developer to analyze, design, code, and test Java/HTML/CSS/SQL applications and web services at JobRialto. This hybrid contract role involves developing and maintaining applications, collaborating with non-technical end users, and ensuring adherence to departmental standards.Key Responsibilities:- Analyze...

  • Senior Snowflake Developer

    7 months ago

    Trenton, United States Core Software Technologies Inc. Remote Work Freelance Full time $65 - $70

    A Senior Snowflake Developer is a highly skilled professional responsible for designing, implementing, and optimizing data solutions using the Snowflake cloud data platform. This role plays a pivotal part in architecting data warehouses, data lakes, and ETL processes to enable efficient data storage, processing, and analytics for the...

  • Senior Snowflake Developer

    2 weeks ago

    Trenton, New Jersey, United States Core Software Technologies Inc. Full time

    About the Role:">This is a highly sought-after position for an expert data architect who will lead the design, implementation, and optimization of cloud-based data solutions using Snowflake. The successful candidate will be responsible for creating efficient data warehouses, data lakes, and ETL processes that enable our organization to store, process, and...

  • Senior Business Intelligence Developer

    3 weeks ago

    Trenton, New Jersey, United States CyberTec Full time

    Job OverviewCyberTec is seeking an experienced Senior Business Intelligence Developer to lead the design and implementation of our Power BI solution. This role will be responsible for creating advanced reports, dashboards, and scorecards using Power BI.The ideal candidate will have at least 7+ years of experience with Microsoft BI stacks such as Power Pivot,...

  • Business Intelligence Developer

    1 week ago

    Trenton, New Jersey, United States TerraCycle Full time

    Job OverviewThe Senior Power BI Analyst is a key member of our data analytics team, responsible for developing, maintaining, and optimizing Power BI dashboards and reports. This role collaborates with various departments to gather requirements, analyze data, and deliver high-quality visualizations that support business goals.Primary ResponsibilitiesDesign,...

  • WebFocus Developer

    2 weeks ago

    Trenton, New Jersey, United States Resource Informatics Group Full time

    Job Title: WebFocus DeveloperWe are seeking a skilled WebFocus Developer to join our team at Resource Informatics Group. As a WebFocus Developer, you will be responsible for developing reports utilizing WebFocus 8 (Information Builders). Your ability to follow a UML Diagram provided by an end user will enable you to create multiple WebReports. You should...

  • Sr. Tableau Developer

    4 days ago

    Trenton, United States Scubyt Full time

    Title: Sr. Tableau DeveloperLocation: Trenton, NJ (Hybrid 3 Days onsite)Duration: Long Term ContractNote: We Dashboard Expert and strong Data Visualization experience.We are seeking an experienced Senior Tableau Developer with over 10 years of expertise in Business Intelligence and Salesforce data integration to join our team in Trenton, NJ. The ideal...

  • Sr. Tableau Developer

    7 days ago

    Trenton, United States Scubyt Full time

    Title: Sr. Tableau DeveloperLocation: Trenton, NJ (Hybrid 3 Days onsite)Duration: Long Term ContractNote: We Dashboard Expert and strong Data Visualization experience.We are seeking an experienced Senior Tableau Developer with over 10 years of expertise in Business Intelligence and Salesforce data integration to join our team in Trenton, NJ. The ideal...

  • Mainframe + Datacom DB Developer

    1 week ago

    Trenton, United States Omni Inclusive Full time

    Datacom DB is mandatory skill understanding of functionality using MF Technology and interface Consultant with Tech and BU, More BU centric - Online and Batch, Cobol, CICS, MVS- Data store: CA-Datacom, SQL enabled Table, DB2 MQ, CA-Librarian, VSAM, TSO, ROSCOE, DQuery

  • Tableau Developer

    7 months ago

    Trenton, United States Core Software Technologies Inc. Remote Work Freelance Full time $50 - $65

    Responsibilities:Data Visualization:Develop interactive and visually appealing dashboards using Tableau.Design and implement charts, graphs, maps, and other visualization elements to effectively communicate data insights.Data Connection and Integration:Connect Tableau to various data sources, including databases, spreadsheets, and cloud-based...

  • Mainframe Development Expert for Mission-Critical Systems

    4 weeks ago

    Trenton, New Jersey, United States Kyndryl Full time

    About KyndrylAt Kyndryl, we design and modernize the technology systems that the world depends on. As a COBOL Mainframe Application Developer, you will support development on the department of labor client's existing payment software system.The RoleYou will create and use programming specs to build assigned components, ensuring they are properly documented,...

  • Java Software Engineer Opportunity

    3 weeks ago

    Trenton, New Jersey, United States JobRialto Full time

    About the RoleJobRialto is looking for a highly skilled Full Stack Java Developer to join our team. As a key member of our development team, you will be responsible for analyzing, designing, coding, and testing Java/HTML/CSS/SQL applications and web services.Key Tasks and Responsibilities:- Identify suitable technology solutions based on business...

  • Senior Data Architect

    3 weeks ago

    Trenton, New Jersey, United States Core Software Technologies Inc. Full time

    About the RoleWe are seeking a highly skilled Senior Snowflake Developer to join our team at Core Software Technologies Inc.Job DescriptionThis is a pivotal role in architecting data warehouses, data lakes, and ETL processes to enable efficient data storage, processing, and analytics for our organization. Key responsibilities include designing and...

  • Technical Solutions Architect

    3 weeks ago

    Trenton, New Jersey, United States GS1 US Full time

    Key ResponsibilitiesCollaborate on the architecture and solution design of set of core services, ensuring they meet functional and non-functional requirements.Develop and optimize complex SQL queries and stored procedures in Azure SQL.Mentor and guide other engineers on technical best practices and problem-solving.Provide technical leadership and direction...

  • Data Transformation Specialist

    1 month ago

    Trenton, New Jersey, United States Core Software Technologies Inc. Full time

    Job DescriptionWe are seeking an experienced Data Transformation Specialist to join our team at Core Software Technologies Inc. in a SQL Engineer role focused on data modeling.About the Role:Design and implement efficient data transformations and models using data to create structured, cleaned, and aggregated datasets.Develop and maintain accurate data...

  • Senior Cloud Solutions Architect

    1 month ago

    Trenton, New Jersey, United States Panna Knows Full time

    Unlock Career Growth with Panna KnowsPanna Knows brings industry communities together to solve supply-chain problems through innovative solutions.About the RoleThis is a unique opportunity for a skilled Solution Engineer to join our team and make a meaningful impact on the way the world does business. You will be responsible for designing, developing, and...

  • Azure Cloud Architect

    4 weeks ago

    Trenton, New Jersey, United States Panna Knows Full time

    We are seeking a highly skilled Azure Cloud Architect to join our team at Panna Knows in Ewing, NJ.Estimated salary: $180,000 - $250,000 per year.The successful candidate will have a minimum of 8 years of experience in software development, with a focus on C# and .NET, as well as 5+ years of experience working with Azure, including Azure SQL, App Service,...

  • Senior Data Modeler Specialist

    2 days ago

    Trenton, United States Crescens Full time

    Job title : Senior Data Modeler Specialist Location: Trenton , NJ (Hybrid) Duration : 6+ monthsJob Responsibilities: This SDM position is for designing and implementing modern data modeling solutions using relational, dimensional, snowflake, star, data lake that meet Judiciary needs using conceptual, logical, and physical data models. The SDM should be...