Design and implement Business Intelligence, information quality & information management governance.
Provide hands-on data modeling (relational and dimensional) for Data Warehouse/Data Marts and overall BI environment.
Provide best practices and guidance regarding use of ETL, data modeling (relational and dimensional), and reporting deliverables.
A good understanding of the design and development of complex business reports.
Ability to understand and support legacy solutions and reports while migrating to a long term strategy.
Work in a small team environment with Project Managers, Database Administrators, Systems Engineers, Business Analysts, and internal business users.
Design and build complex relational data structures.
Work with technical and business users to understand requirements then identify, and design multiple solution options as well as determine and recommend a right-sized approach.
Develop strategies for data acquisition, archive recovery, and enterprise level database implementation.
Develop and build comprehensive data validation and error processes as a component within the “End to End” BI solution architecture.
Minimum 5 years of experience of ETL development with Informatica PowerCenter
Degree in Information Systems, Computer Science, or equivalent education and/or experience.
Minimum 8 years of experience in delivering Business Intelligence solutions.
Minimum 8 years of experience with Relational and Dimensional Modeling.
Must have UNIX OS knowledge including intermediate shell scripting experience.
Minimum 5 years of experience with CA Erwin. (Model Manager or CA MM preferred in addition)
Minimum 4 years of experience with Oracle.
Significant experience with design, development, and maintenance of enterprise level data systems such as Oracle and SQL Server.
In-depth expertise with data security, storage solutions, database virtualization and replication.
Expert level SQL skills.
Strong understanding of reporting tools such as Business Objects suite of products (desktop client, WebIntelligence, Designer, Supervisor, Broadcast Agent, InfoView).
Understanding of Business Objects Enterprise XI R3 architecture. Experience building BO Universes a plus.
Working knowledge of relational database design, logical data modeling, data warehousing, and relational database management systems preferably Oracle 9i/10G/11x
Knowledge of Business Intelligence and Data Warehousing concepts and proven experience delivering both.
Expert knowledge of ETL concepts, development, and experience.
Proven analytical skills and problem solving ability.
Excellent written and oral communication skills.
Demonstrated time management and prioritization skills.
Strong interpersonal skills. Ability to influence without authority. Good liaison skills and negotiation capabilities.
Ability to adapt to a fast-paced, ever-changing environment
