State of Florida-posted 2 months ago
$80,000 - $85,000/Yr
Full-time • Mid Level
Tallahassee, FL
Executive, Legislative, and Other General Government Support

The Data Engineer position at the Florida Department of the Lottery involves improving existing data architecture and developing strategies for effective data analysis and reporting. The role includes the creation and maintenance of data models, data dictionaries, and data catalogs. Responsibilities include designing, developing, documenting, analyzing, creating, testing, and modifying computer databases or programs based on user or software design specifications. The Data Engineer will coordinate database-related activities and provide expert guidance to affected sections, informing them of planned changes and their implications. Additionally, the position requires documentation of database-related processes and collaboration with developers and database administrators to assist in deployment processes.

  • Designs and optimizes data architecture to support scalable and efficient data processing, storage, and retrieval systems.
  • Implements policies, procedures, and standards to enhance the quality and efficiency of IT infrastructure services.
  • Identifies and drives service improvement plans for IT infrastructure programs.
  • Develops and implements processes to correct discrepancies and ensure data quality.
  • Creates and maintains data models, data dictionaries, and data catalogs.
  • Establishes and enforces a data retention policy to ensure compliance and optimize storage.
  • Leads data cleansing initiatives to maintain data accuracy and usability.
  • Enhances data standardization efforts to improve data integration and retrieval processes.
  • Develops and maintains a comprehensive data cataloging system to facilitate data accessibility and compliance with data governance standards.
  • Implements and maintains data governance frameworks to ensure data integrity and privacy.
  • Collaborates with cross-functional teams to support data-related technical issues.
  • Conducts regular audits of data storage and processing systems.
  • Analyzes business needs to develop specific requirements for data collection and storage.
  • Analyzes data to identify trends, patterns, and correlations.
  • Participates in data cleansing and preparation.
  • Assists in the development, implementation, maintenance, and testing of the Lottery's IT Disaster Recovery Plan and Continuity of Operations Plan.
  • Performs other duties as assigned.
  • Five (5) years of experience as a Data Engineer or similar role.
  • Education level of a bachelor's degree or higher is required.
  • Proficient in using SQL for creating tables, views, and materialized views.
  • Proficient in developing and managing ETL processes.
  • Ability to write and debug SQL.
  • Knowledge of relational database concepts and techniques, specifically Oracle 19c or greater, and PL/SQL.
  • Expertise in designing scalable data structures and implementing methods to clean and validate data.
  • Experience handling private and sensitive personal information.
  • Strong critical thinking skills and systematic problem-solving abilities.
  • Experience preparing, reviewing, tracking, and reporting on IT Infrastructure Key Performance Indicators (KPIs).
  • Experienced with TOAD for Oracle.
  • Approximately 97.5% of the premium for health insurance.
  • 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.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service