Senior SQL Developer at Shellpoint Mortgage Servicing in Charleston, South Carolina

Job Description:

Job Description

Who we are

Shellpoint Mortgage Servicing (SMS) is one of America's top-five non-bank mortgage-servicing companies. What is mortgage servicing? Our clients are businesses that own mortgage loans (such as banks and real estate investment firms). On their behalf, we manage (or "service") their loan portfolios, which means that we collect homeowners' mortgage payments, pay their tax and insurance bills, and help homeowners in default to get current.

Position overview

Do you enjoy providing excellent service and building strong internal relationships? We need energetic senior application development professionals to join our Application Development team. If selected, you'll work from the comfort of your own home, building and supporting a variety of applications as part of an expanding application development team for a rapidly growing company. We need someone who enjoys sharing their knowledge and watching junior team members grow and flourish. We're looking for friendly, outgoing, well-spoken people who are service-minded, competent, reliable, and flexible.

Duties & responsibilities

The successful candidate will:

• Performs a variety of complicated coding related tasks.
  
  


• Follow and improve Shellpoint Mortgage enterprise best practices and coding standards.
  
  


• Shares knowledge and mentors' other developers on the team, some of which will be offshore.
  
  


• Achieve and/or support company performance goals.
  
  


• Take part in continuous training in company policies/procedures and industry regulations.
  
  


• Other tasks or responsibilities as assigned by management.
  
  


• Mentor lesser experienced team members
  
  


• Participate in meeting sharing experiences and providing feedback on architectural concepts, proof of concept, proposed solutions, and process improvement
  
  


• Develop SQL, stored procedures, views, functions, indexes, and ETL to enhance the custom software application based on prioritized sprint stories.
  
  


• Experience with SQL Server, noSQL, and Azure cloud architecture to architect and build the "right" solution while considering the entire enterprise.
  
  


• Provide data profiling and work along with the software team to correctly model and follow approved standards
  
  


• Code review sql changes in git repo.
  
  


• Provide unit testing and support QA and UAT testing
  
  


• Have an innovative spirit, try new things, connect sources that have not been connected before and don't be afraid to fail fast.
  
  

Skills & abilities

The successful candidate needs:

• 10+ years' experience in building complex data solutions in both on-prem and cloud environments following defined standards
  
  


• 10+ years writing SQL in a SQL Server environment
  
  


• The ability to work from home is a must as member of remote US team.
  
  


• Experience writing SQL in a cloud based OLAP environment (Snowflake, Teradata, Netezza, Exadata, Vertica, etc.)
  
  


• Thorough understanding of Data Warehousing and advanced data movement/processing concepts (real-time, event based, uBatch, 24x7, dynamic, etc.)
  
  


• Preferably 5+ years of consulting experience with face-to-face experience working directly with business
  
  


• A positive attitude, with an eagerness to solve problems.
  
  


• Excellent reasoning and research skills; the ability to see the "big picture" and manage the details.
  
  


• A strong work ethic, high integrity, and well-organized mindset.
  
  


• Demonstrates experience in a variety of the field's concepts and best practices.
  
  


• Fully understands software development lifecycle and experience with agile/scrum methodologies to software development.
  
  


• Experience working in a team-oriented, collaborative environment.
  
  


• Ability to conduct research into development issues, standards and products as required.
  
  


• Ability to present ideas and designs to variety of audiences.
  
  


• Good communication skills with a strong customer support orientation.
  
  


• Excellent problem-solving skills.
  
  


• Desire to develop in an agile environment.
  
  


• Experience with agile methodologies a plus
  
  


• Experience with JIRA as a project lifecycle management, development and defect tracking tool.
  
  


• Mortgage servicing experience a plus
  
  

System Requirements

• Dedicated and separate high-speed Internet.
  
  


• Secure home office free of background noise and other distractions.
  
  

Company Perks :
* 15 Paid Time Off (PTO) days and 18 after 1st anniversary!
* 8 Paid Holidays
* Employee Engagement Activities

Company Benefits :
* Medical (including Health Savings Account & Flexible Savings Account)
* Dental - RX - Vision - Life, Disability Insurance - 401(k) Plan with company match! - Employee Assistance Plan

* Tuition-Assistance Programs

* Performance-based Incentives
* Pet Insurance

* Advancement Opportunities

Newrez NOW:

* Our Corporate Social Responsibility program, Newrez NOW, empowers employees to become leaders in their communities through a robust program that includes volunteering, philanthropy, nonprofit grants, and more
* 1 Volunteer Time Off (VTO) day, company-paid volunteer day where all eligible employees may participate in a volunteer event with a nonprofit of their choice
* Employee Matching Gifts Program: We will match monetary employee donations to eligible non-profit organizations, dollar-for-dollar, up to $1,000 per employee

* Newrez Grants Program: Newrez hosts a giving portal where we provide employees an abundance of resources to search for an opportunity to donate their time or monetary contributions

Equal Employment Opportunity
We're proud to be an equal opportunity employer- and celebrate our employees' differences, including race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, and Veteran status. Different makes us better.

CA Privacy Policy

CA Notice at Collection