Description

Qualifications:

• Extensive experience in conceptual and dimensional data modeling, including star schema design for data warehouses.
• Strong proficiency in data modeling tools such as Microsoft Visio and/or Erwin.
• Demonstrated ability to create clear and accurate data documentation, including entity definitions, mappings, and data dictionaries.
• Strong verbal and written communication skills, with the ability to facilitate discussions and document requirements across technical and non-technical audiences.
• Experience working with data warehouse teams, including DBEs and DBAs, in enterprise environments.
• Familiarity with human services programs or public sector data systems is preferred.
• Knowledge of data governance, metadata, and ETL processes is a plus.

Required skills and experience:

• Data Analysis (7-9 years of experience)
• Data Modeling in conceptual data modeling for large, complex system (7-9 years of experience)
• Data Warehousing (4-6 years of experience)
• SQL (7-9 years of experience)
• Microsoft Visio and/or Erwin data modeler (4-6 years of experience)
• Strong understanding, experience in design dimensional models and data modeling methodologies
• Excellent verbal and written communication
• Demonstrated ability to work closely with:
• Business analysts and program subject matter experts
• Database Engineers
• Database Administrators
• External contractors and project team

In addition, the ideal candidate will have skills and experience in:

• Experience working with public sector, human services, or healthcare data systems (e.g., APD, CAM/CALMS, MMIS)
• Familiarity with data governance, data cataloging, and metadata management initiatives
• Experience supporting data warehouse development using SQL Server, Snowflake, or similar platforms

Key Skills

Education

Any Graduate