Capital Markets Data Analyst

This position is posted by Jobgether on behalf of a partner company. We are currently looking for a Capital Markets Data Analyst in the United States. This is a highly analytical, data-driven role embedded within a capital markets environment, focused on ensuring the accuracy, integrity, and usability of mission-critical datasets that support financial decision-making. You will work closely with capital markets stakeholders to analyze, validate, and enhance complex data models powering key reporting such as Daily P&L, Gain on Sale reconciliation, and investor exposure analytics. The role requires strong SQL expertise and the ability to independently investigate and improve existing data structures while identifying gaps or inconsistencies in logic. You will also maintain and optimize ETL pipelines and reporting systems across modern Microsoft data platforms. A key aspect of this role is translating business questions into reliable, scalable data solutions that directly inform trading and risk decisions. This position combines technical depth, financial domain exposure, and strong analytical judgment in a collaborative but autonomous environment. \n Accountabilities: Develop, optimize, and maintain complex SQL queries, stored procedures, and data models to ensure accuracy and performance of capital markets datasets. Investigate and resolve data discrepancies, reconciliation issues, and reporting variances by tracing root causes across data pipelines. Maintain and monitor ETL processes and data workflows in Microsoft Fabric and Azure Data Factory to ensure reliability and data freshness. Build and enhance Power BI dashboards and semantic models supporting P&L reporting, investor exposure, and capital markets performance metrics. Partner directly with capital markets stakeholders to translate business questions into robust, reusable, and scalable data solutions. Support investor data integration efforts, ensuring accurate mapping and maintenance of key trading and program data elements. Participate in process improvement and automation initiatives to reduce manual effort and improve data quality and efficiency. Requirements: 5+ years of experience in business intelligence, data analytics, or a similar data-focused role. Advanced SQL expertise with proven ability to analyze, debug, and improve complex existing data structures independently. Strong analytical mindset with a critical approach to data validation, reconciliation, and root cause analysis. Experience working with ETL processes and maintaining data pipelines in production environments. Hands-on Power BI experience, including dashboard development and semantic data model design. Ability to work independently while managing priorities and collaborating with technical and business stakeholders. Experience with Microsoft Fabric (Lakehouse, Warehouse, Notebooks) and Azure SQL is highly desirable. Exposure to mortgage banking or capital markets concepts such as Gain on Sale, hedging, or investor reporting is a strong plus. Benefits: Competitive annual salary ranging from $95,000 to $135,000. Comprehensive health benefits including medical, dental, vision, life, and disability insurance. 401(k) retirement savings plan. Paid time off and 12 paid holidays annually. Employee discounts, referral bonuses, and supplemental compensation opportunities. Paid training and ongoing professional development support. Fully remote work environment with high-speed internet requirements. Inclusive workplace with equal opportunity employment practices and strong commitment to employee wellbeing. \n How Jobgether works: We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team. We appreciate your interest and wish you the best! Why Apply Through Jobgether? Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time.

#LI-CL1