Data Analyst

About The CompanyMichigan Farm Bureau is a leading organization dedicated to supporting the agricultural community in Michigan. With a rich history of serving farmers, ranchers, and rural residents, the company aims to promote sustainable farming practices, provide comprehensive insurance solutions, and advocate for policies that benefit the agricultural sector. Committed to innovation and excellence, Michigan Farm Bureau leverages technology and data-driven insights to enhance its services and operations, ensuring its members receive the highest quality support and resources.

About The RoleThe Marketing Data Analyst position at Michigan Farm Bureau offers an exciting opportunity to play a pivotal role in driving organizational success through advanced data analysis. The successful candidate will be responsible for managing and analyzing enterprise contact data, supporting marketing initiatives, and ensuring data integrity across various systems. This role requires a detail-oriented professional with strong technical skills, capable of translating complex data into actionable insights. The analyst will collaborate closely with cross-functional teams, including marketing, IT, and management, to develop effective business models and support strategic decision-making.

The position is based in Lansing, Michigan, and offers a full-time, permanent employment opportunity with competitive compensation and benefits. QualificationsRequired Qualifications: Bachelor's degree in data analytics, finance, computer science, statistics, or a related field, or equivalent experience. Minimum of four years of experience in data analysis, with at least one year specializing in ETL processes. At least one year of experience in Property/Casualty insurance or a similar domain. Proficiency in database query languages and report writing, particularly SQL. Experience working within an agile team environment. Knowledge of system design concepts and platform architecture.

Willingness to pursue ongoing training and professional development. Preferred QualificationsExperience with SQL query development and report generation. ResponsibilitiesThe Marketing Data Analyst will be responsible for supporting the division and organizational needs related to enterprise contact data and analytics. Key responsibilities include: Utilizing data tools such as SQL Server Management Studio to analyze and manage contact data across enterprise systems. Establishing and maintaining data quality analysis functions, including testing for accuracy and completeness, and researching data anomalies. Communicating data issues and providing recommendations for resolution to management.

Serving as a subject matter expert in business technology, assisting with the design, development, and maintenance of contact data systems. Participating in corporate and departmental projects as a Data Steward to ensure data availability, accuracy, and integrity. Providing insights and support for system data and database queries related to marketing activities. Presenting raw data findings along with interpretations and strategic recommendations based on analysis. BenefitsMichigan Farm Bureau offers a comprehensive benefits package designed to support the health, well-being, and financial security of its employees.

Benefits include medical, dental, and vision insurance plans, a 401(k) retirement savings plan with company matching, paid time off, and opportunities for professional development. The organization values work-life balance and provides a supportive environment for career growth and advancement. Employees also have access to various wellness programs and resources aimed at promoting a healthy lifestyle. Equal OpportunityMichigan Farm Bureau is an equal opportunity employer. We are committed to fostering an inclusive environment where all employees and applicants are treated with fairness and respect.

We do not discriminate based on race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected characteristic. All qualified applicants will receive consideration for employment without regard to these factors.