SQL Developer

4 weeks 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 Developer

    4 weeks ago

    Trenton, United States Sunrise Systems Full time

    Title: Database Manager/Administrator Location: Hamilton, NJ Duration: 10 months contract with possible extensions. Provides technical leadership for architecture, design, documentation and maintenance of an internal database and related systems. Please note that this is a hybrid role that requires an in-person interview. This role is critical...

  • Informatica PC Developer

    5 days ago

    Trenton, United States eTeam Full time

    1. Informatica Powercenter and SAP BODS hands-on experience, along with knowledge of pl/Sql 2. Design, develop, test and implement data pipelines based existing Informatica PowerCenter and SAP BODS and SQL Server technologies. 3. Review existing pipelines for opportunities to tune, optimize and harden Creates ETL Dataflows, Jobs, Mappings, Mapplets,...

  • Senior Snowflake Developer

    3 weeks 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...

  • Tableau Developer

    1 month ago

    Trenton, United States Datawize Technologies LLC Full time

    **Program Support Specialist (Tableau Developer)** **Work Hours : Monday-Friday,9am-5pm (35 hours per week)** **Lunch Period : 1hour (Unpaid)** **Work from office or remote: Hybrid** **Assignment location: 50East State Street, Trenton NJ 08625** **Job Type: Contract** **Job Duration: 12 Month** **Job Description: - ** **Equipment to be used by staffing...

  • Tableau Developer

    4 weeks 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 + Datacom DB Developer

    2 weeks 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

  • Mainframe + Datacom DB Developer

    4 days 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

  • Python Developer at Sira Consulting

    4 weeks ago

    Trenton, United States CareerBuilder Full time

    You are viewing a preview of this job. Log in or register to view more details about this job. 0-3+ years of experience in Python Programming. Background with object oriented programming / scripting, Python preferred Able to create in-house applications / framework leveraging 3rd party APIs Ability to write and troubleshoot SQL a plus Knowledge of code...

  • Senior Microsoft Power BI Developer

    3 weeks ago

    Trenton, United States Feeding America Full time

    As the Senior Microsoft Power Bi Developer, you will work to transform raw data into relevant insights via interactive and simple-to-understand dashboards and reports. You will work closely with members of the CFBNJ team to streamline and improve the existing reports and dashboards while helping to create the next generation of tools meet future needs. End...

  • Project Lead

    4 weeks ago

    Trenton, United States Barnes & Noble Full time

    Barnes & Noble is the world’s largest retail bookseller and the leading retailer of content, digital media and educational products. We operate over 600 Barnes & Noble bookstores in 50 states and one of the web’s premier e-commerce sites, bn.com. Our Nook Digital business offers a lineup of popular NOOK® tablets and eReaders and an expansive collection...

  • Computer Systems Analyst

    4 weeks ago

    Trenton, United States New York Technology Partners Full time

    Work under the direct supervision of the VP for Business Operations and Development and assist him with IT-related business development and management, proposal writing, financial analysis including: (a) identify, interview and work with IT subject matter experts to understand and gather Clients' business requirements and technical specifications,...

  • Senior Business Systems/Data Analyst

    4 days ago

    Trenton, United States New York Technology Partners Full time

    Work under the direct supervision of the VP for Business Operations and Development and assist him with IT-related business development and management, proposal writing, financial analysis including: (a) identify, interview and work with IT subject matter experts to understand and gather Clients' business requirements and technical specifications,...

  • Health Data Specialist II

    2 weeks ago

    Trenton, United States Biogensys Full time

    Job DescriptionJob DescriptionWe are hiring a Health Data Specialist II for one of our clients in Trenton, NJ.Job Description:Assist managing NJ Hospital Uniform Billing (UB) database in AWS environment, including checking data consistencies and data quality. Fulfill internal and external UB data requests.Quality check of UB daily extract data.Fulfill...

  • Terradata Analyst

    4 weeks ago

    Trenton, United States Carvechi Technology Full time

    Carvechi technology is hiring for a Teradata Analyst Administrator based in Union, New Jersey. Job Description: This Terradata position is responsible for primarily supporting Teradata environment that will include configuration, administration and maintenance of non-production and production environments. This position must have advanced working knowledge...

  • Junior Business Intelligence Analyst

    1 month ago

    Trenton, United States Datawize Technologies Full time

    **Equipment to be used by staffing professional**:Computer, printer, phone, etc. **Computer software to be used **:Microsoft Word, Teams, Outlook, Excel, Tableau Desktop/Cloud, Tableau Prep, REDCap or other survey tools. **Knowledge, skills, education, and/or experience **:Applicants must meet one of the following or a combination of both experience and...

  • Solutions Architect

    4 days ago

    Trenton, United States Gridiron IT Full time

    Gridiron IT is seeking a Solutions Architect to support a 100% remote opportunity. The solutions architect is responsible for creating and implementing the product architecture. The architect should be hands-on, steering solution engineering team to deliver on both functional and non-functional requirements while ensuring future product evolution with...

  • Lead - Programmer Analyst

    3 weeks ago

    Trenton, United States ValueMomentum Full time

    TRAVEL: Must be willing to relocate and work anywhere in the US. Work in Insurance Domain with a focus on organizational deliverables, best practices and client management. Perform duties as Business and Application system analyst and support expert for Insurance frontend and backend applications, Rating Applications, Policy Administration Systems. Identify...

  • Sr.Consultant 2-Tableau

    4 days ago

    Trenton, United States Global Pharma Tek Full time

    Title: Sr.Consultant 2-Tableau - Location: Trenton,NJ(REMOTE) Duration:1 year contract Short Description: Sr.Tableau Architect will be working with business and technical group to design, develop, and implement Tableau reporting solution from inception to implementation. Experience with Business Objects is Required. Complete Description: Note: Position can...

  • Pgr Mgr

    4 weeks ago

    Trenton, United States CyberTec Full time

    Job title : Pgr Mgr - Power BI Duration : 12 months + Location : Trenton,NJ (Local only, In Person INterview) Req Exp : 8+yrs Rate :$60/hr Client : confidential until I speak to the potential candidates for further details. Required Skills: •Senior level hands-on skills in building Reports, Dashboards, Scorecards and Reports using Power BI •7+ years of...

  • Sr.Consultant 2-Tableau

    2 weeks ago

    Trenton, United States Global Pharma Tek Full time

    Title: Sr.Consultant 2-Tableau - Location: Trenton,NJ(REMOTE) Duration:1 year contract Short Description: Sr.Tableau Architect will be working with business and technical group to design, develop, and implement Tableau reporting solution from inception to implementation. Experience with Business Objects is Required. Complete Description: Note: Position...