IT Data Analyst

Michigan Farm Bureau; Lansing (MI); Hybrid; USD 65,000 - 90,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

401K

Job summary

Michigan Farm Bureau is seeking an IT Data Analyst to analyze, design, develop, test, and implement processes and systems that support data integrations, standardization, quality, and governance for Farm Bureau Insurance Companies.

The role involves managing and analyzing data processes, participating in data quality, governance, and MDM programs, and providing documentation for data mappings and specifications. A hybrid position is available, with work from the Lansing, MI area.

Qualifications

• Bachelor’s degree in CS or related field, or equivalent experience.
• 2–4 years of experience as a data analyst or equivalent.
• Strong SQL knowledge and ability to write queries.
• Working knowledge of systems design/analysis tools and techniques.

Responsibilities

• Analyze, design, develop, test, and implement data processes and systems.
• Support data integrations, standardization, quality, and governance.
• Provide data analysis, profiling, testing, and discovery as needed.
• Document data mappings, transformations, specs, and catalog updates.
• Address data problems with proactive and reactive solutions.

Skills

SQL

Data analysis

Data profiling

Data governance

Education

Bachelor's degree in computer science or related field

Job description

IT Data Analyst

To analyze, design, develop, test, and implement processes and systems that support data integrations, data standardization, data quality, and data governance for the Farm Bureau Insurance Companies.

Manage and analyze data processes, issues, and questions. Understand the details of data processes and management. Participate in data quality, data governance, and MDM programs.

Serve as a team member or technical lead on projects. Provide data analysis, data profiling, data testing, and data discovery as needed. Provide necessary documentation around data mapping, transformations, technical specs, and data catalog updates. Apply principals of data governance, insurance, and processing requirements.

Assess, correct and identify permanent solutions to data problems. Take calls outside of standard working hours to issue diagnosis and resolution in both proactive and reactive modes.

Required:

Bachelors degree in computer science or related field required, or equivalent experience may be considered.

Two to four years experience as a data analyst or equivalent position required.

Strong experience using SQL and writing queries 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.

Preferred:

Experience working with and managing insurance data structures and processes preferred.

Experience with software for data cleansing, standardization, matching, profiling, MDM, data quality and data governance preferred.

Note:

This is a Hybrid position working remotely from the (State of Michigan), and in the Farm Bureau Home Office located in Lansing, Michigan.

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

PM19

PI286799607