Careers

LiSci Sr Conslt to Sr Mgr Information Management (BI/DW

Job Title: LiSci Sr Conslt to Sr Mgr Information Management (BI/DW Location: Major metro in NE, SE, MW, or W US Job Description: Our client’s Business Intelligence & Data Warehousing Consulting Practice serves many of the world's largest and most prestigious companies across most major industry verticals. They offer solutions to help clients address a wide range of issues affecting business growth for both established as well as early stage and emerging companies. Our client’s Business Intelligence & Data Warehousing Practice area designs, develops, and implements systems and processes to capture, integrate and distribute information in an enterprise. Their specific service offerings within the Business Intelligence & Data Warehousing area include: Information Strategy & Architecture Business Intelligence / Data Warehousing Our client’s Life Sciences Consulting Practice serves nearly all of the world's largest and most prestigious pharmaceutical, biotech, and medical device companies. We offer solutions to help clients address a wide range of issues affecting business growth for both established as well as early stage and emerging life sciences companies. From inception to initial public offering or global product launch, our professionals have comprehensive experience in: customer channel strategy, merger and acquisitions, clinical trials, supply chain optimization, investment prioritization, commercialization strategy, financial and performance management, R&D regulatory requirements, operations excellence, IT strategy, CRM and more. Our client’s technology consultants, working with other IT organizations, can help their clients to use technology integration to solve business challenges. Our client’s technology specialists, most with extensive experience in systems integration and development, are committed to delivering efficient, technology-based solutions to their clients. They assess their client's current technology needs and assist with systems design and implementation to improve both enterprise-wide integration and profitability. Through their long-term partnerships with many of the world's leading technology companies they can offer extremely cost effective implementation to their clients. The objective of this role is to deliver IT value that helps drive business results by understanding both the business of technology and how technology works within the business. For each level described below there are two career tracks: The first is the SME (Subject Matter Expert) path. The SME track is for those who are looking for a career path which emphasizes technical and/or industry expertise over the more traditional business development oriented career path. The second is the more traditional business development oriented career track which emphasizes the generation of revenue and requires that the candidate possesses, maintains, and builds a solid base of contacts from which to drive new business - even if it requires "cold calling.” This path is for those who are interested in and capable of acting as a true “Rainmaker.” Additional opportunities exist for those candidates who possess strong experience in specific industry verticals in addition to meeting the cross-industry requirements stated below. *Candidates interested in pursuing opportunities at levels up to and including Direct Entry Partner will be considered on a case-by-case basis based upon the merits of their accomplishments and qualifications for the role. A Senior Manager in the Business Intelligence & Data Warehousing practice is expected to have the following overall IT and consulting expertise: Development of statements of work and/or client proposals Broad system level expertise across multiple computing platforms and technologies with the ability to influence direction around information management at the Enterprise Level Organize knowledge transfer to clients Develop and manage vendor relationships Lead workshops for client education Identify opportunities to add value to the client’s organization by effective use of information management Build relationships with CXOs and key stakeholders responsible for information and performance management in client’s organization A Manager in the Business Intelligence & Data Warehousing practice is expected to have the following overall IT and consulting expertise: Development of statements of work and/or client proposals Identify business opportunities to increase usability and profitability of information architecture Experience with program leadership, governance and change enablement Develop and manage vendor relationships Lead workshops for client education Manage resources and budget on client projects A Senior Consultant in the Business Intelligence & Data Warehousing practice is expected to have the following overall IT and consulting expertise: Development of statements of work and/or client proposals Defining, developing, and documenting business and systems requirements. Contribute to a strong client relationship through interactions with client personnel Understand the business context of the engagement Job Qualifications: In addition, team members in the Information Management - Business Intelligence and Data Warehousing practice must have the following management/strategy capabilities and technical skills. Management/Strategy Capabilities Sr Manager Ability to scope out the effort and cost for an enterprise reporting solution Ability to define how an enterprise information system will align with the organization’s business and strategic objectives Ability to manage multiple teams on a business intelligence / data warehousing engagement Manager Ability to scope out the effort and cost for an enterprise reporting solution Ability to define how an enterprise information system will align with the organization’s business and strategic objectives Ability to manage multiple teams on a business intelligence / data warehousing engagement Sr Conslt Create processes for defining and documenting data standards and meta models Build an integrated metadata environment consisting of both operational and business metadata and ensure the quality and integrity of the data Identify opportunities to optimize performance of existing data structures Design and implement data quality and data auditing processes Provide expertise in data discovery and profiling Technical Skills Sr Manager To conceptualize, design and assist in the implementation of new and existing systems, middleware, data warehouse and production architectures Identify and promote best practices and patterns for data modeling, and provide oversight for all activities related to data cleansing, data quality and data consolidation using standard data modeling methodologies and processes Provide support on data quality components during the implementation of the solution architecture Manager Proficient in one or more of major ETL tools such as Informatica, Datastage, SAS and their administration Proficient in one or more of major BI Reporting tools such as Business Objects, Hyperion, Cognos, SAS and their administration Proficient in one or more of major metadata tools and their administration Proficient in one or more of major OLAP tools such as MicroStrategy, Hyperion, Brio, SAS and their administration Proficient in one or more of major data modeling tools such as Erwin, Data Architect, Oracle Designer and their administration Provide support on data quality components during the implementation of the solution architecture Provide technical recommendations for optimized data access and retention for the data warehouse Provide oversight support to the design, development and QA teams Define areas of improvement to optimize data flows Identify strategy for data acquisition and archival In addition, ideal candidates will also have experience in three or more of the following: Leading teams through IT Strategy initiatives Leveraging overall technical architecture knowledge across multiple industries Business process analysis, mapping, and design Requirements analysis, meeting with business owners, and performing current state system analysis Leading teams through developing conceptual and technical designs, including the use of object-oriented analysis and design techniques Leading Testing efforts, including all phases: System, Integration, and Performance Testing and ensuring traceability Significant application architecture experience with J2EE or .NET Experience with enterprise applications such as Siebel, SAP, Peoplesoft, Oracle Sr Conslt Ability to architect, design and develop an enterprise business intelligence and data warehousing solution Define, design and implement logical and physical data models Proficient with ETL tools and be able to architect an ETL solution Proficient in SQL Design and implement reporting data sources and complex reports Design and develop data cleansing routines utilizing typical data quality functions involving standardization, transformation, rationalization, linking and matching Knowledge of data, master data and metadata related standards, processes and technology (DW related items are above this bullet, BI related items are below this bullet.) Hands-on experience with database engines such as DB2, Terradata, Informix, Oracle, and/or Sysbase Demonstrated competence with OLAP/ROLAP tools including front end applications such as Hyperon/Essbase, Business Object, Cognos PowerPlay, Wholistic/Holos, Informix/Metacube, Microstrategy/DSS Agent, Oracle/Oracle Express, Pilot Software/ Professional experience with any of the following technologies: Java, Visual Basic, Power Builder, SAS, PL/SQL, and/or COBOL Professional experience and demonstrated competency in any of the following operating systems: Windows NT, MVS, Unix (Solaris, HP, AIX), VMS In addition, ideal candidates for will also have experience in three or more of the following: Leading teams through IT Strategy initiatives Leveraging overall technical architecture knowledge across multiple industries Business process analysis, mapping, and design Requirements analysis, meeting with business owners, and performing current state system analysis Leading teams through developing conceptual and technical designs, including the use of object-oriented analysis and design techniques Leading Testing efforts, including all phases: System, Integration, and Performance Testing and ensuring traceability Significant application architecture experience with J2EE or .NET Experience with enterprise applications such as Siebel, SAP, Peoplesoft, Oracle Education: Sr Manager Bachelor's Degree; an advanced degree or MBA is preferred; 10-14 years of relevant work experience Manager Bachelor's Degree; an advanced degree or MBA is preferred; 6-10 years of relevant work experience Sr Conslt Bachelor's Degree; an advanced degree or MBA is preferred; as well as 4-6 years of relevant work experience The ideal candidate will possess the following professional qualities: Prior consulting experience in a "Trusted Advisor" role (Those without prior consulting experience will still be considered, but for a slightly lower level) Integrity - demonstrating the highest standards in everything you do Leadership Skills - motivating, influencing, and providing direction to others Team Skills - interacting and cooperating with others to achieve common goals Intellectual Competence - learning and processing new information, analyzing problems and new situations, and exercising sound judgment Flexibility - shifting priorities, adapting to new working situations and hours, and bouncing back from possible setbacks Motivation - setting high performance standards for yourself, and exceeding them Communication Skills - effectively articulating your thoughts and ideas both orally and in writing and proactively listening to others vPrioritization Skills - organizing, planning and juggling multiple priorities and assignments to maximize productivity Customer Service Focus - developing, maintaining, and ensuring high quality client or customer relationships Technical Skills - acquiring and using specific knowledge of the technical tools required for the position Mentoring Skills - assist in the mentoring of more junior team members Ability to function independently and interact effectively with operational areas and colleagues vComfortable interacting with C Suite level executives Prior experience performing business development and relationship management functions Good written and verbal communication skills Excellent compensation. (Will not lose a great candidate due to money!) MUST be willing to travel M-F A minimum of a Bachelors degree is REQUIRED. Masters degree, MBA, or higher is highly desirable. Additional professional certification(s) is highly desirable.