Responsible for the overall architecture, design, development, and maintenance of data warehousing and data mart systems and services for the entire enterprise's business function. Works closely with customers from a strategic perspective to identify and maximize opportunities to utilize data marts and/or data warehouse systems to improve business processes, promote the strategic use of information technology, and enable the work force to use technologies as a competitive tool. Ensures the development of enterprise-wide standards for the Data Warehouse to ensure compatibility and integration of multi-vendor platforms. Responsible for organizational balance and system coherency between front-end desktop/client environment and Data Warehouse back-end processing functions. Provides corporate leadership, vision, and direction for data warehouse systems, in support of the enterprise's business objectives and requirements.
Dimensions Education:
Bachelor's or Master's Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience.
Experience:
A minimum of 10 years of IT and business/industry work experience, with at least 3 years of leadership experience in managing multiple, large, cross-function teams and projects, and influencing senior level management and key stakeholders. Experience in strategic planning, development, implementation and maintenance of large-scale integrated relational database systems.
Breadth:
Senior level management. Oversees strategic planning and development of data warehouse solutions in partnership with technical and business leadership. Accountable for enterprise-wide results. Frequently reports to a Chief Information Officer or Chief Technology Officer.
Works with the business and senior IT leadership to identify and establish information requirements, develop and implement data warehouse strategies that utilize data marts and/or data warehouse systems to enhance business processes and manage business intelligence. Leads the activities of data warehouse project teams in the design, development and implementation of data warehouses; and the configuration and auditing of data warehouses to ensure quality control of data.
Responsible for overseeing the development, operations and maintenance of data warehouse environment, including organizational balance and system coherency between front-end desktop/client environment and data warehouse back-end processing functions. Provides guidance regarding the use of data warehouse system, capability of systems to deliver information, and subject matter expertise regarding current systems and emerging technology. Needed knowledge includes process and data modeling, data architectural development methodology, project management and extensive knowledge of data warehouses and data marts.
DimensionsEducation:
Bachelor's Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience.
Experience:
A minimum of 7 years of IT work experience including managing team(s) responsible for systems/applications development, database management systems and data warehouse development and management.
Breadth:Middle level management in the data warehouse function. Works under general direction of senior level management. Typically manages and mentors supervisors, project leaders and/or technical staff. Works on multiple, complex projects as a project leader and a subject matter expert. Frequently reports to a Director, Data Warehouse or Director, Systems and Programming.
Responsible for leading the design and support of enterprise-wide business intelligence applications and architecture. Works with enterprise-wide business and IT senior management to understand and prioritize data and information requirements. Solves complex technical problems. Optimizes the performance of enterprise business intelligence tools by defining data to filter and index that add value to the user. Creates testing methodology and criteria. Designs and coordinates a curriculum for coaching and training customers in the use of business intelligence tools to enhance business decision-making capability. Develops standards, policies and procedures for the form, structure and attributes of the business intelligence tools and systems. Develops data/information quality metrics. Researches new technology and develops business cases to support enterprise-wide business intelligence solutions.
Dimensions Education:
Bachelor's or Master's Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience.
Experience:
A minimum of 7 years of experience with large and complex database management systems, business intelligence tools and systems.
Complexity:
Expert/lead technical role. Provides technical expertise and direction for the development of complex enterprise-wide business intelligence and decision support systems solutions. Works on multiple projects as a project leader or sometimes as a business subject matter expert. Works on highly complex projects that require in-depth knowledge across multiple technical areas and business segments. Coaches and mentors more junior technical staff.
Responsible for gathering and assessing business information needs and preparing system requirements. Performs analyses, development and evaluation of data mining in a data warehouse environment which includes data design, database architecture, metadata and repository creation. Uses data mining and data analysis tools. Reviews and validates data loaded into the data warehouse for accuracy. Interacts with user community to produce reporting requirements. Provides technical consulting to users of the various data warehouses and advises users on conflicts and inappropriate data usage.
Responsible for prototyping solutions, preparing test scripts, and conducting tests and for data replication, extraction, loading, cleansing, and data modeling for data warehouses. Maintains knowledge of software tools, languages, scripts, and shells that effectively support the data warehouse environment in different operating system environments. Possesses working knowledge of Relational Database Management Systems (RDBMS) and data warehouse front-end tools. Must have an extensive knowledge of data warehouse and data mart concepts.
Dimensions Education:
Bachelor's Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience.
Experience:
A minimum of 3 years of IT work experience in business intelligence tools and systems.
Complexity:
Intermediate professional level role. Provides data warehouse architectural design, development and support in multi-platform environments. Works on multiple projects as a team member and may lead projects of moderate complexity. May coach more junior technical staff.
Provides data warehouse support functions including database maintenance, development and enhancement. Performs database administration functions such as loading data into database from external sources, supports users in constructing queries and generating output files. Responsible for on-going design and performance enhancement, which include reviewing queries for performance issues, estimating, monitoring and tuning the warehouse as it operates. Develops and administers processes to ensure interoperability and security of data warehouse system. Must possess a strong understanding of source data, data modeling, and data repository requirements.
Dimensions Education:
Bachelor's Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience.
Experience:
A minimum of 3 years of IT work experience in business intelligence tools and systems.
Complexity:
Intermediate professional level role. Provides daily administration, maintenance and support of data warehouse applications in multi-platform environments. Works on multiple projects as a team member and may lead projects of moderate complexity. May coach more junior technical staff.
Acts as liaison between business and IT leadership regarding the identification of business critical information and knowledge (e.g., customer and market data), and its usage and availability. Manages the Decision Support staff to ensure that the Decision Support Systems (DSS) and Executive Information Systems (EIS) are built to meet the information needs of the business leaders and various business units. Has full understanding of corporate strategies and must manage the diversity of needs and prioritize those needs based on the overall business strategy of the organization.
Works closely with key business leaders to define critical information needs, providing guidance regarding availability of data, capability of systems to deliver information needs, and subject matter expertise regarding current systems and emerging technology. Leads the research, evaluation and selection of new technologies. Leads cost and feasibility studies. Ensures project management process is in place, provides resource management and ensures quality and timely solutions. Needed knowledge includes process and data modeling, data architectural development methodology, IT planning methodology, consulting and facilitation, project management and extensive knowledge of the enterprise's data and decision-making processes.
Dimensions Education:
Bachelor's Degree in Computer Science, Information Systems, Business Administration, or other related field.
Or equivalent work experience.
Experience:
A minimum of 7 years of IT work experience including managing team(s) responsible for database, data warehouse, decision support systems and executive information systems development, support and administration.
Breadth: Middle level management in the data warehouse function. Works under general direction of senior level management. Typically manages and mentors supervisors, project leaders and/or technical staff. Works on multiple, complex projects as a project leader and a subject matter expert. Frequently reports to a Director, Data Warehouse or Director, Systems and Programming.
Works closely with customers and design teams in prioritizing data and information requirements. Determines how Decision Support Systems (DSS) and Executive Information Systems (EIS) will provide the information required to make effective business decisions; translates requirements into applications that employ appropriate decision support and reporting tools. Involved in the design, development and maintenance of DSS. Performs modeling of data sources and flows, works with data management staff to define an operational framework that will define, develop and implement DSS, EIS, policies and security frameworks to ensure precise and secure delivery of knowledge and information. Monitors system performance, implements changes to optimize performance. Involved in the selection of new products. Needed skills and knowledge includes process and data modeling, DSS architecture and tools, development life cycle methodologies, IT planning methodology, extensive knowledge of the enterprise's data and decision-making processes.
Dimensions Education:
Bachelor's Degree in Computer Science, Information Systems, or other related field. Or equivalent work
experience.
Experience:
A minimum of 3 years of IT work experience in business intelligence tools and systems.
Complexity:
Intermediate professional level role. Provides support for user community and development team in design, development and maintenance of DSS and/or EIS applications. Works on multiple function tasks that tend to be of medium technological complexity. Identifies and recommends technology solutions. Works one or more projects as a team member and may lead projects of moderate complexity. May coach more junior technical staff.
Supports the user community in the use of business intelligence tools to query files and databases for report outputs. Assists customers in use of OLAP tools, extracts and collects data for performing queries and writing reports. Reviews queries for performance issues, making changes as needed. Participates in the design and development of the system, as well as creation of user documentation. Monitors customer usage, upgrades enterprise-wide OLAP query and reporting tools, monitors batch queries and ensures interoperability and security of various front-end components. Maintains meta data coordination, and supports production system. Needed knowledge includes process and data modeling and data architectural development methodologies.
Dimensions Education:
Associate's or Bachelor's Degree or technical institute degree/certificate in Computer Science, Information Systems, or other
