Data Warehouse Architect

1 month ago


richmond, United States Software Technology Inc. Full time

Description:

In office 1-2 days for first 3 months, then the resource should be in office every Wednesday.

Data architect to provide data intake, data governance, data transformation, data quality, data Lineage, metadata and master data management, data virtualization, data services and consumption. Extensive experience with cloud infrastructure.

We are seeking an experienced Data Warehouse TechnicalArchitect who will be responsible for supporting and evolving our existingdata warehouse technologies, which include Oracle Datawarehouse, IBMDataStage, and MFT. The ideal candidate will also have deep experience indata management and governance tools like IBM Information Governance Catalog(IGC), Information Knowledge Catalog (IKC), or Collibra, ensuringeffective data quality management including data quality, data lineage,metadata and master data management.

This role also requires expertise in modern cloud datawarehouse technologies such as Azure Synapse Analytics or Snowflake or Google Big Query, Azure Data Lake, and AzureData Factory with the ability to support existing on-premises systems whilealso collaborating with Enterprise Architecture to create roadmaps thattransition the organization to future data technologies.

Key Responsibilities:

  • Provide technical oversight and support for existing data warehouse technologies including Oracle Data warehouse and DataStage.
  • Collaborate with Enterprise Architecture teams to define and implement roadmaps for transitioning to modern cloud-based data warehousing solutions.
  • Design, develop, and maintain data governance and management processes using tools like IGC, IKC, or Collibra.
  • Conduct data capacity planning, life cycle, duration, usage requirements, feasibility studies.
  • Ensure the data infrastructure meets the needs of business operations by ensuring data quality, integrity, and security.
  • Work closely with business analysts, developers, business users, architects, and DBAs to ensure the data warehouse supports business goals.
  • Drive initiatives related to data integration, ETL processes, and data migration strategies.
  • Provide leadership and mentorship to the data warehouse team, ensuring best practices in data architecture and engineering are followed.
  • Monitor performance and manage scaling strategies for existing data warehouse environments.
  • Stay up to date with industry trends and innovations in data warehouse and data management technologies, recommending improvements as necessary.

Required Skills and Qualifications:

  • 15+ years of experience in data warehousing and data architecture.
  • Extensive experience in data mining, large scale data modeling, data profiling, and data mapping.
  • Experience with Azure Cloud, Azure Data Factory, and Data Bricks.
  • Experience with different database platforms and services like SOAP, REST, etc.
  • Strong experience with Oracle, DataStage, and IBM Integration Bus (IIB) for data integration and ETL.
  • Solid experience with data management and governance tools like IBM Information Governance Catalog (IGC), Information Knowledge Catalog (IKC), or Collibra.
  • Expertise with modern cloud data warehouse platforms such as Azure Synapse or Snowflake.
  • Experience in defining and implementing data governance frameworks and ensuring data quality management.
  • Proven experience in designing and implementing scalable data warehouse solutions and strategies.
  • Understanding of ETL processes, data integration strategies, and data migration in both on-premise and cloud environments.
  • Familiarity with data modeling, data lakes, and big data technologies.
  • Strong analytical and problem-solving skills with the ability to balance competing priorities.
  • Experience working in collaboration with Enterprise Architecture teams to create strategic roadmaps for data platforms.
  • Excellent communication and stakeholder management skills, with the ability to work cross-functionally across teams.

Preferred Qualifications:

  • Knowledge of big data tools like Hadoop, Spark, and Kafka.
  • Certifications in Oracle, Azure, or Snowflake technologies.
  • Experience with data privacy regulations like GDPR, CCPA, and best practices in data security
  • Experience with Automation and AI in Data Warehousing

Personal Attributes:

· Strong written and oral communication skills. Strongpresentation and interpersonal skills and Ability to present ideas inuser-friendly language.

