BI, Developer/Data Architect, Bridgewater, NJ. SQL Server, Oracle, Cognos cubes, Informatica, Hadoop. Details follow.
The BI developer/data architect will analyze, document and implement changes to new and existing custom and third party Business Intelligence applications.
REQUIREMENTS:
- Over 10 years of advanced experience with SQL server multi-cube solution as a developer and being able to reverse engineering existing solution to clearly document the data sources, business requirements and business rules applied to reporting solution (inputs and outputs).
- Advanced experience in relational databases (e.g. Oracle, SQL Server) and multi-dimensional databases. (e.g. Cognos PowerPlay cubes).
- Intermediate knowledge of transactional systems (ERP, CRM etc.) to document integrations.
- Experience with system design/development methodology (SDLC).
- Experience with automated job scheduling tools.
- Experience with Informatica for data extraction.
- Experience with building data exploration using Hadoop.
- Excellent communication skills.