Houston, TX, USA
19 days ago
Sr Data Engineer - Business Intelligence (On-Site)

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.
 

Primary Function/Summary

We are on a mission to evolve how we use data at Shellpoint to grow our business and fulfill the needs of our customers. We are modernizing our data and integration platform to be best in class. In this role you will be responsible for implementing modern architecture and engineering design patterns in a range of technologies, considering both technical and economic perspectives. You will partner with technical and business stakeholders to implement solutions balancing current and legacy technical standards, while keeping an eye towards scalability and resilience. We are looking for someone who can design, code, and execute in both cloud and on prem environments – while evangelizing the opportunities of good engineering design, modern integration architectures and data as a service.

Principal Duties

Serve as a key contributor to identify, evaluate, and execute the development and implementation of data infrastructure.Deliver collaborative products that align with organization and decision strategies.Consult with technology and business staff to understand business need and provide thought leadership on solutions during requirements gathering sessions.Serve as key contributor in the development and maintenance of the data warehouse.Support critical strategic initiatives and architect moderately complex data engineering projects.Design and develop scalable, efficient data pipeline processes to handle data ingestion, cleansing, transformation, integration, and validation required to provide access to curated data sets to data analysts and data scientists.Develop, communicate, and present solution architectures to both technology and business stakeholders.Develop highly complex SQL queries to extract data for analysis and model construction.Design, build, and maintain internal and external data integrations.Build robust data pipelines, optimizing workloads across on prem and cloud environments.Test and validate data pipelines, transformations, datasets, reports, and dashboards built by team.Document and test data processes including performance of through data validation and verification.Contribute to delivery of multiple large, complex data engineering projects simultaneously.Collaborate with technology management to define standards and best practices for team.Mentor and assist other data engineers, data analytics and data scientists.Provide support to other data engineering, data analytics, application development, data systems and production support teams.Work on other projects as assigned.Performs related duties as assigned by supervisor.

Core Development Stack  

Languages: SQL (standard and DB-specific)Tools/Products: Microsoft SQL Server, Snowflake, SSIS (SQL Server Integration Services), HVR/Fivetran, Snaplogic, SSRS (SQL Server Reporting Services), RedGate Developer Toolkit, Tableau, PowerBIFrameworks: Amazon Web Services (AWS) & Microsoft Azure cloud servicesOther: Azure DevOps, Smartsheet, Microsoft Visio, TFS (Team Foundation Server), Octopai

Education and Experience Requirements  

College or university degree in the field of Information Technology, Data Science, Computer Science, MIS, or another STEM-related field required.  Significant experience in a similar role or industry will be considered as a replacement.5-7 years engineering/development experienceExpertise in SQL Server 2017 or higherExpertise with data and analytics technologies such as RDBMS, ETL and BIExperience with SQL Server Integration Services (SSIS)Experience with SQL Server Reporting Services (SSRS)Experience with Microsoft Visual Studio 2017 or higherExperience with on prem and cloud solution design and engineeringExperience with Snowflake, Azure, AWS, or other cloud technologiesExperience with agile delivery methodologies

Knowledge, Skill, and Ability Requirements 

Cloud-based solution design and engineeringExperience with tools such as HVR/Fivetran and Snaplogic are a plusAzure data and analytics deploymentsExperience in solution design spanning multiple frameworksExperience in other languages such as Python, R, Spark SQL, Java, etc. are a plusExperience with Azure DevOps, TFSFamiliarity with API-first architecturesReal time streaming data deliveryDevOps and CI/CD experienceMortgage servicing, mortgage lending and/or finance experience

While this description is intended to be an accurate reflection of the position’s requirements, it in no way implies/states that these are the only job responsibilities.  Management reserves the right to modify, add or remove duties and request other duties, as necessary.

Company Perks:
•    15 Paid Time Off (PTO) days and 18 after 1st anniversary!
•    9 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 

•    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

Confirm your E-mail: Send Email