Establish and maintain an Enterprise Data Model that describes how data is processed, stored, and utilized. Manage the data structures required to support the enterprise through the BI program. Provide the means of system integration by understanding the source and target data and build the data mapping. Determine architectural approaches for data environments and help ensure that the data needs of the enterprise are being met. Responsible for developing and maintaining a formal description of the data and data structures - this can include data definitions and data models. Build strategy and design for managing data history.
- Understand and translate business needs into data models supporting long-term solutions.
- Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
- Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
- Optimize and update logical and physical data models to support new and existing projects.
- Maintain conceptual, logical and physical data models along with corresponding metadata.
- Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
- Recommend opportunities for reuse of data models in new environments.
- Perform reverse engineering of physical data models from databases and SQL scripts.
- Evaluate data models and physical databases for variances and discrepancies.
- Validate business data objects for accuracy and completeness.
- Analyze data-related system integration challenges and propose appropriate solutions.
- Develop data models according to company standards.
- Guide System Analysts, Engineers, Programmers and others on project limitations and capabilities, performance requirements and interfaces.
- Review modifications to existing software to improve efficiency and performance.
- Examine new application design and recommend corrections if required.
- Complex Problem Solving — Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
- Programming — Writing computer programs for various purposes.
- Systems Analysis — Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes.
- Judgment and Decision Making — Considering the relative costs and benefits of potential actions to choose the most appropriate one.
- 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.
- Critical Thinking — Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.
- Operations Analysis — Analyzing needs and product requirements to create a design.
- 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.
- Mathematics — Using mathematics to solve problems.
- Speaking — Talking to others to convey information effectively.
- Reading Comprehension — Understanding written sentences and paragraphs in work related documents.
- Technology Design — Generating or adapting equipment and technology to serve user needs.
- Time Management — Managing one's own time and the time of others.
- Troubleshooting — Determining causes of operating errors and deciding what to do about it.
- Coordination — Adjusting actions in relation to others' actions.
- Monitoring — Monitoring/Assessing performance of yourself, other individuals, or organizations to make improvements or take corrective action.
- Management of Personnel Resources — Motivating, developing, and directing people as they work, identifying the best people for the job.
- Writing — Communicating effectively in writing as appropriate for the needs of the audience.
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)