Data Warehouse Developer

1 month ago


Wilmington, United States DEW Softech, Inc Full time

Data Warehouse Developer

Location: 100% Remote

Contract Duration: 36 months to start

Fully remote (Core EST hours)

MUST have very strong SQL skills and Data Modeling experience please make sure they match all technical qualifications.

Data Vault experience is a huge plus but not required

Looking for a Sr. Level resource and work their way up to an architect level

Job Description:

  • We are looking for a Data Warehouse Developer. This position will be a fulltime and remote contract opportunity.
  • This project involves conversion of legacy data warehouse to a new architecture which includes Data Vault 2.0 and traditional Data Mart.

What Youll Do:

  • Connect to new data sources
  • Explore data model in the data vault and data mart
  • Configure and/or code data vault and data mart structures
  • Code complex stored procedures which implement business rules and load Fact tables
  • Convert complex existing report stored procedures from the legacy warehouse to the new one
  • Validate results using TSQL; document all the differences
  • Troubleshoot code at all levels
  • Work with the report developers as they adapt to using the new warehouse
  • Individual will be on a very small team (23 people) and needs to be a selfstarter who can quickly get up to speed

What Youll Need Required:

  • 6 years of TSQL development. Very strong TSQL skills needed
  • 4 years SSIS experience required
  • Strong database and data warehouse modeling experience
  • Experience with Microsoft database projects (dacpac)
  • Experience with DevOps
  • Experience with Microsoft Access as a front end for SQL Server

Preferred:

  • Experience with advanced TSQL such as dynamic code generation recursion Gaps & Islands desirable
  • SSAS experience desired
  • Exposure to Data Vault

Physical Demands:

  • Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal state and local standards
  • Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings etc.
  • Ability to conduct repetitive tasks on a computer utilizing a mouse keyboard and monitor

