capabilities to support day-to-day operation of the company's data strategy as directed by senior staff. This is a 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 on assigned tasks 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.
Programs, tests, documents, and implements ETL solutions for business problems using software tools and technology. Supports 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.
Works with data modelers and database engineers to ensure that the data processing environment and the supporting data structures are designed and maintained to ensure optimum system performance, data integrity, and the ability to meet business processing requirements. Assists in the collaboration between analysts, developers, system owners, quality assurance, business process owners, and data governance in the review and testing of new and changed data elements, structures, reports, and services to ensure final business solution acceptance.
Assists project management staff in defining data project milestones and resource efforts. Provides new and junior members of the data team with technical, business, and procedural guidance specific to their assigned tasks. 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. Maintains an effective working relationship with management team members, serving as an automation advisor in the formulation of company goals and objectives.
Evaluates and reports 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 Database: Postgre SQL Languages: Python, Java Script Physical: IBM OS/390, Client/Server development platforms, Microsoft LAN servers, Remote communications, Operating System Environments and Extension, z OS, z VM, TSO, Linux, MS Windows - server and client, Apache Tom Cat, 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.
Five years minimum experience using technology in data analysis projects or in projects that dealt with business data flows. Three years minimum of ETL and SQL programming experience. Use of graphical ETL tools (Pentaho Kettle, Talend, Informatica, IBM Infosphere Data Stage) is preferred. Demonstrated understanding of the information needs and processing flows of a property/casualty insurance company is preferred. Experience with the phases of a project and general knowledge of project management. 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, interactionual 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 800-442-xyz X.
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.
