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

Sonoma Consulting Inc.; Irving (TX); On-site; USD 85,000 - 115,000; Full time

Job summary

A leading IT consulting firm based in the United States seeks a Sr. SQL Server Analyst/Developer with extensive experience in the mortgage industry. This position requires strong skills in SQL Server T-SQL and SSIS, along with the ability to conduct thorough data analysis. The successful candidate will design database structures, ensure data quality, and contribute to various projects, showcasing a solid understanding of database modeling concepts. Competitive salary and full-time commitment are offered.

Qualifications

• 5+ years of experience with SQL Server T-SQL coding.
• 2+ years of experience with SSIS.
• 3-4 years of experience working in the mortgage industry.

Responsibilities

• Design and support database structures for new data sources.
• Perform data analysis to ensure data quality.
• Create and analyze SQL and SSIS for data integration.

Skills

SQL Server T-SQL

SSIS

Data Analysis

Database Modeling

ETL Processes

Education

Bachelor's degree in a related field

Tools

SQL Server 2005/2008/2012

Data Warehousing Tools

Job description

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

• Full-time

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.

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.