- Develop creative Business Intelligence solutions using SQL, views, and stored procedures
- Develop reports, dashboards, and custom files for internal/external clients
- Develop routines for data summarizations, queries, data cubes, and data reporting templates
- Develop production tasks and processes within the Business Intelligence Department in a mortgage servicing space
- Develop scalable processes to generate reports, files, dashboards, and data cubes according to business requirements
- Develop and manage process-driven solutions using Windows and Microsoft SQL Server environment
- Develop queries, reports, files, dashboards, etc., using Microsoft Windows and Microsoft SQL Server environment
- Develop and maintain scalable BI process using queries, reports, files, data marts, dashboards, etc.
- Develop and maintain automated production environment using stored procedures
- Collaborate with other developers to create/maintain scalable processes and best practices
- Collaborate with other departments on timing and details of the development cycle
- Ensure quality control best practices are followed
- Ensure seamless and scalable BI development lifecycle is followed
- Make recommendations and develop best practices for BI presentation layers, such as stand-alone reports, dashboards, and self-service/drill through tools
- Manage/balance workload; monitor/manage efficiency and timeliness of deliveries
- Work with other departments on Business Intelligence needs and improvements
- All other duties as assigned
- Bachelor’s Degree in Business, Computer Science, Information Technology, or related field
- 5+ years of experience in information systems and/or technical operations
- 5+ years of proven experience within Business Intelligence, IS, or MIS areas
- 5+ years of proven experience with Microsoft SQL Server tools, including queries and stored procedures
- SQL programming experience required
- Experience in managing and supporting a BI or IS production environment
- Experience in the financial sector, specifically in the credit/mortgage industry
- Experience with mortgage or other credit product servicing
- Experience with MSP or other mortgage platforms preferred
- Strong resource management/leadership skills; ability to organize and motivate others
- Strong verbal and written communication skills; ability to communicate with all levels of the organization
- Ability to multi-task, organize, prioritize, and research/resolve issues in a prompt and effective manner
- Ability to work independently with minimal supervision and effectively meet deadlines
About us …
LoanCare, its affiliates and subsidiaries, is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, protected veteran status, national origin, sexual orientation, gender identity or expression (including transgender status), genetic information or any other characteristic protected by applicable law.
WORK CONDITIONS
Working conditions are normal for an office environment. Ability to attend work and be productive during normal business hours and to work early, late, or weekend hours as needed for successful job performance. Overtime required as necessary.
Essential functions are the basic job duties that an employee must be able to perform, with or without reasonable accommodation.
ESSENTIAL FUNCTIONS
Critical Thinking — Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems.
Reading Comprehension — Understanding written sentences and paragraphs in work-related documents.
Speaking — Talking to others to convey information effectively.
Active Learning — Understanding the implications of new information for both current and future problem-solving and decision-making.
Active Listening — Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times.
Instructing — Teaching others how to do something.
Judgment and Decision Making — Considering the relative costs and benefits of potential actions to choose the most appropriate one.
Time Management — Managing one's own time and the time of others.
PHYSICAL DEMANDS
Sitting up to 90% of time
EQUAL EMPLOYMENT OPPORTUNITY
LoanCare, its affiliates and subsidiaries, is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, protected veteran status, national origin, sexual orientation, gender identity or expression (including transgender status), genetic information or any other characteristic protected by applicable law.