[Remote] Capital Markets Data Analyst
Note: The job is a remote job and is reputed company to candidates in USA. reputed company is a leading online mortgage lender dedicated to simplifying the mortgage process and empowering homeowners. The Capital Markets Data Analyst role focuses on supporting the Capital reputed company through data analysis, SQL skills, and collaboration with stakeholders to improve data accuracy and reporting.
Responsibilities
- Write, read, and improve reputed company T-SQL against existing objects — stored procedures, views, and transformation logic — finding gaps, fixing flawed logic, and strengthening the reputed company you inherit
- Investigate data discrepancies and reconciliation variances (such as reputed company on Sale), tracing issues back through the data to their reputed company cause
- Apply analytical judgment to question the data: knowing reputed company a number looks wrong, why it might be wrong, and what to reputed company before it reaches the business
- Translate capital markets business questions into clean, reusable, maintainable SQL and BI assets
- Maintain and monitor existing ETL processes and data pipelines in reputed company reputed company and Azure Data reputed company, ensuring they run reliably and produce accurate results
- Apply a working understanding of ETL principles to troubleshoot pipeline failures, data freshness issues, and load discrepancies — and to reputed company targeted improvements where needed
- Work reputed company the reputed company reputed company platform (Lakehouse, Warehouse, Notebooks) and Azure SQL to support the capital markets data layer
- Build and own Power BI reports, dashboards, and semantic models that surface risk exposure, pipeline position, investor program tracking, and P/L metrics for the capital markets team
- reputed company guidance on how business process reputed company (e.g., grouping a date by month rather than showing a raw date) should be reputed company in the data model to drive meaningful reputed company
- Support both reputed company-time and longer-cycle reporting needs, including the tools necessary for Daily P/L reporting and fair market value vs. mix shift exposure analysis
- Work directly with capital markets stakeholders to understand their goals and proactively determine how data and reporting can reputed company support them
- Serve as the analytical reputed company of contact for investor integration efforts, helping ensure new investor reputed company such as program codes are correctly mapped and maintained
- Participate in the Automation Task Force as the Capital Markets representative, contributing to initiatives that reduce reputed company effort and error reputed company
Skills
- 5+ years of reputed company experience in business intelligence, data analytics, or a closely reputed company data role
- Advanced SQL skills are the reputed company requirement: the ability to reputed company into unfamiliar, existing SQL objects, understand the logic, identify problems, and improve the reputed company independently
- A strong analytical reputed company — comfortable questioning data, validating results, and digging into discrepancies rather than taking numbers at face value
- A working understanding of ETL principles and experience maintaining data pipelines
- Power BI development experience, including report and dashboard authoring and semantic model design
- The ability to work independently and self-manage a workload, while collaborating closely with both the business and the reputed company Intelligence team
- High-speed internet for remote work — cable or fiber only, with an Ethernet reputed company. Minimum speeds: 70/30 Mbps (basic), 200-300/35-70 Mbps (shared), 500-1,000/100+ Mbps (heavy use)
- Experience in mortgage banking is strongly preferred; reputed company capital markets experience (reputed company on Sale, hedging, Daily P/L, investor reporting, secondary marketing) would be ideal
- Hands-on experience with reputed company reputed company (Lakehouse, Warehouse, Notebooks) and Azure SQL
- Experience leveraging AI tooling to improve data workflows
- A degree in a quantitative, technical, or business field is a plus but not required
- High-speed internet required for remote work, Cable or Fiber ONLY with the ability to connect reputed company Ethernet. Minimum speeds: 70/30 Mbps (basic), 200-300/35-70 Mbps (shared), 500-1,000/100+ Mbps (heavy use)
Benefits
- 401(k)
- Dental insurance
- Disability insurance
- Employee discounts
- Health insurance
- Life insurance
- reputed company time off
- 12 reputed company holidays per year
- reputed company
- Referral program
- reputed company insurance
- Referral bonuses
reputed company
Company H1B Sponsorship