APPLICATION ANALYST II - ENTERPRISE DATA WAREHOUSE

Click here to apply: https://administrators-ocps.icims.com/jobs/68144/application-analyst-ii---50286187/job?mode=view
APPLICATION ANALYST II – Enterprise Data Warehouse
QUALIFICATIONS:
1. Associate of Arts degree with courses related to technology from an accredited institution or an equivalent combination of related education, training and/or experience which provides the required knowledge, skills and abilities to perform the essential job functions.
2. Two (2) years of experience with a Business Intelligence application. Cognos Analytics (v10.x.x or higher) or Oracle Business Intelligence Enterprise Edition (v11.x or higher).
3. Three (3) years of experience with a SQL programming language. (PL-SQL, T-SQL, SQL, or My-SQL) PL-SQL preferred.
4. Two years of experience with ETL programming concepts. Oracle Warehouse builder preferred.
KNOWLEDGE, SKILLS AND ABILITIES:
Knowledge and commitment to decentralized decision-making, and accountability for results. Ability to work and communicate effectively as part of the team to participate in the implementation of administrative computer applications that achieve expected results. Analytical skills to review information, identify important issues and formulate alternative solutions to problems in area of responsibility. Knowledge of systems design techniques and multiple programming languages. Ability to remain current with changing technology as it relates to Systems Development. Knowledge of software applications and their corresponding functions. Ability to think and function logically in a multi-tasking environment. Ability to plan work and effectively utilize time. Knowledge of data warehousing technical components and business intelligence technologies. Knowledge of data base architecture and designs, star schemas, dimensional models, and data marts. Knowledge of business intelligence dashboard components and architectures.
REPORTS TO:
Enterprise Data Architect
JOB GOAL:
To analyze processes to facilitate, design, integrate, develop, test, implement and support enterprise student applications in support of district priorities.
SUPERVISES:
None
MACHINES, TOOLS, EQUIPMENT:
Machines, tools, equipment, electronic devices, vehicles, etc., used in this position. Telephone, Computer, (Personal Computer and Mainframe), Automobile, Copier
Application Analyst II – Enterprise Data Warehouse
01/20/2021 2
PHYSICAL REQUIREMENTS:
Describes physical conditions of this position.
Light Work: Exerting up to 20 pounds of force occasionally and/or up to 10 pounds of force
frequently. If the use of arm and/or leg controls requires exertion of forces greater than that for
sedentary work and the worker sits most of the time, the job is rated as Light Work.
PHYSICAL ACTIVITY:
Physical activities of this position. Percent of a typical day involved in each applicable activity is
noted.
Percentage
70 Sitting: Resting with the body supported by the buttocks or thighs.
10 Standing: Assuming an upright position on the feet, particularly for sustained periods of time.
10 Walking: Moving about on foot to accomplish tasks, particularly for long distances.
5 Bending: Lowering the body forward from the waist.
5 Reaching: Extending hand(s) and arm(s) in any direction.
5 Lifting: Raising objects from a lower to a higher position or moving objects horizontally from
position-to-position through the use of the upper extremities and back muscles exerting up
to 10 pounds of force.
80 Finger Dexterity: Picking, pinching, typing or otherwise working primarily with fingers rather
than with the whole hand or arm.
70 Grasping: Applying pressure to an object with the fingers and palm.
90 Talking: Expressing or exchanging ideas by means of the spoken word. Those activities in
which detailed or important spoken instructions must be conveyed accurately, loudly or
quickly.
90 Hearing Acuity: The ability to perceive speech and other environmental sounds at normal
loudness levels.
90 Visual Acuity: The power to see at a level which allows reading of numbers and text,
operation of equipment, inspection of machines, etc.
Note: Will total more than 100 percent as several activities may be performed at one time.
WORKING CONDITIONS:
Conditions the worker will be subject to in this position.
Indoors and Outdoors: The worker is subject to both environmental conditions. Activities occur
inside and outside.
Application Analyst II – Enterprise Data Warehouse
01/20/2021 3
PERFORMANCE RESPONSIBILITIES:
? Manifest a professional code of ethics and values.
? Respond to internal and external customers in a timely, accurate, courteous and empathetic
manner representing OCPS in a positive light.
? Model the routine, intentional and effective use of technology in daily work, including
communications, organization and management tasks.
? Provide services that support the development life cycle of enterprise automated student
applications necessary for compliance with state statute, school board policy, and operational
efficiency. Assignment and responsibility will be specific to a minimum of one of the following
functional areas: Student registration, demographics, school assignment, scheduling,
attendance, student behavior, pupil progression, gradebook, grades, report cards, test scores,
one identification card, and Florida DOE requirements.
? Work with subject matter experts to acquire and keep up-to-date a knowledge base of the
Learning Communities and district operational processes in assigned area at a level sufficient
to analyze and support systems and processes of moderate complexity to resolve problems
expeditiously, offering alternatives where appropriate.
? Produce estimates of time to complete assigned tasks; maintain and meet agreed upon
schedules that achieve desired results meeting quality expectations as district and Learning
Community needs evolve.
? Prepare documents for systems, components, and programs as assigned.
? Work as a team player to achieve results. Must be able to build positive working relationships
with database administrators and ETL developers.
? Participate in the analysis of business requirements for the EDW as they relate to business
intelligence.
? Apply skills toward resolving issues related to the BI backend environment.
? Keep the senior business intelligence team member within the EDW team informed about
issues and incidents about which they should be aware.
? Follow the district’s policies and procedures as related to all HRMD guidelines and the
district’s instructional initiatives.
? Follow the district’s policies and procedures as related to fixed assets.
? Develop leadership in subordinates.
? Responsible for keeping up to date on current technology being used by OCPS. With the
support of the district, attend training to ensure skill level in various technologies is at the level
required to perform in current position.
? Responsible for maintaining timely and accurate information and accountable for the quality
of information maintained by those they supervise.
? Responsible for self-development and keeping up to date on current research, trends and
best practices relevant to the area of responsibility.

• Perform other duties and responsibilities as assigned by the lead.

? Essential Performance Responsibilities
TERMS OF EMPLOYMENT:
Non-bargaining unit compensation plan, twelve months, 8.0 hours per day.
EVALUATION:

Performance of this job will be evaluated in accordance with provisions of the Board’s policy on evaluation of personnel.

Job Type: Full-time

Benefits:

• Dental insurance
• Health insurance
• Retirement plan
• Vision insurance

Schedule:

• 8 hour shift

Education:

• Associate (Preferred)

Experience:

• Business Intelligence application: 2 years (Required)
• a SQL programming language: 3 years (Required)
• ETL programming concepts: 2 years (Required)

Company's website:

• https://administrators-ocps.icims.com/jobs/68144/application-analyst-ii---50286187/job?mode=view

Work Remotely:

• No

COVID-19 Precaution(s):

• Remote interview process
• Personal protective equipment provided or required
• Temperature screenings
• Social distancing guidelines in place
• Virtual meetings
• Sanitizing, disinfecting, or cleaning procedures in place