Data Warehouse Technical Architect

Our government client is looking for an experienced Data Warehouse Technical Architect on a hybrid 12+ months renewable contract role inRichmond, VA.

Position Data Warehouse Technical Architect

Job Overview:
We are seeking an experiencedData Warehouse Technical Architectwho will be responsible for supporting and evolving our existing data warehouse technologies, which includeOracle Datawarehouse, IBM DataStage, and MFT. The ideal candidate will also have deep experience in data management and governance tools likeIBM Information Governance Catalog (IGC), Information Knowledge Catalog (IKC),orCollibra, ensuring effective data quality management including data quality, data lineage, metadata and master data management.
This role also requires expertise inmodern cloud data warehouse technologiessuch asAzure SynapseAnalyticsor Snowflakeor Google Big Query,Azure Data Lake, andAzure Data Factorywith the ability to support existing on-premises systems while also collaborating with Enterprise Architecture to create roadmaps that transition 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 I 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+ yearsof 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 withOracle,DataStage, andIBM Integration Bus (IIB)for data integration and ETL.
• Solid experience withdata management and governance toolslikeIBM Information Governance Catalog (IGC),Information Knowledge Catalog (IKC), orCollibra.
• Expertise withmodern cloud data warehouse platformssuch asAzure SynapseorSnowflake.
• Experience in defining and implementingdata governance frameworksand ensuringdata quality management.
• Proven experience in designing and implementing scalable data warehouse solutions and strategies.
• Understanding ofETL processes, data integration strategies, and data migration in both on-premise and cloud environments.
• Familiarity withdata modeling,data lakes, andbig datatechnologies.
• Strong analytical and problem-solving skills with the ability to balance competing priorities.
• Experience working in collaboration withEnterprise Architecture teamsto create strategic roadmaps for data platforms.
• Excellent communication and stakeholder management skills, with the ability to work cross-functionally across teams.

Preferred Qualifications:

• Knowledge ofbig data toolslike Hadoop, Spark, and Kafka.
• Certifications inOracle,Azure, orSnowflaketechnologies.
• Experience with data privacy regulations likeGDPR,CCPA, and best practices indata security
• Experience with Automation and AI in Data Warehousing

Personal Attributes:
Strong written and oral communication skills. Strong presentation and interpersonal skills and Ability to present ideas in user-friendly language.
Required/Desired Experience:

• 15 years of Advanced skills in Data Warehousing, Data Analytics and Data Architecture Required
• 15 years of Strong Background in data governance, data quality, data lineage and enterprise master data management Required
• 15 years of Experience working with Oracle PL/SQL and SQL Server Database Developement Required
• 15 years of Written and oral communications Required
• 15 years of Familiarity with data modeling, data lakes, and big data technologies Required
• 12 years of Expertise with modern cloud data warehouse platforms such as Azure Synapse or Snowflake Required
• 12 years of Strong Experience with other data integration tools and techniques including IBM DataStage, IBM IKC or Collibra Required
• 10 years of Experience to use Snowflake Highly desired
• 10 years of Experience with Automation and AI in Data Warehousing Highly desired
• 10 years of Knowledge of big data tools like Hadoop, Spark, and Kafka Highly desired

About Vector:
Vector Consulting, Inc., (Headquartered in Atlanta) is an IT Talent Acquisition Solutions firm committed to delivering results. Since our founding in 1990, we have been partnering with our customers, understanding their business, and developing solutions with a commitment to quality, reliability and value. Our continuing growth has been and continues to be built around successful relationships that are based on our organization's operating philosophy and commitment to ** People, Partnerships, Purpose and Performance - THE VECTOR WAY

Celebrating 30 years of service.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.