<div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">AmeriSave Mortgage is a leading online mortgage lender dedicated to simplifying the mortgage process and empowering homeowners with fast, transparent, and competitively priced loans. Through innovative technology and a customer-centric focus, we make home financing more accessible and tailored to individual needs.</span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;"> </span></div><div style="line-height: 150.0%;"><b><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Position Overview</span></b></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">The Capital Markets Data Analyst is dedicated exclusively to supporting the Capital Markets group from within the Enterprise Intelligence department. This is a data-focused analyst role centered on strong SQL skills, sound analytical judgment, and a close working partnership with the capital markets business.</span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">The right person can be dropped into an existing data object, understand what it is doing, find the holes, and improve the logic — all while knowing when to question whether the data itself is telling the right story. You will own the accuracy and reliability of the datasets and reports that drive capital markets decision-making, including Daily P/L, Gain on Sale reconciliation, and investor exposure analytics. You will work independently and manage your own workload, with the support of the broader Enterprise Intelligence team behind you.</span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;"> </span></div><div style="line-height: 150.0%;"><b><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">What You’ll Do:</span></b></div><div style="line-height: 150.0%;"><b><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Data Analysis & SQL</span></b></div><ul style="margin-top: 0.0px;"><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Write, 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 inherit.</span></li><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Investigate data discrepancies and reconciliation variances (such as Gain on Sale), tracing issues back through the data to their root cause.</span></li><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Apply 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 business.</span></li><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Translate capital markets business questions into clean, reusable, maintainable SQL and BI assets.</span></li></ul><div style="line-height: 150.0%;"><b><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">ETL & Pipeline Maintenance</span></b></div><ul style="margin-top: 0.0px;"><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Maintain and monitor existing ETL processes and data pipelines in Microsoft Fabric and Azure Data Factory, ensuring they run reliably and produce accurate results.</span></li><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Apply a working understanding of ETL principles to troubleshoot pipeline failures, data freshness issues, and load discrepancies — and to make targeted improvements where needed.</span></li><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Work within the Microsoft Fabric platform (Lakehouse, Warehouse, Notebooks) and Azure SQL to support the capital markets data layer.</span></li></ul><div style="line-height: 150.0%;"><b><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Reporting & Power BI</span></b></div><ul style="margin-top: 0.0px;"><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">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.</span></li><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Provide 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 insight.</span></li><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Support 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 analysis.</span></li></ul><div style="line-height: 150.0%;"><b><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Business Partnership</span></b></div><ul style="margin-top: 0.0px;"><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Work directly with capital markets stakeholders to understand their goals and proactively determine how data and reporting can better support them.</span></li><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Serve as the analytical point of contact for investor integration efforts, helping ensure new investor elements such as program codes are correctly mapped and maintained.</span></li><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Participate in the Automation Task Force as the Capital Markets representative, contributing to initiatives that reduce manual effort and error rate.</span></li></ul><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;"> </span></div><div style="line-height: 150.0%;"><b><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">What You’ll Need</span></b></div><div style="line-height: 150.0%;"><b><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Required</span></b></div><ul style="margin-top: 0.0px;"><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">5+ years of professional experience in business intelligence, data analytics, or a closely related data role.</span></li><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Advanced SQL skills are the core requirement: the ability to step into unfamiliar, existing SQL objects, understand the logic, identify problems, and improve the code independently.</span></li><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">A strong analytical mindset — comfortable questioning data, validating results, and digging into discrepancies rather than taking numbers at face value.</span></li><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">A working understanding of ETL principles and experience maintaining data pipelines.</span></li><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Power BI development experience, including report and dashboard authoring and semantic model design.</span></li><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">The ability to work independently and self-manage a workload, while collaborating closely with both the business and the Enterprise Intelligence team.</span></li><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">High-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).</span></li></ul><div style="line-height: 150.0%;"><b><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Preferred</span></b></div><ul style="margin-top: 0.0px;"><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Experience in mortgage banking is strongly preferred; direct capital markets experience (Gain on Sale, hedging, Daily P/L, investor reporting, secondary marketing) would be ideal.</span></li><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Hands-on experience with Microsoft Fabric (Lakehouse, Warehouse, Notebooks) and Azure SQL.</span></li><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Experience leveraging AI tooling to improve data workflows.</span></li><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">A degree in a quantitative, technical, or business field is a plus but not required.</span></li><li><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">High-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).</span></li></ul><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;"> </span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;color: black;">**Please note that the compensation and benefit information that follows is a good faith estimate for this position only and is provided pursuant to applicable state and local laws on pay transparency. It is estimated based on what a successful applicant in the relevant state might be paid. **  </span><span style="font-size: 10.5pt;line-height: 150.0%;font-family: Calibri , sans-serif;color: black;"><span style="outline: none;"> </span></span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;"> </span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Compensation:</span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">The annual compensation for this position generally ranges from between $95,000 - $135,000. </span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;"> </span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Benefits:<span>   </span></span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">·<span>         </span>401(k)<span>   </span></span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">·<span>         </span>Dental insurance<span>   </span></span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">·<span>         </span>Disability insurance<span>   </span></span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">·<span>         </span>Employee discounts<span>   </span></span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">·<span>         </span>Health insurance<span>   </span></span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">·<span>         </span>Life insurance<span>   </span></span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">·<span>         </span>Paid time off<span>   </span></span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">·<span>         </span>12 paid holidays per year<span>   </span></span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">·<span>         </span>Paid training<span>   </span></span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">·<span>         </span>Referral program<span>   </span></span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">·<span>         </span>Vision insurance<span>   </span></span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;"><span>    </span></span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">Supplemental pay types:<span>   </span></span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;">·<span>         </span>Referral bonuses<span>   </span></span></div><div style="line-height: 150.0%;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;"> </span></div><div style="line-height: 150.0%;background: white;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;color: black;">AmeriSave is an equal opportunity employer. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.<br><br></span><span style="font-size: 10.5pt;line-height: 150.0%;font-family: Calibri , sans-serif;color: black;"> </span><span style="font-size: 10.5pt;line-height: 150.0%;font-family: Calibri , sans-serif;color: rgb(51,51,51);"> </span></div><div style="line-height: 150.0%;background: white;"><b><u><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;color: black;">California Consumer Privacy Act Disclosure Acknowledgment</span></u></b><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;color: black;">  </span><span style="font-size: 10.5pt;line-height: 150.0%;font-family: Calibri , sans-serif;color: black;"> </span><span style="font-size: 10.5pt;line-height: 150.0%;font-family: Calibri , sans-serif;color: rgb(51,51,51);"> </span></div><div style="line-height: 150.0%;background: white;"><i><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;color: black;">Employment Applicants, New Hires, and Employees Residing in California</span></i><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;color: black;">  </span><span style="font-size: 10.5pt;line-height: 150.0%;font-family: Calibri , sans-serif;color: black;"> </span><span style="font-size: 10.5pt;line-height: 150.0%;font-family: Calibri , sans-serif;color: rgb(51,51,51);"> </span></div><div style="line-height: 150.0%;background: white;"><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;color: black;">   </span><span style="font-size: 10.5pt;line-height: 150.0%;font-family: Calibri , sans-serif;color: black;"> </span><span style="font-size: 10.5pt;line-height: 150.0%;font-family: Calibri , sans-serif;color: rgb(51,51,51);"> </span></div><div style="line-height: 150.0%;background: white;"><b><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;color: black;">AmeriSave Mortgage Corporation’s Privacy Policy Statement (“Policy”) can be reviewed here: </span></b><span style="font-size: 10.5pt;line-height: 150.0%;font-family: Calibri , sans-serif;color: black;"><a href="https://protect.checkpoint.com/v2/___http:/www.amerisave.com/privacy-policy___.YzJ1OmFtZXJpc2F2ZTpjOm86OWY4M2JiZDM0NzViNmQyM2QxZjQyMmRjZDQyNDcxNmE6NjpiNmI4Ojk0NTZlNjUzMzhiNTllM2E3NDcyMTE1MDI5ODNkNmNhM2FjMTA2YzE0NTdkZTg1YTVlYjA2OGIzN2M2MjVkMzY6aDpU"><b><span style="font-size: 11.0pt;line-height: 150.0%;color: black;">www.amerisave.com/privacy-policy</span></b></a></span><span style="font-size: 11.0pt;line-height: 150.0%;font-family: Calibri , sans-serif;color: black;">  </span><span style="font-size: 10.5pt;line-height: 150.0%;font-family: Calibri , sans-serif;color: black;"> </span><span style="font-size: 10.5pt;line-height: 150.0%;font-family: Calibri , sans-serif;color: rgb(51,51,51);"> </span></div>