about us services testimonials submit resume contact us back home
iTech Solutions Job Search
New Search  Submit Your Resume Now

Position Detail:  
Posting #: JEPQ1615 Bookmark and Share
Title: BI Designer Architect   
Skills: BI Tools (Cognos, MicroStrategy, SAS), DW, ETL, RDMS, Data Modeling
Location: CT - Hartford
Type:
Length: 12 Months
Description: BI Designer Architect

Since 1995, iTech Solutions Inc., has been providing IT Consulting and Direct Hire Services to the Insurance, Financial, Communications, Manufacturing  and Government sectors with local offices in Connecticut, Minnesota and New Jersey / Pennsylvania area.  
 
Our recruiting strategy is simple, if you want to find qualified IT professionals then use IT professionals to find them.   So at iTech Solutions,  our personnel are all career IT professionals with a wide range of IT experience.  We can honestly say our staff understands the technologies, the complexities of finding and selecting the appropriate personnel and the pressures of running successful IT projects.  
 
Our direct client is looking for 
BI Designer Architect

The primary function of the business intelligence designer is to provide overall business intelligence design direction that supports the development and implementation of the enterprise data warehouse and associated data marts within the Management Information area of Personal Lines. 
These initiatives target improved business value through data acquisition and data presentation to the business community via business intelligence tools which support business analytics and decision making functions. 
These initiatives include highly complex concurrent projects.  This position is responsible for end to end business intelligence design from data acquisition through data presentation with a special focus on web analytics. 
This position requires direct and active involvement in ETL design, business intelligence application design, and code level development processes. 
The business intelligence designer will be required, based on the assignment, to write and test code to support prototypes, code reviews, and performance efforts within the MI arena.  The business intelligence designer will deliver design documents which can be shared across the business, application development and quality assurance organizations.  The individual must be able to effectively communicate with business representatives, in their terminology, using both verbal and written skill sets.
 This position requires a “hands on” approach which will utilize both a detailed code level expertise and a broad perspective on application solutions in the MI space in order to provide business intelligence functionality to the business.

Primary Duties: 
Provide designs and code, as needed, to meet specific to data warehouse application requirements.
Ensure that designs are consistent with Personal Insurance architecture guidelines through blueprint and design reviews
Assist in the assessment of application stability and performance through code level reviews
Adopt and communicate new concepts, ideas, techniques, and best practices specific to the MI tool portfolio
Perform project level design, data analysis and application performance analysis
Responsible for the design of enterprise data warehouse application utilities including best practices and guidelines for supported technologies
Provide technical expertise in the following areas (dependent on knowledge and expertise):
Requirements:

Primary Skills:

Excellence in verbal, written communications, presentations and technical documentation
Data analysis and interpretation
Web Analytics and Web Technologies
Business intelligence tools (Cognos, MicroStrategy, SAS)
Data warehouse concepts and design including active data warehousing techniques
ETL tools including Ab Initio ( preferred ), Informatica and Data Stage
RDBMS including TeraData ( preferred), UDB DB2, Oracle, SQL Server with a heavy emphasis on SQL coding expertise
Unix/Linux shell scripting (k-shell)
ETL design
Data modeling
Database design covering both star schema and third normal form implementations
Meta data, including data types, XML, fixed and variable record layouts


Secondary Skills:

Coding Languages: Java, C#, C++, COBOL
Development platforms (.NET, J2EE, COM)
Application Integration
Middleware technologies
Component Based Design
Operating Systems
Performance Engineering
Networks

Competencies

Technical Knowledge
Deep experience in web analytics in a data warehouse environment including web based data acquisition, content knowledge, and presentation. 

Demonstrated coding expertise in SQL, detailed ETL tool coding experience, and significant first hand BI tool development experience. 

Demonstrates a broad conceptual understanding of the capabilities business intelligence technologies. 

Specific technical knowledge and experience with ETL tools and ETL design in a multi-terabyte data environment. 

Fundamental understanding of performance issues in both ETL tools, databases and business intelligence tools. 

Ability to provide integrated, end to end business intelligence designs. 

Demonstrated ability to clearly articulate technical designs, issues and resolutions in verbal and written communications.

Problem Solving & Decision Making
Demonstrates advanced analytical and diagnostic skills dealing with issues that are often novel and not readily defined, lack known precedent or appear contradictory. 

Able to develop solutions by applying accepted processes or creating new approaches to leverage technology from abstract information.

Sees the big picture, and is fully aware of technology and business directions. 

Has department, corporate and group objectives in focus while identifying and removing barriers. 

Optimizes the use of all available resources. 

Bases decisions on an accurate understanding of the situation, is able to infer future needs of known and unprecedented situations based on an advanced understanding of technology and business objectives.

Effectively assesses the long-term and short-term implications of decisions on the department, corporation and group


Our client is looking to fill this need immediately, so if you are interested in this opportunity, please send a Word copy of your resume and availability information to the iTech Solutions recruiter listed below.
 
iTech Solutions is a National Professional Services Firm, specializing in Technical Staffing, Recruiting and Consulting Services for Information Technology, Engineering and Business professionals.

iTech Solutions, Inc. does not support and will not post: Any posting that does not comply with applicable laws relating to labor and employment, equal employment opportunity and employment eligibility requirements; and Any posting that requires U.S. citizenship or lawful permanent residence in the U.S. as a condition of employment, unless otherwise required in order to comply with law, regulation, executive order, or federal, state, or local government contract.

iTech Solutions, Inc is an equal opportunity employer.

iTech Solutions is a E-Verify program participant.  This employer will provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS), with information from each new employee’s Form I-9 to confirm work authorization.
 
For more information contact Janice DiCicco at 860-674-1636 ext 202 or Submit your resume now.





© Copyright 2000-2010 iTech Solutions, Inc. - An Equal Opportunity Employer - iTech Solutions is an E-Verify Employer - All Rights Reserved

Bookmark and Share Subscribe