We prefer candidates local to Richmond Area or Ready to move to Richmond. This position is Hybrid In person 2-3 days a week for first 3 months and once a month after that.



  • Richmond, California, United States DataStaff, Inc. Full time

    Data Warehouse Architect OpportunityDataStaff, Inc. is seeking a skilled Data Warehouse Architect to support a long-term contract opportunity with one of our direct clients in Richmond, VA.Key Responsibilities:Provide technical oversight and support for existing data warehouse technologies.Collaborate with Enterprise Architecture teams to define and...


  • Richmond, California, United States V-Soft Consulting Group Full time

    Job Title: Data Warehouse Technical ArchitectJob Summary: We are seeking a highly skilled Data Warehouse Technical Architect to join our team at V-Soft Consulting Group. As a Data Warehouse Technical Architect, you will be responsible for designing, developing, and maintaining data governance and management processes using tools like IGC, IKC, or...


  • Richmond, United States Software Technology Inc. Full time

    Description: In office 1-2 days for first 3 months, then the resource should be in office every Wednesday. Data architect to provide data intake, data governance, data transformation, data quality, data Lineage, metadata and master data management, data virtualization, data services and consumption. Extensive experience with cloud infrastructure.We are...


  • richmond, United States Software Technology Inc. Full time

    Description: In office 1-2 days for first 3 months, then the resource should be in office every Wednesday. Data architect to provide data intake, data governance, data transformation, data quality, data Lineage, metadata and master data management, data virtualization, data services and consumption. Extensive experience with cloud infrastructure.We are...


  • Richmond, California, United States RICEFW Technologies Full time

    Job Title: Data Warehouse Technical ArchitectJob Summary:At RICEFW Technologies, we are seeking an experienced Data Warehouse Technical Architect to support and evolve our existing data warehouse technologies. The ideal candidate will have extensive experience in data management and governance tools, as well as expertise in modern cloud data warehouse...


  • Richmond, Virginia, United States Vector Consulting, Inc Full time

    About the Role:We are seeking an experienced Data Warehouse Technical Architect to support and evolve our existing data warehouse technologies, including Oracle Datawarehouse, IBM DataStage, and MFT. The ideal candidate will have deep experience in data management and governance tools like IBM Information Governance Catalog (IGC), Information Knowledge...


  • Richmond, California, United States Vector Consulting, Inc Full time

    We are seeking an experienced Data Warehouse Technical Architect to support and evolve our existing data warehouse technologies, including Oracle Datawarehouse, IBM DataStage, and MFT. The ideal candidate will have deep experience in data management and governance tools like IBM Information Governance Catalog (IGC), Information Knowledge Catalog (IKC), or...


  • Richmond, California, United States DATASOFT TECHNOLOGIES Full time

    About the JobDuration: 8 Months Contract (possibility of extension)Location: Hybrid- Richmond, VAPay rate: Hourly, depending on experienceJob ID:We are seeking a highly skilled Data Warehouse Technical Architect to provide technical oversight and support for existing data warehouse technologies including Oracle Data warehouse and DataStage. The ideal...


  • richmond, United States DataStaff, Inc. Full time

    DataStaff, Inc. is seeking a Programmer Analyst/Data Warehouse Technical Architect for a long-term contract opportunity with one of our direct clients in Richmond, VA*In office 1-2 days for first 3 months, then the resource should be in office every Wednesday.Job Description:Data architect to provide data intake, data governance, data transformation, data...


  • richmond, United States DataStaff, Inc. Full time

    DataStaff, Inc. is seeking a Programmer Analyst/Data Warehouse Technical Architect for a long-term contract opportunity with one of our direct clients in Richmond, VA*In office 1-2 days for first 3 months, then the resource should be in office every Wednesday.Job Description:Data architect to provide data intake, data governance, data transformation, data...

  • Senior Data Architect

    4 weeks ago


    Richmond, Virginia, United States Insight Global Full time

    Job Title: Senior Data ArchitectJob Summary:Insight Global is seeking a Senior Data Architect to support a local client. This role involves leading the enhancement of data architecture programs, ensuring data quality through advanced processes, and overseeing the modernization of the data warehouse.Key Responsibilities:Design data models to optimize data...

  • Senior Data Architect

    4 weeks ago


    Richmond, California, United States GSK Solutions Full time

    Job Title: Senior Data ArchitectAt GSK Solutions Inc, we are seeking an experienced Senior Data Architect to support and evolve our existing data warehouse technologies. The ideal candidate will have extensive experience in data management and governance tools like IBM Information Governance Catalog (IGC), Information Knowledge Catalog (IKC), or Collibra,...

  • Senior Data Architect

    1 month ago


    richmond, United States Insight Global Full time

    Required Skills & Experience•15+ years' experience in a data warehousing environment with hands-on experience in managing and optimizing large-scale data warehouses •Demonstrated proficiency in key technologies including IBM DataStage, Snowflake, and Data Factory. •Strong knowledge and understanding of Azure concepts, with experience in leveraging...

  • Senior Data Architect

    1 month ago


    Richmond, United States Insight Global Full time

    Required Skills & Experience•15+ years' experience in a data warehousing environment with hands-on experience in managing and optimizing large-scale data warehouses •Demonstrated proficiency in key technologies including IBM DataStage, Snowflake, and Data Factory. •Strong knowledge and understanding of Azure concepts, with experience in leveraging...


  • Richmond, California, United States Pinnacle Group Full time

    Job Title: Data Analytics ArchitectJob Summary:Pinnacle Group is seeking a highly skilled Data Analytics Architect to lead the design and implementation of data analytics solutions. The ideal candidate will have a strong background in data modeling, extensive experience with various databases and technologies, and a deep understanding of data analytics...


  • Richmond, United States TalentBurst, an Inc 5000 company Full time

    Title: Data Analytics Systems ArchitectLocation: Richmond, VA 23219 HybridDuration: 12 Month’sJob Description:We are seeking a highly skilled and experienced Data Analytics Systems Architect to join our team. The ideal candidate will have a strong background in data modeling, extensive experience with various databases and technologies, and a deep...


  • richmond, United States TalentBurst, an Inc 5000 company Full time

    Title: Data Analytics Systems ArchitectLocation: Richmond, VA 23219 HybridDuration: 12 Month’sJob Description:We are seeking a highly skilled and experienced Data Analytics Systems Architect to join our team. The ideal candidate will have a strong background in data modeling, extensive experience with various databases and technologies, and a deep...


  • richmond, United States Vector Consulting, Inc Full time

    Our government client is looking for an experienced Data Warehouse Technical Architect on a hybrid 12+ months renewable contract role in Richmond, VA.Notes:Position is Hybrid - In office 1-2 days for first 3 months, then the resource should be in office every Wednesday. Preference would be someone local to Richmond or Driving distance from Central Office.We...


  • richmond, United States Vector Consulting, Inc Full time

    Our government client is looking for an experienced Data Warehouse Technical Architect on a hybrid 12+ months renewable contract role in Richmond, VA.Notes:Position is Hybrid - In office 1-2 days for first 3 months, then the resource should be in office every Wednesday. Preference would be someone local to Richmond or Driving distance from Central Office.We...


  • Richmond, United States Vector Consulting, Inc Full time

    Our government client is looking for an experienced Data Warehouse Technical Architect on a hybrid 12+ months renewable contract role in Richmond, VA.Notes:Position is Hybrid - In office 1-2 days for first 3 months, then the resource should be in office every Wednesday. Preference would be someone local to Richmond or Driving distance from Central Office.We...