Sr. Data Engineer
Farm Bureau Mutual Insurance of Idaho
Pocatello, ID US
Posted ago
Farm Bureau Mutual Insurance of Idaho

The Sr. Data Engineer will oversee Data Engineers, and build business data collection systems and processing pipelines. The Sr. Data Engineer will also maintain a Data Warehouse and look for opportunities to increase efficiencies. In addition, they will build data processing frameworks that handle the business’s database.

Responsibilities

Essential Functions

Reasonable Accommodations Statement

To accomplish this job successfully, an individual must be able to perform, with or without reasonable accommodation, each essential function satisfactorily. Reasonable accommodations may be made to help enable qualified individuals with disabilities to perform the essential functions. 

 Essential Functions Statements

  • Work closely with teams and gather technical requirements for data governance across the company
  • Develop and maintain reliable data pipelines
  • Build frameworks and tools to empower data analysts
  • Ability to perform root cause analysis on external and internal processes and data to identify opportunities for improvement and answer questions 
  • Help build, maintain, and improve the Data Warehouse
  • Identifying, designing, and implementing internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes
  • Prepare data for predictive and prescriptive modeling
  • Excellent analytic skills associated with working on unstructured datasets 
  • Ability to build processes that support data transformation, workload management, data structures, dependency, and metadata
  • Miscellaneous tasks as directed

Qualifications

Skills and Abilities

Required;

  • 4+ years in data management including Data Warehousing using star schema
  • Strong knowledge of industry data engineering best practices
  • Strong experience in SQL query design and implementation
  • Experience in SQL performance tuning and query optimization by indexing, partitioning, and denormalization
  •  Strong experience in Informatica
  • Experience with SSIS & SSRS
  • Well versed in migrating and converting data from one system to another
  • Proficient in Microsoft Office suite
  • Experience working with MySQL, flat files, and DB2
  • Experience with ODBC connections
  • Working knowledge of Microsoft Power BI
  • Experience in documenting workflows and processes
  • Supervisory experience

Preferred;

  • Insurance industry software experience (specifically Guidewire)
  • Experience with an Enterprise Accounting System
  • Experience in AWS and Azure environments
  • Knowledge of software development methodologies
  • Experience with Git, Jenkins, and PowerShell
  • Using Big Data platforms
  • Experience working with reporting tools like Cognos, Tableau
  • Programming experience with Python, JavaScript, Java
  • Experience with statistical software such as R, Minitab, SAS, etc. 
  • Knowledge of test-driven development

 Education;

  • Bachelor’s Degree in Computer Science, Information Technology, or related field preferred. 

Compensation
$100,000 to $120,000 yearly DOE
About Farm Bureau Mutual Insurance of Idaho

Our employees are rewarded with a competitive salary, a benefit program that recognizes the diverse needs of our employees, and the security of a well-established company.


Some of our employee benefits include:


  • Health
  • Dental
  • Life
  • Long Term Disability
  • Vacation
  • Sick Leave
  • Holidays
  • Parental Leave/Major Medical Leave
  • 7 1/2 Hour Work Days
  • Purchased Vacation
  • Flexible Schedules
  • Employee Profit-Sharing Plan
  • Section 125 Cafeteria Plan (Tax-Free Spending Account)
  • Loans, Savings, and Investments available through Farm Bureau Finance Company
  • Cancer, Accident, and Short-Term Disability insurance plans are also available

APPLY NOW
Acceptable file formats include .doc, .docx, .pdf, .txt.
By applying, you consent to WizeHire's  Privacy Policy  and  Terms of Service.