Data Architect

Prince William County Public Schools - Manassas, VA

Full-time

Manassas, VA

Educational Services

About the position

The Data Architect position is crucial for leading the architecture, design, and implementation of next-generation data solutions. This hands-on role involves architecting and engineering data pipelines, platforms, integrations, and products on modern cloud platforms like Snowflake, Databricks, and Azure. The role requires collaboration with the data leadership team to shape the long-term vision, cloud adoption roadmaps, and data governance frameworks necessary for transformation.

Responsibilities

• Architect and engineer data pipelines, platforms, integrations, and products on cloud platforms.
• Develop and implement data strategies for cloud data platform, master data management, and analytics.
• Design future-state analytical architecture and cloud migration roadmap.
• Lead platform evaluation and build-out of data infrastructure on cloud technologies.
• Define and implement data integration, security, governance, and metadata retention strategies.
• Implement methodologies and reuse strategies to enhance quality and optimize development.
• Define metadata strategy and lineage tracking capabilities.
• Drive initiatives to improve system reliability, availability, and performance.
• Lead cloud adoption while ensuring continuity of existing analytical initiatives.
• Monitor post-implementation architecture health, performance, and scalability.
• Maintain continuity of existing analytics and data engineering initiatives during transformation.
• Improve architecture health, scalability, and efficiency as changes emerge.
• Design and document the Logical Data Model and develop a Physical Data Model.
• Create and execute Data Definition Language (DDL) statements for Data Warehousing and/or Data Lake objects.
• Drive and build data model and architecture, implementing frameworks to ensure adherence to data architecture.
• Provide deep expertise in databases, data modeling, data architecture, and operating systems.
• Support end-to-end data asset lifecycle management activities.
• Design robust, scalable, real-time data pipelines and data platform architecture.
• Lead the review and design of new data products, maintaining product documentation.

Requirements

• Experience with cloud platforms such as Snowflake, Databricks, and Azure.
• Strong knowledge of data architecture, data modeling, and database management systems.
• Proficiency in SQL and data integration techniques.
• Experience in designing and implementing data governance frameworks.
• Ability to develop and execute data strategies for cloud data platforms.

Nice-to-haves

• Familiarity with data warehousing and data lake concepts.
• Experience with metadata management and lineage tracking.
• Knowledge of data security and compliance standards.