[Remote] Capital Markets Data Analyst

Note: The job is a remote job and is open to candidates in USA. AmeriSave Mortgage is a leading online mortgage lender dedicated to simplifying the mortgage process and empowering homeowners with fast, transparent, and competitively priced loans. The Capital Markets Data Analyst will support the Capital Markets group by ensuring the accuracy and reliability of datasets and reports that drive decision-making, focusing on data analysis, ETL processes, and reporting using SQL and Power BI.ResponsibilitiesWrite, read, and improve complex T-SQL against existing objects — stored procedures, views, and transformation logic — finding gaps, fixing flawed logic, and strengthening the code you inheritInvestigate data discrepancies and reconciliation variances (such as Gain on Sale), tracing issues back through the data to their root causeApply analytical judgment to question the data: knowing when a number looks wrong, why it might be wrong, and what to check before it reaches the businessTranslate capital markets business questions into clean, reusable, maintainable SQL and BI assetsMaintain and monitor existing ETL processes and data pipelines in Microsoft Fabric and Azure Data Factory, ensuring they run reliably and produce accurate resultsApply a working understanding of ETL principles to troubleshoot pipeline failures, data freshness issues, and load discrepancies — and to make targeted improvements where neededWork within the Microsoft Fabric platform (Lakehouse, Warehouse, Notebooks) and Azure SQL to support the capital markets data layerBuild 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 teamProvide guidance on how business process elements (e.g., grouping a date by month rather than showing a raw date) should be structured in the data model to drive meaningful insightSupport both real-time and longer-cycle reporting needs, including the tools necessary for Daily P/L reporting and fair market value vs. mix shift exposure analysisWork directly with capital markets stakeholders to understand their goals and proactively determine how data and reporting can better support themServe as the analytical point of contact for investor integration efforts, helping ensure new investor elements such as program codes are correctly mapped and maintainedParticipate in the Automation Task Force as the Capital Markets representative, contributing to initiatives that reduce manual effort and error rateSkills5+ years of professional experience in business intelligence, data analytics, or a closely related data roleAdvanced SQL skills are the core requirement: the ability to step into unfamiliar, existing SQL objects, understand the logic, identify problems, and improve the code independentlyA strong analytical mindset — comfortable questioning data, validating results, and digging into discrepancies rather than taking numbers at face valueA working understanding of ETL principles and experience maintaining data pipelinesPower BI development experience, including report and dashboard authoring and semantic model designThe ability to work independently and self-manage a workload, while collaborating closely with both the business and the Enterprise Intelligence teamHigh-speed internet for remote work — cable or fiber only, with an Ethernet connection. 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; direct capital markets experience (Gain on Sale, hedging, Daily P/L, investor reporting, secondary marketing) would be idealHands-on experience with Microsoft Fabric (Lakehouse, Warehouse, Notebooks) and Azure SQLExperience leveraging AI tooling to improve data workflowsA degree in a quantitative, technical, or business field is a plus but not requiredHigh-speed internet required for remote work, Cable or Fiber ONLY with the ability to connect via Ethernet. Minimum speeds: 70/30 Mbps (basic), 200-300/35-70 Mbps (shared), 500-1,000/100+ Mbps (heavy use)Benefits401(k)Dental insuranceDisability insuranceEmployee discountsHealth insuranceLife insurancePaid time off12 paid holidays per yearPaid trainingReferral programVision insuranceReferral bonusesCompany OverviewAmeriSave Mortgage, NMLS ID #1168, is one of the largest privately owned online mortgage lenders in the country, with strong consumer direct, traditional retail and Third Party Origination (TPO) channels. It was founded in 2002, and is headquartered in Atlanta, Georgia, USA, with a workforce of 5001-10000 employees. Its website is http://www.amerisave.com.