Talent.com
Data Engineer
Data EngineerGuild Mortgage • United States, United States, United States
Data Engineer

Data Engineer

Guild Mortgage • United States, United States, United States
7 days ago
Job type
  • Full-time
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 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.

Qualifications

  • 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
  • Supervision

  • Job Scope : Responsible for understanding the department / functional area objectives and goals and how own job contributes to achievement of these goals; may recommend changes and enhancements based on analysis and evaluation of circumstances.
  • Complexity : General precedents may exist for most problems; conducts independent research / analysis to identify the appropriate approach.
  • Impact : Decisions and actions primarily impact own work with limited impact on peers in their area, contributes as team member rather than leader.
  • Interaction / Supervision : Acts as a mentor / guide to less experienced professional contributor staff in a similar role; works independently and only under general direction; guided by professional standards, desired outcomes, and project plan specifications.
  • Requirements

    Physical : Work is primarily sedentary; mobility in an office setting.

    Manual Dexterity : Frequent use of computer keyboard and mouse.

    Audio / Visual : Ability to accurately interpret sounds and associated meanings at a volume consistent with interpersonal conversation. Regularly required to accurately perceive, distinguish and interpret information received visually and through audio, e.g., words, numbers and other data broadcasted aloud / viewed on a screen, as well as print and other media.

    Environmental :   Office environment – moderate noise, no substantial exposure to adverse environmental conditions.

    Mental : Learn new tasks, remember processes, maintain focus, complete tasks independently, and make timely decisions in the context of a workflow. This role requires effective adaptation to workplace stressors, including customer service complaints, security responsibilities, and competing priorities. Must be able to adhere to process protocol. Must be able to apply established protocols in a timely manner.

    Schedules : Work is primarily performed during the business week, Monday - Friday.

    Travel : 5% or less

    Guild offers a pleasant work environment, competitive compensation and excellent benefits package; including medical, dental, vision, life insurance, AD&D, LTD and 401(k) with employer match.

    Guild Mortgage Company is an Equal Opportunity Employer.

    REQ# : DATAE017824

    Create a job alert for this search

    Data Engineer • United States, United States, United States

    Similar jobs
    Data Analytics Engineer

    Data Analytics Engineer

    Grasshopper Bank • United States
    Remote
    Full-time
    We are a highly experienced team who pride ourselves on.Nationally chartered, our portfolio of products and services range from VC, PE & Portfolio Companies to SBA Lending, as well as direct SMB an...Show more
    Last updated: 11 days ago • Promoted
    Remote Cloud Data Engineer (AZURE)

    Remote Cloud Data Engineer (AZURE)

    ClearanceJobs • United States
    Remote
    Full-time
    Advantech GS Enterprises is seeking a Data Cloud Engineer with expertise in cloud-based data architecture, security compliance, and analytics to support the DISA NEXUS program at Fort Meade.The ide...Show more
    Last updated: 2 days ago • Promoted
    Data Analytics & Engineering - Data Engineer IV

    Data Analytics & Engineering - Data Engineer IV

    Mindlance • United States
    Remote
    Full-time
    Join the SBG-Marketing Science Team at Meta, where you'll help build robust data foundations to optimize advertising performance. The team is focused on transforming validated solutions into actiona...Show more
    Last updated: 17 hours ago • Promoted • New!
    Staff Data Engineer P-133

    Staff Data Engineer P-133

    Smash CR • US
    Full-time
    Quick Apply
    We believe in long-lasting relationships with our talent.We invest time getting to know them and understanding what they seek as their professional next step. We aim to find the perfect match.As age...Show more
    Last updated: 21 days ago
    MS Fabric Data Engineer / Architect- US Citizens only.

    MS Fabric Data Engineer / Architect- US Citizens only.

    Bright Mind Solutions LLC • United States
    Full-time +2
    Quick Apply
    Need US Citizen only Must be from Florida or Texas only Senior Data Engineer / Arc...Show more
    Last updated: 4 days ago
    Data Engineer

    Data Engineer

    VirtualVocations • Guaynabo, Puerto Rico, United States
    Full-time
    A company is looking for a Data Engineer.Key Responsibilities Design and implement scalable data pipelines and data models Utilize various data engineering tools and technologies to optimize dat...Show more
    Last updated: 6 hours ago • Promoted • New!
    Azure Data Engineer -Remote

    Azure Data Engineer -Remote

    Staffing the Universe • United States
    Remote
    Full-time
    Over 10 years of IT experience.Dataops & Ci / cd practices to enable automated building, testing, and deployment of data products and applications.Show more
    Last updated: 11 days ago • Promoted
    Senior Data Engineer (GCP)

    Senior Data Engineer (GCP)

    Sumeru Solutions • United States
    Full-time
    Quick Apply
    Experience : 8+ years overall in Data Engineering / Data Analytics Mandatory GCP Experience : Minimum 4+ years Show more
    Last updated: 1 day ago
    VDH Cloud Data Engineer

    VDH Cloud Data Engineer

    RICEFW Technologies Inc • United States
    Full-time
    Quick Apply
    We are seeking a skilled Cloud Data Engineer to join our development team and help build modern, cloud native applications across leading cloud platforms, with a particular emphasis on Microsoft ...Show more
    Last updated: 5 days ago
    Data Integration Engineer

    Data Integration Engineer

    Two95 International Inc. • US
    Remote
    Full-time
    Quick Apply
    Develop, test, document and maintain scalable data pipelines.Build out new data integrations including APIs to support continuing increases in data volume and complexity. Establish and follow data g...Show more
    Last updated: 30+ days ago
    Snowflake Data Engineer

    Snowflake Data Engineer

    Blue Acorn iCi • US
    Full-time
    Quick Apply
    We are seeking a Snowflake Data Engineer to join our consulting team.In this role, you will design, implement, and optimize scalable data ingestion pipelines that deliver high-quality sales, custom...Show more
    Last updated: 30+ days ago
    Data Engineer - Azure (Scala / Kafka)

    Data Engineer - Azure (Scala / Kafka)

    Tiger Analytics Inc. • US
    Remote
    Full-time
    Quick Apply
    Tiger Analytics is pioneering what AI and analytics can do to solve some of the toughest problems faced by organizations globally. We develop bespoke solutions powered by data and technology for sev...Show more
    Last updated: 30+ days ago
    Sales Engineer-Data

    Sales Engineer-Data

    Altimate AI • United States
    Remote
    Full-time
    Altimate AI is at the forefront of the AI-driven data revolution, tackling one of the biggest pain points in modern enterprise analytics-an overwhelming volume of data and a shortage of skilled dat...Show more
    Last updated: 10 days ago • Promoted
    Lead Snowflake Data Engineer with DBT

    Lead Snowflake Data Engineer with DBT

    Perficient • United States
    Full-time
    We currently have a career opportunity for a.The Lead Data Engineer will be responsible for designing, developing, and maintaining data pipelines and solutions to enable our client to harness the p...Show more
    Last updated: 2 days ago • Promoted
    Data Architect / Principal Data Engineer

    Data Architect / Principal Data Engineer

    VSG Business Solutions LLC • United States
    Full-time
    Quick Apply
    Role Overview We are seeking a senior-level Data Architect / Principal Data Engineer with deep expertise in SSIS and ETL modernization. This role requires strong leaders...Show more
    Last updated: 1 day ago
    Data Engineer

    Data Engineer

    Signify Technology • United States
    Full-time
    A data-driven healthcare organization modernizing our analytics platform to power value-based care.Our team is transitioning from SQL Server to Snowflake as our cloud data warehouse and implementin...Show more
    Last updated: 2 days ago • Promoted
    Data Engineer / Palantir Foundary

    Data Engineer / Palantir Foundary

    Lorven technologies • United States
    Full-time
    Quick Apply
    Hi, Our client is looking for a Data Engineer with a Long-Term Contract project in Remote below is ...Show more
    Last updated: 1 day ago
    Data Engineer

    Data Engineer

    Programmers.io • United States
    Full-time
    Quick Apply
    Data Engineer (Mid Senior Level) Remote Apache Airflow (Workflow Orchestration) Show more
    Last updated: 1 day ago