Data Analyst - Acquisitions
Rushmore Loan Management Services is growing rapidly and expanding our team. We want YOU to be a part of it! If you are a top performer looking for a company that can provide opportunities to grow in your career, Rushmore is the place for you. We offer competitive salaries and a comprehensive benefit package with medical, dental and vision benefits effective Day 1 of employment.
As a nationwide mortgage servicer licensed in all 50 states with nearly $50 billion in loans being serviced and growing, we offer a dynamic team environment, collaborative culture, and commitment to customer satisfaction.
POSITION SUMMARY:
The Acquisitions Data Analyst is responsible for creating, implementing, and maintaining solutions for Rushmore’s Acquisitions department. The analyst develops an understanding of business processes/data requirements and delivers analysis, reports, scripts, then data maps the automated data and document image boarding to Rushmore’s system.
ESSENTIAL DUTIES AND RESPONSIBILITIES:
- Mine, analyze, and interpret data from multiple disparate sources and formats.
- Import and export data from multiple desktop data sources and formats.
- Develop data validation tools and techniques to increase data quality.
- Clean, analyze, organize, manipulate, and deliver data from reports and text files.
- Use SQL to insert, extract, and manage data throughout the loan boarding process.
- Develop desktop scripts and tools to automate data and image file management tasks.
- Troubleshoot data quality issues and inconsistencies providing recommendations, scripts and desktop solutions.
- Provide ad-hoc reporting and analysis services as required to team members and departments.
- Work with peers to simplify and optimize data usage, reports, scripts, and data management activities.
- Perform other duties as assigned by management.
ESSENTIAL KNOWLEDGE & SKILLS:
- Strong organizational and follow-through skills
- Ability to prioritize and meet close deadlines
- Analytical / interpersonal / written and oral communication skills
- Beginner level software engineering skills
- Ability to work independently with little direction
- Very high attention to detail and accuracy
- Self-motivated, organized
- Works well within a team setting
- Ability to independently learn technical tools/technologies
- Strong Excel Data Analysis knowledge
EDUCATION AND/OR EXPERIENCE:
- High School Diploma required
- Bachelor’s Degree preferred (in Information Systems, Computer Science, or Data Management/Analytics)
- Minimum 2 years’ experience or equivalent
- Professional experience working with data in reports, text files, and databases desirable
- Prefer experience in the mortgage industry
- Prior experience and knowledge of IBM Filenet is a plus
- Experience and/or knowledge of shell scripting including DOS, Windows Shell, and Unix
- Experience and/or knowledge of ETL tools such as Talend, Microsoft SSIS, or Informatica
- Experience and/or knowledge of Visual Basic, Python, shell scripting, and SQL
MACHINES, OFFICE EQUIPMENT & SOFTWARE:
- Advanced in Microsoft Office applications, especially MS Excel and MS Access
- Beginner to intermediate Visual Basic, Python, shell scripting, and SQL skills
- Experience with the Black Knight MSP system is a plus