ETL Data Ops Analyst

About the role

Bayview Asset Management (BAM) is seeking a highly motivated Analyst to join its IT Data Operations team. This role is part of a cross-functional group operating at the intersection of residential, consumer, and commercial loan analytics, capital markets, and structured finance. The Analyst will support BAM’s core mortgage-related activities, including loan acquisitions and sales, securitization preparation, collateral management, and ad hoc data and strategy initiatives. Positioned within the Capital Markets group, this role offers direct exposure to trading, research, system development, operations, and structuring teams.

Responsibilities

• Analyze and prepare loan tape data for internal credit models, investor deliverables, and rating agency packages
• Assist in designing and implementing ETL pipelines to extract data from various systems, such as SQL databases, CRM, and flat files
• Cleaning, formatting, and transforming raw data into usable formats for analytical purposes, including data warehousing
• Developing and performing unit tests to ensure data quality and integrity. Optimizing ETL workflows for better performance and efficiency
• Providing production support for ETL jobs, debugging issues, and reducing technical defects
• Providing analytics support across residential, consumer, and commercial departments, as well as to strategy and structuring teams
• Conduct quarterly residential loan portfolio valuations (institutional level) and provide market commentary and pricing perspectives
• Performing collateral integrity checks, identifying and troubleshooting data anomalies, and enhancing validation procedures
• Preparing daily rate-lock updates, daily position reports, and month-end collateral reviews
• Contributing to automation and AI-driven initiatives to enhance operational efficiency and improve daily workflows
• Partnering with research, technology, and operations teams to build scalable and game-changing solutions that contribute to the team’s evolving front-office function
• Managing and prioritizing intraday and ad-hoc data requests from trading desks and internal stakeholders

Requirements

• Exceptional analytical and quantitative skills with strong attention to detail
• Strong communication skills, with the ability to clearly articulate complex data and insights both verbally and in writing
• Familiarity with ETL tools such as Informatica, Microsoft SSIS, Talend, or DataStage
• Solid understanding of data modeling, data warehouse design, and cloud technologies
• Proficiency in Excel, Word, SQL, and Python required
• Experience with Tableau or Power BI is a plus
• Quick learner with the ability to adapt to proprietary systems and new tools
• Strong organizational skills, with the ability to manage multiple priorities and meet tight deadlines
• Collaborative team player who thrives in cross-functional environments and builds strong stakeholder relationships
• Able to perform effectively under pressure while maintaining high-quality work in fast-paced settings

Qualifications

• Bachelor’s degree in a quantitative or analytical field (e.g., Finance, Economics, Math, Computer Science, or related discipline)

Location & Compensation

This is a hybrid position that can be based in either Bayview's Denver office or Fort Lauderdale office. This will be 3 days on-site, 2 days remote. The compensation offered for this role will be between $80,000 - $100,000 and will depend on the level of experience. This role is eligible to participate in the firm’s performance-based bonus compensation programs.

EEOC

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.