VDOT Programmer Analyst 4Datawarehouse Technical Architect

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 lineagemetadata 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 onpremises 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 cloudbased 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 onpremise and cloud environments.
• Familiarity with data modeling data lakes and big data technologies.
• Strong analytical and problemsolving 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 crossfunctionally 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 inuserfriendly language.

Required/Desired Skills

Skill Required /Desired Amount Consultant Experience Consultant Last Used Advanced skills in Data Warehousing Data Analytics and Data Architecture Required 15 Strong Background in data governance data quality data lineage and enterprise master data management Required 15 Experience working with Oracle PL/SQL and SQL Server Database Developement. Required 15 Written and oral communications Required 15 Familiarity with data modeling data lakes and big data technologies. Required 15 Expertise with modern cloud data warehouse platforms such as Azure Synapse or Snowflake. Required 12 Strong Experience with other data integration tools and techniques including IBM DataStage IBM IKC or Collibra Required 12 Experience to use Snowflake Highly desired 10 Experience with Automation and AI in Data Warehousing Highly desired 10 Knowledge of big data tools like Hadoop Spark and Kafka. Highly desired 10 Questions No. Question Consultant Answer Question1 Commonwealth of Virginia security policies prohibit the use of offshore IT contractors. Do you attest to the fact that your candidate will physically reside within the US for the duration of the assignment Question2 Please list candidates email address. Question3 In what city/state does your candidate PERMANENTLY reside Question4 Is candidate willing and able to interview onsite at VDOT in Richmond VA Question5 Is candidate willing and able to work onsite 4 days/wk for the first few weeks and up to 3 days every week afterwards at VDOT in Richmond VA which is REQUIRED NO exceptions. Question6 How soon after offer can candidate start