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.
WHO WE ARE
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 .
WHO YOU ARE
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.
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
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.