Job Description :
Job Title: BI Architect
Location: Madison, Wisconsin
Duration: 12 Months


Data warehousing/Business Intelligence
Data Integration
Performance tuning using Informatica tools
Relational Database technologies: Oracle, DB2, or SQL Server
SDLC process: planning, analysis, design, coding, testing, implementation, support
Data management and data analysis using SQL



Strong skills in data warehousing process design, ETL development, performance & tuning using the Informatica tool suite

Excellent skills in the architecture of data warehouse and data integration strategies and solutions

Demonstrated skills in establishing data warehouse best practice standards

Excellent knowledge and programming in relational data base technologies; e.g. Oracle, DB2, SQL Server

Strong skills working with relational and dimensional data models

Strong skills working with slowly changing dimensions

Strong data management and data analysis using SQL

Strong verbal and written communication skills, including facilitation of meetings with customers and technical staff

Knowledge and skills in the project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support)

Demonstrated knowledge and skills in requirements gathering

Effective interpersonal relations skills, ability to effectively collaborate with others and work as part of a team

Skills in navigating a large organization in order to accomplish results

Ability to initiate and follow through on complex projects of both short and long term duration

Excellent organizational and time management skills.

Excellent analytical and problem solving skills

Works independently, assumes responsibility for job development and training, researches and resolves questions and problems, requests supervisor input and keeps supervisor informed

Proficiency with MS Office suite, MS Visio, and MS Outlook

Ability to complete projects of substantial depth and complexity, and work with customers at many levels in the organization