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.
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
What you will bring to Fay:
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, initiatives, and people
Equity and Inclusion are embedded into our way of working at Fay. We believe that the best ideas come from having a team that is diverse in backgrounds, experiences, and perspectives. We strive to ensure each of our employees feels valued, respected, and included and is presented with equal opportunities to be successful here at Fay. We are proud to be an equal opportunity workplace. The Fay Group and affiliated companies participate in E-Verify. For more information go to www.dhs.gov/E-Verify. E-Verify is a registered trademark of the U.S. Department of Homeland Security.