ETL Data Ops Analyst

Bayview Asset Management
Denver, CO, United States
about 2 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Compensation
$80,000.0 - $100,000.0
Working hours
Regular working hours
Job source

Tech stack

Microsoft Word Microsoft Excel Artificial Intelligence Data Analysis Unit Testing Cloud Computing Extract Transform Load (ETL) Data Transformation Data Warehousing IBM InfoSphere DataStage Software Debugging Python (Programming Language)
+10 more
Systems Development Life Cycle Power BI DataOps SQL Databases SQL Server Integration Services Tableau (Software) Talend Informatica Powercenter Information Technology Data Analytics

Job description

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., * 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

Requirements

Do you have experience in Writing skills?, Do you have a Bachelor’s degree?, * 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, * Bachelor’s degree in a quantitative or analytical field (e.g., Finance, Economics, Math, Computer Science, or related discipline)

Benefits & conditions

1819 Wazee Street, Denver, CO 80202 Hybrid work $80,000 - $100,000 a year - Full-time, * 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.

About the company

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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

2:00 min

Separating dataset creation from low-level software implementation steps

Jan Zawadzki · WWC 2022

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader · WWC Europe 2026

1:42 min

Combining technical skills with strong business communication

Lukas Kölbl · LIVE

Videos

See all

Related articles

See all