Log In
Sign Up
Remote / Hybrid – Hastings, Michigan
Hastings, MI, USA
Description
Hastings Mutual is currently looking for an Associate ETL Developer to join our Data and Business Intelligence team! This is a great opportunity for an entry-level or early-career IT professional to contribute to our company’s data management function.
Position Overview
The Associate ETL Developer provides effective and efficient ETL (Extract, Transform, and Load) programming capabilities to support day-to-day operation of the company’s data strategy as directed by senior staff. This is an entry-level technical position and works predominantly with the IT engineering, architectural, and data analysis staff.
Position Location & Work Format
This position is flexible in its location! We will entertain candidates who reside within our six-state territory (Michigan, Indiana, Illinois, Wisconsin, Iowa, or Illinois) to work a remote schedule. Candidates residing within the greater Hastings, Michigan will be able to work a hybrid (combination on-site and work-from-home) schedule as an alternative. Generally, this position will work within our standard office hours of Monday – Friday, 8:00 am – 4:30 pm.
Hastings Mutual may consider candidates in other states to work remotely if elements of their application are strong.
Position Duties & Responsibilities
- Works as directed by senior ETL development staff with other ETL developers, data analysts, modelers, and business SMEs to obtain programming specifications needed to build ETL code that moves data from its origin to its ultimate destination.
- Works with senior staff to learn the best programming and testing practices along with the implementation of balancing controls necessary to ensure data integrity.
- Programs, tests, documents, and implements ETL solutions for business problems using software tools and technology.
- Learns and assists with ETL tool administration.
- Performs environment tuning and maintenance.
- Ensures proper access for authorized users and provides support to data tool users.
- Provides the necessary documentation associated with the developed and maintained solutions to satisfy all company, IT and Data Governance policies, procedures, standards, practices, and guidelines.
- Participates in the collaboration between analysts, developers, system owners, quality assurance, business process owners, and data governance in the testing of new and changed data elements, structures, reports, and services.
- Provides project management staff with effort and progress information.
- Keeps current with the technologies that have potential impact on company information processes, identifying opportunities and making recommendations for changes and/or additions to the data analyst’s toolbox – including changes in best practice and methodologies.
- Begins developing a relationship with management team members, to ensure an understanding of company goals and objectives.
- Develops an understanding on how technology (software and hardware) may be effectively employed to achieve unit goals.
- Actively participates in professional development, i.e. continuing education or self-improvement.
- Other duties as assigned by leadership, either verbally or in writing.
Technical Environment Overview
- Data: VSAM and Flat File Structures (Fixed, CSV, Text, etc.), DB2 and MSSQL databases, XML and JSON structures, BI/Data cubes, Data modeling (ER, Data Flows, etc.), DDL, ETL
- Physical: IBM OS/390, Client/Server development platforms, Microsoft LAN servers, Remote communications, Operating System Environments and Extension, zOS, zVM, TSO, Linux, MS Windows – server and client, Apache TomCat, VMware
- Development Tools: COBOL LE, Assembler, Bim-Edit, CICS, Visual Basic, .Net and Java development tools, Pentaho Kettle, Microsoft Office
Candidate Requirements & Qualifications
- Bachelor’s degree in Information Technology, Business, Economics, or related field or equivalent work experience with emphasis on research and data analysis.
- One year minimum experience using technology in data analysis projects or in projects that dealt with business data flows.
- One year minimum of ETL and SQL programming experience.
- An understanding of various computing environments including mainframe, client-server and internet platforms.
- Demonstrated excellent written and verbal communication skills.
- Demonstrated ability to maintain confidentiality, follow directions, and use good judgment in an environment that can be ambiguous and time sensitive.
Hastings Mutual is not looking to partner with any third party staffing agencies for recruitment not this role, or any other open positions at this time.
Our Commitment as an Employer
We value the strength of a diverse and inclusive workforce. Hastings Mutual is committed to providing equal opportunity for all employees and candidates in a work environment that does not tolerate any form of discrimination or harassment. Decisions related to employment are based on business needs, position requirements, and individual characteristics without regard to appearance, nationality, origin, race, color, religion, gender, sexual orientation, age, body, disability, veteran, family, marital status, or any legally protected class.
Hastings Mutual seeks to provide reasonable accommodation to disabled individuals in the hiring process in compliance with federal, state, and local law. Candidates requiring accommodation to complete their job application or participate in the interviewing process are asked to notify the Talent Acquisition Specialist or contact us at (phone number removed).
About Hastings Mutual Insurance Company
From our humble roots in 1885 providing coverage for windstorm damage, Hastings Mutual has evolved into a leading regional property and casualty insurance carrier, offering innovative products for businesses, farm owners, and individuals. We work with customers in six Midwestern states (Illinois, Indiana, Iowa, Michigan, Ohio, and Wisconsin). Hastings Mutual is known for its financial strength, high ethical standards, and culture of service and responsiveness.
The core of our ongoing success is our employees. Whether at the corporate offices in Hastings, Michigan, or our remote team members throughout the Midwest, Hastings Mutual is made up of talented professionals across multiple divisions and functional areas. Our commitment to our employees and work culture has been confirmed with our inclusion in the “Best and Brightest Companies to Work for in West Michigan” each year since 2011.
Hastings Mutual offers a friendly, family-like environment that values transparency and approachability. We recognize the hard work of our employees with many benefits, including fully paid certification training, a cafeteria, and fitness center at our corporate offices, ongoing professional development opportunities, and financial stability backed by our “A” rating from A.M. Best. We also have a long-term commitment to the communities in which we live and work, either through partnerships with local charitable organizations or through our own Hastings Mutual Charitable Foundation.
At Hastings Mutual, we’re always looking for professionals of all experience and education levels to help us continue our more than 130-year history of successful, stable growth.
