ETL Data Ops Analyst

Bayview Asset Management

Denver, Colorado

JOB DETAILS
SALARY
$80,000–$100,000 Per Year
JOB TYPE
Full-time
SKILLS
Analysis Skills, Artificial Intelligence (AI), Asset Management, Automation, Business Activity Monitoring (BAM), Capital Analysis, Capital Markets, Cloud Computing, Commercial Loans, Communication Skills, Compensation and Benefits, Computer Science, Consumer Loans, Cross-Functional, Customer Relations, Customer Relationship Management (CRM), Data Analysis, Data Formats, Data Modeling, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), Debugging Skills, Detail Oriented, Economics, Establish Priorities, Finance, IBM WebSphere DataStage, Identify Issues, Informatica, Investment Management, Loan Portfolio, Loans, Marketing/Sales Collateral, Mathematics, Microsoft Excel, Microsoft Product Family, Microsoft Word, Mortgage, Mortgage Servicing, Multitasking, Operational Audit, Operational Improvement, Operational Strategy, Organizational Skills, Power BI, Pricing, Process Improvement, Production Support, Python Programming/Scripting Language, Quality Management, Quantitative Analysis, Real Estate Appraisals, Residential Mortgages, SQL (Structured Query Language), SQL Databases, SQL Server Integration Services (SSIS), Sales, Scalable System Development, Securities, Strategic Planning, System Operations, Tableau, Team Player, Technical Operations, Technical Research, Testing, Time Management, Unit Test
LOCATION
Denver, Colorado
POSTED
14 days ago
Overview:

About Us

Founded in 1993, Bayview Asset Management is an investment management firm focused on mortgage and consumer credit investments, including whole loans, asset-backed securities, mortgage servicing rights, and other credit-related assets.

 

Position Summary

 

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. The ideal candidate is analytically strong, technically proficient, and eager to drive impact through data-driven insights and process improvements. 

 

Key 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
  • Assist in developing, updating, and maintaining ETL mappings and workflows.
  • 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
  • Provide analytics support across residential, consumer, and commercial dept, as well as to strategy and structuring teams
  • Conduct quarterly residential loan portfolio valuations (institutional level) and provide market commentary and pricing perspectives
  • Perform collateral integrity checks, identify and troubleshoot data anomalies, and enhance validation procedures
  • Prepare daily rate-lock updates, daily position reports, and month-end collateral reviews
  • Contribute to automation and AI-driven initiatives to enhance operational efficiency and improve daily workflows
  • Partner with research, technology, and operations teams to build scalable and game-changing solutions that contribute to the team’s evolving front-office function
  • Manage and prioritize intraday and ad-hoc data requests from trading desks and internal stakeholders

 

Required Skills and Experiences:  

  • 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. 

 

About the Company

B

Bayview Asset Management