Data Engineer III

Job Posting Title

Data Engineer III

Agency

090 OFFICE OF MANAGEMENT AND ENTERPRISE SERV

Supervisory Organization

CIO

Job Posting End Date (Continuous if Blank)

October 26, 2024

Note: Applications will be accepted until 11:59 PM on the day prior to the posting end date above.

Estimated Appointment End Date (Continuous if Blank)

Full/Part-Time

Full time

Job Type

Regular

Compensation

Salary is up to $103,400.00 based on education and experience.

Job Description

As a Data Engineer III with OMES you will enjoy:

• Generous leave including 15 days of vacation, 15 days of sick leave and 11 paid holidays annually.
• A comprehensive Benefit Package with a generous benefit allowance to offset the cost of insurance premiums for employees and their eligible dependents.

Job Details

• Full-time 40-hour work weeks.
• Support the Data Services Team with the Information Services Division.
• Position is on-site in Oklahoma City, OK

Position Summary

We are seeking a skilled and experienced Data Engineer III to join our innovative data services team. As a Data Engineer III within our organization, you will play a critical role in building and maintaining robust data pipelines that enable advanced analytics initiatives and support data-driven decision-making. Leveraging your strong foundation in data modeling, ETL processes, and data warehousing, you will manage complex data engineering projects and demonstrate increased initiative in collaborating with stakeholders at various levels.

Your responsibilities will include designing and implementing scalable data architectures, ensuring the reliable ingestion and processing of large datasets, and optimizing data storage and retrieval for performance and efficiency. Furthermore, you will contribute significantly to the development and maintenance of data platforms and tools that facilitate efficient data analysis and integration. With a proven track record of advancing data engineering solutions, you will enhance our team's capabilities in managing our data ecosystem. This role offers a fantastic opportunity to impact our data architecture, refine data management practices, and foster innovation within our organization. This position will provide support to the Department of Transportation.

Key Responsibilities

• Develops data pipelines to replicate and aggregate data in a data warehouse. 
• Models data and is responsible for data acquisition and access analysis and design. 
• Designs and implements archive, recovery, and load strategies. 
• Determines database structural requirements by analyzing client or internal operations, applications, and programming. 
• Review objectives with clients or internal users and evaluate current systems. 
• Coordinates new data development, ensuring consistency and providing for integration with existing warehouse structure. 
• Reviews business requests for data and data usage. 
• Research data sources for new and better data feeds. 
• Assists in continuous improvement efforts in enhancing performance and providing increased functionality.
• Coordinates testing, monitoring, and alerting to ensure data quality. 
• May be responsible for preparing users by conducting training. 
• Administrates Cloud platform(s).
• Trains new team members, or business users of the data platform.
• Develops, maintains, and enforces data platform best practices.

Physical Demands and Work Environment

This position works in a comfortable office setting for a large percentage of the workday. The noise level in the work environment is usually mild. Occasional travel may be required.

Minimum Qualifications

5+ years of experience in an information technology field and a 2-year degree or certification in computer science, management information systems, data management or a related field. 

Preference will be given to candidates who possess

• Knowledge of any data storage systems and techniques.
• Knowledge of any data transformation systems and techniques.
• Experience developing software.
• Ability to produce an accurate, timely and quality product to a customer.
• Experience providing provide excellent customer service to both 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 a business problem.
• Experience developing alerts and monitoring for data pipelines.
• Experience delivering end-to-end solutions without support.
• Experience training others on data-engineering related skills or topics.
• Familiarity with ticketing and project management systems.

About OMES

The Office of Management and Enterprise Services provides excellent service, expert guidance and continuous improvement in support of our partners’ goals. We are a highly qualified workforce committed to serve those who serve Oklahomans and make government run in the most efficient, innovative manner possible.

OMES is an Equal Opportunity Employer. Reasonable accommodation to individuals with disabilities may be provided upon request.

Equal Opportunity Employment

The State of Oklahoma is an equal opportunity employer and does not discriminate on the basis of genetic information, race, religion, color, sex, age, national origin, or disability.

Current active State of Oklahoma employees must apply for open positions internally through the Workday Jobs Hub.