Collaborate with data architects, business sponsors, core system administrators, and report writers within an Agile methodology.
Analyze source system data to improve data quality.
Partner with the business to identify data issues and potential solutions.
Proactively identify ways to improve data quality through business rules automation.
Review existing application functionality and perform gap analysis to identify enhancements. Apply configuration changes and updates via an application management tool.
Develop test plans and execute test scripts for application and data model changes.
Evaluate business requests for feasibility. Research and identify options.
Respond to questions from business and IT technical teams.
Track new or enhanced solutions to determine potential issues, communicate business impacts, and recommend solutions within the mortgage data warehouse model.
Assist with task automation and process improvements using scripting or tooling.
Assist with analysis, creation, and testing of integrations between systems, including API-based or file-based exchanges.
Investigate and resolve issues related to inbound and outbound data feeds supporting the PLM platform.
Respond to escalated calls from users and the help desk.
Support the core commercial mortgage servicing and accounting platform.
Maintain regular and predictable attendance.
Perform other duties as assigned.
Experience Requirements
Ability to transform data into information for analytics.
Advanced SQL skills, including use of Alteryx or similar tools for data anomaly detection.
Experience with Python for data analysis, automation, or scripting is a plus.
Experience with APIs or system integrations (REST, JSON) is a plus.
Advanced Excel skills.
Ability to learn new technologies.
Strong oral and written communication skills.
Ability to adapt to new methods and work under tight deadlines within Agile methodology.
Strong investigative, analytical, and problem-solving skills.
Strong data analysis and troubleshooting skills within complex data models.
Ability to trace data issues from source through reporting across systems.
Strong interpersonal skills and customer service orientation.
Ability to accept guidance and ask relevant questions during onboarding.
Ability to set goals and manage multiple tasks, clients, and projects.
Ability to balance priorities, deadlines, and deliverables.
Team collaboration experience on department or team projects.
Attention to detail with a methodical approach and sense of urgency.
Ability to align detail with departmental goals and objectives.
Ability to translate business needs into viable solutions.
Ability to provide customer support for core platform capabilities and/or system development experience.
Basic negotiating and persuasion skills.
General business knowledge.
Preferred: 8+ years IT experience in Business Analysis or Data Analysis.
Preferred: 2+ years Financial or Investment industry knowledge.
Preferred: Experience in Commercial Real Estate Finance.
Preferred: Working knowledge of Loan Management Systems.
Preferred: CCIM, MAI, CPA, LOMA, or other industry accreditation.
Preferred: Insurance, Reinsurance, or Financial Services experience.
Preferred: Experience developing technical skills in Python, data automation, or system integration.
Education Requirements
Bachelor's degree or equivalent related work experience.
5-7 years IT-related experience such as Business Analysis or Quality Assurance.
