Data Engineer II

okgov; Oklahoma; On-site; USD 85,000 - 120,000; Full time

Benefits offered by this job

Generous leave

Comprehensive benefits

Insurance premium assistance

Job summary

Office of Management and Enterprise Services (OMES) in Oklahoma City seeks a Data Engineer II to build and maintain data pipelines and support advanced analytics initiatives. The role focuses on data modeling, ETL processes, and scalable data architectures to enable data-driven decision-making.

You will collaborate with stakeholders and contribute to data platform development; on-site work in Oklahoma City is expected with a solid benefits package and career growth opportunities.

Qualifications

• 4 years of experience in information technology or data management.
• Two-year degree or certification in computer science, MIS, data management, or related field.

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

Skills

ETL pipelines

Data modeling

Data warehousing

Data integration

Cloud data warehouses

Education

Associate degree or certification in CS/MIS/data management

Tools

SQL

Data storage systems

Job description

Data Engineer II

Agency: 090 OFFICE OF MANAGEMENT AND ENTERPRISE SERV

Supervisory Organization: IS-Data

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: Full time

Job Type: Regular

Compensation: Salary is based on education and experience.

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.
• 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

  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

  • 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 act