Database Designer/Analyst

Harvey Nash; Frankfort (KY); Ibrido; USD 70.000 - 100.000; Tempo pieno

Descrizione del lavoro

The Cabinet Division of School Data Services in Frankfort, KY, is seeking a Database Designer/Analyst on a long-term contract to lead the enterprise education data catalog design and governance, aligning with CEDS and metadata models to ensure data is discoverable and trusted.

You will implement metadata management processes, glossaries, and standards, work with program areas and data stewards, and provide training on catalog usage and governance concepts in a hybrid work setting.

Competenze

• Experience with K-12 data governance metadata management and data catalog design.
• Proficiency in SQL and interpreting database schemas.
• Familiarity with FERPA and privacy/security requirements.
• Strong communication skills to explain technical concepts to non-technical audiences.

Mansioni

• Design, implement, configure, and administer CABINET's enterprise education data catalog, including alignment to CEDS and metadata models.
• Develop and maintain metadata management processes, glossaries, taxonomies, and data classifications.
• Establish and monitor data quality, lineage, and governance documentation practices.
• Create and maintain technical procedures, catalog configurations, workflows, and integrations.

Conoscenze

SQL

Metadata management

Data governance

Data catalog design

Communication skills

Formazione

Data governance training

Strumenti

Microsoft Purview

Collibra

Alation

Informatica

Descrizione del lavoro

Position: Database Designer/Analyst

Location: Frankfort, KY (Hybrid)

Status: Contract

Estimated Duration: Long-Term Indefinite Contract

Starts: READY TO HIRE

Position Overview

Cabinet Division of School Data Services has receivedapproval to fill Database Designer/Analyst Contract Position #2 for thepurpose, description and bill rate as described below.

Purpose

The position supports the client data governance efforts by leading the design,configuration, implementation, documentation, and administration of CABINET’senterprise education data catalog. This position establishes catalog standards,metadata models, stewardship workflows, user roles, documentation, andgovernance practices needed to launch and sustain the catalog. The role workswith CABINET program areas, information system owners, data controllers, datastewards, reporting teams, and the Data Governance Committee to ensureeducation data assets are discoverable, trusted, secure, and aligned withCABINET data governance, privacy, security, and reporting requirements.

Description

• Design, implement,configure, and administer CABINET's enterprise education data catalog,including alignment to Common Education Data Standards (CEDS), metadatamodels, catalog standards, asset classifications, user roles, permissions,and governance workflows.
• Develop and maintainmetadata management processes, business glossaries, taxonomies, dataclassifications, and standards to support data governance, consistency,and discoverability of education data assets.
• Establish and monitordata quality, data lineage, and metadata documentation practices toimprove transparency, traceability, trust, and understanding of CABINETdata assets and reporting resources.
• Develop, document, andmaintain technical procedures, catalog configurations, workflows,integrations, and user guidance related to the data catalog and associatedgovernance processes
• Coordinate with programareas, data stewards, system owners, analysts, developers, and otherstakeholders to implement catalog integrations and support datagovernance, reporting, analytics, and compliance activities.
• Provide training,technical assistance, and support to catalog users and stakeholders onmetadata standards, catalog functionality, data governance practices, anddata literacy concepts.
• Monitor catalogperformance, metadata completeness, user adoption, and implementationprogress; identify and implement improvements to enhance catalogfunctionality, usability, and data quality.
• Perform other duties asassigned in support of CABINET data governance and data catalogpriorities.

Required Experience/Education –

Any combination of education, training and experience that demonstrates theability to support K-12 data governance metadata management, data catalogdesign and administration, data analysis and related technicalresponsibilities.

Preferred Skills

• Experience witheducation systems data catalogs, metadata management or data governanceplatforms.
• Knowledge of FERPA, theCommon Education Data Standards (CEDS) and applicable privacy and securityrequirements.
• Knowledge of datastewardship, lineage, quality, classification and metadata standards.
• Proficiency in SQL andinterpreting database schemas, data flows and business rules.
• Experience with businessglossaries, taxonomies, workflows and metadata ingestion.
• Knowledge of datawarehousing, modeling, integration and enterprise architecture.
• Ability to troubleshootconfiguration issues, validate metadata and resolve documentation gaps.
• Strong communicationskills and ability to explain technical concepts to nontechnicalaudiences.
• Familiarity withMicrosoft Purview, Collibra, Alation, Informatica or similar platforms.
• Experience witheducation, public-sector, compliance or secure data environments.