Previous Job
Previous
SQL, C# Developer
Ref No.: 18-61591
Location: WestLake Village, California
Position Type:Direct Placement
Start Date: 08/23/2018
 As an analyst programmer within Mortgage Accounting and Finance Investment Technology, you will be directly involved with the support and development of the company's mortgage accounting and economics, and tax accounting applications. This role interacts directly with users and other stakeholders to understand business requirements and translate into technical documents. The role will require hands-on SQL development experience which will be leveraged to create proof-of-concept database designs, reconciliation reporting, and ad hoc data sourcing. In addition, development experience is required to trace SQL and C# code as it pertains to data sourcing and business logic. Candidates can expect to be involved in projects related to the sourcing, mapping, value-added processing, and enhancement of mortgage-centric financial data. The role includes a support function where the candidate will need to respond to production issues which require development experience to understand production code and data flows and to query and compare data as part of root cause analysis routines. In addition, candidates will be involved in projects related to supporting the company's enterprise data management standards and other enterprise control-functions. 

Required Skills 
Familiar with Agile devlopment practices and concepts 
Perform "source-to-target” data mapping. 
Document and develop data exchange interfaces 
Develop SQL-based reporting to reconcile data between systems 
Research and refactor C#/C++/T-SQL source code 
Perform ad hoc data analysis using SQL, Excel 
Perform walkthroughs of proposed technology changes 
7+ years experience working with database systems (SQL Server, Oracle, DB2) 
Develop Power-point presentations to express technical concepts to non-technical audiences 

Desired Skills 
Mortgage, finance, accounting knowledge and experience a strong plus 
Familiarity with data governance and IT/Financial control concepts a strong plus