Senior Data Modeling Architect

3 weeks ago


Wilmington, Delaware, United States DEW Softech, Inc Full time

At DEW Softech, Inc, we are seeking a highly skilled Senior Data Modeling Architect to join our team. This is a remote contract opportunity that will last for 36 months, with a core schedule of EST hours.



The ideal candidate will have 6 years of experience in TSQL development, with strong skills in database and data warehouse modeling. They will also have experience with Microsoft database projects (dacpac), DevOps, and Microsoft Access as a front-end for SQL Server. SSIS experience is also required, with at least 4 years of experience.



This project involves the conversion of a legacy data warehouse to a new architecture, which includes Data Vault 2.0 and traditional Data Mart. The successful candidate will be responsible for connecting to new data sources, exploring data models in the data vault and data mart, configuring and/or coding data vault and data mart structures, and coding complex stored procedures that implement business rules and load fact tables.



They will also be responsible for converting complex existing report stored procedures from the legacy warehouse to the new one, validating results using TSQL, and documenting all differences. Troubleshooting code at all levels will also be a key responsibility, as well as working with report developers as they adapt to using the new warehouse.



This is a senior-level position, and the successful candidate will have the opportunity to work their way up to an architect level. Experience with Data Vault is a huge plus, but not required. Estimated salary for this position is $120,000 - $180,000 per year, depending on experience.



What You'll Do:


  • Connect to new data sources and explore data models in the data vault and data mart.
  • Configure and/or code data vault and data mart structures.
  • Code complex stored procedures that 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 and document all differences.
  • Troubleshoot code at all levels.
  • Work with report developers as they adapt to using the new warehouse.


What You'll Need:


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


