LOW INCOME INVESTMENT FUND

IT Business Partner, SQL Programmer

Location: New York
Reports to: Director of IT
Exempt classification: Non-Exempt
Status: Full time
Salary range: $90,000 to $105,000 Annually

THE COMPANY:
The Low Income Investment Fund is a non-profit community development financial institution, that mobilizes capital and partners to achieve opportunity, equity and well-being for people and communities. LIIF innovates financial solutions that center racial equity to create more equitable outcomes for all by building and preserving affordable homes, quality educational opportunities from early childhood through higher education, health clinics, healthy food retail and community facilities. In this way, LIIF provides a bridge between private capital markets and communities. LIIF’s headquarters is in San Francisco and has offices in Los Angeles, New York, Atlanta, and Washington D.C. More on LIIF can be found at liifund.org.

POSITION SUMMARY:

LIIF is currently in search of an IT Business Partner, SQL Programmer (ITBP). This is a great opportunity to join a highly successful, mission driven organization. We are looking for a seasoned SQL programmer with solid experience in SQL data conversions and strong data integrity background. The ideal candidate will be able to learn systems quickly and be able to work closely with a wide variety of stakeholders.

You’ll be responsible for monitoring a wide array of technical functions in the office including, but not limited to, serving as the strategic interface within your sphere, application support and support of some office technology including managing inter-office teleconferences, phone system user changes, IT administrative support, solution discovery, relationship management, and correspondence with IT vendors and specialized employee software & technology training. The ITBP serves as the business relationship link between business units and IT.

The ITBP proactively serves as a “trusted advisor,” and is the primary IT point of contact to individual Departments. They operate as the key business contact representing IT in promoting IT services and capabilities. The ITBP provides support in delivering technology products that meet the needs of the business. The ITBP focuses on strategic initiatives and planning activities for their business area. They strive to understand market challenges, including customer priorities and competitive issues. ITBPs are proactive and anticipatory in their thinking. They are, by nature, driven and provide significant value to business units. ITBP’s facilitate the intake process and assist in the high level planning and execution of business initiatives through the use of technology. They serve a lead role in enabling the business to achieve their objectives through the effective use of technology.

REPORTING RELATIONSHIPS:

This position reports to the Director of IT.

ESSENTIAL FUNCTIONS:

SQL Programming:

• Support the Excel file onboarding to the loan servicing system, Precision LM.
• Maintain and troubleshoot loan servicing system, Precision LM, including managing the system upgrade (every year at least)
• Support Precision LM users troubleshooting data and workflow issues and occasional fixes in database
• Removal of remaining custom code in Precision LM as warranted
• Maintain, troubleshoot, and create new reports in Excel, Crystal, and SQL-based reports.
• Manage data transfers between Salesforce and Precision LM/SQL Server using a 3rd party tool called Jitterbit.
• Create/Modify LMS reports (Excel/Crystal/SQL based) as needed by the business.
• Create/Maintain data quality edits for Precision LM and a loan origination system, nCino, which sits on the Force.com platform.

Other Essential Functions:

• Analyze business processes in required areas of the organization and create requirements documents that are necessary to communicate requirements effectively to the business users and technical IT staff.
• Define and document business rules and policies for data consistency.
• Manage and maintain the enterprise data architecture, including maintenance of the corporate “data dictionary” and other documentation related to business/systems policy and procedures.

IT Operations Support:

• Assist in managing general office technology such as teleconference system, phone system user moves, adds and changes across the various offices.
• Develop and implement employee training for various applications and office technologies.
• Help with IT administrative functions.
• Act as the key liaison across all functional areas, including business units, the IT department, and outside vendors.
• IT Vendor Management relating to invoice processing, vendor help tickets, and annual vendor agreements.
• Collaborate with management to develop annual budgets for respective business areas.
• Perform other IT tasks as requested by the Director of IT.

OTHER FUNCTIONS:

Other duties as assigned.

SKILLS REQUIRED:

• 
  Strong customer service orientation.
• Ability to maintain confidentiality.
• Five years’ experience SQL Server Programming (primarily T-SQL)
• Experience creating and editing reports using SSRS.
• Excel VBA coding for Reports is desired, can be trained on existing reports.
• Experience with Jitterbit is desired, though this can be trained.
• Salesforce familiarity with reading Object configurations is desired.
• Business Analysis skills are desired.
• Familiarity with SS&C’s Precision LM is desired.
• You should have excellent communication, collaboration, and customer service skills
• Excellent project management skills with ability to juggle multiple projects/tasks across various user groups while remaining detail focused.
• Ability to identify and research various solutions to a given problem.
• Must be able to think independently and provide sound judgement regarding user requests.
• Strong oral and written communication skills.
• Excellent teamwork skills– you’ll be collaborating directly with several key stakeholders and many different teams.
• Experience in researching and documenting possible solutions to business needs and clearly explain trade-offs and potential return on investment for different options.
• Ability to take initiative and learn on your own.
• Skill in conducting research to solve problems

EDUCATIONAL AND OTHER REQUIREMENTS

• 
  Bachelor’s Degree (BA or BS) or equivalent work experience.

LIIF offers great health care plans and well as other highly competitive benefits; you can read about them on our website here. This position is eligible for our yearly bonus plan.

HOW TO APPLY:

Please apply with Resume and Cover Letter via our recruitment portal:

https://workforcenow.adp.com/mascsr/default/mdf/recruitment/recruitment.html?cid=cb73ca7c-d700-429b-a6ab-bf50165187ec&ccId=19000101_000001&lang=en_US

Notice to Third Party Recruitment Agencies:

Please note that Low Income Investment Fund does not accept unsolicited resumes from recruiters or employment agencies. In the absence of an executed Recruitment Services Agreement, there will be no obligation to any referral compensation or recruiter fee.

In the event a recruiter or agency submits a resume or candidate without an agreement Low Income Investment Fund shall explicitly reserve the right to pursue and hire those candidate(s) without any financial obligation to the recruiter or agency. Any unsolicited resumes, including those submitted to hiring managers, shall be deemed the property of Low Income Investment Fund.

We do not accept unsolicited phone calls. Only candidates being considered for a position will be contacted.

LIIF, an EOE (Equal Opportunity Employer), believes that diversity ensures excellence. All qualified applicants will receive consideration for employment without regard to race, color, religion, sexual orientation, gender, or national origin. Candidates of diverse background and with diverse experience are strongly encouraged to apply for this position.