• Desenvolver dashboards e soluções analíticas em Power BI • Estruturar modelos de dados eficientes e escaláveis • Criar métricas e indicadores utilizando DAX • Realizar tratamento e transformação de dados com Power Query • Trabalhar com consultas e organização de dados em SQL e Snowflake • Apoiar análises e automações utilizando Python • Interagir com áreas de negócio para entendimento e refinamento das demandas • Garantir qualidade, performance e clareza das entregas analíticas

• Serve as a member of the project team with primary responsibility for coordinating the clinical data review, query generation / resolution and reconciliation activities to support the Data Management lead with the delivery of clinical data according to client quality and integrity specifications, project timelines and productivity targets. • Assist in the development of the project Data Management Plan, including data review guidelines /diagnostics specification and setup of the data management systems according to project requirements. • Serve as back-up to Clinical Data Manager, with oversight of data management activities for the delivery of clinical data according to client quality and integrity specifications, project timelines and budgets. • Ensure that all allocated projects are carried out in strict accordance with the relevant protocols, global harmonized SOPs, and the specified standards of GCPs. • Perform all data management tasks as appropriate to include, but not to be limited to data review and query management to ensure that quality standards (both internal and client) are achieved within stipulated timelines. • Assist with reviewing clinical trial data in accordance with Data Management Plans, Edit Check Specifications and/or Data Review Guidelines and raise queries to resolve erroneous, missing, incomplete data. • Generate, resolve and track queries to address problematic data identified during aggregate data review activities. • Run and execute additional programs, special listings, reconciliation discrepancy listings etc.) used to support the review of clinical trial data. • Interact with other project team members to support the set-up, maintenance, and closure of the Data Management aspects of the project and attend meetings as required. • Assist with review of data listings for internal data review. • Assist or create dummy data to test edit checks and to test database screen design and functionality. • Assist or create dummy data to test SAS reports and data listing. • Modify standard templates to create study specific Data Management Plans, or eCRF completion guidelines. • Support team members by creating forms/memos as required. • Posting of Data Management documentation and data management related administrative tasks as requested, including maintenance of eTMF as required. • Generate study status reports. • Perform database extracts. • Assist with the completion of Database Lock activities. • Support the training of new staff on project specific Data Management processes.

• Design and deliver tailored data insights that translate clinical and quality information into clear, actionable recommendations for customers • Build and apply statistical and predictive models to identify patterns, trends, and opportunities for performance improvement • Apply clinical data expertise to evaluate quality outcomes and measure the impact of improvement initiatives • Contribute analytical input to cross-functional initiatives supporting service and process improvement • Support the design, development, and testing of business intelligence reporting and analytics solutions • Engage in collaborative working groups to define data processing and visualisation requirements with internal teams and external partners • Partner with commercial and technical teams, including Sales, Marketing, Research and Development, Implementation, and Support, to support evidence generation, lifecycle data collection, and ROI analysis • Identify opportunities to enhance customer value through data-led insights that support retention and growth

