Trust Systems & Data Analyst

Midwest Trust Company; Overland Park (KS); On-site; USD 70,000 - 100,000; Full time

Job summary

Midwest Trust Company is seeking an Information Systems Analyst to support reporting, data, and applications for our outsourced back-office trust services.

You will develop SQL queries, maintain data extracts, monitor jobs, support trust accounting platforms, and coordinate data interfaces for internal and external clients.

Strong analytical skills, attention to detail, and ability to own issues from detection to resolution are essential.

Qualifications

• 2–5+ years of relevant experience in information systems, data analysis, application support, financial technology, trust operations, or a related field.
• Intermediate to advanced proficiency with SQL, including the ability to develop, modify, troubleshoot, and validate queries and data extracts.
• Experience with Microsoft Excel and database/reporting technologies.
• Working knowledge of Visual Studio, Microsoft Access, Power BI or comparable development and data-management tools.
• Strong written and verbal communication skills.
• Ability to analyze large or complex datasets and validate reporting accuracy.

Responsibilities

• Develop, maintain, and execute SQL queries, reports, and data extracts based on defined business and client requirements.
• Analyze data requirements and translate business needs into accurate, efficient, and scalable reporting solutions.
• Validate report outputs and data extracts for accuracy, completeness, consistency, and appropriate formatting prior to delivery.
• Monitor reporting databases, scheduled reports, batch processes, and related system jobs.
• Troubleshoot reporting errors, data discrepancies, and failed processes and coordinate resolution as appropriate.
• Assist with recurring and ad hoc reporting requirements supporting trust operations, client servicing, management, audit, and regulatory needs.

Skills

SQL & Data Analysis

Reporting & Data Validation

Data Interfaces & File Transfers

Application Support

Software Testing & QA

Project Management

Client Service

Information Security Awareness

Documentation & Process Discipline

Attention to Detail

Ownership & Accountability

Collaboration

Continuous Improvement

Education

Bachelor's degree in Computer Science, Information Systems, Mathematics, Finance, Business, Financial Services, or a related field

Tools

Visual Studio

Microsoft Access

Power BI

Job description

Midwest Trust Company is seeking an Information Systems Analyst to support reporting, data, and applications for our outsourced back-office trust services.

You will develop SQL queries, maintain data extracts, monitor jobs, support trust accounting platforms, and coordinate data interfaces for internal and external clients.

Strong analytical skills, attention to detail, and ability to own issues from detection to resolution are essential.