The BI Developer is responsible for supporting the business areas and clients by developing business intelligence solutions leveraging the Microsoft technology platform (SQL Server, SSRS, SSAS, SSIS and Excel BI tools).

Duties and Responsibilities: include the following. Other duties may be assigned.

• Develop complex SQL stored procedures/views as required
• Create variety of complex reports using SQL Server Reporting Services, including but not limited to drill down, drill through, tabular, matrix, dashboard, multi parameter reports, etc.
• Analyze data to provide recommendations to AVP of group on issues and improvements
• Provide advice and guidance on database good practices
• Provide input on systems architecture as required.
• Identify areas and processes where performance can be improved.
• Make and justify recommendations for improvement.
• Continuously tune and optimize SQL queries. Ensure that code and other deliverables adhere to company standards.
• On-call status is a requirement of the position.
• Work on special projects as needed.

QUALIFICATIONS:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Special skills/abilities/competencies required:

• Working experience of SQL Server 2008
• Excellent data analysis skills using SQL
• Working experience of Dynamic SQL
• Understanding of Business Intelligence solutions: operational and analytical, strong knowledge of relational and multi-dimensional database architectures
• Working experience of SQL Server Reporting Services
• Working experience of SQL Server Analysis Services
• Working experience of SQL Server Integration Services is a plus
• Strong analytical skills and a strategic thinker
• Understanding of Mortgage servicing including loss mitigation, collections, fc/bk, default reporting and general loan servicing
• Excellent working knowledge of Excel

COMPETENCIES:

To perform the job successfully, an individual should demonstrate the following:
Adaptability - Adapts to changes in the work environment. Manages competing demands. Changes approach or method to best fit the situation. Able to deal with frequent change delays, or unexpected events.
Business Ethics - Treats people with respect. Keep commitments. Inspires the trust of others. Works with integrity and ethically. Upholds organizational values.
Communications - Expresses ideas and thoughts verbally. Expresses ideas and thoughts in written form. Expresses ideas and thoughts in written form. Exhibits good listening and comprehension. Keeps others adequately informed. Selects and uses appropriate communication method.
Customer Service - Displays courtesy and sensitivity. Manages difficult or emotional customer situations. Meets commitments. Responds promptly to customer needs. Solicits customer feedback to improve service.
Dependability - Responds to requests for service and assistance. Follows instructions, responds to management direction. Takes responsibility for own actions. Commits to doing the best job possible. Keeps commitments. Meets attendance and punctuality guidelines.
Teamwork - Balances team and individual responsibilities. Exhibits objectivity and openness to others’ views. Gives and welcomes feedback. Contributes to building a positive team spirit. Puts success of team above own interests.
The above job description is not intended to be an all-inclusive list of duties and standards of the position. Incumbents will follow any other instructions, and perform any other related duties, as assigned by their supervisor.

The company is committed to the total wellbeing of its employees and therefore offers one of the best benefits packages available in the industry today, which includes:

• Paid Time Off (PTO)
• Medical, Dental &Vision
• Employee Assistance Program
• Flexible Spending Account
• Health Savings Account
• Paid Holidays
• Company paid Life Insurance
• Matching 401(k) Plan

Job Type: Full-time
Pay: $95,000.00 - $105,000.00 per month

Benefits:

• Work from home

Work Location: Remot

Duties and Responsibilities: include the following. Other duties may be assigned.

• Develop complex SQL stored procedures/views as required
• Create variety of complex reports using SQL Server Reporting Services, including but not limited to drill down, drill through, tabular, matrix, dashboard, multi parameter reports, etc.
• Analyze data to provide recommendations to AVP of group on issues and improvements
• Provide advice and guidance on database good practices
• Provide input on systems architecture as required.
• Identify areas and processes where performance can be improved.
• Make and justify recommendations for improvement.
• Continuously tune and optimize SQL queries. Ensure that code and other deliverables adhere to company standards.
• On-call status is a requirement of the position.
• Work on special projects as needed

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Special skills/abilities/competencies required:

• Working experience of SQL Server 2008
• Excellent data analysis skills using SQL
• Working experience of Dynamic SQL
• Understanding of Business Intelligence solutions: operational and analytical, strong knowledge of relational and multi-dimensional database architectures
• Working experience of SQL Server Reporting Services
• Working experience of SQL Server Analysis Services
• Working experience of SQL Server Integration Services is a plus
• Strong analytical skills and a strategic thinker
• Understanding of Mortgage servicing including loss mitigation, collections, fc/bk, default reporting and general loan servicing
• Excellent working knowledge of Exce