Sr. SQL Server Analyst / Developer (Mortgage Industry - Must)

Job description

Candidates should posses extensive Mortgage experience. Essential Functions 1. Adhere to general work requirements. 2. Serve as subject matter expert within the team and apply specialized knowledge to support the organization’s vision and direction 3. Design and support database and table structures for new and evolving sources of data being brought into the organization 4. Coordinate development of ETL/data warehouse best practices needed to support new and evolving sources of data used in reporting, transaction processing and analytics 5. Perform extensive and detailed data analysis necessary to ensure strict adherence to data quality guidelines 6. Create and analyze complex SQL and SSIS as needed to support new and evolving data integration projects and data extracts 7. Participate in production support and code deployment after regular business hours 8. Take on end-to-end ownership and perform different roles as per the phase/requirement of tickets/projects assigned: 1. Analysis phase - Requirements gathering, data analysis, documentation, source-to-target mapping, data/process flow diagrams 2. Development phase - Coding/development, unit testing, peer code reviews, code performance aspects, impact analysis 9. Set/manage expectations with clients, provide proactive communication and status updates, prioritize deliverables with client/requestor, and follow and implement Change Control and release management processes 10. Perform other duties as assigned Additional Skills · Understanding of and experience in database administration Candidates should posses extensive Mortgage experience . Minimum Qualifications · Bachelor’s degree in a related field · 5+ years of experience with SQL Server 2005/2008/2012 T-SQL coding · 2+ years of experience with SSIS · 5+ years of experience as a data analyst and/or SQL/SSIS developer · 3-4 years of experience working in the mortgage industry · Good understanding of database modeling concepts, preferably in the context of mortgage industry (originations and/or servicing). Example – MISMO specifications · Experience using data warehouse with underlying SQL databases and/or analytical tools for business purposes · Knowledge of key data warehousing and database processes · Ability to reverse engineer existing SQL code to determine business logic, and create source-to-target mapping documents. All qualified applicants will receive consideration for employment without regard to race, color, religion, place of origin, ethnic origin, national origin, ancestry, age, sex, sexual orientation, gender identity, transgender status, genetic information, mental or physical disability, marital status, pregnancy, veteran status, or any other characteristic protected by applicable national, state, or local law. Sonoma Consulting is one of the fastest growing national IT Consulting and Executive Search company in the United States, which was founded in 2011 by Mark McGee, the President and CEO. Sonoma Consulting has two business divisions - IT Consulting Services & Executive Search to serve its 150 national clients which range from entrepreneurial start-ups to Global Fortune 500.