Data Engineer

About The Company

Michigan Farm Bureau is a leading agricultural organization dedicated to serving the needs of Michigan's farmers and rural communities. With a rich history of supporting sustainable farming practices, advocating for agricultural policies, and providing valuable resources to its members, Michigan Farm Bureau plays a vital role in strengthening the agricultural industry within the state. The organization is committed to innovation, community engagement, and fostering a collaborative environment that promotes growth and development in the agricultural sector.

About The Role

The Data Engineer position at Michigan Farm Bureau is a critical role responsible for designing, building, and maintaining robust data pipelines that support the organization’s analytics, reporting, and strategic decision-making processes. The ideal candidate will work closely with cross-functional teams to understand data sources, optimize data flow, and ensure data integrity across various systems. This role requires a proactive approach to managing data architecture, identifying system changes, and adapting pipelines to meet evolving business needs. The Data Engineer will also collaborate with IT and business stakeholders to deliver scalable solutions that align with organizational goals.

Qualifications

The ideal candidate will possess a bachelor’s degree in information systems, computer science, or a related field. Equivalent experience may also be considered. Candidates should have three to five years of experience working with Microsoft SQL Server, T-SQL, Visual Studio IDE, and SSIS or similar ETL platforms. A solid understanding of computer hardware, operating systems, programming languages, and testing tools is essential. Familiarity with systems design and analysis techniques, along with a willingness to pursue ongoing training, is required. Preferred qualifications include experience with transactional and analytical data structures, knowledge of database best practices such as compression, indexing, and security, and prior experience working within the insurance industry.

Responsibilities

• Design, develop, and optimize data pipelines to support business analytics, reporting, and data warehousing initiatives.
• Identify source data systems, understand data flow, and recognize system changes impacting data pipelines.
• Modify and adapt data pipelines to accommodate updates triggered by source system modifications or business requirements.
• Collaborate with IT and business teams to gather requirements, provide technical expertise, and ensure solutions meet organizational needs.
• Monitor data pipeline performance, troubleshoot issues, and implement improvements to enhance efficiency and reliability.
• Ensure data quality, security, and compliance with organizational standards and best practices.
• Document data processes, architecture, and workflows for future reference and compliance purposes.
• Participate in project planning, provide progress updates, and communicate potential risks or dependencies to stakeholders.
• Stay current with emerging data technologies and continuously develop skills in data management and engineering.

Benefits

Michigan Farm Bureau offers a comprehensive benefits package designed to support the well-being of its employees. Benefits include medical, dental, and vision insurance plans, a 401(k) retirement savings plan, paid time off, and professional development opportunities. The organization fosters a collaborative and inclusive work environment, encouraging growth and innovation. As a hybrid position, employees have the flexibility to work remotely from Michigan while also enjoying the benefits of being part of a dedicated team based at the Farm Bureau Home Office in Lansing. Additional perks include a supportive work culture, ongoing training, and opportunities for career advancement within the organization.

Equal Opportunity

Michigan Farm Bureau is an equal opportunity employer. We value diversity and are committed to creating an inclusive environment for all employees. We do not discriminate based on race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability, or any other protected characteristic. We encourage applications from candidates of all backgrounds and experiences to join our team and contribute to our mission of supporting Michigan’s agricultural community.