Job Description :
Title: Business Intelligence Architect 2 Position.

Duration: Long Term Contract.

Location: Madison, WI.

Rate: $83/hr on C2C.

OPT, CPT, H4, H1B, H1Transfer, GC, Citizen are Accepted

Telephonic + F2F Interview Mandatory.

Client: State of WI: Dept-DOT.

Preferred Employment

· Corp-Corp

· W2-Permanent

· W2-Contract

· 1099-Contract


DOT is looking for a candidate that can help us build our next generation Data Warehouse & BI practice, by implementing best practice design, architecture, and development methodologies.

The candidate will lead design, including data design, database architecture, metadata, ETL design, reporting & dashboard design, development, testing, implementation and maintenance of data warehouse and data integration initiatives. Develop ETL templates, standards, processes & procedures for loading information into data warehousing systems and for ensuring reliability of information loaded. Seek continuous improvement in performance & tuning of data warehouse and ensure security of data. Lead Data Warehouse & BI software & tools evaluations and implement solutions. Assist with PowerCenter and other Informatica suite tool implementations and upgrades. Recognized as advanced individual contributor. Subject matter expert with additional experience and/or education in field. Conducts highly complex work critical to the organization. Works with other IT technical teams and Business users to understand requirements and recommend & implement end-to-end solutions. Works without supervision with extensive latitude for independent judgment. Assist less experienced peers and provide technical guidance. Typically requires 10 years experience or equivalent education.

Ideal candidate will have minimum of 10 years skills and experience in the following areas:

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

Familiarity with Business Object and Tableau Software

Familiarity with PeopleSoft Financials

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


Must Have

Administration - Business Analysis

Gather and document requirements and 10 years

Administration - Training

Assist in training staff and 10 years

General Competencies

Ability to be self directed and 10 years

Able to work independently and 10 years

Analytical/problem solving skills 10 years

Awareness of IT infrastructure and 10 years

Bachelor's Degree in Computer Science or Software Engineering Yes

Excellent Communication Skills and 10 years

Information Technology - Architecture

Business Rules and 10 years

EPA Exchange Network and 10 years

Experience Designing Application Reporting solution and 10 years

Information Technology - Databases

Data analysis and 10 years

Database design and 10 years

Data Flow & Structure Modeling and 10 years

Data flow diagramming and 10 years

Data Warehouse - Experience in data warehouse design and development 10 years

Data Warehouse - Experience in requirements gathering for data warehouse 10 years

Data Warehouse - Performance tuning 10 years

Data warehousing and 10 years

DB2 and 10 years

Experience in Data Conversion projects and 10 years

Informatica 10 years

Information Integration and 10 years

Knowledge of Oracle PL/SQL and 10 years

Knowledge of SQL based database management systems (i.e. SQL Server, Oracle, DB2, etc and 10 years

Microsoft SQL Server 2008 and 2012 10 years

Information Technology - Design

Data modeling and 10 years

Information Technology - Desktop Support

Microsoft Office 2010 Suite