Job Opportunities API

Empowered to live. Inspired to work. Compeer Financial is a member-owned cooperative located in Illinois, Minnesota and Wisconsin. We bring together team members with a variety of backgrounds and experiences to help provide financial services to support agriculture and rural communities. Join us in a culture that not only promotes meaningful work and professional development, but provides a flexible, hybrid work environment and excellent benefits, which empower you to thrive both personally and professionally. How we support you: Hybrid model – up to 50% work from home Flexible schedules including ample flexibility in the summer months Up to 9% towards 401k (3% fixed Compeer contribution plus up to 6% match) Benefits: medical, dental, vision, HSA/FSA, life & AD&D insurance, short-term and long-term disability, wellness program & EAP Vacation, sick leave, holidays/floating holidays, parental leave, and volunteer paid time off Learning and development programs Mentorship programs Cross-functional committee opportunities (i.e. Inclusion Council, emerging professional groups, etc.) Professional membership/certification reimbursement and more! Casual/seasonal & intern team members are not eligible for benefits except for state-mandated programs. To learn more about Compeer Financial visit  www.compeer.com/careers .  This position offers a hybrid work option up to 50% remote and is open to any Compeer office location in Illinois, Minnesota and Wisconsin . The contributions you will make:   This position is responsible for the development, enhancement and effective operations of complex data movement between various systems using ETL methodologies. Responsible for leading company database development efforts and coordinating with business users, consultants/contractors, vendors and internal team members to maximize the usage and value of company data assets. In many cases ETL processes are used to extract data from source systems, transform and enrich the data, and load it into the Data Warehouse.  A typical day:   ETL Development Designs, builds, deploys and maintains SQL Server Integration Service (SSIS) packages. Develops, maintains and administers systems databases. Functions as a primary contributor in designing, coding, testing and debugging ETL packages and processes to create a seamless data flow. Supports overall strategy related to database and data warehouse development. Monitors, troubleshoots and analyzes ETL process failures, data anomalies, inconsistencies and other ETL related issues identified by monitoring, technical team members, and end-users. Generates automated, repeatable and stable processes to support data load, data validation, and data synchronizations for the data warehouse. Creates database coding requirements for data warehouse data migrations and business unit and SQL server projects via programming and the various SQL languages. Identifies and resolves data integrity issues between the data warehouses and the original data sources. Consumption Views Supports reporting and analytic users by designing and creating 15% consumption views for use by various reporting or analytics systems. Creates logical links between databases as part of an Enterprise Data Warehouse. Utilizes various SQL tools. Database Administration Supports overall strategy related to database and data warehouse development. Actively participates with the Business Technology department in preparing and implementing backup and disaster recovery procedures and processes for mission critical databases. Contributes to data dictionaries and database diagrams for complex in-house databases. Provides on-call support for problem resolution of database related issues. The skills and experience we prefer you have:   Bachelor’s degree in computer science, engineering, MIS or related field or an