Manage data assets and provide reporting/analysis tools to end users. Set enterprise data and reporting standards. Able to manage multiple competing priorities at any given time, is detail-oriented and able to work collaboratively in a deadline driven environment. Proficient in SQL, ODBC, JDBC, REST, JSON, Microsoft SSIS/BIDS, and Excel. A Bachelor’s degree (or equivalent experience) in a Math or Computer Science Program is required.
- Create technical documents to document Oracle or other database contents, concepts, and mapping between databases.
- Participate in the design, development, and analysis of data architecture and warehousing approaches.
- Create business intelligence tools and reports, such as physical data models and dimensional analyses.
- Design, code, test, and aggregate results from SQL queries to provide information to users.
- Design and Develop solutions based on: Microsoft SQL Server Reporting Services (SSRS) development, Microsoft SQL Server Integration Services (SSIS) development and, Microsoft SQL Server Analysis Services (SSAS) development.
- Deploy reporting and dashboard solutions.
- Deploy reporting and dashboard solutions within large Manufacturing Execution Systems (MES), (i.e. Camstar , Apriso , Visiprise ).
- Support full Software Development Lifecycle (SDLC) including requirements, design, development, testing, and training.
- 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)