Lakeview is an Equal Employment Opportunity employer. All aspects of consideration for employment and employment with the Company are governed on the basis of merit, competence and qualifications without regard to race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, or any other category protected by federal, state, or local law.
Data Engineer, Mortgage Servicing
Location
United States
Posted
17 days ago
Salary
$220K - $300K / year
Seniority
Mid Level
Job Description
Data Engineer, Mortgage Servicing
Lakeview Loan Servicing
Role Description The Data Engineer, Mortgage Servicing on the Nebula team acts as the mortgage servicing data subject matter expert and plays a critical role in building and evolving the data foundation that powers analytics, reporting, AI development, and operational decision-making across the organization. This role is responsible for designing, building, and maintaining reliable, scalable, and flexible data systems that support a wide range of internal and external use cases. - Requires domain awareness in mortgage and servicing-related data environments. - Understanding of the complexities associated with loan-level lifecycle data, transaction processing, cash movement, and reconciliation across systems. - Must be able to translate business workflows and system behavior into accurate, auditable data structures that support downstream reporting, operational processes, and regulatory requirements. - Contributes to the development and evolution of core data capabilities, including batch and real-time pipelines, operational and analytical data stores, semantic models, and BI-ready datasets. - Expected to operate effectively in a modern engineering environment, using automation, observability, and infrastructure-as-code practices. - Help enable downstream analytics, reporting, product capabilities, and AI systems by ensuring that data is trustworthy, accessible, and fit for purpose. Responsibilities - Data Pipeline Development: - Design, build, and maintain robust data pipelines for a wide variety of input and output sources, including internal systems, third-party platforms, files, APIs, event streams, and databases. - Develop scalable ETL and ELT workflows for both batch and real-time processing. - Ensure pipelines are reliable, testable, observable, and easy to extend as business needs evolve. - Build reusable data integration patterns that support growing volumes, new source systems, and downstream consumers across analytics, applications, and AI initiatives. - Data Platform & Storage: - Design and manage data architectures that support OLTP, OLAP, and reporting workloads across operational and analytical environments. - Build and optimize data models, warehouse schemas, and curated datasets for analytics and BI use cases. - Contribute to the design and operation of modern data platforms, including warehouses, lakehouses, streaming systems, and supporting orchestration frameworks. - Help define patterns for data storage, partitioning, performance optimization, retention, and lifecycle management. - Servicing-Oriented Data Modeling & Integrity: - Design and maintain data models that accurately reflect loan-level lifecycle events, including payment activity, balances, adjustments, and status changes. - Ensure consistency and reconciliation across systems where transactional, financial, and reporting data must align. - Identify and resolve discrepancies across source systems, and build data structures that support accurate, auditable outputs for downstream operational processes, reporting, and decisioning. - Cloud Deployment & Operations: - Deploy, operate, and improve data pipelines and data stores on major cloud platforms such as AWS, GCP, or Azure. - Use infrastructure-as-code, CI/CD, and automation practices to improve deployment speed, consistency, and reliability. - Monitor production data systems using logging, alerting, and observability tooling to proactively identify and resolve issues. - Support secure, resilient, and cost-conscious operation of cloud-based data infrastructure. - Data Quality, Reliability & Governance: - Implement data quality checks, validation rules, reconciliation processes, and monitoring to ensure trustworthy data across systems. - Establish and maintain standards for lineage, documentation, metadata, schema evolution, and operational runbooks. - Partner with stakeholders to improve data accessibility, consistency, and usability while maintaining appropriate controls and governance. - Contribute to practices that support security, privacy, auditability, and compliance in a regulated environment. - Cross-Functional Collaboration: - Partner closely with Product, Engineering, and business stakeholders to understand data needs, workflows, and constraints. - Translate business and operational requirements into clean, scalable, and maintainable data solutions. - Support downstream consumers of data, including analysts, researchers, product teams, and operational users. - Communicate clearly with both technical and non-technical stakeholders about data availability, quality, tradeoffs, and delivery timelines. - Iteration & Continuous Improvement: - Continuously improve pipeline performance, reliability, scalability, and developer productivity. - Identify opportunities to simplify architecture, reduce operational toil, and improve data platform leverage across teams. - Operate with a strong bias toward action and iterative delivery, moving quickly from problem definition to implementation and improvement. - Help raise the bar on engineering quality through thoughtful design, testing, documentation, and operational discipline. Qualifications - 5-8+ years of experience building and operating production-grade data pipelines and data systems. - Prior experience in mortgage, servicing, or similarly regulated financial domains. - Strong experience with industry-standard tools and platforms for ETL/ELT, orchestration, data warehousing, streaming, and BI. - Experience working with both OLTP and OLAP systems, with a strong understanding of the tradeoffs between transactional and analytical workloads. - Experience building flexible data pipelines that integrate with many different source and destination types, including databases, APIs, files, message queues, SaaS platforms, and event streams. - Experience supporting both batch and real-time data processing patterns. - Experience deploying and operating data infrastructure on major cloud platforms such as AWS, GCP, or Azure. - Strong SQL skills and experience with data modeling, transformation frameworks, and performance optimization. - Experience building AI-powered capabilities on top of LLMs, including orchestration, evaluation, and data integration patterns. - Experience with modern programming languages commonly used in data engineering, such as Python, Java, Scala, or Go. - Comfort working with CI/CD, infrastructure-as-code, observability, and production operations for data systems. - Strong judgment in ambiguous environments where requirements evolve and systems must balance speed, reliability, and flexibility. - Clear communication skills with both technical and non-technical teammates. Preferred Experience - Experience with modern orchestration and transformation tools such as Airflow, Dagster, dbt, or similar platforms. - Experience with cloud-native data warehouses or lakehouse platforms such as Snowflake, BigQuery, Redshift, Databricks, or equivalent technologies. - Experience with streaming and real-time data platforms such as Kafka, Kinesis, SQS, or similar systems. - Experience enabling BI and self-service analytics through curated datasets, semantic layers, and reporting platforms such as Looker, Power BI, Tableau, or similar tools. - Experience working with loan-level or transaction-heavy financial data within residential mortgage servicing domains. - Experience dealing with data reconciliation challenges across multiple systems, particularly where cash balances, or investor/reporting outputs must align. - Experience building data platforms that support AI, machine learning, or decisioning workflows. - Experience improving data quality, reliability, cost efficiency, and platform scalability as a system grows. A Note to Candidates If you are a strong data engineer with solid technical judgment, a systems mindset, and excitement for solving complex data problems, we would love to hear from you. If your background does not line up perfectly with every bullet, but this role feels like the kind of work you want to do, please apply. Bayview is an Equal Employment Opportunity employer. All aspects of consideration for employment and employment with the Company are governed on the basis of merit, competence and qualifications without regard to race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, or any other category protected by federal, state, or local law. #LI-Remote
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
Excel & Google Sheets Data Migration Specialist
MSP OPERATIONAL CORPAt MSP Corp, we don’t just build our own teams — we help our clients build theirs. As a national leader in managed IT services, we partner with exceptional companies to find the right talent to power their growth.
Role Description We are seeking a detail-oriented Google Sheets and Microsoft Excel expert to manually migrate and rebuild over 1,000 Google Sheets files into Excel while maintaining formulas, formatting, structure, and functionality. The ideal candidate will have advanced spreadsheet expertise, strong analytical skills, and experience working with complex formulas and large data sets. - Manually migrate Google Sheets documents to Microsoft Excel format. - Rebuild and validate complex formulas, functions, and spreadsheet logic in Excel. - Ensure data integrity, formatting consistency, and workbook functionality throughout the migration process. - Identify and resolve compatibility issues between Google Sheets and Excel. - Organize and manage large volumes of spreadsheet files efficiently. - Perform quality assurance testing to ensure accuracy after migration. - Collaborate with internal stakeholders to clarify spreadsheet structures and business logic when required. - Maintain confidentiality and security of company data. Qualifications - Advanced expertise in Google Sheets and Microsoft Excel. - Strong knowledge of: - Complex formulas and functions - Pivot tables - Lookup functions (VLOOKUP, XLOOKUP, INDEX/MATCH) - Conditional formatting - Data validation - Spreadsheet troubleshooting - Experience migrating spreadsheets between platforms. - Strong attention to detail and accuracy. - Ability to manage high-volume repetitive tasks efficiently. - Strong organizational and time management skills. - Experience working with large datasets is considered an asset. - Experience with macros, VBA, or spreadsheet automation. - Familiarity with Google Apps Script. - Data cleanup and normalization experience. - Previous migration or data conversion project experience. Company Description At MSP Corp, we don’t just build our own teams — we help our clients build theirs. As a national leader in managed IT services, we partner with exceptional companies to find the right talent to power their growth.
Role Description The Data Engineer will be part of the Research & Development team, responsible for designing, building and maintaining internal systems used by management, coaches, scouts, analysts and all other Hockey Operations staff. The primary focus of the role will be back-end development but front-end development skills and systems management experience is preferred. This position is available for in-person or remote work (with occasional travel). - Develop, document, and maintain the schemas and ETL pipelines for all hockey operations databases - Maintain web interfaces for hockey operations use, in conjunction with department personnel - Work with other members of the R&D team to address and support all existing data-related requests from across hockey operations - Create, summarize, and deliver statistical reports to stakeholders across hockey operations - Optimize data collection, storage, manipulation and transformation tasks - Maintain a system for unit-testing and monitoring all hockey operations databases, data products and associated raw data feeds - Collaborate with a team of data scientists, data engineers, and other department personnel - Communicate effectively and directly with hockey operations staff - Perform all job duties in a variety of work settings including virtual meetings and distributed work environments, at in-person meetings, via phone/email, and in other settings - Document all data pipelines, code, processes, workflows, etc. - Perform ad-hoc and time-sensitive tasks upon request - Maintain the upmost confidentiality - Perform other related duties as assigned Qualifications - Bachelor’s degree (or equivalent experience) in software engineering, computer engineering, computer science, information technology, information systems or a related field - Demonstrated experience reading, writing and documenting code in Python. Experience working with common Python libraries (ex. numpy, pandas, etc.) and building or working with custom Python packages is preferred. - Ability to write ad hoc SQL queries to support data analysis - Ability to work with Git for version control, and experience working collaboratively on shared coding projects - Some front-end development experience with HTML, CSS, and/or JavaScript - Some web development experience. Experience with Python Django preferred - Ability to work a flexible schedule (including nights, weekends and holidays when necessary) and to occasionally travel Requirements - Experience with R and/or Python for data analysis (preferred but not required) - Experience working with pipeline management tools (ex. Airflow) (preferred but not required) - Experience working with containers for application deployment (ex. Docker) (preferred but not required) - Experience working with distributed storage and computer infrastructures (ex. HDFS, Spark, Yarn) (preferred but not required) - Experience reading and writing with relational database systems (ex. Postgres) (preferred but not required) Critical Competencies - Strong attention to detail and highly organized - Ability to manage multiple projects at once - Excellent written and verbal communication skills - Flexibility to adapt to changing priorities - Collaborative and creative - Strong problem-solving skills Compensation This role will pay between $62,500 - $75,000 annually. Note: Wages will be determined based on factors such as candidate experience, qualifications, skill set and internal equity. Benefits - Medical Plans: Comprehensive and affordable medical plans; supplemental vision care, dental care, life insurance coverage, fully paid, short and long-term disability and life insurance coverage. - Investments: 401(k) with employer matching; annual discretionary defined employer contributions - Paid Time Off: Paid Volunteer Days - Sabres Experience: (up to 4) Comp tickets to Buffalo Sabres, Buffalo Bandits, Rochester Americans when available - Wellness: Annual Health & Wellness fair, monthly wellness initiatives including but not limited to lunch & learns, fitness classes and challenges. - Sabres Family: many annual social events for employees and their families to enjoy, including various holiday parties and activities. DEI committee with annual initiatives, ERG (Employee Resource Groups), Community Volunteer opportunities and more.
• Build infrastructure and data automation pipelines to ingest, process, and load data from various sources • Automate and integrate new components into the data pipeline • Collaborate with stakeholders and data science teams to develop data products, including entity resolution and best selection, to efficiently execute product vision and strategy in alignment with organizational goals and priorities • Create unit and stress-test components to monitor technical performance and ensure that identified issues are resolved • Develop data analysis tools to provide data insights and capture key metrics • Research solutions and maintain technical documentation • Follow best practices for data governance, quality, cleansing, and other ETL-related activities
Role Description The Corporate Workspace Technology area is currently hiring for the role of Senior Data Engineer for the modernization of tooling enablement function. As a Senior Data Engineer, you will be responsible for design, modeling, development and management of data warehouse objects in Snowflake data store utilizing effective data pipelines such as Talend, Informatica and APIs. - Designing, implementing, managing scalable data solutions using Snowflake environment for optimized data storage and processing. - Migrate existing data domains/flows from relational data store to cloud data store (Snowflake). - Identify and optimize new/existing data workflows. - Identify and implement data integrity practices. - Integrate data governance and data science tools with Snowflake ecosystem as per practice. - Support the development of data models and ETL processes to ensure high quality data ingestion in cloud data store. - Collaborate with team members to design and implement effective data workflows and transformations. - Assist in the maintenance and optimization of Snowflake environments to improve performance and reduce costs. - Contribute to proof of concept, documentation and best practices for data management and governance within the Snowflake ecosystem. - Participate in code reviews and provide constructive feedback to improve team deliverables quality. - Design and develop data ingestion pipeline using Talend/Informatica using industry best practices. - Writing efficient SQL and Python scripts for large dataset analysis and building end to end automation process on a set schedule. - Design, implement data distribution layer using Snowflake REST API. Qualifications - Self-driven, dedicated individual who works well in a team and thinks and acts strategically. Requirements - Bachelor’s Degree, in lieu of a degree, demonstrating in addition to the minimum years of experience required for the role, three years of specialized training and/or progressively responsible work experience in technology for each missing year of college is required. Benefits - Competitive compensation. - Professional development opportunities. - Flexible work arrangements.

