Data Warehouse & SQL Developer

Oklahoma Farm Bureau Insurance Company; Oklahoma City (OK); On-site; USD 80,000 - 110,000; Full time

Job summary

Oklahoma Farm Bureau Insurance Company in Oklahoma City is seeking a skilled Database Developer to design, build, and optimize data storage systems that support business applications. You will write complex queries, design robust schemas, and ensure data integrity across the data warehouse.

The role requires strong SQL Server and MySQL expertise, ETL development, and familiarity with reporting tools such as Power BI.

Qualifications

• Proven work experience as an ETL developer.
• Extensive knowledge of coding languages including ODBC, Excel, text, XML.
• Proficiency in warehousing architecture techniques.
• Experience in P&C Insurance, developing insurance-related activities in web applications.

Responsibilities

• Design and code the data warehousing system to meet end-user specifications.
• Conduct preliminary testing of warehousing environments before data extraction.
• Ensure data quality and accuracy across warehouses.
• Extract company data and migrate it into the warehousing environment.
• Follow lifecycle methodologies, create design documents, and perform coding/testing.
• Develop and execute test plans and data to verify program functionality.

Skills

SQL Server

MySQL

ETL

Data Modeling

Stored Procedures

Data Warehousing

Power BI

ODBC/Excel/XML

Education

Bachelor's degree in computer science or related field

Tools

SSRS

SSIS

SQL Server Agent

Aurora

Redshift

Snowflake

Job description

Oklahoma Farm Bureau Insurance Company in Oklahoma City is seeking a skilled Database Developer to design, build, and optimize data storage systems that support business applications. You will write complex queries, design robust schemas, and ensure data integrity across the data warehouse.

The role requires strong SQL Server and MySQL expertise, ETL development, and familiarity with reporting tools such as Power BI.