Business Intelligence Lead--Informatica - (US-NY-New York)

Normal 0 false false false MicrosoftInternetExplorer4

Compensation: $100K - $115K / Year
Minimum Education: Bachelors
Job Type: Full Time
Jobcode: GNRJA2

Review and understand data requirements for data warehousing projects, Business Intelligence (BI)/Business Objects (BO) Reporting Systems and perform data analysis and data administration activities such as creation of data dictionaries, data transformations, assess data quality and recommend data quality improvements. Identify data augmentation and data integration required to support the corporate projects, define data mart specifications etc.

System Analyst/BI developer should have strong analytical skills. He (She) should have hands-on working experience in data warehousing projects using tools such as Informatica and Business Objects. Candidate should be able to juggle between multiple projects. .

Skills and Competencies:
- Minimum 10 years experience in an IT organization.
- 4 to 5yrs experience in a system analyst and BI developer role.
- Over 5 yrs of strong database and SQL skills.
- Strong knowledge of ETL concepts using Informatica.
- Strong knowledge of BI concepts using Business Objects.
- Strong knowledge of data analysis, data transformation, conceptual data modeling, data transformation and metadata management.
- Good knowledge of various RDBMS, Mainframe, Unix.
- Experience in life insurance industry is a big plus.
- Exposure to Navisys workflow product is a big plus.
- Strong experience is creating Use Cases, Activity diagrams, functional specifications.
- Analytical skills, including the ability to critically evaluate the information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a more general understanding, and distinguish requests and solution ideas from requirements.
- Proven ability to work directly with the business community, handle demanding user groups, and communicate with internal clients.
- Excellent Customer Relations – forms productive relationships with customers and development teams.
- Excellent writing and communication skills.
- Ability to learn new concepts, systems, and software independently and quickly.
- Attention to process and procedures to comply with internal/external audits

Primary Responsibilities
- Work with business users to understand the requirements and translate it to technical specification.
- Insurance domain knowledge is a must.
- Develop and make enhancement to new and existing systems.
- Participate in the development plans and resource estimation for task planning.
- Work with application development teams from initial specification drafting through implementation;
- Analyze source systems and develop a detail functional specification for BI projects
- Work with data architect to support data model changes.
- Develop data mapping document with transformation rules between source systems and data mart. Support ETL development activities.
- Develop detail report specification for business objects reports.
- Ensure that Quality Assurance test plans are executed before releasing product enhancements for User Acceptance Testing
- Contribute knowledge and support to QA and UAT teams throughout the process of testing the application
Facilitate the production release of new functionality and provide support of production issues

Travel: 10% Regional Travel

Email resume in Word to TheBigGameHunter@cisny.com. Please include the job code for the position with your resume.

NO RELOCATION. NO VISA TRANSFERS. NO OVERSEAS RESUMES. NO 3RD PARTIES.

To receive a complimentary subscription to my job search ezine, No B.S. Job Search Advice, go to www.JeffAltman.com to subscribe.

Receive tweets from Twitter with job search tips and job listings – TheBigGameHuntr