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, 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...

  • 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, 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...

  • Data Architect

    7 days ago


    Richmond, United States McKesson Full time

    The Data Architect will be responsible for providing guidance, maintenance, and deployment to customers in the structure, integration, monitoring, storage, and governance of data.What Sets you Apart:You will have experience with creating data pipelines and flows to and between business applications and data repositories.You will have a technical and business...


  • Richmond, VA, 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 Pyramid Consulting, Inc Full time

    Immediate need for a talented Data Analytics Systems Architect . This is a 12+ Months Contract opportunity with long-term potential and is located in Richmond VA (Hybrid). Please review the job description below and contact me ASAP if you are interested.Job ID:24-46409Pay Range: $80 - $90/hour. Employee benefits include, but are not limited to, health...


  • Richmond, United States Pyramid Consulting, Inc Full time

    Immediate need for a talented Data Analytics Systems Architect . This is a 12+ Months Contract opportunity with long-term potential and is located in Richmond VA (Hybrid). Please review the job description below and contact me ASAP if you are interested.Job ID:24-46409Pay Range: $80 - $90/hour. Employee benefits include, but are not limited to, health...


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

    Title: Data Analytics Systems ArchitectLocation: Richmond, VA 23219 HybridDuration: 12 Month’sJob DescriptionWe 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 McKesson Full time

    The Data Architect will be responsible for providing guidance, maintenance, and deployment to customers in the structure, integration, monitoring, storage, and governance of data.What Sets you Apart:You will have experience with creating data pipelines and flows to and between business applications and data repositories.You will have a technical and business...


  • richmond, United States McKesson Full time

    The Data Architect will be responsible for providing guidance, maintenance, and deployment to customers in the structure, integration, monitoring, storage, and governance of data.What Sets you Apart:You will have experience with creating data pipelines and flows to and between business applications and data repositories.You will have a technical and business...


  • Richmond, United States SunPlus Data Group, Inc Full time

    Job DescriptionJob DescriptionWe are looking for an IT Security Architect IV to work for the State of Virginia in Richmond, VA.This is expected to be for 12+ monthsHour are M-F 40 hrs week day shiftPay is $70 W2 hourly or $78 per hour 1099Job# 751727**This position is 4 days per week onsite and 1 day remote to start.  Some flexibility may be allowed once...

  • Senior Data Architect

    4 weeks ago


    Richmond, United States Genworth Full time

    At Genworth, we empower families to navigate the aging journey with confidence. We are compassionate, experienced allies for those navigating care with guidance, products, and services that meet families where they are. Further, we are the spouses, children, siblings, friends, and neighbors of those that need care—and we bring those experiences with us to...

  • Lead Data Architect

    5 months ago


    Richmond, United States CapTech Full time

    Company Description CapTech is an award-winning consulting firm that collaborates with clients to achieve what's possible through the power of technology. At CapTech, we're passionate about the work we do and the results we achieve for our clients. From the outset, our founders shared a collective passion to create a consultancy centered on strong...


  • Richmond, United States SunPlus Data Group, Inc Full time

    Job DescriptionJob DescriptionSunPlus Data Group is looking for an Enterprise Network Architect 4 for the State of VA in Richmond, VA. Candidates ae required to already be local to Richmond, not relocateThis is for 12 months with extensionHours are generally M-F, 40 hrs/weekPay is $100 W2 hourly & $ 110 hr 1099 on contractJob # 745173**This position is...