Data Analyst

At NC Farm Bureau, we operate with integrity, employ people who care, and offer benefits that grow with you. Come join the Farm Bureau family. Data Analyst Location Department Position Reports To Department: Information Systems Position Reports To: Information Systems Applications Supervisor About Us At 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 Role Key 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 & Experience A 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 Abilities Hands-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 Role Collaborate 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. How to Apply Send your resume and cover letter to our Corporate Talent Administrator , Kristin Tolley. Send by Mail Send by Email Send your resume and cover letter to our Corporate Talent Administrator , Kristin Tolley. Farm Bureau is an equal employment opportunity employer, and it is the policy of Farm Bureau to maintain a working environment free of discrimination, intimidation, and harassment. This means that all employment decisions at Farm Bureau shall be based on merit, qualifications, and abilities without regard to race, color, creed, religion, sex, national origin, age, physical/mental disabilities, veteran status, or any other characteristic protected by state or federal law. #J-18808-Ljbffr Ncfbins