2 days on site required. Richmond candidates preferred OR must be within 3 hours drive of RVA
Parking NOT available for contractors
2 Days ON SITE required each week.
Local RVA candidates preferred OR (to be considered) must currently be within 3 hours drive of RVA, proof required of current residence required.
Parking NOT available for contractors.
ABOUT THE ROLE:
DBHDS - Senior Data Warehouse Architect for the EDW Modernization Project, a cornerstone of the Agency's Data Exchange and Modernization Program. This project will implement a SaaS EDW and build integrations with multiple source systems.
The Department of Behavioral Health and Developmental Services (DBHDS) is seeking a Senior Data Warehouse Architect to join our team for a long-term project involving the implementation of a new Enterprise Data Warehouse (EDW) Software-as-a-Service (SaaS) solution and a new Data Governance SaaS platform. This transformative initiative aims to enhance our data management capabilities, drive data-driven decision-making, and ensure data governance compliance across the DBHDS organization. This role will be a member of the Data Exchange and Modernization Program and will be working with a multi-project team in a hybrid agile environment. Position will be hybrid remote and 2 days a week on average required to be on-site at DBHDS office in Richmond. Parking will be in public lots with a daily rate. Some travel within VA may be required, occasionally overnight.
KEY RESPONSIBLITIES:
The Senior Data Warehouse Architect will work with the team and vendor to strategically design and implement the new EDW while ensuring high levels of data availability. This individual will determine the strategy for transitioning data sources from the existing data warehouse to the new EDW. This individual is also responsible for defining data standards and models for warehouse architecture. Required/Desired Skills
Skill | Required /Desired | Amount | of Experience |
Experience as a data warehouse architect, including cloud SaaS solutions | Required | 8 | Years |
Proficient in data modeling, database design, and the use of ETL tools. | Required | 8 | Years |
Experience working with multiple database platforms, such as SQL Server, MySQL, Oracle, DB2, Netezza, and IMS DB. | Required | 10 | Years |
Proficient in programming languages, such as SQL, PL/SQL, Java, Python, Cobol, and JCL. | Required | 10 | Years |
Understanding of data governance policies, procedures, and standards, including those for security | Required | 5 | Years |
Understanding of APIs and other integration technologies | Required | 5 | Years |
Experience with business intelligence and reporting platforms | Required | 8 | Years |
Understanding of machine learning and predictive analytics. | Required | 5 | Years |
Familiar with DevOps best practices and automation, including building, configuration, documentation, testing and monitoring | Required | 8 | Years |
Excellent written and spoken communications skills and active listening skills | Required | 8 | Years |
Strong team-building skills | Required | 8 | Years |
Experience working with senior management, business owners, and other stakeholders to understand requirements | Required | 5 | Years |
Experience working with a vendor, especially one who is hosting a cloud SaaS data warehouse | Highly desired | 5 | Years |
Experience with data quality assessment and improvement techniques | Highly desired | 5 | Years |
Experience as a solutions architect | Highly desired | 5 | Years |
Experience with Healthcare IT and related data standards (HIPPA, etc.) | Highly desired | 4 | Years |
Experience with migration of on-premise data warehouse to a cloud platform | Highly desired | 4 | Years |
Data warehouse architect certification | Nice to have | 5 | Years |
Experience using agile project delivery methods | Nice to have | 5 | Years |
Questions No. | Question |
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 candidate's email address. |
Question3 | In what city and state does your candidate CURRENTLY reside? |
Question4 | Because of the ON SITE requirement (2 days/week - no exceptions) the agency is asking that the candidate reside within 3 hours' drive of Richmond. Pls upload a copy of a recent utility bill (or photo of a shipping label) with your candidate's name and current address under the REFERENCE TAB to be considered. They will be rejected if this is not included. |