Responsibilities:

• 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 datarelated 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.

Qualifications 

• 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 performance optimization. 

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

• Bachelor’s 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.