<h3>Description</h3> <div> Position at loanDepot </div> Position Summary:The Senior Data Engineer will be responsible for delivering senior level innovative and compelling software solutions for our consumer, internal operations, and value chain constituents across a wide variety of enterprise applications. The job duties and requirements are defined for backend. Provides technical leadership and mentorship to junior team members.Responsibilities:<ul><li>Designs, develops, and delivers solutions that meet business line and enterprise requirements.</li><li>Creates data and reporting infrastructure by building and optimizing production-grade data pipelines using continuous integration/ continuous deployment.</li><li>Participates in rapid prototyping and POC development efforts.</li><li>Understand business and technical requirements and constraints to design effective data engineering solutions.</li><li>Assists in efforts to develop and refine functional and non-functional requirements.</li><li>Champion engineering excellence, including software design patterns, code reviews and automated unit/functional testing.</li><li>Create conceptual architectures and detailed designs for data engineering solutions.</li><li>Contributes to overall enterprise technical architecture and implementation best practices.</li><li>Participates in iteration and release planning.</li><li>Performs other duties and projects as assigned.</li></ul>Requirements:<ul><li>Bachelor’s Degree required, and a minimum of four (5)+ related work experience.</li><li>Required Technical Skills:<ul><li>Design and implementation of data lake, data warehouse and data mart.</li><li>Web API, REST, GraphQL, XML/JSON.</li><li>ETL/ELT, and one of data engineering languages (Python/Java/Scala).</li><li>ADF, ADLS, Airflow, DBT and any of cloud-native data warehouse (Snowflake, Databricks, BigQuery).</li><li>Strong SQL experience, with expert-level skills in query performance tuning and data modeling.</li><li>Designs enterprise database systems using Microsoft SQL Server.</li><li>Has working knowledge of GIT. Develops branching and merging strategies.</li></ul></li><li>Ability to design, develop, and maintain scalable, reusable code.</li><li>Estimates tasks with a level of granularity and accuracy commensurate with information provided to ensure expectations of delivery are reasonable.</li><li>Excels in a rapid iteration environment with short turnaround times.</li><li>Knowledge of cubes and SSAS is a plus.</li><li>Knowledge of SSRS, Power BI, and Tableau a plus.</li></ul> Why work for #teamloanDepot:<ul><li>Competitive compensation package based on experience, skillset and overall fit for #TeamloanDepot.</li><li>Inclusive, diverse, and collaborative culture where people from all backgrounds can thrive</li><li>Work with other passionate, purposeful, and customer-centric people</li><li>Extensive internal growth and professional development opportunities including tuition reimbursement</li><li>Comprehensive benefits package including Medical/Dental/Vision</li><li>Wellness program to support both mental and physical health</li><li>Generous paid time off for both exempt and non-exempt positions</li></ul><div>About loanDepot:</div><div>  </div><div>loanDepot (NYSE: LDI) is a digital commerce company committed to serving its customers throughout the home ownership journey. Since its launch in 2010, loanDepot has revolutionized the mortgage industry with a digital-first approach that makes it easier, faster, and less stressful to purchase or refinance a home. Today, as the nations second largest non-bank retail mortgage lender, loanDepot enables customers to achieve the American dream of homeownership through a broad suite of lending and real estate services that simplify one of lifes most complex transactions. With headquarters in Southern California and offices nationwide, loanDepot is committed to serving the communities in which its team lives and works through a variety of local, regional, and national philanthropic efforts.</div><div> </div><div>Base pay is one part of our total compensation package and is determined within a range. This provides the opportunity to progress as you grow and develop within a role. The base pay for this roles is between $140,000 and $180,000. Your base pay will depend on multiple individualized factors, including your job-related knowledge/skills, qualifications, experience, and market location. </div><div> </div><div>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.</div>