Data Engineer

Description : Position Summary : Do you love a Challenge? Are you Passionate about technology? Are you customer obsessed? Looking to innovate? Join NAF Tech New American Funding (NAF) is a mortgage lender offering an array of loan options.Established in 2003 and headquartered in Tustin, CA, United States.At New American Funding, we value culture and team dynamics that will be able to help you advance in your career, while you explore all the different technologies we offer.Our engineers focus on developing our New American Funding web and mobile technology solutions by having a clear understanding of product requests, collaborating with our product team and designers, and providing solutions to our business problems.This role will provide insights into our development efforts.We're expecting this candidate to be able to make independent decisions, and use their creativity to solve different problems, and most important of all, have fun with the team hereWe are seeking a highly skilled and motivated Data Engineer to join our growing data team.The ideal candidate will bring deep technical expertise in SQL, ETL processes, Python, and orchestration tools, along with strong capabilities in data visualization and reporting.This role offers the opportunity to work with modern data platforms and contribute to the design and implementation of scalable data solutions across the : - Design, develop, and optimize scalable data pipelines using ETL tools (preferably Databricks).- Document database designs, data models, metadata, ETL specifications and process flows.- Monitor, maintain and optimize production systems.- Write advanced SQL queries (Snowflake preferred), including T-SQL, for data transformation, analysis, and reporting.- Build and support data visualizations and dashboards using tools such as Power BI, Tableau, or SSRS to support business intelligence needs.- Implement and maintain orchestration workflows (preferably Airflow) to ensure reliable data delivery.- Perform query optimization and performance tuning for large-scale datasets.- Collaborate with cross-functional teams including Data Analysts, Data Scientists, and Business Stakeholders to understand data and reporting requirements.- Develop and maintain data models, data dictionaries, and process documentation.- Use Python for data manipulation, automation, and integration tasks.- Ensure data quality, consistency, and governance across platforms.- Mentor junior engineers (for Lead role) and help define engineering and reporting best practices.- Become a trusted part of NAF's technical leadership.- Work with stakeholders including the Executive, Product, Data and Design teams to assist with data related technical issues and support their data infrastructure needs.- Perform code reviews to ensure code is rigorously designed, elegantly coded, and effectively tuned for performance.- Do research on new data platforms, data visualization tools and analysis.- Keep engineering teams up to date on advanced architecture and technology trends.- Have a full understanding of the mortgage business processes and know how systems support each process as well as an understanding of software used throughout the organization.Core Competencies : - 3+ years of experience in Data Engineering or related roles.- Strong proficiency in SQL, with hands-on experience in Snowflake or similar cloud data warehouses.- Expertise in ETL development, preferably using Databricks or similar platforms.- Solid understanding and hands-on experience with T-SQL, complex queries, and Proficient in Python for data scripting and automation.- Experience with orchestration tools like Apache Airflow.- Experience developing reports and dashboards in Power BI, Tableau, and/or SSRS.- Good Understanding of Data Modelling (Fact & Dimension tables).- Familiarity with CI/CD pipelines, and version control systems (e.g., Git).- Strong problem-solving and communication skills.- Proven ability to work collaboratively in a team-oriented environment.Desired Education/Skills : - Bachelors Degree in and work experience.- Excellent presentation, time management, and organizational skills.- Excellent written and oral communication skills.- Experience with working in highly motivated Agile Teams.- Experience mentoring engineers. (ref:hirist.tech)