Commercial Loan Operations Programmer
Flagstar Bank
Hicksville, NY
Position Title
Commercial Loan Operations ProgrammerLocation
Hicksville, NY 11801Job Summary
The Commercial Loan Operations Programmer is responsible for developing and maintaining database queries, operational reports, and dashboards to support commercial loan processing, oversight, and compliance. This role works closely with loan operations, IT, and data governance teams to ensure data integrity, streamline reporting, and provide actionable insights that enhance decision-making and operational efficiency.Pay Range: $53,025.00 - $70,700.00 - $76,104.00
Pay Range: Local Minimum Wage - $0.00 - $0.00
Job Responsibilities:
- Develop, test, and maintain complex SQL queries to support operational reporting, data validation, and ad hoc business requests.
- Design and implement dashboards using reporting tools (e.g., Power BI, Tableau, SSRS, or similar) to visualize commercial loan operations metrics, KPIs, and SLA performance.
- Perform detailed database inquiries across loan servicing systems and data warehouses to support reconciliation, exception tracking, and regulatory compliance.
- Collaborate with business users to understand reporting needs and translate them into technical requirements.
- Maintain data accuracy and consistency by validating source system data and conducting quality checks.
- Support automation of manual reporting tasks and provide documentation for repeatable queries and processes.
- Assist in the integration of loan systems with enterprise reporting environments and data lakes.
- Provide technical support for audits, risk reviews, and regulatory exams by producing requested reports and data extracts.
- Troubleshoot performance issues in queries and reports, optimizing data retrieval for large commercial loan datasets.
- Participate in the development of data governance practices and operational reporting standards.
ADDITIONAL ACCOUNTABILITIES
- Performs special projects, and additional duties and responsibilities as required.
- Consistently adheres to regulatory and compliance policies and standards linked to the job as listed and complete required compliance trainings. Accountable to maintain compliance with applicable federal, state and local laws and regulations.
JOB REQUIREMENTS
Required Qualifications:
- HS Diploma, GED or Foreign Equivalent
- College, Vocational or Associates Degree (2 years or equivalent) and 3 to 5 years related experience; or equivalent combination of education and experience.
- Minimum experience required: 4+ Years programming experience in a large commercial bank or related financial institution.
Preferred Qualifications:
- Education level preferred: Undergraduate Degree (4 years or equivalent)
- Familiarity with commercial lending processes, loan accounting, and regulatory reporting (e.g., Call Reports, CECL).
- Experience working with ETL processes or enterprise data warehouses.
- Strong analytical and troubleshooting skills with attention to detail.
Job Competencies:
- Advanced proficiency in SQL (T-SQL, PL/SQL, or similar dialects) for data extraction, joins, CTEs, and performance tuning.
- Experience with loan servicing systems (e.g., ACBS, Loan IQ, AFSVision, or internal commercial loan platforms).
- Strong understanding of data structures, financial systems, and relational databases.
- Proficiency with business intelligence tools such as Power BI, Tableau, SSRS, or similar.
- Strong analytical and troubleshooting skills with attention to detail.
- Strong communication skills and ability to work across departments.
- Demonstrates a strong ability to build and maintain effective relationships with stakeholders by communicating clearly, engaging in proactive collaboration, and leveraging cross functional insights. Aligns relationship building efforts with enterprise goals to accelerate performance and drive strategic results.
- Builds trusted client relationships, whether internal or external, by identifying needs and delivering tailored solutions to enhance the overall client experience.
- Fosters or supports a positive work culture and productive work environment, displaying importance of effective relationships with customers and stakeholders.
Flagstar is an Equal Opportunity Employer
Flagstar provides teammates access to a variety of benefits including medical, dental, vision, life, and disability insurance, as well as a comprehensive leave program. Please click the following link for detailed information: Benefits | Flagstar Bank
About the Company
Flagstar Bank
On December 1, 2022, New York Community Bank (NYCB) and Flagstar Bank joined together to become one company. Today, New York Community Bancorp, Inc. is the parent company of Flagstar Bank, N.A., one of the largest regional banks in the country. The company is headquartered in Hicksville, New York.
At June 30, 2024, the company had assets of $119.1 billion. We operate over 400 branches across 10 states, including a significant presence in the Northeast and Midwest and locations in high growth markets in the Southeast and on the West Coast. Flagstar Mortgage operates nationally through a wholesale network of approximately 3,000 third-party mortgage originators.
We believe in cultivating a diverse, inclusive, and respectful workplace that engages employees, broadens perspectives, and encourages teamwork. We hire people who represent the talents, experiences, backgrounds, and diversity of the communities we serve. Together our goal is to deliver a new energy in banking to our customers, opening new doors for financial and personal success. Customers will have access to a broad spectrum of technology, products and services—all with a shared customer-first approach. Relationships are at the center of all that we do, enhanced by our commitment to delivering local market expertise, personalized solutions, and a long-standing focus on strengthening our communities. Follow us on LinkedIn to stay up to date on news and updates, new hires, community initiatives, access to our collective insights, and banking industry updates that you need to know..