Data Warehouse Architect 3
Lansing MI
12 Months
 
Short Description:
Designs, implements and supports data warehousing. Implements business rules via stored procedures, middleware, or other technologies. Defines user interfaces and functional specifications.
 
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.
 
•Designs, implements and supports data warehousing. Implements business rules via stored procedures, middleware, or other technologies. Defines user interfaces and functional specifications. Responsible for verifying accuracy of data, and the maintenance and support of the data warehouse. Knowledge of data warehouse end-to-end implementation processes, from business requirement logical modeling, physical database design, ETL, end-user tools, database, SQL, performance tuning. Demonstrated problem resolution skills with team of persons, and strong leadership with implementation team Experience in data warehouse design and data modeling (both relational and dimensional) and development and maintenance of multi-dimensional data models. Development experience in implementation of data warehousing utilizing RDBMS. Understanding of data warehouse Metadata concepts, tools and different data warehouse methodologies. Expertise in SQL and proficiency in database tuning techniques. Responsible for the ongoing architecture and design of the data warehouse, data mart, and reporting environments. Develop strategies for flexibility and scalability, and define the future technical architecture direction for the business intelligence reporting physical environment.
•Responsible for proper selection of appropriate hardware, software, tools and system lifecycle techniques for the different components of the end-to-end data warehouse architecture including ETL, metadata, data profiling software, database platform, performance monitoring, reporting and analytic tools. Defining and documenting the technical architecture of the data warehouse, including the physical components and their functionality. Setting or enforcing standards and overall architecture for data warehouse systems. Monitoring the data warehousing industry and assisting in establishing the organization's data warehousing strategy and section of strategic warehousing tools and techniques. Ensuring compatibility of the different components of the DW architecture and ensuring alignment with broader IT strategies and goals. Ability to educate the project teams on the standards and architecture of each component of the data warehouse architecture. Very strong written and oral communication skills, including some presentation skills.
 
Skill: 

• Design, implementation and support of data warehousing. Required 8 Years
• Knowledge of data warehouse end-to-end implementation processes. Required 8 Years
• Experience in data warehouse design and data modeling and development and maintenance of multi-dimensional data models. Required 8 Years
• Business requirement logical modeling, physical database design, ETL, end-user tools, database, SQL, performance tuning. Required 8 Years
• Ensuring compatibility within current DW architecture Required 8 Years
• Excellent Written/Oral Communication Skills Required 8 Years
• Demonstrated experience implementing business rules via stored procedures, middleware, etc Required 8 Years

 
Questions
Description
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?
Answer:
 
Question 2
Please list candidate's email address that will be used when submitting E-RTR.
Answer:
 
Question 3
For any potential candidate in need of work authorization/verification, please be advised that by order of the SOM Attorney General’s office – CAI and suppliers cannot request letters from the State of Michigan, and SOM managers cannot and will not sign any supplier letter(s) directly. If you require a template letter with engagement specifications for any potential H1 filing(s), please contact the CAI Contract Managers. Do you accept this requirement?
Answer:
 
 
Question 4
Please only submit candidates who can interview on March 27, 28, or 29.
Answer:
 
Question 5
Please include a paragraph re: candidate's availability, location, applicable skills, and other pertinent information in the Summary of Qualifications tab, when submitting.
Answer:
 
Question 6
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.
Answer:
Regards,
 
Ravi
 
Key Business Solutions, Inc.
 
|| Office: 916 646 2080 Ext 218 || Fax: 916 646 2081
 
Note: This email is not intended to be a solicitation. Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list.