If you are interested in the following position please contact Dr. Cole and send your resume at rocole@fscj.edu.
JOB TITLE: Data Warehouse Analyst EEO CODE: 02
PAY GRADE/BAND: 340 FLSA: E
BARGAINING UNIT: PEA OCC CODE:2342
POSITION SUMMARY:
Professional work that provides support to internal customers in using data warehouse query tools and other business intelligence applications. Participates in all technical aspects of Data Warehouse and Business Intelligence projects through the complete software development lifecycle (SDLC). Also supports and maintains existing data warehouse subject areas.
IMMEDIATE MANAGER: Director, Business Intelligence
SUPERVISION/DIRECTION RECEIVED: General
REQUIRED COMPETENCIES:
Proficient – Working understanding of the required competencies, with some advanced skills and abilities, sufficient to successfully apply them under general supervision.
Knowledge of:
· Data warehouse concepts, principles, practices and techniques.
· Applications analysis and programming principles, practices and techniques.
· Computer hardware, software and data communications functionality and capability.
· Basic business concepts.
Skill in:
· Developing and/or supporting basic data warehouse applications.
· Using database management tools.
· Trouble shooting and solving technical problems.
· Using Fourth-Generation (4GL) or Fifth-Generation (5GL) structured programming language.
Ability to:
- Set priorities and establish a systematic course of action to ensure accomplishment of objectives on time and within budget.
- Deal with some ambiguity and make decisions with limited information.
- Exercise some creativity and imagination in approaching assignments.
- Quickly grasp new ideas and concepts.
- Work well within a team and assist others with their assignments.
- Acquire and maintain basic knowledge of the business of JEA and Technology Services products.
- Research and acquire knowledge of developing information technology trends and emerging technologies.
- Identify what issues need to be communicated and inform others.
- Communicate effectively, orally and in writing, with users of varied backgrounds and experience.
- Establish effective working relationships with internal customers.
- Follow through with commitments.
EXAMPLES OF WORK:
· Implements business rules via stored procedures, middleware or other technologies.
· Participates in the implementation, support maintenance and enhancement of data warehouse products and services.
· Interacts with other technical team members to establish technical specifications.
· Defines user interfaces and functional specifications.
· Develops extract, transform and load (ETL) programs and business intelligence applications to meet implementation requirements or enhance customer functionality.
· Supports specified ETL programs under direct supervision.
· Performs routine testing of ETL programs affected by applications and database patches.
· Resolves escalated problems and refers new and unusual problems or situations to a higher level.
· Participates in ongoing training to continuously upgrade technical knowledge and skills.
· Performs other job-related tasks as assigned.
PERSONAL CONTACTS:
Regular contact with users in other work groups is required to obtain and clarify information, coordinate problem solving actions and provide other technical assistance.
OPEN REQUIREMENTS:
Bachelor’s Degree in Computer Science or related discipline and two (2) years of professional experience in the specific computer systems analysis, software development and/or system configuration discipline being recruited.
OR
A combination of six (6) years education and experience.
PROMOTIONAL REQUIREMENTS: N/A
LICENSE/CERTIFICATION/REGISTRATION:
Certification, Registration and/or Training specific to the job may be required during employment.
PROBATIONARY PERIOD: 1 year
SAFETY SENSITIVE: No
PHYSICAL REQUIREMENTS:
Sitting |
Up to 7 hours per day |
Lifting |
Up to 2 hours per day |
|
|
Walking |
Up to 2 hours per day |
|
Up to 50 max. pounds |
|
|
Standing |
Up to 3 hours per day |
Pushing |
Will not generally apply |
|
|
Bending |
Up to 2 hours per day |
|
Up to 50 max. pounds |
|
|
Squatting |
Up to 1 hour per day |
Pulling |
Will not generally apply |
|
|
Stooping |
Up to 2 hours per day |
|
Up to 50 max. pounds |
|
|
Reaching |
Up to 2 hours per day |
Climbing |
|
|
|
Balancing |
Up to 1 hours per day |
Stairs |
Up to 1 hours per day |
|
|
Twisting |
Up to 1 hour per day |
Ladder |
Will not generally apply |
|
|
Crawling |
Will not generally apply |
Poles |
Will not generally apply |
|
|
Kneeling |
Will not generally apply |
Outdoors |
Will not generally apply |
|
|
PC Use |
Up to 6 hours per day |
|
||
|
Unusual hearing or vision demands: |
None specified |
|||
|
Other physical demands or notes: |
JEA employees should not attempt to lift, pull or push a load in excess of 50 lbs. without assistance. Care should always be taken when lifting, pushing or pulling in an awkward position. Must possess sufficient strength and agility to perform lifting, climbing and carrying of tools and equipment. Able to wear appropriate safety equipment; work at heights and perform arduous duties. |
|||