VDOT Programmer Analyst 4

Role: VDOT Programmer Analyst 4/Datawarehouse Technical Architect

Job Type : Contract

Location: 1401 E Broad St Richmond VA 23219 - 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

Interview Process: Both Web Cam and in Person Interview

Preference would be someone local to Richmond or Driving distance from Central Office.

Job Description:

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 Technical Architect

who will be responsible for supporting and evolving our existing data warehouse technologies, which include

Oracle Datawarehouse, IBM DataStage, and MFT . The ideal candidate will also have deep experience in data management and governance tools like

IBM Information Governance Catalog (IGC), Information Knowledge Catalog (IKC),

or

Collibra , ensuring effective data quality management including data quality, data lineage, metadata and master data management.

This role also requires expertise in

modern cloud data warehouse technologies

such as

Azure Synapse

Analytics

or Snowflake

or Google Big Query ,

Azure Data Lake , and

Azure Data Factory

with 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 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 securityExperience with Automation and AI in Data WarehousingPersonal Attributes:•Strong written and oral communication skills. Strong presentation and interpersonal skills and Ability to present ideas in user-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.

Skill Matrix:

Advanced skills in Data Warehousing, Data Analytics and Data ArchitectureRequired15YearsStrong Background in data governance, data quality, data lineage and enterprise master data managementRequired15YearsExperience working with Oracle PL/SQL and SQL Server Database Developement.Required15YearsWritten and oral communicationsRequired15YearsFamiliarity with data modeling, data lakes, and big data technologies.Required15YearsExpertise with modern cloud data warehouse platforms such as Azure Synapse or Snowflake.Required12YearsStrong Experience with other data integration tools and techniques including IBM DataStage, IBM IKC or CollibraRequired12YearsExperience to use SnowflakeHighly desired10YearsExperience with Automation and AI in Data WarehousingHighly desired10YearsKnowledge of big data tools like Hadoop, Spark, and Kafka.Highly desired10Years