Sonoma Consulting Inc.
Sr. SQL Server Analyst / Developer (Mortgage Industry - Must)
Irving, TX, United States · Senior
Sponsorship not specifiedDetected 3255 days ago
Code ReviewSQLData AnalysisData EngineeringCommunication
About the role
- 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.
- Development phase - Coding/development, unit testing, peer code reviews, code performance aspects, impact analysis 9.
Responsibilities
- Design and support database and table structures for new and evolving sources of data being brought into the organization
- Coordinate development of ETL/data warehouse best practices needed to support new and evolving sources of data used in reporting, transaction processing and analytics
- Perform extensive and detailed data analysis necessary to ensure strict adherence to data quality guidelines
- Create and analyze complex SQL and SSIS as needed to support new and evolving data integration projects and data extracts
- Participate in production support and code deployment after regular business hours
- Take on end-to-end ownership and perform different roles as per the phase/requirement of tickets/projects assigned:
- 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
- Perform other duties as assigned
Requirements
- 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
- Experience using data warehouse with underlying SQL databases and/or analytical tools for business purposes
- Knowledge of key data warehousing and database processes
Benefits
- Serve as subject matter expert within the team and apply specialized knowledge to support the organization's vision and direction
Apply directly at Sonoma Consulting Inc. →Create a free account for alerts like thisView Sonoma Consulting Inc. immigration profile
This listing is sourced directly from Sonoma Consulting Inc.'s careers page and normalized into a canonical job model.