DATA ARCHITECT

Recruitment #21-134-2110

Job Description

The Loudoun County Department of Information Technology (DIT) is currently seeking a talented, highly motivated individual to serve as Data Architect for County applications and databases. The Data Architect will lead long-term strategic goals for data architecture vision in accordance with the technology roadmap provided by department of Information Technology. This position is responsible for architectural frameworks, methods, design patterns and tools and will need to work with key stakeholders to document data sources and associated data artifacts, to include data models and metadata. The Data Architect will comprehensively define the data architectural solutions for Loudoun County's Business Intelligence (BI), Data Analytics and Data integration platforms while working with DIT technical leads and Subject Matter Experts (SME), as well as other department staff. The Data Architect will also be responsible for designing information management strategies necessary to store, move and manage business data by applying existing, new, and emerging techniques. The Data Architect will translate business needs into enterprise data architecture requirements and identify and forecast future state data architecture alternatives. In addition, the position requires skills for customer engagement, collaboration and communication with business partners, data users, vendors for COTS products and other key stakeholders across the county and the ability to operate in a fast-paced environment. The job would require strong understanding of data governance and the ability to model the data flows. Specific job expectations include, but are not limited to:

  • Translating business functions into conceptual, logical and physical data models.
  • Create and implement complex data models for Online Analytical Processing (OLAP), Data Warehouse, and logical Data warehouse applications
  • Assist in the design Data Warehouse solution and work with various Data Warehouse technologies to develop plans that best support the County, including data design, database architecture, and metadata repository creation
  • Collaborate with internal business resources and technical teams/SMEs to understand various data sources
  • Define how information should flow and be consumed by various departments and IT customers
  • Define data standards, policies and governance strategies for the enterprise
  • Determine data management lifecycle requirements such as data archival, retention and retirement
  • Plan data storage based on projected needs over the next 2-5 years
  • Documentation of architectural standards, reference architectures, and data flows, processes and operating models
  • Provide periodic briefings to peers and leadership on the state of the data architecture.

Job Requirements

Requires any combination of education and experience equivalent to a Bachelor's degree in Information Systems, Computer Science, or related field and at least four (4) years of experience supporting Data Architecture initiatives. Any certification or work related to Database management is highly desirable. Technical expertise in legacy database environments and SQL server is strongly preferred. Experience with Oracle a plus. Experience in using various modelling tools such as TOAD or Microsoft Visio is preferable.

Special Requirements

We are seeking an individual with:

  • Excellent analytical and technical skills
  • Excellent written, verbal, communication, and presentation skills
  • Microsoft related certifications such as the MCSD/MCSE
  • Experience with Tableau, PowerBI or other BI Tools
  • Demonstrated experience translating business and technical requirements into comprehensive data strategies and analytic solutions
  • Experience with Datawarehouse Platforms.

Post Conditional Offer Contingencies

The successful candidate will undergo a credit, fingerprinting/criminal and DMV check.

Click on a link below to apply for this position: