Data Warehouse & SQL ETL Developer

Oklahoma Farm Bureau Insurance; Oklahoma City (OK); On-site; USD 70,000 - 100,000; Full time

Job summary

Oklahoma Farm Bureau Insurance seeks a Database Developer in Information Systems to design, build, and optimize data storage systems that support business applications. You will write complex queries, design schemas, and ensure data integrity while leveraging SQL Server, MySQL, and BI tools.

Responsibilities include warehousing design, data extraction, testing, and documentation to improve system efficiency. Strong SQL, SSRS/SSIS and Power BI experience are essential.

Qualifications

• Four-year college degree or equivalent in computer science or related field.
• Extensive IT concepts and IT documentation knowledge.
• Proven experience as an ETL developer.
• Knowledge of data warehousing concepts and data modeling.
• Insurance domain experience with web applications is a plus.

Responsibilities

• Design and code data warehousing solutions per end-user specs.
• Conduct preliminary testing of warehousing environments before data extraction.
• Ensure data quality and accuracy across systems.
• Extract company data and load into warehousing environments.
• Follow life-cycle methodologies and create design documents.

Skills

Analytical thinking

Teamwork

Oral communication

Written communication

Planning/organizing

Professionalism

Quality

Adaptability

Initiative

Problem solving

Education

Bachelor's degree in computer science or related field

Tools

SQL Server

SSRS

SSIS

MySQL

ODBC

Excel

Power BI

Aurora

Redshift

Snowflake

Job description

Oklahoma Farm Bureau Insurance seeks a Database Developer in Information Systems to design, build, and optimize data storage systems that support business applications. You will write complex queries, design schemas, and ensure data integrity while leveraging SQL Server, MySQL, and BI tools.

Responsibilities include warehousing design, data extraction, testing, and documentation to improve system efficiency. Strong SQL, SSRS/SSIS and Power BI experience are essential.