Data Engineer

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 Engineer is a key technical position and plays an important role in the organization by performing several activities related to the company’s Information Technology functions. The role is primarily responsible, under limited supervision, for executing the data strategy and analysis efforts within the company’s enterprise data platform by expanding and optimizing data and data pipeline architecture, as well as optimizing data flow and collection from cross functional areas. Responsibilities include supporting software developer, database architects, data analysts and data scientists on various data initiatives as well as ensuring optimal data delivery architecture is maintained as needs grow.

Compensation 

This role is an exempt position with a Targeted Salary Range of $92,000 - $132,000 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 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.