Michigan IT Jobs

Mobile michigan-jobbank Logo

Job Information

SET SEG Data Engineer in East Lansing, Michigan

Title: Data Engineer

Reports To: Chief Information Officer

Location: East Lansing, MI

Department: Information Technology

The Data Engineer will design the data architecture and identify the software platforms and frameworks required to accomplish the company?s goals. They will diagnose and propose solutions for issues in existing pipelines as well as develop and automate additional data pipelines that are scalable and easily maintained. The Data Engineer will understand data needs and advise SET SEG on processes, systems, and strategies for long term data platform architecture.


School Employers Trust (SET) is a non-profit company that was created after a monumental shift in school funding happened in 1965. SET, which began in 1971, served as an employee benefits association focused on offering comprehensive and affordable employee benefit solutions to Michigan public schools and their employees. Two years later, its partner organization School Employers Group (SEG) was formed to administer compensation and fringe benefits for SET. As schools were faced with more challenges related to insurance, SEG evolved and grew into a company that provides workers? compensation and property/casualty services for Michigan public schools.

Today, SET SEG continues to expand and find creative ways to meet the specialized needs of its members. This, coupled with a superior member experience, is why SET SEG has maintained its position as an industry leader in the school insurance market.

We value those who proactively solve challenges, simplify the complex, thrive in a fast-paced setting, have a customer-first mentality, and seek a collaborative and inclusive work environment. We are also listed on the Business Insurance Best Places to Work. We offer 100% employer paid insurance (medical, dental, and vision), Paid Time off (PTO), and paid parental leave.

Our passion is delivering peace of mind to Michigan public schools and we look for team members who are motivated by our cause. To learn more, visit: https://setseg.org .


You are energized by working with a collaborative team and industry peers to support Michigan public schools through their challenges. You seek understanding and are motivated to tackle projects and problems with the customer in mind. You anticipate needs and preempt challenges and concerns, delivering increasingly relevant customer experiences over time. You value a culture that is rooted in mutual respect, where you can learn from different perspectives and roles.

You are process-oriented problem solver with seven or more years of experience in the information technology field. You have experience designing, building, and maintaining data processing systems. You have excellent verbal and written communication skills, as well knowledge of programming languages. Preferably, you have experience with the insurance industry and ACA compliance. You have a high level of customer service.

Primary Responsibilities:

  • Builds scalable data systems and pipelines

  • Collaborates with analytics and business teams to improve data models that feed business intelligence tools, increase data accessibility, and foster data-driven decision making across the organization

  • Implements processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it

  • Performs data analysis required to troubleshoot data related issues and assist in the resolution of data issues

  • Works closely with a team of frontend and backend engineers, product managers, and analysts

  • Designs data integrations and data quality framework

  • Creates and evaluates open source and vendor tools for data lineage

  • Collaborates across all business units and IT teams to develop strategy for long term data platform architecture

  • Other duties as assigned

    Required Qualifications:

  • Bachelor?s degree in Computer Science or a related technical field; a master?s degree is a plus

  • Seven or more years of experience in the information technology field

  • Previous experience as a Data Engineer or in a similar role

  • Knowledge of programming languages (e.g. .NET, Java, Python)

  • Hands-on experience with SQL database design (MS SQL Server preferred)

  • Experience with designing and building within SAP BOE

  • Experience with schema design and dimensional data modeling

  • Experience designing, building, and maintaining data processing systems (SSIS preferred)

  • Experience in insurance, Affordable Care Act compliance, and/or public schools is a plus

  • Knowledge of agile software development methodologies

  • Excellent problem solving and troubleshooting skills

  • Process oriented with great documentation skills

  • Excellent oral and written communication skills with a strong focus on customer service

    Physical Demands / Work Environment

    Several hours per day at a sit/stand desk, average mobility to move around an office environment; able to spend several hours per day at a computer; travel to various locations throughout Michigan. Punctual, regular, and consistent attendance is required. May require on-call availability and may require working during non-business hours and on weekends.

    We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. We are proud to be an equal opportunity workplace.