Previous Job
CSS - Data Warehouse Architect 3
Ref No.: 18-46862
Location: Lansing, Michigan
Start Date: 07/05/2018
Status New
Position # 565082
Position CSS - Data Warehouse Architect 3
Client & Department State of Michigan- DTMB
Worksite Address N Washington, Lansing MI 48933
Tenure 6+ Months
No. of Openings 1 (INTERVIEW TYPE: In Person only)
No. of submittals 2

Question 1 Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?
Question 2 Please list candidate's email address that will be used when submitting E-RTR.
Question 3 In the summary of qualifications, please provide candidate location, availability to interview/start, and experience with each of the skills matrix requests. Thank you.
Question 4 The selected candidate will be responsible for any and all costs associated with parking for this position. These costs will not be reimbursed by CAI or State of Michigan. Please confirm you have discussed this with your candidate and he/she accepts this requirement.
Question 5 UPDATE: Interviews (in-person only) will take place on 7/12, 7/13 (afternoon only), 7/16 (afternoon only), 7/17 (morning only), 7/19

Skill Required / Desired Amount of Experience Candidate Experience Last Used Last Used
Experience with RDBMS platforms (Oracle, MS SQL Server, DB2) Required 10 Years
Experience with data reporting, intelligence, analytics and visualization tools (Cognos, PowerBI, SAP Business Objects, WebFocus) Required 10 Years
Understanding of and experience in data marts, data warehouse, and data mastering (Hadoop, Teradata, IBM MDM, IBI OmniGen) Required 10 Years
Experience in data analysis, data quality, data transformation, and ETL (IBM Infosphere, IBI iWay) Required 10 Years

SHORT DESCRIPTION: Reviews, analyzes, and evaluates business data, analytics, and intelligence needs. Experienced with understanding business needs and providing actionable visualizations and analytics from business data.


Years of Experience: 16 or more years of experience in the field.

Job Description: Relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks, a wide degree of creativity and latitude is expected.

•Prepare and document Functional and Technical Specifications for reporting and data mart work. Assist with business data mart/intelligence support and enhancements. Assist in deployment and management of end-user reporting tools and platforms. Work with IT and business project teams to understand reporting and data mart requirements and propose solutions. Document and provide knowledge transfer to the rest of the Enterprise Data Management Team for all solutions.

•Knowledge of commonly-used concepts, practices, and procedures within data architecture, reporting, analytics and visualization. Familiar with relational database concepts, and client-server concepts. Relies on experience and judgment to plan and accomplish goals. Performs a variety of tasks. Works under general supervision; typically reports to a project manager. A certain degree of creativity and latitude is required.