loanDepot

Sr Data Engineer - SQL/ADF/SSIS

Job description

We are at the forefront of change in this rapidly evolving lending market. mello™, the Greek word for “future,” was the product of a recent $80+ million dollar investment in research & development to transform & streamline the home buying process into a digital experience like no other competitor offers. But mello™ is just the beginning… loanDepot will continue to invest in developing our own advanced technology ecosystem built around serving our customers & enabling our valued employees to provide exceptional service. We have funding, we have opportunities, you have ideas—it’s a perfect match. Come join us!

loanDepot — We are America’s Lender.

Position Summary:

Responsible for delivering leading innovative, compelling, coherent software solutions for our consumer, internal operations, and value chain constituents across a wide variety of enterprise applications through the creation of discrete business services and their supporting components. The job duties and requirements are defined for backend. Provides technical leadership and mentorship to junior team members. This position ensures the performance of all duties in accordance with the company’s policies and procedures, all U.S. state and federal laws and regulations, wherein the company operates.

Responsibilities:

  • Designs, develops, and delivers solutions that meet business line and enterprise requirements.
  • Creates enterprise-grade application services.
  • Participates in rapid prototyping and POC development efforts.
  • Advances overall enterprise technical architecture and implementation best practices.
  • Assists in efforts to develop and refine functional and non-functional requirements.
  • Participates in iteration and release planning.
  • Performs functional and non-functional testing.
  • Contributes to overall enterprise technical architecture and implementation best practices.
  • Informs efforts to develop and refine functional and non-functional requirements.
  • Performs other duties and projects as assigned.

Requirements:

  • Bachelor’s Degree is required, and/or a minimum of four (4) + related work experience.
  • 5+ years of experience designing enterprise database systems using Microsoft SQL Server
  • 5+ years of experience working with ETL tools such as SSIS and Azure Data Factory
  • 5+ years of experience with advanced queries, stored procedures, views, triggers, etc.
  • 5+ years of experience with indexing and normalization.
  • 5+ years of experience of performance tuning queries.
  • 5+ years of experience of both DDL and DML.
  • 5+ years of experience of database administration
  • Experience with Cloud technologies – Azure, AWS, Snowflake is a plus
  • Experience with Replication and Streaming is a plus
  • Understanding of data mart and data warehousing concepts including variant schemas (Star, Snowflake).
  • Working understanding of Web API, REST, JSON.

Why work for #teamloanDepot:

  • Aggressive earning potential and 401K with robust company match
  • Inclusive, diverse and collaborative culture where people from all backgrounds can thrive
  • Work with other passionate, purposeful and customer-centric people
  • Extensive internal growth and professional development opportunities including tuition reimbursement
  • Comprehensive benefits package including Medical/Dental/Vision
  • Wellness program to support both mental and physical health
  • Generous paid time off for both exempt and non-exempt positions

We are an equal opportunity employer and value diversity in our company. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.