Develop standards and procedures for data warehousing, and the design and development of data information systems and information management functions. Enforce data integrity, security, and stewardship. Provide data structure, integration and intelligence solutions. May design and develop databases and systems used to acquire, store and analyze a company’s business intelligence. A Bachelor’s degree (or equivalent experience) in a Math or Computer Science Program is required.
- Guide business partners in developing and implementing BI-related strategic goals that will assist them in achieving their objectives.
- Direct, influence, and support projects in the implementation and use of new BI software tools and systems.
- Lead the integration efforts for merging BI platforms with enterprise systems and applications.
- Design, code, test, and document all new or modified BI systems, applications, and programs.
- Develop the Data layer, Cubes, metadata and report functionality.
- Lead the design of databases and data warehouses to ensure interoperability with BI solutions.
- Analyze user requirements and, based on findings, design functional specifications for BI front-end applications.
- Work with project managers to ensure that data entry, retrieval, change and delete functions meet business requirements for project completion.
- Design and deliver end-user training and training materials; provide technical support as necessary.
- Troubleshoot BI tools, systems, and software; performance-tune these applications as necessary.
- Act as evangelist for BI benefits throughout the organization promoting healthy usage and adoption of standards and best practices.
- Evaluate and influence selection of database/data warehouse components, including hardware performance, dimensional and relational database management systems, ETL best practices, metadata management tools, and database design solutions.
- Conduct research and provide recommendations regarding BI products, services, and standards to support customer procurement, retention, and development efforts.
- Mentor and/or provide leadership to members of the team.
- Develop, design, implement, enhance, maintain and analyze database systems, queries, and procedures in SQL Server and other environments.
- Develop complex SQL SSIS packages for ETL data to Data Warehouse projects and assignments and be able to modify existing Data Warehouse structure to incorporate data from disparate data sources.
- Perform development and unit testing of ETL processes (various platforms).
- Develop, test, and implement solutions that involve databases, OLAP cubes and reporting components.
- Perform initial data load and data validation in production environment
- Conduct knowledge transfer sessions with team members, business and IT partners
- Facilitate user requirement discussions with the business and drive architecture and design consistent with enterprise strategy
- Critical Thinking — Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.
- Active Listening — Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times.
- Reading Comprehension — Understanding written sentences and paragraphs in work related documents.
- Active Learning — Understanding the implications of new information for both current and future problem-solving and decision-making.
- Speaking — Talking to others to convey information effectively.
- Judgment and Decision Making — Considering the relative costs and benefits of potential actions to choose the most appropriate one.
- Systems Analysis — Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes.
- Time Management — Managing one's own time and the time of others.
- Writing — Communicating effectively in writing as appropriate for the needs of the audience.
- Complex Problem Solving — Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
- Social Perceptiveness — Being aware of others' reactions and understanding why they react as they do.
- Systems Evaluation — Identifying measures or indicators of system performance and the actions needed to improve or correct performance, relative to the goals of the system.
- Coordination — Adjusting actions in relation to others' actions.
- Mathematics — Using mathematics to solve problems.
- Monitoring — Monitoring/Assessing performance of yourself, other individuals, or organizations to make improvements or take corrective action.
- Persuasion — Persuading others to change their minds or behavior.
- Learning Strategies — Selecting and using training/instructional methods and procedures appropriate for the situation when learning or teaching new things.
Title: Job Zone Four: Considerable Preparation Needed
Education: Most of these occupations require a four-year bachelor's degree, but some do not.
Related Experience: A considerable amount of work-related skill, knowledge, or experience is needed for these occupations. For example, an accountant must complete four years of college and work for several years in accounting to be considered qualified.
Job Training: Employees in these occupations usually need several years of work-related experience, on-the-job training, and/or vocational training.
Job Zone Examples: Many of these occupations involve coordinating, supervising, managing, or training others. Examples include accountants, sales managers, database administrators, teachers, chemists, art directors, and cost estimators.
SVP Range: (7.0 to < 8.0)