*Submission deadline: 12/17/2015 by Noon CT* *Architect for State of MN*
*Duration: 1 year from Jan 04/2016*
-
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 o 5 plus years’ experience with implementing
applications based on SQL in stored procedures; creation of views; etc.
*Project 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.
*The successful candidate will:*
-
Work in a Microsoft operating system environment
-
Have senior level skills in Microsoft SQL Server Analysis Services
and SSIS package development
-
Work in compliance with Statewide Enterprise Architecture as directed
and be required to report or demonstrate such compliance as needed
-
Work in compliance with Statewide Project Management Methodology as
directed and be required to report or demonstrate such
compliance as needed
-
work and resulting products must comply with the Minnesota
Accessibility Standards adopted September 1, 2010
Work in compliance with the Statewide Enterprise Security Requirements as
directed and be required to report or demonstrate such compliance as needed.
Send resumes with rate contact numbers and references with the attached
skill matrix ASAP as time is very short.
--
Ravi Reddy
UBCI
Kendall Park NJ 08824
Tel:732-297-9960
email:[email protected]
--
You received this message because you are subscribed to the Google Groups
"DSP_" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/dsp_.
For more options, visit https://groups.google.com/d/optout.
RFO0101 Architect - Required and Desired Skills Matrices.docx
Description: MS-Word 2007 document