Role Description The Senior Mortgage Risk Data Analyst is responsible for independently gathering, validating, analyzing, interpreting, and presenting operational, regulatory, and risk-related data used for senior management reporting, investor reporting, state reporting, and regulatory submissions. This role serves as a subject matter expert for mortgage-related risk data, Mortgage Call Report preparation, and state reporting requirements across all 50 states. The Senior Risk Data Analyst is expected to identify data trends, reporting gaps, operational risks, and process weaknesses, while providing recommendations to strengthen reporting accuracy, operational controls, and compliance outcomes. The Senior Risk Data Analyst will work cross-functionally with Business Partners and senior leadership. - Independently prepare, validate, and analyze risk, operational, and regulatory reporting data for senior management, investors, regulators, and internal business partners. - Serve as a subject matter expert for Mortgage Call Report preparation, validation, and submission, including required knowledge of MCR reporting requirements and the ability to identify, research, and resolve reporting discrepancies. - Prepare, review, and validate RMLA data for Mortgage Call Report submissions across all applicable business lines on a quarterly basis. - Maintain required knowledge of state reporting requirements across all 50 states and support accurate, timely preparation and submission of applicable state reports. - Analyze mortgage loan data to identify trends, operational gaps, reporting inconsistencies, and areas of potential compliance or risk exposure. - Apply current federal and state laws and regulatory requirements governing mortgage lending, including but not limited to TILA, RESPA, TRID, ECOA, GLBA, QM/ATR, and applicable state reporting requirements. - Apply knowledge of investor and governmental agency guidelines, including FNMA, FHLMC, FHA, VA, and RHS, to categorize, analyze, and report operational deficiencies. - Perform detailed data scrubbing, reconciliation, and validation across multiple systems and departments to ensure accuracy and completeness of reporting outputs. - Coordinate with stakeholders across Risk, Compliance, Operations, Servicing, Finance, Audit, Information Technology, and other business areas to gather data, confirm reporting assumptions, and resolve data discrepancies. - Develop and maintain reporting controls, tracking tools, validation checks, and supporting documentation for regulatory and management reporting. - Utilize prescriptive analytics to identify operational weaknesses and recommend process improvements, reporting enhancements, and risk mitigation strategies. - Prepare clear, concise summaries of reporting findings, data trends, and risk observations for leadership review. - Support internal and external audits by providing reporting documentation, data support, research, and explanations related to risk and regulatory reporting. - Identify opportunities to improve reporting processes, reduce manual work, increase data accuracy, and strengthen reporting controls. - Provide guidance and support to less experienced analysts or business partners regarding reporting requirements, data validation, and risk reporting processes. - Manage competing deadlines and shifting priorities, particularly during quarterly reporting cycles, regulatory deadlines, audits, and high-volume reporting periods. - Maintain strict confidentiality of company, employee, borrower, investor, and regulatory information. - Complete other duties and/or projects as assigned. Qualifications - Minimum 7 to 10 years of mortgage industry experience, including experience in origination, servicing, compliance, risk, quality control, regulatory reporting, or related mortgage operations. - Minimum 3 years of experience in a risk, compliance, regulatory reporting, data analytics, audit, or mortgage reporting capacity. - Required experience preparing, reviewing, validating, or supporting Mortgage Call Report reporting. - Required knowledge of MCR reporting requirements and how Mortgage Call Reports are prepared, reviewed, validated, and submitted. - Required knowledge of state regulatory reporting requirements across all 50 states. - Strong understanding of mortgage loan data, mortgage operations, and standard industry processes within a mortgage banking environment. - Strong working knowledge of federal mortgage regulations, including TILA, RESPA, TRID, ECOA, GLBA, QM/ATR, and related compliance requirements. - Strong knowledge of investor and agency guidelines, including FNMA, FHLMC, FHA, VA, and RHS. - Advanced Microsoft Excel experience, including formulas, pivot tables, data validation, reconciliations, and large data set analysis. - Demonstrated ability to analyze complex data, identify discrepancies, research root causes, and communicate findings clearly. - Ability to independently manage reporting deadlines, prioritize competing work, and escalate risks or concerns timely. - High degree of accuracy, attention to detail, and accountability when working with regulatory and executive-level reporting. - Ability to work remotely in a paperless environment while adhering to strict privacy, confidentiality, and data security requirements. Preferred Qualifications - Bachelor’s degree in Business, Finance, Accounting, Data Analytics, Risk Management, Compliance, or a related field preferred. - Prior underwriting, quality control, forensic review, compliance, audit, or regulatory examination experience preferred. - Experience with mortgage-specific loan origination systems, including DataTrac, BytePro, FNMA Loan Quality Connect, or similar systems preferred. - Experience with SharePoint, SQL, XML, Power BI, Tableau, or other data/reporting tools preferred. - Experience preparing reports for senior leadership, regulators, investors, internal audit, or external audit preferred. - Experience developing reporting controls, process documentation, validation tools, or audit support materials preferred. Physical and Environmental Conditions This role operates in an ADA compliant office environment, utilizing typical office equipment and tasks including computer work. The position may involve partial stationary positions and moving throughout the day. Flexibility to work overtime to meet project deadlines is required. Base Compensation Information This is a remote role that can be performed from within the United States. CMG pays a competitive salary which ranges from $90,000 to $110,000. Factors that affect base salary may include: Specific Mortgage Risk experience, overall knowledge of mortgage risk and compliance, number of years worked in mortgage industry, types of roles performed, computer skills, customer service experience specific to working with mortgage lenders, and education.