Business Intelligence/Data Warehouse Architect position will contribute to the company's success by performing a key role in designing, building and supporting our enterprise Business Intelligence architecture including Data Warehouse, Data Mart and Reporting Solutions which enable key business users to make solid business decisions.
Responsibilities:
- Define Business Intelligence Strategy based on current business and information technology realties. Define, design, and implement Business Intelligence (BI) strategies for operational, ad-hoc, and other BI related solutions.
- Work directly with IT and business users to facilitate, define and document data requirements as the foundation for data base design, data extraction, analysis and cleansing.
- Assist in the definition, documentation and development of mapping rules for movement of data from desperate data sources and into the various components and subject areas of the BI environment.
- Create data models including robust data definitions, entity-relationship-attribute models, as well as relational and/or dimensional models.
- Work closely with DBAs to transition logical models to physical implementation of data structures.
- 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
