|
|
|
|
Title
|
Longitudinal Data System
|
|
Location
|
St. Paul, MN
|
|
Project Start/End Date
|
The
project resources selected will be expected to be available on or about
January 4, 2016 for an engagement approximately one year.
|
|
The Business Need
|
MN.IT @ Education is
looking for a single vendor to supply an experienced team of an architect and
developer to work in parallel with MN.IT @ Education staff to enhance and
maintain an interagency data warehouse. The interagency warehouse contains
anonymized unit record data for individuals from birth to workforce
employment that will support education research. The data is drawn from
multiple resources
–
Minnesota Department of Education (MDE), the Minnesota Department of Health
(MDH), Minnesota Department of Human Services (DHS), Minnesota Office of
Higher Education (OHE), and Minnesota Department of Economic Development
(DEED). All work will be directed by MN.IT @ Education project managers.
This RFO is to secure the services of approximately 2 resources
with skills in the identified service categories to supplement the MN.IT @
Education team. It is anticipated that the engagement will consist of 1
resource from the Architect Category and 1 resource from the Database
Administration/Development Category. Selected individuals will be responsible
for design, construction, testing, documentation, and support of the
warehouse effort. A team member will also help with leveraging our current
investment in business intelligence tools by creating and updating any
necessary data marts for the public and secured reports.
|
|
Deliverables
|
·
Coordinate and manage
data set “logistics” (e.g. issues, access to data, coordination of subject
matter experts, etc.).
·
Conduct data
profiling, using MN P20W standards practices to iteratively work with the
data provider to define, document, and clean the data.
·
Define the data
linking rules to be exercised on the personally identifying information
available in each data set. Use this definition to evaluate existing data
linking rules and integrate the new data set in a way that maintains or
improves the quality of data linking results.
·
Develop the program
logic to link and load each data set into the operational data store (ODS).
·
Create the database
architecture required to support the linking, loading, and storage of the new
data in the ODS, consistent with the existing architecture.
·
Create and populate a
data warehouse from the ODS.
·
Evaluate and possibly
refine the data operations to accommodate the data frequency and business
needs.
|
|
Job Requirements
|
All
experience described in the matrix must also be on the resume.
The following skills are required for
resource(s) being submitted. These are scored as pass/fail.
Required minimum qualifications must be
met for each resource submitted under each category:
Architect
·
5 plus years’
experience with business intelligence project management
·
5 plus years’
experience with MS SQL Server Databases
·
5 plus years’
experience with data modeling and analysis tools
·
5 plus years’
experience with warehouse data modeling using the “Kimball” approach
·
5 plus years’
experience with implementing applications based on SQL in stored procedures;
creation of views; etc.
Database Administration/Development
·
5
plus years’ experience with MS SQL Server Databases
·
5
plus years’ experience with MS SSIS, SSAS
·
5
plus years’ experience with warehouse data modeling using the “Kimball”
approach
·
5
plus years’ experience with data modeling and analysis tools
·
5
plus years’ experience with ETL (extract, transform, and load) programming
·
5
plus years’ experience with:
§ MS SQL Server
§ XML
§ MDX
§ Subversion
Desired
Skills - (applies to both the Architecture & Database
Administration/Development Categories)
·
Subject
matter expertise in K-12 education, health, human services, higher education,
workforce and or labor data and research
·
Business
requirements analysis for data warehousing
·
Experience
with data linking rules development
·
Experience
in coaching or team development situations
|
|
RFO Evaluation Process
|
·
Experience of candidates (50%)
·
Desired Skills (20%)
·
Cost (30%)
|
|
References
|
List three
(3) references who can speak to the resource’s work on a similar project.
Include the company name and address, reference name, reference email,
reference phone number, and a brief description of the project this resource
completed.
|
Job#5500 Architecture & Database Administration/Development
