SQL Server Developer

Sr. SQL Server Analyst / Developer (Mortgage Industry - Must)Candidates should possess extensive Mortgage experience.Essential Functions1. 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 direction3. Design and support database and table structures for new and evolving sources of data being brought into the organization4. Coordinate development of ETL/data warehouse best practices needed to support new and evolving sources of data used in reporting, transaction processing and analytics5. Perform extensive and detailed data analysis necessary to ensure strict adherence to data quality guidelines6. Create and analyze complex SQL and SSIS as needed to support new and evolving data integration projects and data extracts7. Participate in production support and code deployment after regular business hours8. 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 diagrams2. Development phase - Coding/development, unit testing, peer code reviews, code performance aspects, impact analysis9. 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 processes10. Perform other duties as assignedAdditional Skills· Understanding of and experience in database administrationQualificationsCandidates should possess 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.Additional InformationAll 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.