Description

You will develop and maintain business intelligence solutions using the Microsoft technology platform.

Responsibilities

• Develop complex SQL stored procedures, views, and T-SQL queries.
• Create diverse reports including drill-down, drill-through, tabular, matrix, and dashboards.
• Tune and optimize SQL queries to improve system performance.
• Provide guidance on database best practices and systems architecture.
• Analyze data to provide actionable recommendations to senior management.
• Participate in on-call rotations during weekends and out-of-office hours.

Required Skills

• 5+ years of related experience in BI development or database design and maintenance.
• Strong proficiency in SQL Server (including SQL Server 2017).
• Expertise in T-SQL and relational database design.
• Experience with SQL Server Reporting Services (SSRS).
• Hands-on experience with Power BI or Google Looker.
• Deep understanding of relational and multi-dimensional database architectures.
• Advanced data analysis skills using SQL and Excel.
• Knowledge of operational and analytical Business Intelligence solutions.
• Domain knowledge in mortgage servicing, including Loss Mitigation, Collections, Foreclosure, and Bankruptcy.

Preferred Skills

• Working experience with SQL Server Integration Services (SSIS).
• Experience with SQL Server Analysis Services (SSAS).
• Background in Computer Software Programs.

Key Skills

Education

Any Graduate