Data Engineer II

Job Posting Title

Agency

Supervisory Organization

Job Posting End Date

Refer to the date listed at the top of this posting, if available. Continuous if date is blank.

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

Job Type

Compensation

Job Description

As a Data Engineer II 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.
• Salary is based on education and experience.
• Position is on-site in Oklahoma City, OK

Position Summary

As a Data Engineer II 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.

Dedicated to the Department of Transportation (ODOT), 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.

Key Responsibilities

• Develops data pipelines to replicate and aggregate data in a data warehouse
• Model 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
• Reviews objectives with clients or internal users and evaluates 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
• Other duties as assigned

Physical Demands and Work Environment

This position works in a comfortable office setting with a computer and telephone for a large percentage of the workday. This position requires long periods, up to eight hours per day, of sitting and working at a desk. The noise level in the work environment is usually mild. Occasional travel may be required.

Minimum Qualifications

Requirements include 4 years of experience in an information technology field or data management and a two-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
• 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.

If you are needing any extra assistance or have any questions relating to a job you have applied for, please click the link below and find the agency for which you applied for additional information:

Agency Contact