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.

Requirements

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.
Familiarity with commercial lending processes, loan accounting, and regulatory reporting (e.g., Call Reports, CECL).
Experience working with ETL processes or enterprise data warehouses.
Advanced proficiency in SQL (T-SQL, PL/SQL, or similar dialects).
Experience with loan servicing systems (e.g., ACBS, Loan IQ, AFSVision, or internal commercial loan platforms).

Benefits

📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLT-SQLPL/SQLETL processesdata validationdata accuracydata consistencyreportingdashboard designdata integration

Soft Skills

collaborationcommunicationtechnical requirements translationattention to detailproblem-solving

Certifications

HS DiplomaGEDAssociates Degree