Wednesday, February 04, 2009

Business Intelligence Analyst - NYC $90K


 

Strong Oracle,  Strong Data Modeling, Strong SQL or Report Development needed!

 

Business Intelligence Analyst II

To: $90K  (outstanding benefits; 9-5 environment)

Addition to staff, very stable company; no layoffs, 9-5 environment…

Stable work history, really well spoken, and 2 yrs. exp. in Banking

 

 

 

Technical Skills

·          Oracle Database SQL programming

·          Data modeling

 

·          Familiar w/ Data Warehousing Concepts such as star schemas, metadata, operational data stores and master data

·          Experience documenting mapping rules for ETL jobs

·          Report development (BusinessObjects Enterprise Web Intelligence and/or Crystal reports preferred)

·          Sybase, MS SQL Server, DB2 knowledge a plus

·          BS in Technical Field is preferred; must have an undergraduate degree

 

 
Personal Skills

 

·          Emotional Maturity

·          Reliable

·          Dependable

·          People oriented

·          Outgoing personality

·          Self Starter

·          Strong Communication Skills: Verbal & Written

·          Effective documentation skills

·          Willing to learn new skills

·          Possesses an analytical approach toward drawing logical conclusions

 

Domain Knowledge

·          Familiarity with Banking & Finance industry

·          Requirements gathering

·          Business Analysis

·          Testing

 

   Experience-

 

·          Minimum 3 years of IT experience

·          Minimum 2 years of Business Intelligence experience

·          Minimum 2 years of Requirements Gathering for BI projects experience

·          Minimum 1 year of testing experience

·          Minimum 1 year of ETL rules mapping experience

·          Minimum 1 year of Data Profiling experience

·          Minimum 2 years of Banking & financial services experience

·          Familiarity with reading and understanding dimensional and 3rd Normal form data models

 

 

Reporting Relationship:

 

Reports to the Business Intelligence Project Manager or Business Intelligence Technical Architect.

 

 

Function:

 

Work with business users to gather requirements for Business Intelligence projects.  Analyze and structure findings to be used by developers.  Profile data to identify data quality issues using SQL and specialized tools.  Develop plans for resolving data quality issues.  Participate in design sessions.  Develop test plans and test deliverables.  Data analytics and report development.

 

Essential Duties:

 

·          Provide the necessary level of self-management and task control to keep all assigned projects on schedule.

·          Design, develop, maintain and document large business intelligence/data warehousing projects.

·          Perform preliminary project analysis and document findings in a Management Summary Report.

·          Conduct business area analysis, requirements definition, identify source data, define data quality, transformation, and summarization processes. 

·          Interview end users to determine requirements for data, reports, analyses, metadata, training, service levels, data quality, and performance.

·          Work with developers to translate requirements into technical specifications. Helps identify and assess potential data sources.

·          Participate in the analysis and design: Star Schemas, operational data stores and master data repositories

·          Capture metadata

·          Prepare and execute test plans

·          Document test results

·          Document mapping rules for ETL development

·          Report development in BusinessObjects Enterprise using  Web Intelligence & Crystal Reports

·          Develop SQL scripts to profile and test data

·          Profile data to identify data quality issues

·          Work from data models documented in Information Engineering or IDEF0 format

·          Support BI design & architecture activities

·          Develop test plans and conduct tests on the deliverables

·          Provide full support for the Bank’s business intelligence environment.  Support includes, but is not limited to: problem resolution (business and non-business hours); user support; and system maintenance.

·          Support the Bank's application development process.

·          Assist project managers and end users in identifying and recommending automated solutions to business problems.

·          Monitor business use and performance of the data warehouse and provides feedback to data warehouse architects, developers, and database administrators.

·          Ensure the data warehouse meets service level requirements.

·          Support the Bank's data users by providing relevant training, consulting, and guidance.

 

 

 

 

Key Relationships:

 

     Internal-

 

Regular contact and direct involvement with Development, Technical Support and End User staffs.

Serves as a liaison between the end users and Business Intelligence / Data Warehousing project team.

 

    External-

 

Direct contact with software vendors and consultants.  Frequent contact with industry professionals.

 

 

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 about consulting assignments; subscribe to USConsulting on Twitter

 

 

 

 

 

 

posted by Unknown at 10:22 AM