Programmer Analyst / Datawarehouse Technical Architect - Ztek Consulting INC

Job Title: Programmer Analyst / Datawarehouse Technical Architect

Location: Richmond VA

Position Type: Contract

Duration: 6 / 12 Month

Work Type: Hybrid

Rate: Pay range offered to a successful candidate will be based on several factors, including the candidate's education, work experience, work location, specific job duties, certifications, etc.

Job Description:

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

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.

ABOUT Ztek:

Website: www.ztekinc.com

Ztek Consulting Inc is a minority- and woman-owned business enterprise that leverages a unique blend of human talent, machine learning algorithms, and artificial intelligence to provide customized talent management solutions for clients. Ztek's diversity-focused hiring models have proven successful, particularly in hiring veterans. The company's veteran-focused hiring and deployment program, Z-V.E.T, matches skilled veterans with clients' needs in various areas.

Disclaimer:

Ztek is an Equal Opportunity Employer and prohibits any kind of unlawful discrimination and harassment. Ztek is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment on the basis of race, color, religion or belief, national origin, citizenship, social or ethnic origin, sex, age, physical or mental disability, veteran status, marital status, domestic partner status, sexual orientation, or any other status protected by the statutes, rules, and regulations in the locations where it operates. If you are an individual with a disability and need a reasonable accommodation to assist with your job search or application for employment, please contact us at hrd@ztekinc.com Please indicate the specifics of the assistance needed. Ztek encourages all interested and qualified candidates to apply for employment opportunities. Ztek does not discriminate against applicants based on citizenship status, immigration status, or national origin, in accordance with 8 U.S.C. 1324b.