Guild Mortgage · 1 hour ago
Data Engineer
United States
Full-time
Remote
Mid, Senior Level
$92K/yr - $132K/yr
3+ years expGuild Mortgage Company is a mortgage banking firm dedicated to serving homeowners and buyers. The Data Engineer plays a crucial role in executing the company's data strategy, optimizing data architecture, and supporting various data initiatives across the organization.
Consumer LendingLendingMortgageReal Estate
Responsibilities
Collaborate with key stakeholders, including the business unit leaders, Product, Data & Technology teams, to assist with their data-related technical issues and support their data infrastructure needs by collecting data from primary sources and optimizing the data architecture, improving quality of sourced data, and ensuring consistent delivery of data to key stakeholders in a timely manner
Extract, Load & Transform (ELT) data from various primary data sources (internal & 3rd party) into the data lake to create optimal data pipeline architecture utilizing Snowflake and Informatica tool suites
Assemble large, complex data sets that meet functional / non-functional business requirements
Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc
Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and leading ELT tools. This will include set up and configure Informatica Intelligent Cloud Services Environment and Tools
Design and Implement Processes to govern usage of the tools and platform at enterprise level for performance, security and audit compliance
Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics
Keep our Personally Identifiable Information (PII) data separated and secured through table splitting, data masking, access control restrictions and redundancy (high availability across multiple zones)
Create data tools for data scientist and analytics team members that assist them in building and optimizing data analysis and reporting
Improve the quality of data used for analysis by assessing the accuracy of new data sources and the effectiveness of new data gathering techniques
Develop processes and tools to monitor and analyze data warehouse performance and data accuracy
Contribute to the team of data professionals by using expertise to answer questions and sharing repeatable design patterns with less experienced teammates, enhancing skillsets and competencies of team members, and sharing technical knowledge throughout the team
Participate in stakeholder reviews, and design sessions
Provide data, reports, and information to management as needed
Identify, track, and monitor trends and avoidable technology-related errors; work across functions to develop complex solutions, improvements, and stop-gaps
Focus on the continual improvement of policies, procedures, and processes falling under scope of authority
Stay abreast of latest technology trends and participate in high-level decisions impacting the direction of Information Technology function
Consistently monitor and model platform usage, database sizes, compute resources and third-party costs to ensure that the data teams spend is as cost-efficient as possible
Champion data transformation to new ways of working and generating insights
Drive strong communications, partnerships, and stakeholder management with senior leaders, functional managers, and staff
Perform other duties as assigned
Qualification
Required
Bachelors Degree directly related to the position or equivalent, required. BS in Statistics, Computer Science, Data Science, or related quantitative field is required
Minimum three years' experience to five years' experience in Data Engineer related role(s)
Proficient in building and optimizing Big Data pipelines, architecture, and data sets
Proficient with data loading, processing, and data warehouse design techniques: star or snowflake schema designs, etc
Well versed in Informatica Intelligent Cloud Services, Administration, Environment configuration and set up of various tool suite (Mass Ingestion, CDC, Data Catalog, Data Quality, Data Integration, API Management)
Proven expertise in developing in Informatica Intelligent Cloud Services and various tools
Proven experience with data lake and warehouse best practices and leading products in the marketplace
Expert at creating data integrations using Extract, Transform and Load (ETL) tools and modern data pipes
Strong knowledge of Kafka, Sparks, ESB and/or other messaging queues, real-time data integration & stream processing technologies
Proven experience with querying and analyzing data from SQL relational databases such as AuroraDB, IBM DB2, MemSQL, MS SQL Server, MySQL, Postgres, Redshift or Snowflake, and NoSQL Databases such as Cassandra, DynamoDB, Redis, or MongoDB
Experience with data science languages such as R, and Python as well as general purpose languages such as Java, Scala, C# or JavaScript
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
Experience with data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc
Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
Strong analytical skills to build 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
Problem solver with an ability to work as a team towards a solution
Ability to prioritize multiple tasks in a deadline-driven environment, strong sense of urgency and responsiveness
Strong detail orientation and highly organized with proven ability to lead effectively and drive results in a matrixed management environment
Ability to think critically, including the ability to evaluate facts and data to draw conclusions, determine the downstream impact of decisions and associated risks
Excellent verbal and written communication skills plus demonstrate strong leadership capabilities
Strong interpersonal and team building skills
Self-starter with the demonstrated ability to learn/adapt to new technologies and techniques
Highly organized and detail-oriented; ability to work in a fast-paced, metrics-driven environment required
Proficiency in Microsoft Office Suite, Word, Excel, Wiki, collaborative cloud-based programs, and third-party software applications required
Commitment to company values
Customer Service - Proactive attention to each person
Integrity - Do and say what's right
Respect - Treat others with dignity
Collaboration - Listen and work together
Learning - Seek knowledge and strive for improvement
Excellence – Deliver the unexpected
Benefits
Medical
Dental
Vision
Life insurance
AD&D
LTD
401(k) with employer match
Company
Guild Mortgage
Guild Mortgage is a growing mortgage company that offers residential mortgage products as well as local in-house origination and servicing.
1001-5000 employees
Funding
Current Stage
Public CompanyTotal Funding
unknown2025-06-18Acquired
2020-10-21IPO
Leadership Team
M
Michael Lau
President & CEO
Adam O'Daniel
Senior Vice President and Chief Marketing Officer
Recent News
HousingWire.com
2026-01-06
2025-12-17
Company data provided by crunchbase