IT Data Analyst - Mission, KS - In office, not remote position

About Mainstreet Credit Union

Why Work for Mainstreet Credit Union?

Mainstreet Credit Union has consistently provided stability for employees and members over the span of more than 70 years. Not to mention, Mainstreet Credit Union aims to be the financial home to every member. We continue to strive for a welcoming culture, where our employees are knowledgeable, helpful, and accountable for their position within the team. To achieve this vision, we provide continued training and development opportunities, as well as a friendly environment where members and employees can feel at home. Being a not-for-profit organization, we keep business simple and real. We enjoy sharing in our community, and we always find the most effective way to serve our members and provide full pay and benefits for our employees, even through uncertain times.

In addition to our friendly and welcoming environment, we offer our employees:

• Day-time hours that provide for a healthy work-life balance
• Three weeks of PTO in the first year with a generous annual PTO carryover plan
• A wide variety of insurance options for health, dental, and vision
• 401k with company match
• Company provided life insurance and long-term disability
• Special product perks for employee

Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

Company Expectations

All employees are expected to maintain reliable attendance, interact professionally with members, employees, vendors, and the public, and perform duties accurately and efficiently. Employees must complete required onboarding and ongoing training, comply with all Credit Union policies and procedures, and uphold standards outlined in the Employee Handbook.

Position Overview

The Data Analyst is responsible for transforming data into actionable insights that support strategic planning, operational efficiency, and system optimization across the Credit Union. This role focuses on analyzing data from multiple sources, including the Symitar core processing system, to support business decision-making and regulatory needs. Working closely with the VP of IT and cross-functional teams, the Data Analyst develops reports, dashboards, and analytics solutions that enhance system performance, improve processes, and inform leadership. The position requires strong analytical and technical expertise, effective communication skills, and the ability to bridge business and technical requirements.

Key Responsibilities

Data Analysis, Reporting & Visualization

• Collect, analyze, and interpret data from internal departments, leadership, and external partners.
• Analyze large and complex datasets to identify trends, risks, and opportunities for improvement.
• Develop, maintain, and enhance dashboards, reports, and visualizations.
• Document analytical findings and technical solutions in a clear and usable format.
• Ensure data integrity and perform regular data validation/cleansing.

Systems & Technical Support

• Evaluate existing systems and recommend enhancements to improve efficiency and performance.
• Coordinate with internal staff and third-party vendors to implement technical solutions.
• Install, configure, integrate, and support system components to ensure operational reliability.
• Identify opportunities to automate manual reporting processes to increase departmental efficiency.
• Provide operational and backup support for the Symitar core system.

Compliance, Projects & Operations

• Support IT-related regulatory and compliance initiatives.
• Maintain accurate documentation for procedures, workflows, and system configurations.
• Serve as a liaison between business users and technical teams to ensure requirements are clearly understood.
• Lead or support IT and data initiatives by coordinating timelines, resources, and deliverables.
• Provide scheduled after-hours and rotational support as required.
• Perform additional duties as assigned in support of evolving business and technology needs.
• Assist in defining and maintaining a data dictionary to ensure consistent terminology across the organization.
• Collaborate with Information Security to ensure all data reporting and visualization adheres to member privacy standards (GLBA).

User Support & Training

• Develop user guides and reference documentation.
• Assist with onboarding, training, and help desk support.
• Promote knowledge sharing and adoption of best practices.

Required Qualifications

• High School Diploma or equivalent
• 3-5 years of Experience with Microsoft SQL databases and queries
• 2-3 years of Experience with Snowflake, Tableau
• Strong analytical, technical, and problem-solving skills.
• Ability to manage multiple priorities and meet deadlines.
• Working knowledge of basic project management principles.
• Strong written and verbal communication skills.
• Ability to work flexible hours, including occasional weekends.
• Occasional business travel using personal transportation.
• Must be bondable and pass a criminal background check and credit check.

Preferred Qualifications

• Bachelor’s degree in Computer Science, Information Technology, Business Technology, or a related field.
• Experience with the Symitar core system and related tools (PowerOn, SymForms, ARCU, SSRS).
• Experience with Arkatechture platform with Arkalytics solution.

Skills, Abilities & Physical Requirements

• Self-motivated, detail-oriented, and able to work independently or as part of a team.
• Comfortable in a fast-paced, dynamic work environment.
• Ability to work at a computer and remain seated or standing for extended periods.
• Ability to communicate effectively with a diverse workforce.
• Occasional lifting, carrying, pushing, or pulling of items up to 25 pounds.
• Valid driver’s license with reliable transportation.