Preferred Skills:


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


  • Wilmington, Delaware, United States Diverse Lynx Full time

    Job Title: Data Architect/ModelerType: ContractWork Location: Wilmington, DE or Columbus, OH (onsite)Contract Duration: Long TermHourly Pay Rate: $ 53 W2 and $65 C2CAccelerate data definition and metadata capture by modernizing and automating data governance practices. Shift data governance from 'by process' to 'by exception' to improve data quality and...


  • Wilmington, Delaware, United States Diverse Lynx Full time

    Job Title: Data Architect/ModelerType: ContractWork Location: Wilmington, DE or Columbus, OH (onsite)Contract Duration: Long TermHourly Pay Rate: $ 53 W2 and $65 C2CAccelerate data definition/metadata capture and modernize/automate data governance practices that shift data governance from 'by process' to 'by exception'.Collaborate with Engineering and...

  • Senior Data Architect

    4 weeks ago


    Wilmington, Delaware, United States AAA Mid Atlantic Full time

    Job SummaryAAA Club Alliance is seeking a Data Architect to design, develop, and maintain the data architecture for our organization. The ideal candidate will have a strong understanding of data modeling concepts, techniques, and tools, as well as experience with data warehousing, ETL processes, and data integration tools.Key ResponsibilitiesDesign and...


  • Wilmington, Delaware, United States Data Wave Technologies Inc Full time

    Job Title: Senior Enterprise Solutions ArchitectLocation: Wilmington DE, Coral Springs FL, or Omaha NEDuration: Full TimeJob Description:Key Technology: Java, Microservices, Front end architecture10+ years of experience in large-scale IT system development, design and implementation, involving demonstrated project management, resource management, business...

  • Data Architect

    4 weeks ago


    Wilmington, Delaware, United States Omni Inclusive Full time

    Data Architect:Omni Inclusive is seeking a highly skilled Data Architect to join our team. The ideal candidate will have a strong background in data architecture and experience working in ADF environments. They will be responsible for guiding the development of data models, leveraging PySpark, and ensuring the overall data architecture aligns with business...

  • Senior Data Engineer

    4 weeks ago


    Wilmington, Delaware, United States Aloden, Inc. Full time

    Job Title: Senior Data Engineer - Cloud ArchitectAloden, Inc. is seeking a highly skilled Senior Data Engineer - Cloud Architect to join our team. As a key member of our data engineering team, you will be responsible for designing, developing, and maintaining scalable and efficient data pipelines in the AWS cloud environment.Key Responsibilities:Design and...


  • Wilmington, Delaware, United States Saviance Full time

    Job Title: Senior Software Architect - Full StackLocation: RemoteDuration: FulltimeAbout Saviance:Saviance is a remote technology consulting firm headquartered in Boston. We deliver a range of solutions including custom machine learning/AI integrations and data warehousing and processing solutions. Our comprehensive approach serves clients from a variety of...


  • Wilmington, Delaware, United States CAI Full time

    Job Title: Senior Solutions ArchitectCAI is seeking a highly skilled Senior Solutions Architect to lead the architecture and design efforts for our client's system. This role involves overseeing subsystems and managing internal and external interfaces.Key Responsibilities:Lead the architecture and design efforts for the client's system, ensuring alignment...


  • Wilmington, Delaware, United States Interaction24,LLC Full time

    Job OverviewWe are seeking a highly skilled Data Warehouse Architect to design and deliver complex, large-volume data warehouse applications using Ab Initio ETL development. The ideal candidate will have strong experience in advanced SQL programming, Oracle databases, and Unix familiarity with shell scripting experience.Key Responsibilities:Design and...


  • Wilmington, Delaware, United States Pantheon Data Full time

    Job OverviewPantheon Data, a Kenific Holding company, is a private business based in the Washington, DC area. We provide various services, including infrastructure resiliency, contact center operations, information technology, software engineering, program management, strategic communications, engineering, and cybersecurity. Our customer base includes...


  • Wilmington, Delaware, United States TD Bank Group Full time

    Job DescriptionThe Senior Analyst - Modeling and Forecasting role at TD Bank Group is a key position that requires a high level of expertise in data modeling and forecasting. The successful candidate will be responsible for creating a broad range of data models by applying various techniques to build out complex data models.Key ResponsibilitiesAct as a...


  • Wilmington, Delaware, United States AAA Club Alliance Inc. Full time

    AAA Club Alliance Inc. is seeking a Senior Enterprise Architect to develop business and technology architecture and strategy across the company.This position is responsible for driving the creation and maintenance of enterprise business and technology capability architecture blueprints, integrated roadmaps, and enterprise standards that guide ACA's strategic...


  • Wilmington, Delaware, United States MITREC Full time

    Job DescriptionThe Data Historian Architect will be responsible for designing, developing, and implementing Level 3 & Level 4 data management, historian, and reporting solutions for our customers.A qualified candidate will have experience in Windows and Network Security, system administration, data integrity, data analytics, and visualization tool sets.They...


  • Wilmington, Delaware, United States AAA Club Alliance Full time

    About the RoleWe are seeking a Senior Enterprise Solutions Architect to develop business and technology architecture and strategy across AAA Club Alliance.This position will drive the creation and maintenance of enterprise business and technology capability architecture blueprints, integrated roadmaps, and enterprise standards.Key Responsibilities:Drive and...

  • Enterprise Architect

    4 weeks ago


    Wilmington, Delaware, United States Insight Global Full time

    Job Title: Enterprise Architect - Data & Analytics ExpertJob Summary:We are seeking a highly skilled Enterprise Architect with expertise in Data & Analytics to support projects related to ESG (environmental, social, governance) within R&D and manufacturing.Key Responsibilities:Provide technical expertise across enterprise, global, and regional initiatives to...


  • Wilmington, Delaware, United States Mondo Full time

    Job OverviewMondo is seeking a highly skilled Senior Solution Architect to join our team. As a key member of our technology organization, you will play a pivotal role in shaping the technology landscape to meet business, application, data, and infrastructure requirements.Key ResponsibilitiesDesign and implement robust architectures and solution blueprints...


  • Wilmington, Delaware, United States Black Fox Full time

    About the RoleWe are seeking a highly experienced and motivated Senior IT Applications Solution Architect to join our team at Black Fox. In this critical role, you will be responsible for defining and implementing innovative technology solutions that address the complex needs of our rail transportation clients.Key Responsibilities:Collaborate with business...


  • Wilmington, Delaware, United States Mondo Full time

    About the Role:Mondo is partnering with a global leader in the pharmaceutical and biotech industry to find a Senior Solution Architect. This is a hybrid role based in San Francisco, with 3 days onsite every other week. The start date is ASAP for this long-term contract position.Key Responsibilities:Design robust architectures and solution blueprints for...


  • Wilmington, Delaware, United States OneMain Financial Full time

    Job SummaryOneMain Financial is seeking a highly skilled Senior Model Governance Specialist to join our team. As a key member of our Model Risk Management team, you will be responsible for providing hands-on model governance oversight in the development of new models or modifications to existing models used across the customer credit lifecycle.Key...


  • Wilmington, Delaware, United States OneMain Financial Full time

    Job SummaryWe are seeking a highly skilled Senior Model Governance Specialist to join our team. The successful candidate will be responsible for providing model governance oversight in the development of new models or modifications to existing models used across the customer credit lifecycle.Key ResponsibilitiesProvide model governance oversight in the...