Data Engineer

Michigan Farm Bureau; Lansing, Northern (MI, KY); Hybrid; USD 82,000 - 100,000; Full time

Benefits offered by this job

Medical, dental, vision, and 401K

Job summary

Michigan Farm Bureau is seeking an Associate Data Engineer to build, manage, and optimize data pipelines supporting analytics and strategic business needs. You will identify source data systems, monitor data flows, and adapt pipelines to changing requirements while collaborating with IT and business teams.

The role requires a Bachelor's degree and 3–5 years' experience with SQL Server, T-SQL, Visual Studio IDE, and SSIS or ETL platforms.

Qualifications

• Bachelor's degree in information systems, computer science, or related field.
• 3–5 years' experience with Microsoft SQL Server, T-SQL, Visual Studio IDE, and SSIS or equivalent ETL platforms.
• Willingness to pursue continuing job-related training and education in systems and insurance.

Responsibilities

• Identify and understand source data systems and data flow between systems.
• Assemble large sets of data that meet business requirements and ensure data quality and security.
• Deliver trustworthy data and support optimal extraction, transformation, and loading of data.
• Document pipelines and conduct knowledge sharing with peers.

Skills

SQL Server

T-SQL

Visual Studio IDE

SSIS

ETL

Education

Bachelor's degree in information systems or computer science

Tools

ETL platforms

Job description

To build, manage, optimize, and assist in the design of data pipelines in support of information, analytics, and strategic business needs across the enterprise.

Identify and understand source data systems and data flow between systems. Recognize changes in those systems and assess impacts on data pipelines. Adapt data pipelines to accommodate modifications triggered by source system changes or business requirements.

Work closely with other IT or business personas while participating on projects. Demonstrate proficiency in understanding requirements and assist the team by offering expertise on data-related technical issues. Provide continuous updates on progress to project stakeholders, as well as issues or dependencies that put milestones at risk. Communicate efficiently, both written and verbally. Ask clarifying questions when needed and demonstrate teamwork and collaboration with the project team to ensure deliverables meet expectations.

Assemble large sets of data that meet non-functional and functional business requirements and that comply to best practices and guidelines set by architects, senior and lead engineers.

Deliver trustworthy data to ensure quality, consistency, and security practices.

Demonstrate ability to build the required infrastructure for optimal extraction, transformation, and loading of data using current enterprise technologies. Document newly developed pipelines and keep documentation up to date. Hold frequent knowledge shares with peers to ensure cross-training.

Requirements

Required
Bachelor's degree in information systems, computer science, or related field required, or equivalent experience may be considered.
Three to five years' experience working with Microsoft SQL Server, T-SQL, Visual Studio IDE, and SSIS (or equivalent ETL platforms) required.
Current knowledge of computer hardware, operating systems, program language(s) and tools, testing techniques and tools, program specification and interpretation required.
Working knowledge of systems design and analysis tools and techniques required.
Willingness to pursue continuing job-related training and education in systems and insurance required.

Preferred
Working knowledge of transactional, analytical, big data structures preferred.
Understanding database best practices and technologies such as types of compression, indexes, security, data types, and AlwaysOn preferred.
Prior experience at an insurance company or on projects for an insurance company preferred.

• Farm Bureau offers a full benefit package including medical, dental, vision, and 401K.

Note: If a candidate is not selected, an Associate Data Engineer position may be considered on the level of experience and qualifications.

Work Type

Hybrid

Standard Hours

8:00am-4:30pm

Position Type

Full-time

90,766

Location(s)

Lansing , Michigan 48917

The Michigan Farm Bureau Family of Companies is an equal opportunity employer. The Company will not discriminate against applicants or employees on the basis of race, color, religion, national origin, age, sex, pregnancy (including childbirth or related medical condition), disability, genetic information, sexual orientation, gender identity, military status, citizenship, or any other class protected by applicable law. In accordance with Michigan's Persons with Disabilities Civil Rights Act, the companies listed above advise you as follows: If you believe that any of the above-listed companies has failed to accommodate you as a disabled individual, you may allege a violation against that company for failing to so accommodate you, but only if you have notified that company in writing of your need for accommodation within 182 days after the date on which you knew, or reasonably should have known, that an accommodation was needed by you to perform the job which you hold or seek.