Data Engineer II

Oklahoma Ag; Oklahoma City (OK); On-site; USD 90,000 - 130,000; Full time

Job summary

OMES in Oklahoma City is seeking a Data Engineer II to build and maintain robust data pipelines enabling analytics and data-driven decisions. You will leverage data modeling, ETL, and data warehousing to manage complex projects and collaborate with stakeholders.

The role focuses on designing scalable architectures, ensuring reliable data ingestion, and supporting data platforms. On-site position with generous leave and comprehensive benefits.

Qualifications

• 4 years of experience in information technology or data management.
• A two-year degree or certification in computer science, MIS, data management, or related field.
• Experience with data pipelines, ETL, data warehousing, and cloud data platforms.

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 archive, recovery, and load strategies.
• Coordinates new data development, ensuring consistency and integration with existing warehouse structure.
• Monitors data quality and coordinates testing and alerting.
• Collaborates with stakeholders to translate business requirements into data solutions.

Skills

Data pipelines

ETL processes

Data modeling

Data warehousing

Cloud computing

Data quality monitoring

Education

Two-year degree or certification in computer science/MIS

Job description

Data Engineer II# State of Oklahoma Careers## Data Engineer IIApply: Oklahoma County: Full time: Posted Today: End Date: October 28, 2026 (6 days left to apply): JR65664**Job Posting Title**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****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.**