IT Database Analyst

SUMMARY

Maintain data warehouse and be able to produce analytical reports utilizing a variety of reporting tools. Must be able to create and validate queries written against the various databases and produce reports that can be utilized by the operating departments.

ESSENTIAL DUTIES AND RESPONSIBILITIES include the following:


•Understanding of analytical reporting and query language on the AS/400 and Intel platforms.

•Ability to create ad-hoc reporting for the operating departments utilizing various reporting software packages.

•Ability to analyze data and to produce clean files for direct mail marketing promotions.

•Ability to assist in report writing/modification for financial system software.

•Maintains the confidentiality of IT systems, their applications and employees.

•Ability to troubleshoot areas, place service calls and keep management informed of critical situations.

•Works to provide continual support for users.

•Maintains office integrity.

•Completes production and special assignments as required.

•Must be capable of presenting a positive image of the Casino to its guests and vendors and to assist them as required.

•Must follow all safety policies and procedures and attend all scheduled safety meetings and training as a condition of employment.

•Performs any other duties that may be assigned from time to time.

SUPERVISORY RESPONSIBILITIES

None

Competencies

To perform the job successfully, an individual should demonstrate the following competencies:

*Analytical - Synthesizes complex or diverse information; Collects and researches data; Uses intuition and experience to complement data.

*Design - Generates creative solutions; Translates concepts and information into images; Uses feedback to modify designs; Applies design principles; Demonstrates attention to detail.

*Problem Solving - Identifies and resolves problems in a timely manner; Gathers and analyzes information skillfully; Develops alternative solutions; Works well in group problem solving situations; Uses reason even when dealing with emotional topics.

*Technical Skills - Assesses own strengths and weaknesses; Pursues training and development opportunities; Strives to continuously build knowledge and skills; Shares expertise with others.

*Customer Service - Manages difficult or emotional customer situations; Responds promptly to customer needs; Solicits customer feedback to improve service; Responds to requests for service and assistance; Meets commitments.

*Interpersonal Skills - Focuses on solving conflict, not blaming; Maintains confidentiality; Listens to others without interrupting; Keeps emotions under control.

*Oral Communication - Speaks clearly and persuasively in positive or negative situations; Listens and gets clarification; Responds well to questions; Demonstrates group presentation skills; Participates in meetings.

*Written Communication - Writes clearly and informatively; Edits work for spelling and grammar; Presents numerical data effectively; Able to read and interpret written information.

*Teamwork - Exhibits objectivity and openness to others' views; Gives and welcomes feedback; Contributes to building a positive team spirit; Puts success of team above own interests; Supports everyone's efforts to succeed.

*Cost Consciousness - Works within approved budget; Develops and implements cost saving measures; Contributes to profits and revenue; Conserves organizational resources.

*Diversity - Demonstrates knowledge of EEO policy; Shows respect and sensitivity for cultural differences; Promotes a harassment-free environment.

*Ethics - Treats people with respect; Keeps commitments; Inspires the trust of others; Works with integrity and ethically; Upholds organizational values.

*Organizational Support - Follows policies and procedures; Completes administrative tasks correctly and on time; Supports organization's goals and values; Benefits organization through outside activities; Supports affirmative action and respects diversity.

*Judgement - Exhibits sound and accurate judgment; Supports and explains reasoning for decisions; Includes appropriate people in decision-making process; Makes timely decisions.

*Motivation - Sets and achieves challenging goals; Demonstrates persistence and overcomes obstacles; Measures self against standard of excellence.

*Planning/Organizing - Prioritizes and plans work activities; Uses time efficiently; Plans for additional resources; Sets goals and objectives.

*Professionalism - Approaches others in a tactful manner; Reacts well under pressure; Treats others with respect and consideration regardless of their status or position; Accepts responsibility for own actions; Follows through on commitments.

*Quality - Demonstrates accuracy and thoroughness; Looks for ways to improve and promote quality; Applies feedback to improve performance; Monitors own work to ensure quality.

*Quantity - Meets productivity standards; Completes work in timely manner; Strives to increase productivity; Works quickly.

*Safety and Security - Observes safety and security procedures; Determines appropriate action beyond guidelines; Reports potentially unsafe conditions; Uses equipment and materials properly.

*Adaptability - Adapts to changes in the work environment; Manages competing demands; Changes approach or method to best fit the situation; Able to deal with frequent change, delays, or unexpected events.

*Attendance/Punctuality - Is consistently at work and on time; Ensures work responsibilities are covered when absent; Arrives at meetings and appointments on time.

*Dependability - Follows instructions, responds to management direction; Takes responsibility for own actions; Keeps commitments; Commits to long hours of work when necessary to reach goals; Completes tasks on time or notifies appropriate person with an alternate plan.

*Initiative - Volunteers readily; Undertakes self-development activities; Seeks increased responsibilities; Takes independent actions and calculated risks; Looks for and takes advantage of opportunities; Asks for and offers help when needed.

*Innovation - Displays original thinking and creativity; Meets challenges with resourcefulness; Generates suggestions for improving work; Develops innovative approaches and ideas; Presents ideas and information in a manner that gets others' attention.

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education and/or Experience

High school diploma or general education degree (GED).

Minimum three (3) years experience in related field.

Language Skills

Ability to read and interpret documents such as safety rules, operating and maintenance instructions, and procedure manuals.

Ability to write routine reports and correspondence.

Ability to speak effectively before groups of customers or employees of organization.


Reasoning Ability

Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form.

Ability to deal with problems involving several concrete variables in standardized situations.


Certificates, Licenses, Registrations

Must have or be able to obtain California driver's license.
Must be able to pass background suitability investigation.
Must be able to obtain Tribal Key Gaming License.
Must pass initial and random drug screens.
Must document GED or High School Diploma.


Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is frequently required to stand and sit. The employee must frequently lift and/or move up to 50 pounds. Specific vision abilities required by this job include close vision, color vision and ability to adjust focus.


Work Environment

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

The noise level in the work environment is usually loud.

The Casino is open 24 hours per day, seven (7) days per week; therefore, you must be flexible to work any and all shifts.

The Casino is a gaming facility.

The Casino is not a smoke-free environment.
REQUIREMENTS
Please see job description.