Data Engineer II

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., * 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., 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.

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

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.