Lead Business Intelligence Architect

Responsibilities:


Responsibilities include:
Working with current data warehouse operations team to understand the current DW architecture state and challenges experienced
Leading the evaluation and selection of a new Business Intelligence Tool for the next generation DW environment
Facilitating the gathering, consolidation and prioritization of client business requirements
Documentation and presentation of business requirements for a variety of audiences including client executives, project managers, end users and technical designers and developers
Definition of a roadmap/design document for the new business intelligence architecture (tool) that ensures self-service, flexibility, scalability, offshore development/support capability, and security.
Developing an architecture standards document for future code design, team based-development and code release management in the new architecture.
Leading initial data modeling activities to adjust the current DW model to support new requirements and eliminate past constraints on flexibility.
Working with current data warehouse team to define a phased migration path from the old report base to new architecture
Working with the project team to validate the scope and requirements for the incremental releases of some existing reports and a planned sunset of many legacy reports in favor of a self-service approach.
Serving as a primary thought leader on the business intelligence tool (yet to be selected) and its capabilities.
Working with the Lead ETL Architect to ensure that the next generation ETL architecture is meeting the data integration requirements for downstream reporting by both internal users as well as the company's Partners (external consumers)
Working with portfolio development and sales teams to understand evolving market place requirements for reporting, analytics and data mining to ensure that the phased business intelligence rollout is aligned to meet those requirements.
Working with department management to prioritize work and allocate funding on an annual basis to support each incremental phase of development and required capital expenditures for dev/test/production capacity.
Ensuring vision, design and projects are in alignment with company business strategy and the company's Product Management vision.
Working closely with product development project managers to define resources, estimates, project plans needed for future phases.
During the execution of each phase, assume an active project roll and support development team leads during requirements, design, testing and implementation rollout.
Providing hands-on problem-solving assistance with data integration and data profiling tools to team leads and developers.
Working closely with the data warehouse operations team to ensure a smooth transition from new product development to production operation and support.


Qualifications:


Requirements:

10+ years of full life-cycle experience in Data Warehousing and Business Intelligence
A successful track record of delivering complex business intelligence projects on time.
Strong knowledge of performance tuning tactics appropriate at each layer within a business intelligence/data-warehouse environment (Oracle related experience is preferred)
Experience with determining requirements, evaluating vendors, and playing a key role in a BI tool selection project effort
Significant experience providing technical design review, development plan critique, code review, test plan/results review
Deep experience with one or more best-of-breed BI tools is required (Business Objects, Cognos, Microstrategy) - setup, configuration, design best practices, performance optimization, team based development approaches.
Experience with BI tools on the Linux/Unix platform
Experience with complex reporting requirements in a global company (e.g. data sources from multiple regions in different time zones, character sets, and report business rules)
Interaction with senior executives to convey technical concepts and assist in messaging about benefits of next generation platform.
Strong understanding of relational database concepts - data modeling, SQL, query optimization, data warehouse architecture
Strong hands on data modeling and demonstrated ability to translate business requirements into a data model structure (dimensional or snowflake)
Knowledge of metadata technologies, techniques and approaches for capturing and distributing BI metadata
Knowledge of data profiling technologies, techniques and approaches for utilizing as part of upfront analysis and production control operations.
Marketplace awareness of evolving BI topics such as data mining, service-oriented data integrations, master data management and near real-time operational reporting approaches
eCommerce, Retail, Supply Chain Management experience preferred, but not required
Experience estimating BI development work and creating a matching resource plan.
Strong leadership, communication and collaboration skills
Ability to coordinate across multiple infrastructure groups and assist in deployment planning.
BA/BS in Computer Science, Business or related field

Please refer to job code 4371RR when responding to this ad.

Category:	Information Technology
Location:	King of Prussia, PA
County:	Montgomery County
ZIP Code:	19406
Pay Rate:	open
Job Terms:	full time
Company:	Keystone Computer Associates
Phone:	215-643-3800
Fax:	215-643-0115