Senior Data Analyst

🕒 May 1

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Guild Mortgage

WebsiteLinkedInAll Job Openings

1001 - 5000 employees

Founded 1960

💸 Finance

🏠 Real Estate

Finance • Real Estate

Guild Mortgage is a U. S. -based mortgage lender and loan servicer that provides a wide range of home financing products and services to consumers and business partners. The company offers purchase and refinance mortgages, including conventional, FHA, VA, USDA, jumbo, renovation, construction, reverse mortgages, HELOCs, and specialty programs and down-payment assistance. Guild Mortgage operates nationwide through local branches and loan officers, supports borrowers with servicing and online account management, and partners with builders, real estate agents, title agents, and correspondents.

📋 Description

• Partner with key stakeholders to assess their data and analytics needs by eliciting data requirements, and researching internal systems of record and publicly available data sources and assessing their quality of data • Requisition and obtain private data sources to support business needs for data and insights • Identify translation or transformation requirements for sourced data into the data warehouse • Improve quality of sourced data by data curation and validation rules as well as maintaining the Master Data tables • Maintain the Logical Data Dictionary (LDD) with data lineage information • Ensure consistent delivery of high-quality insights to key stakeholders by reconciling and validating dashboards and reports in a timely manner • Document functional / non-functional business requirements for collecting, loading, transforming, curating, processing data and for visualization and distribution of insights • Identify internal process improvements for automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability • Provide actionable insights using analytics tools into customer acquisition, operational efficiency and other key business performance metrics

🎯 Requirements

• Bachelor's Degree in Computer Science, Data Science or related quantitative field • Master’s Degree in business administration (MBA) or related to the position or equivalent, preferred • Minimum 5 years' experience in Data Analyst related role(s) and two of those years spent in a senior technical level role(s) required • Highly proficient with eliciting business requirements, documenting user stories, analyzing data sources, and assessing data quality • Highly proficient in data analysis, technical documentation, logical data dictionary, data validation rules, acceptance criteria, software development lifecycle (SDLC) such as Scrum and IT Service Management (ITSM) – ITILv4 • Experience in identifying data integrations needs using Extract, Transform and Load (ETL) tools and modern data pipes • Proven experience with querying and analyzing data from SQL relational databases such as AuroraDB, IBM DB2, MemSQL, MS SQL Server, MySQL, Postgres, Snowflake, and NoSQL Databases such as Cassandra, DynamoDB, Redis, MongoDB • Experience collecting structured, semi-structured and unstructured data in various popular formats and sourced from internal core systems as well as 3rd partner providers such as Google Analytics, Facebook Insights, Zillow, CoreLogic, MLS Data, Public Records, and Property Data • Strong analytical skills to document processes supporting data transformation, data structures, metadata, dependency and workload management • Strong data governance skills to ensure highest quality of data is made available for data analysis and accuracy in reporting

🏖️ Benefits

• medical • dental • vision • life insurance • AD&D • LTD • 401(k) with employer match