Data Engineer II

State of Oklahoma • Oklahoma City, OK

3d • Onsite

About The Position

As a Data Engineer II with the Office of Management and Enterprise Services (OMES), you will support the Data Services Team within the Information Services Division and be dedicated to the Department of Transportation (ODOT). You will build and maintain data pipelines and platforms that enable advanced analytics and data-driven decision-making. The role includes managing complex data engineering projects, collaborating with stakeholders, designing scalable data architectures, reliably ingesting and processing large datasets, and optimizing data storage and retrieval. Salary is based on education and experience. The position is full-time, 40 hours per week, and on-site in Oklahoma City, Oklahoma.

Requirements

• Four years of experience in an information technology field or data management.
• A two-year degree or certification in computer science, management information systems, data management, or a related field.

Nice To Haves

• Knowledge of data storage systems and techniques.
• Knowledge of data transformation systems and techniques.
• Experience developing software.
• Ability to produce accurate, timely, high-quality work for a customer.
• Experience providing excellent customer service to internal and external clients.
• Experience developing data pipelines on cloud computing platforms.
• Experience with cloud data warehouses.
• Experience analyzing business requirements.
• Experience designing solutions to business problems.
• Experience developing alerts and monitoring for data pipelines.
• Familiarity with ticketing and project management systems.

Responsibilities

• Develop data pipelines to replicate and aggregate data in a data warehouse.
• Model data and handle data acquisition and access analysis and design.
• Design and implement archive, recovery, and load strategies.
• Determine database structural requirements by analyzing client or internal operations, applications, and programming.
• Review objectives with clients or internal users and evaluate current systems.
• Coordinate new data development, ensuring consistency and integration with the existing warehouse structure.
• Review business requests for data and data usage.
• Research data sources for new and improved data feeds.
• Contribute to continuous improvement efforts to enhance performance and functionality.
• Coordinate testing, monitoring, and alerting to ensure data quality.
• Perform other duties as assigned.

Benefits

• 15 days of vacation annually.
• 15 days of sick leave annually.
• 11 paid holidays annually.
• A comprehensive benefit package with a benefit allowance to offset insurance premiums for employees and eligible dependents.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree