Data Analyst

North Carolina Farm Bureau Insurance Group

Raleigh, NC

JOB DETAILS
SKILLS
Access Control, Agile Programming Methodologies, Analysis Skills, Best Practices, Business Analysis, Business Intelligence, Business Intelligence Software, Business Solutions, Communication Skills, Computer Science, Data Analysis, Data Migration, Data Modeling, Data Modeling Tools, Data Quality, Data Sets, Data Visualization, Data Warehousing, Data Warehousing Applications, Database Administration, Database Design, Database Extract Transform and Load (ETL), DevOps, Enterprise Data Integration, Environmental Monitoring, Error Handling, Identify Issues, Information Technology & Information Systems, Insurance, Logic Design, Microsoft Visual Studio, Microsoft Windows Azure, Multitasking, Operational Support, Organizational Skills, Performance Analysis, Performance Management, Performance Tuning/Optimization, Problem Solving Skills, Process Development, Process Improvement, Publications, Query Optimization, Reporting Dashboards, Requirements Management, SQL (Structured Query Language), SQL Databases, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Server Maintenance, Software Development Lifecycle (SDLC), Sprint Planning, Stored Procedures, Sybase PowerDesigner, Systems Administration/Management, Systems Analysis, Tableau, Team Player, Technical Writing, Time Management, Work From Home
LOCATION
Raleigh, NC
POSTED
23 days ago

About UsAt North Carolina Farm Bureau Insurance, we take pride in our strong, community-oriented roots that began right here in North Carolina. In 1953, our company was born out of the need to provide insurance coverage to our farmers and rural communities. Now, with local offices in each of the 100 counties, we provide services to all North Carolinians across the state. Here at NCFB we are a familiar face in the community with a service oriented mindset that truly sets us apart. Guided by our mission, we are deeply committed to both our neighbors and employees. Helping you is what we do best! If you are passionate about making a meaningful impact and value a people-centered culture, we invite you to join us!About the RoleKey responsibilities include designing and developing SSIS-based ETL solutions, optimizing SQL queries for reporting and business intelligence dashboards, maintaining Tableau Server while developing interactive data visualization dashboards. The role also involves supporting end-to-end project delivery in Agile environments using Azure DevOps.Education & ExperienceA four-year degree with courses in Computer Science or Information Systems.Minimum of three years experience in a development or analysis role in an enterprise setting.Required Skills and AbilitiesHands-on experience with complex ETL process development and maintenance using SQL Server Integration Services (SSIS), including data flow design, transformation logic, and error handling for reliable data movement.Strong knowledge of data integration concepts, with the ability to consolidate data from multiple systems into unified platforms for reporting, analytics, and business intelligence.Experience with interactive Tableau dashboard design, visualization best practices, and the conversion of complex datasets into actionable business insights.Proven Tableau Server administration experience, including user access control, workbook publication, server upgrades, performance monitoring, and environment maintenance.Proficiency with complex SQL queries, stored procedures, views, and database objects to support reporting, analytics, troubleshooting, and performance improvement.Knowledge of data modeling, relational database design, normalization principles, and data warehouse methodologies.Familiar with Software Development Life Cycle (SDLC) processes and Agile methodologies, with the ability to support sprint planning, testing, and iterative project delivery.Experience with Visual Studio and SQL Server Reporting Services (SSRS) report development, including parameterized reports, automated subscriptions, and report optimization.Strong analytical and problem-solving skills, with the ability to gather, analyze, and document business requirements, workflows, and functional specifications through stakeholder collaboration.Excellent communication, collaboration, and organizational skills, with the ability to manage multiple priorities, work independently, and meet deadlines in fast-paced environments.Location & Commitments Position is located in Raleigh, NC and applicant must live in North Carolina.Hybrid work from home policy.Responsibilities of the RoleCollaborate with business stakeholders, analysts, and development teams to identify, troubleshoot, and resolve data, reporting, and process-related issues.Design, develop, and maintain ETL pipelines to support enterprise data integration, migration, and transformation initiatives.Analyze, troubleshoot, and optimize SQL queries and database processes to improve system performance.Maintain Tableau Server environments, including user access management, workbook deployment, performance tuning, version upgrades, and system monitoring.Analyze and validate data from multiple sources to design Tableau dashboards and business intelligence solutions.Develop, enhance, and maintain enterprise reporting solutions.Utilize data modeling tools such as PowerDesigner to create logical and physical data models supporting operational databases, data warehouses, and BI applications.Monitor daily batch processing jobs and proactively identify, communicate, and resolve issues related to data integrity, ETL workflows, and database operations.Create and maintain technical documentation, including job flows, data mappings, process workflows, and system design specifications.This document is intended to outline the essential responsibilities of the position, and does not limit the tasks that may be assigned or amended by the supervisor.

About the Company

N

North Carolina Farm Bureau Insurance Group