Data Analyst, Senior

Louisiana Farm Bureau Insurance; Baton Rouge (LA); Hybrid; USD 95,000 - 125,000; Full time

Benefits offered by this job

Hybrid home/office schedule

Comprehensive benefits package

Job summary

Southern Farm Bureau Casualty Insurance Company is seeking a Senior Data Analyst to guide data modeling and ETL design for the Enterprise Data Warehouse. You will actively participate in Data Governance initiatives and support analytics across operational and analytical databases.

This role works closely with the Data Analyst Lead to align with the Enterprise Data Strategy. Primary responsibilities include modeling data, designing ETL processes, and creating data marts to empower BI tools and

Qualifications

• Experience with data modeling and ETL design for data warehouses.
• Familiarity with Data Governance initiatives and analytics across environments.
• Ability to analyze data, identify patterns, and translate into actionable insights.
• Experience supporting Enterprise Data Warehouse and related data integration.
• Strong communication and collaboration across teams.

Responsibilities

• Analyze and model enterprise data to identify patterns and correlations.
• Design and document ETL strategies to move data between sources and the warehouse.
• Create data marts to support BI tools and end-user reporting.
• Perform statistical analysis and prepare useful presentations from data.

Skills

Data modeling

ETL

Data governance

SQL

Enterprise Data Warehouse

Data analysis

Job description

Are you looking for a great team environment? Southern Farm Bureau Casualty Insurance Company is currently seeking a Data Analyst, Senior. Southern Farm Bureau is a great company and an excellent place to work. The Company offers a family-oriented work environment and a rich benefit package including paid time off, company matched 401(k), pension/retirement, medical, dental, vision, group life, accidental death and dismemberment, employee assistance program, a continued education program, and a hybrid home/office work schedule. This position is located in Ridgeland, MS, Baton Rouge, LA, Cayce, SC and Little Rock, AR. The Data Analyst, Senior will direct and perform logical data modeling, identify patterns in data, design, analyze and document the enterprise data warehouse and ETL processes supporting it. This team member actively participates in Data Governance initiatives to support the Enterprise Data Strategy across operational and analytical database environments. This position will work closely with the Data Analyst Lead working close to support the Enterprise Data Warehouse.

Essential Functions

• Analyze and mining business data to identify patterns and correlations among the various data points.
• Map and trace data within the enterprise data framework in order to solve a given business or system problem.
• Design and create marts to support the business intelligence tools and provide data to the end users in support of business decisions.
• Perform statistical analysis of the enterprise data. Extract existing data to manipulate/calculate/format into useful presentations.
• Identify and explore opportunities to enhance enterprise analytical databases using knowledge gained from experience and from an understanding of emerging methodologies.
• Create and document logical data integration (ETL) strategies for data flows between source/target systems and the Enterprise Data Warehouse.
• Perform a variety of in-depth data analysis, data modeling, and data administration tasks on complicated datasets with potentially complex data integration scenarios with limited supervision.
• Establish, maintain, adhere to, and enforce Enterprise Data modeling and Data Integration standards.
• Must support innovations by actively keeping technical and professional business knowledge current on emerging technology and Data Trends which may fit with enterprise needs. Must be able to research and accurately articulate benefits and goals of these technologies.

Additional Responsibilities

• Regular and predictable attendance is required.
• Other duties as assigned.