Applications Programming Manager jobs in Rio Rancho, NM

JOB TITLE: Data Applications Manager

SALARY GRADE: 10

DIVISION: Information Technology

FLSA CODE: EX

DESCRIBE PRIMARY REASON JOB EXISTS:

The Data Applications Manager is responsible for the organizing, storing, and utilization of data related to the Lottery and its providers. This position utilizes technical, analytical, and creative skills to deliver information to internal stakeholders that helps the Lottery better understand its business.

ESSENTIAL FUNCTIONS:

FUNCTION: Database Querying and Reports

%Time: 50%

Frequency: Daily

Major Duties:

1. Designs, schedules, and maintains database queries. Translates query results into user- friendly reports that meet the needs of Lottery management and staff.

2. Automates regular reports and information requests.

3. Problem-solves and finds creative solutions for management and staff data needs.

FUNCTION: Gaming System Operations

%Time: 10%

Frequency: Daily

Major Duties:

1. Performs user acceptance testing for elements of the Lottery’s gaming system that pertain to back-office and gaming system reports.

2. Meets with internal stakeholders to understand and document requests for back-office and gaming system reports.

3. Works with gaming vendors to document and troubleshoot issues.

4. Cross-trains and assists as directed in troubleshooting, development, and user acceptance testing of other areas related to the gaming system, such as game development, retailer equipment, and internal control systems.

FUNCTION: Internal Database Management

%Time: 35%

Frequency: Daily

Major Duties:

1. Responsible for maintaining the integrity and performance of Lottery databases, including the database used for accounting software.

2. Evaluates and recommends database modifications and software purchases. Oversees the development of new databases as needed.

3. Coordinates access to databases and any scripts needed to automate information internally or with vendors, such as for the Lottery’s website or winning numbers hotline.

FUNCTION: Other Duties as Assigned

%Time: 5%

Frequency: As Needed

1. Assists with various information technology and Lottery duties as requested.

Total Percentage of time: 100%

TYPICAL COMPETENCIES:

KNOWLEDGE: (Describe specialized knowledge required)

1. Strong knowledge of database query composition and related tools; for example, the Lottery has used Toad Data Point.

2. Knowledge of efficient and user-friendly report design and the tools end users would utilize to access reports.

3. Knowledge of relational databases and programming languages; both SQL and Oracle are used in Lottery and gaming system databases.

SKILLS/ABILITIES: (Include intellectual skills/abilities, equipment used, production levels)

1. Must possess highly developed problem-solving, analytical, and mathematical skills.

2. Must have excellent written and oral communications skills.

3. Must have the judgment and decision-making capabilities to work independently without constant direct supervision from management.

4. Must possess and practice those traits and qualities that foster and maintain cordial and professional working relationships which further cooperative efforts toward individual and organizational goals and objectives.

JOB RELATIONSHIPS:

Supervised By: Deputy Director of Information Technology

Positions Supervised: None

REQUIREMENTS NECESSARY TO PERFORM ESSENTIAL FUNCTIONS:

Normal visual, hearing, and speech acuity is required, as is manual ability to operate a keyboard and calculator. The requirements in this section are not intended to conflict with applicable federal and state laws or regulations including the Americans with Disabilities Act and the New Mexico Human Rights Act, including providing reasonable accommodations as may be necessary under these laws. The NMLA encourages application for this position, and for all work positions, from any applicant who believes they can perform the essential functions of the job applied for with or without accommodations.

WORK ENVIRONMENT

General office setting but also requires ability to bend and lift, and occasional travel.

TYPICAL EXPERIENCE/EDUCATION/CERTIFICATIONS:

Bachelor’s degree in computer science, information systems, or a related field is required. Sufficient prior work experience related to database querying and report creation is required. Database or related certifications are a plus. Lottery gaming system or lottery IT experience is a plus.

The foregoing job description is not all-inclusive of the duties, functions, and accountabilities to which an employee may be assigned. In order to ensure maximum staff flexibility and efficiency, to promote and foster cross training among positions, and to meet changing operational needs, employees will be assigned to such additional related duties and projects as are deemed necessary or desirable by management.

This job description is not a contract of employment, nor is it meant to be part of any contract of employment either expressed or implied. All employment and positions with the NMLA are “at will.”

Job Type: Full-time

Pay: $50,125.00 - $85,212.00 per year

Benefits:

• Dental insurance
• Disability insurance
• Employee assistance program
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Retirement plan
• Vision insurance

Experience level:

• 7 years

Schedule:

• 8 hour shift

Work Location: In person