SENIOR DATA ANALYST - 36000885

Requisition No: 833163 

Agency: Department of Lottery

Working Title: SENIOR DATA ANALYST - 36000885

 Pay Plan: Lottery Exempt Serv

Position Number: 36000885 

Salary:  85,000.00 Annually 

Posting Closing Date: 09/16/2024 

Total Compensation Estimator Tool

SENIOR DATA ANALYST

FLORIDA DEPARTMENT OF THE LOTTERY – DIVISION OF DATA MANAGEMENT

*Open Competitive Opportunity*

AGENCY BENEFITS:

If hired, as employee of the Florida Lottery, you will be provided the benefits listed below:

• Approximately 97.5% of the premium for health insurance
  • Individual (~$8/month) or Family (~$30/month)
• 100% of the premium for individual or family dental insurance
• 100% of the premium for basic life insurance
• Employer contributions to the Pension Plan or Investment Plan; contribution levels will vary based upon Pay Plans.

GENERAL POSITION DESCRIPTION:

This position involves translating complex business requirements into technological solutions, ensuring alignment between IT capabilities and business goals. As a key liaison, you will work closely with IT staff and business relationship managers to facilitate effective communication and project alignment. Your expertise will also extend to leading the modernization of ETL processes, maintaining the data warehouse, and developing standards and governance for data management. By helping to mentor data team members, you will foster a culture of advanced analytics and data-driven decision-making, enhancing the agency’s capability to deliver on its mission through insightful data interpretation and application.

ESSENTIAL DUTIES:

Each employee is expected to be knowledgeable of the Lottery's Responsible Gaming program, including the No Underage Play and Play Within Your Means messaging, and will ensure retailers and players are aware of the program and provided information, as necessary.

• Provides consultation and technical assistance to development team and functional users.
  • ensuring that both parties are aligned in their understanding and execution of project objectives.
• Analyzes business needs to develop specific requirements for data collection and storage.
• Analyzes data to identify trends, patterns, and correlations that can impact business decisions.
• Creates comprehensive reports and visual presentations to help stakeholders understand the data.
• Develops and implements policies and procedures related to data governance, standards, and best practices.
• Develops detailed database design documents to document data structures and relationships.
• Develops and implements processes to correct discrepancies and ensure data quality.
• Researches and recommends appropriate technical solutions to meet functional requirements.
• Research new data management models and techniques.
• Researches and evaluates sources of information to determine limitations in reliability or usability.
• Determines data requirements and communicates with Database Administrators.
• Audits databases regularly to maintain adherence to guidelines.
• Compares and analyzes statistical information to identify patterns, relationships, and problems.
• Participates in efforts to modernize and optimize ETL processes, ensuring efficient data extraction, transformation, and loading activities.
• Works with Data Engineer to oversee the ongoing maintenance of the data warehouse, implementing improvements to enhance functionality and performance.
• Provide necessary assistance to the Computer Systems Operations Manager, the Orlando Data Center Shift Supervisor, and the COOP Coordinator in the development, implementation, maintenance, and testing of the Lottery’ Information Technology Disaster Recovery Plan (ITDRP) and Continuity of Operations Plan (COOP).
• Performs other duties as assigned.
• Total hours in workweek:  40

 KNOWLEDGE, SKILLS AND ABILITIES:

• Five (5) years of experience as a Data Base Analyst or similar role.
• Proficient in using SQL for database queries and familiar with Oracle SQL Developer as an integrated development environment.
• Proficient in engaging with stakeholders to understand their requirements and translate these needs into system specifications and solutions.
• Proficient in managing ETL processes, including extracting, transforming, and loading data to facilitate streamlined data integration and warehousing.
• Skilled in creating complex SQL queries and troubleshooting or optimizing existing queries for performance.
• Skilled in data mining, data analysis and evaluation, mathematical and statistical skills to gather, measure, organize, and analyze data.
• Skilled in business analytics/visualization tools such as Power BI, Tableau, etc.
• Knowledge of relational database concepts and techniques (specifically Oracle 19c or greater) and PL/SQL
• Solid foundation in mathematics and a thorough understanding of accounting principles, aiding in precise financial data analysis, and reporting.
• Well-versed in employing data mining techniques to discover patterns and relationships in large datasets, enhancing business intelligence efforts.
• Experience working with private and sensitive personal information.
• Experienced with data cataloging and data standardization.
• Proficient business analyst skills.
• Experienced with TOAD for Oracle
• Exceptional logical thinking and problem-solving skills, enabling effective resolution of complex data-related challenges.
• Ability to compile and organize statistical information retrieved and present findings.
• Basic understanding of machine learning.

MINIMUM AGENCY-WIDE REQUIREMENTS:

Successful passing of a criminal background check (state, local, and national) is required.

Maintains strict confidentiality of information learned while working with the Florida Lottery, whether learned through assigned duties or through working with other units.  The types of confidential information may include, but are not limited to, payroll information, budget matters, policy decisions, tax matters, employee disciplinary issues, and other personnel data. 

STATUTES ESTABLISHING OR DEFINING WORK PERFORMED:

Chapter 24, Florida Statutes

The State of Florida is an Equal Opportunity Employer/Affirmative Action Employer, and does not tolerate discrimination or violence in the workplace.

Candidates requiring a reasonable accommodation, as defined by the Americans with Disabilities Act, must notify the agency hiring authority and/or People First Service Center (1-866-663-4735).

Notification to the hiring authority must be made in advance to allow sufficient time to provide the accommodation.

The State of Florida supports a Drug-Free workplace. All employees are subject to reasonable suspicion drug testing in accordance with Section 112.0455, F.S., Drug-Free Workplace Act.

Nearest Major Market: Tallahassee

The State of Florida is an Equal Opportunity Employer/Affirmative Action Employer, and does not tolerate discrimination or violence in the workplace.

Candidates requiring a reasonable accommodation, as defined by the Americans with Disabilities Act, must notify the agency hiring authority and/or People First Service Center (1-866-663-4735). Notification to the hiring authority must be made in advance to allow sufficient time to provide the accommodation.

The State of Florida supports a Drug-Free workplace. All employees are subject to reasonable suspicion drug testing in accordance with Section 112.0455, F.S., Drug-Free Workplace Act.