t-sql,Data Modeling,Data Vault



  • Wilmington, North Carolina, United States The Chefs' Warehouse Full time

    Join The Chefs' Warehouse team as we seek an experienced Inventory Management Specialist to bolster our operations. With a competitive salary range of $55,000 - $65,000 annually, this role offers an exciting opportunity to contribute to our success.Job Summary: We are looking for a highly skilled and organized individual to oversee inventory control...


  • Wilmington, United States Solenis Full time

    Solenis is a leading global producer of specialty chemicals focused on delivering sustainable solutions for water-intensive industries, including consumer, industrial, institutional, food and beverage, and pool and spa water markets. Owned by Platinum Equity, the company's product portfolio includes a broad array of water treatment chemistries, process aids,...


  • Wilmington, North Carolina, United States The Chefs' Warehouse Full time

    Job Title: Inventory Control ClerkAbout the Job:We are seeking a highly skilled and detail-oriented Inventory Control Clerk to join our team at The Chefs' Warehouse. As an Inventory Control Clerk, you will be responsible for ensuring accurate inventory records, conducting cycle counts, physical inventory, and data entry.Key Responsibilities:Maintain accurate...


  • Wilmington, North Carolina, United States Syntricate Technologies Full time

    Job Title: ETL Developer (Synapse, ADL, SSIS)Job Summary:We are seeking an experienced ETL Developer to join our team at Syntricate Technologies. The ideal candidate will have a strong background in implementing data solutions on MS Azure using Azure Data Factory, Synapse, or Azure SQL Data Warehouse.Key Responsibilities:• Design, implement, and...


  • Wilmington, United States US012 Marsh & McLennan Agency LLC Full time

    Description: Our not-so-secret sauce. Award-winning, inclusive, Top Workplace culture doesn’t happen overnight. It’s a result of hard work by extraordinary people. More than 11,000 of the industry’s brightest talent drive our efforts to deliver purposeful work and meaningful impact every day. Learn more about what makes us different and how...


  • Wilmington, North Carolina, United States Diverse Lynx Full time

    Job Summary We are seeking a highly skilled SAP BODS Developer with Informatica PC experience to join our team at Diverse Lynx LLC. As a key member of our data integration team, you will be responsible for designing and developing ETL solutions using SAP BODS and Informatica PowerCenter. ResponsibilitiesDeploy code across Dev, QA, and Production...


  • Wilmington, North Carolina, United States Diverse Lynx Full time

    Job Summary We are seeking a highly skilled SAP BODS Developer with expertise in Informatica PowerCenter to join our team at Diverse Lynx LLC. As a key member of our data integration team, you will be responsible for designing, developing, and maintaining ETL solutions using SAP BODS and Informatica PowerCenter. Responsibilities:Design and develop ETL...


  • Wilmington, United States Amazon Warehouse Full time

    Job Overview Join Amazon Air and be a part of a dedicated team that sorts packages in the warehouse or loads packages onto the aircraft, ensuring timely delivery to customers. Gain valuable experience in the air cargo industry and receive comprehensive training. Duties & Responsibilities Load and unload aircraft and trucks Prepare packages for sortation and...

  • Data Architect

    1 month ago


    Wilmington, Delaware, United States Liberty Personnel Services, Inc Full time

    Job DescriptionData Architect - Business Intelligence LeaderWe are seeking an experienced Data Architect to lead our business intelligence efforts and design a data architecture that aligns with our business objectives.Key Responsibilities:Design and implement a data architecture that supports business intelligence and analyticsLead a team of data engineers...


  • Wilmington, Delaware, United States City National Bank Full time

    Job Summary:City National Bank is seeking a highly skilled Data Governance Specialist to join our team. As a Data Governance Specialist, you will play a critical role in ensuring the accuracy, consistency, and quality of our data.Key Responsibilities:Implement data management and/or data sourcing capabilities and operations management as outlined in data...


  • Wilmington, United States Diverse Lynx Full time

    Responsibilities: Deploys code across Dev, QA and Production environments using central repositories Develops/Maintains/Supports new and existing data flows from multiple source systems Develops/Maintains/Supports business rules and process around data cleansing, consolidation and validation, etc. Troubleshoots/debugs ETL and SQL query issues and provides...

  • Amazon Package Sorter

    2 months ago


    wilmington, United States Amazon Warehouse Full time

    Amazon Delivery Station Warehouse AssociateJob OverviewYou’ll be part of the dedicated Amazon team at the delivery station – the last stop before we deliver smiles to customers. Our fast-paced, active roles receive trucks full of orders, then prepare them for delivery. You’ll load conveyor belts, and transport and stage deliveries to be picked up by...


  • Wilmington, North Carolina, United States Syntricate Technologies Full time

    Data Integration SpecialistAt Syntricate Technologies, we are seeking a highly skilled SAP BODS Developer to join our team. As a key member of our data integration team, you will be responsible for designing, implementing, and managing data integration and data quality solutions using the SAP BusinessObjects Data Services tool.Key Responsibilities:Design and...


  • Wilmington, Illinois, United States ABM Industries Full time

    Warehouse Lead Cleaner Job DescriptionAt ABM Industries, we're seeking a skilled Warehouse Lead Cleaner to join our team. As a key member of our facilities maintenance team, you'll be responsible for leading a team of cleaners and ensuring our warehouse operations run smoothly.Key Responsibilities:Provide guidance and motivation to a team of cleanersConduct...


  • Wilmington, United States OneMain Financial Full time

    We are a forward-thinking financial services organization, committed to delivering innovative digital solutions. Our data-driven approach powers our digital products, and we are establishing a shared data products organization to enhance our data platform capabilities and provide actionable insights into digital behaviors and performance.We are seeking an...


  • WILMINGTON, United States OneMain Financial Full time

    We are a forward-thinking financial services organization, committed to delivering innovative digital solutions. Our data-driven approach powers our digital products, and we are establishing a shared data products organization to enhance our data platform capabilities and provide actionable insights into digital behaviors and performance.We are seeking an...


  • WILMINGTON, United States OneMain Financial Full time

    We are a forward-thinking financial services organization, committed to delivering innovative digital solutions. Our data-driven approach powers our digital products, and we are establishing a shared data products organization to enhance our data platform capabilities and provide actionable insights into digital behaviors and performance.We are seeking an...


  • WILMINGTON, United States OneMain Financial Full time

    We are a forward-thinking financial services organization, committed to delivering innovative digital solutions. Our data-driven approach powers our digital products, and we are establishing a shared data products organization to enhance our data platform capabilities and provide actionable insights into digital behaviors and performance.We are seeking an...


  • Wilmington, United States OneMain Financial Full time

    We are a forward-thinking financial services organization, committed to delivering innovative digital solutions. Our data-driven approach powers our digital products, and we are establishing a shared data products organization to enhance our data platform capabilities and provide actionable insights into digital behaviors and performance.Apply now, read the...


  • Wilmington, United States MSRCosmos LLC Full time

    Job DescriptionThis role is more into SAP NATIVE HANA with SQL Query , Administration , Performance tuning , BI/Datawarehouse is only 10% 5+ years of experience in NATIVE SAP HANA.Strong hands-on experience in SQL Query and Performance Tuning in SAP Native HANA.Experience in developing reporting and analytical solutions based on SAP data using SAP HANA.Have...