TrueBridge Resources, a professional services staffing firm, is assisting a dynamic client in the Phila suburbs in a search for a new full time hire. This position offers challenging work and an outstanding compensation and benefits package!SENIOR BI ARCHITECT
This new senior lead position will be in the Products and Technology Group and will play a key role in the selection of a new BI tool, the design of the new BI architecture, the phased implementation planning and delivery. Strong coordination with the current Datawarehouse operations team will be required to understand the current state and then jointly define a migration path from old code to new code from a development and support perspective.
This position is ideal for a candidate who has a good mix of senior level communication and planning experience combined with a strong desire to be involved in hands-on design and problem solving support to project teams as they build out the next generation product on a daily basis.
Responsibilities include: Working with current Datawarehouse 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 modelling activities to adjust the current DW model to support new requirements and eliminate past constraints on flexibility. Working with current Datawarehouse 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 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. 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 Datawarehouse operations team to ensure a smooth transition from new product development to production operation and support.
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 (eg 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 modelling, SQL, query optimization, Datawarehouse architecture Strong hands on data modelling 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
Additional Project Details: Candidates must understand the business, drive business solutions and be comfortable interacting with Sr. Management Will select a new BI tool that will replace Net Acumen o This will be a global tool that will be able to support multiple currencies Candidates must be able to promote their plans to gain support Will define a roadmap for the transition from Net Acumen to the new BI tool Work with a team of 10 - 15
Additional Candidate Requirements: Candidates must have great presentation skills o PowerPoint skills are required Candidates must have good business acumen Candidates must have strong Data Modeling experience Candidates must have hands on experience with large BI implementations Candidates must have a strong understanding of how a business partner would use the BI tool Candidates must have knowledge of a global environment Candidates must be proficient with Metadata technologies