Data Analyst I- Mortgage

Overview

The Data Analyst I - Mortgage position is responsible for compiling, analyzing mortgage data, preparing reports, arranging new data sources, making presentations, dashboards, interpreting data, and creating automation projects and low-code applications to drive actionable insights and innovation for the Mortgage line-of-business.

Responsibilities

• Create, run, modify, and produce accurate standard/ad-hoc queries and reports to support Mortgage business needs for information and/or data.
• Analyze and understand internal and external mortgage and economic data to provide up-to-date trends and forecasting to assist with data-driven decisions.
• Create dashboards, meaningful graphic visualizations, general and executive-level presentations, and effective reports to deliver actionable insights to all mortgage stakeholders.
• Maintain current knowledge on data and analytic trends and best practices for long-term solutions related to Mortgage data.
• Develop 2-3 automation projects per year using Python/SQL or low-code/no code tools.
• Complete monthly Fair Lending related incentive studies and deliver to key management stakeholders.
• Maintain Mortgage analytics and automation infrastructure through error tracking and application lifecycle management frameworks.
• Perform regular audits of Mortgage databases to ensure accuracy and completeness.
• Associates are expected to perform all additional duties as assigned.

Qualifications

• Bachelor’s degree in Business, Finance, Data Analytics, Real Estate, or related field of study, or equivalent work experience
• 2 years of data analytics experience or demonstrated aptitude for analytics
• Ability to write SQL queries.
• Knowledge of banking industry, preference is prior experience with Trustmark data and organizational structure
• Must be able to exercise confidentiality at all times
• Must have strong organizational skills with the ability to manage multiple projects effectively
• Proven experience applying attention to detail with strong critical thinking
• Excellent verbal and written communication skills
• Excellent customer service skills and the ability to maintain cooperative working relationships
• Advanced skills in Microsoft Products including Word, Excel, PowerPoint, Pivot Tables and VLOOKUPs
• Data Analytics or other related certification preferred
• Experience with dashboard software including Power BI, Tableau etc. preferred
• Ability to write Python scripts preferred
• Experience using Microsoft Azure, Power Automate, Power Apps preferred

Physical Requirements & Working Conditions:  Must be able to sit for long periods of time and use computer keyboard and/or mouse requiring hand and wrist manipulation, while viewing computer screens.

 

Disclaimer: Management retains the right to add, delete or modify the responsibilities and qualifications of the position at any time.

 

Trustmark Bank does not accept unsolicited resumes from agencies and/or search firms for any job postings on this site.  Resumes submitted to any Trustmark Bank employee by a third-party agency and/or search firm without a valid, written search agreement signed by Trustmark, will become the sole property of Trustmark Bank.  No fee will be paid if a candidate is hired for a position as a result of an unsolicited agency or search firm referral.