Data Analyst

Guild Mortgage; United States; On-site; USD 83,000 - 118,000; Full time

Job summary

Guild Mortgage Company is seeking a Data Analyst to support IT and Data & Analytics functions, documenting data requirements and KPIs while ensuring data quality and governance.

The role partners with stakeholders to deliver actionable insights and maintain data documentation, including the Logical Data Dictionary, across cross-functional teams.

Qualifications

• BS in Statistics, Computer Science, Data Science, Information Systems, Mathematics, or a related quantitative field.
• Experience with data analysis and reporting in IT/Data & Analytics preferred.

Responsibilities

• Collaborate with business stakeholders to gather, document, and clarify data and reporting requirements.
• Research internal systems of record and external data sources to support analytical and reporting needs; assist in evaluating data availability and quality.
• Support onboarding of new data sources, including third-party and private datasets, to enhance business insights.
• Assist in identifying data transformation and integration requirements for loading data into the enterprise data warehouse.
• Perform data validation and quality checks to ensure accuracy, consistency, and reliability of dashboards, reports, and analytical outputs prior to delivery.
• Maintain and update data documentation, including the Logical Data Dictionary (LDD), with field definitions, data lineage, and source system details.

Education

BS in Statistics, Computer Science, Data Science, Information Systems, Mathematics, or a related quantitative field

Job description

Guild Mortgage Company, closing loans and opening doors since 1960. As a mortgage banking firm we are dedicated to serving the home owner/buyer. Our goal is to provide affordable home financing for our customers, utilizing the best terms available while providing a level of professionalism and service unsurpassed in the lending industry.

Position Summary

The Data Analyst plays an important role in the organization by supporting activities related to the company's Information Technology and Data & Analytics functions. This role is primarily responsible, under general supervision, for executing data analysis and reporting activities within the company's enterprise data platform. The Data Analyst partners with business stakeholders to gather and document data requirements, support the definition and tracking of Key Performance Indicators (KPIs), and perform data validation to ensure accuracy and consistency of reporting outputs. The position contributes to the delivery of actionable insights by analyzing data, researching internal and external data sources, and supporting data quality and governance initiatives. Responsibilities include assisting stakeholders with reporting needs, maintaining data documentation such as the Logical Data Dictionary (LDD), and collaborating with cross-functional teams to ensure reliable, high-quality data is available for business decision-making.

This role is an exempt position with a targeted salary range of $82,506.00 to $118,355.94 annually.

Compensation at Guild is influenced by a wide array of factors including but not limited to local and federal minimum wage requirements, education, level of experience, and applicant's geographical location.

Essential Functions

• Collaborate with business stakeholders, Product, and Data & Technology teams to gather, document, and clarify data and reporting requirements.
• Research internal systems of record and external data sources to support analytical and reporting needs; assist in evaluating data availability and quality.
• Support onboarding of new data sources, including third-party and private datasets, to enhance business insights.
• Assist in identifying data transformation and integration requirements for loading data into the enterprise data warehouse.
• Perform data validation and quality checks to ensure accuracy, consistency, and reliability of dashboards, reports, and analytical outputs prior to delivery.
• Maintain and update data documentation, including the Logical Data Dictionary (LDD), with field definitions, data lineage, and source system details.
• Document functional and non-functional requirements related to data collection, transformation, processing, and visualization.
• Generate reports and deliver insights on customer behavior, operational performance, and key business metrics using standard analytics tools.
• Support KPI definition, tracking, and monitoring to ensure alignment with business objectives and data accuracy.
• Identify data trends, anomalies, and data quality issues; elevate findings and assist in root cause analysis and resolution.
• Assist in improving data quality through data curation activities, validation rules, and support of master data management processes.
• Identify opportunities to automate manual reporting processes and improve efficiency in data delivery workflows.
• Support identification and documentation of Personally Identifiable Information (PII) and adhere to established data governance and access control policies.
• Contribute to documentation of data availability, recovery requirements, and business continuity practices.
• Participate in team meetings, stakeholder reviews, and solution design sessions; collaborate effectively across teams.
• Prepare and deliver data, reports, and analysis to management and business partners as requested.
• Follow established data governance standards, policies, and best practices.
• Perform other duties as assigned.

Qualifications

• BS in Statistics, Computer Science, Data Science, Information Systems, Mathematics, or a related quantitative field required.