ABOUT US

Full Potential Solutions (FPS) is a performance-based analytically driven omnichannel solutions organization with operations in Kansas City, MO, Chennai, India, Bogota, Colombia, and Manila, Philippines that puts culture and employees first. We are a rapidly growing global company, employing the best people, processes and proprietary technology to deliver groundbreaking solutions for our clients and fulfilling careers for our employees.
We invest in our people and put culture first because we believe that happy, fulfilled teams deliver breakthrough results. FPS offers a competitive suite of benefits for our employees, including a lucrative compensation program, medical, dental and vision benefits, and the opportunity for high potential career growth with a fast-growing company.

POSITION SUMMARY:

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

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

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