Sr. Business Intelligence Developer

The Fay Group originated in 2008, is a full-scale real estate services company that offers mortgage servicing, property renovations, business purpose lending, insurance, and more to homeowners, investors, and clients nationwide.
Fay handles a wide range of mortgage loan solutions for prospective homeowners with varying credit histories and also offers refinancing for existing mortgages.


The Fay Group is made up of separate business units offering a complete range of home ownership products and services that provide customers with solutions to navigate the challenges of home ownership while helping them build toward their long-term financial goals.


Fay Cares!
While others in our industry focus on collecting money-or else-we take a kinder, more humane approach when homeowners fall short, explains CEO Ed Fay.
We consider the people behind those mortgages and work hard to give them the best chance possible to stay in their homes.


The Fay-Constructive Foundation was established to fulfill the philanthropic mission of Fay Financial employees to serve the communities in which they live and work.
Over 80% of employees across Fay, Constructive, and GenStone affiliate companies make voluntary contributions to the Foundation.
Each quarter, their contributions are donated to organizations focused on improving education opportunities, combating poverty, and supporting military service members and first responders.


Come join us on our journey to serve our customers and be the leader in our industry! We are currently looking for a Business IntelligenceDeveloper to join our team!

Reporting to the VP, Data Management, the Sr.
Business Intelligence Developer will be responsible for hands-on involvement in the architecture, delivery, and governance of data reporting and data delivery.
The role will encompass data warehousing and business intelligence responsibilities with a focus on data architecture, sourcing, reporting, and analytics.
The position will optimize data models, reports, and dashboards with the expectation to integrate advanced analytics and machine learning, while also ensuring data accuracy, compliance, and security by providing technical support and end-user training.
The BI Developer will drive innovation by suggesting and implementing new BI tools, optimizing queries, and documenting data processes.


Additionally, the role will contribute to the full development life cycle, mentor junior team members, and design operational and analytical reporting.
The position will be required to be current and updated on industry trends, analyze business requirements, and adhere to best practices and regulatory standards.


What you will do for Fay:

• Collaborate with cross-functional teams and external vendors to align business requirements with technical solutions, fostering effective communication
• Regularly review data models, reports, and dashboards, identifying optimization opportunities and ensuring standardization
• Be current and updated on industry trends, integrating advanced analytics and machine learning for actionable insights
• Actively engage in data governance to maintain accuracy, consistency, and regulatory compliance
• Provide technical support, troubleshoot reporting issues, and lead end-user training
• Drive innovation by evaluating and implementing new BI tools and technologies
• Perform and provide administration support for the BI tools deployed within the environment
• Design, develop, and maintain operational and analytical reporting
• Optimize data queries for improved system responsiveness
• Serve as a subject matter expert, offering guidance to internal stakeholders and contributing to strategic data-related discussions
• Analyze business requirements, perform ad-hoc queries, and contribute to story point assignments in DevOps
• Contribute to technical best practices and help develop prediction systems and machine learning algorithms
• Engage in the full development life cycle, documenting it in ADO, ensuring adherence to company process, procedures and guidelines
• Design and support effective system and user acceptance testing
• Collaborate on projects, providing mentorship to junior team members and ensuring effective engagement with other departments/ teams
• Conduct ongoing and ad-hoc data and process analysis
• Implement technical improvements and adhere to company policies and regulatory standards
• Develop productive relationships across the organization
• Develop domain knowledge of Fay's business to include an understanding of short-term goals and long-term strategies for the organization
• Ensure compliance with Fay's policies, processes, and practices.
  
• Maintain a current working knowledge of federal, state, and local regulatory requirements; ensure compliance
• Role model ethical standards, professionalism, and code of conduct
• Ensure demonstrated behaviors align with Fay's Values and Operating Principles
• Perform other duties and responsibilities as assigned

• Bachelor's Degree in Computer Science, Information Systems, or related field
• 5+ years' experience with MS SQL Server Standard and Enterprise 2014 and above
• 4+ years' demonstrated experience with Power BI
• 4+ years' experience with Power BI Services Administration
• Strong expertise in Power BI - M Query, DAX, and Data Modeling
• Demonstrated experience with Azure Data Factory for building data pipelines
• Experience with Azure DevOps and ServiceNow for product development and incident/request/change management
• Prior experience with Azure and Azure SQL Managed Instance
• Proficient in SQL Server programming and Microsoft BI suite
• Advanced SQL development skills with a strong T-SQL background
• Strong skills in MS Word, Excel, and PowerPoint
• Familiarity with the Loan Servicing industry is strongly preferred
• Working knowledge of Loan Servicing Systems like MSP is strongly preferred
• Strong verbal and written communication skills
• Active listening skills with the ability to facilitate meetings and effectively lead discussions
• Strong interpersonal skills with the ability to develop and foster effective working relationships across the organization
• Strong analytical skills and problem-solving abilities
• Ability to explain decisions and the reasons why to promote understanding and buy-in with others
• Solid decision-making abilities coupled with sound judgment
• Strong organizational and time management skills; ability to effectively prioritize in a fast-paced, dynamic environment
• Client-focused with strong execution skills
• Strong attention to detail; strong compliance orientation; high quality of work product
• Flexible, open to change, ability to learn new things quickly
• Collaborative work style; team-oriented
• Compliance orientation
• Self-directed; comfortable working with ambiguity and uncertainty
• Proven ability to lead projects, initiat.