Sr Data Warehouse Engineer

Position: Senior Data Warehouse Engineer

Location:: Remote/ Hybrid two days a week if you reside within 30 miles of Tustin, CA or Austin, TX area

Position Summary:

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 here!

Salary: Starting at $130k DOE

Responsibilities:

Become a trusted part of NAF's technical leadership.

Be accountable for all aspects of the team’s data pipelines as a hands-on technical leader.

Provide technical expertise and hands-on support in the consolidation and migration of databases to new environments and platforms.

Document database designs, data models, metadata, ETL specifications, and process flows.

Monitor, maintain, and optimize production systems.

Perform code reviews to ensure code is rigorously designed, elegantly coded, and effectively tuned for performance.

Successfully manage time between coding, design, and architecture.

Influence planning strategies and bring industry context to technical decisions.

Have a full understanding of the mortgage business processes and know-how systems that support each process as well as an understanding of the software used throughout the organization.

Exemplary performance in architecture, efficiency, stability, extensibility, maintainability, and growth.

Lead conversations to remove blockers and encourage collaboration between teams.

Keep engineering teams up to date on advanced architecture and technology trends.

Ensures that OKR-level goals are aligned with the business’s goals.

Drive engineering excellence as a role model.

Qualifications:

5+ years of Database Engineer experience with Snowflake (on Azure Cloud Preferred).

5+ years of hands-on experience using Python and Airflow.

Solid and working knowledge of FiveTran or other no-code ETL tools.

Strong knowledge of SQL-based databases.

Experience with data streaming tools and real-time data technology

Ability to investigate complex issues across multiple systems.

Excellent knowledge of application security in transit and at rest.

Manages time to focus on priorities across multiple projects.

Ability to build processes supporting data transformation, data structures, metadata, dependency, and workload management.

Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.

Desired Education/Skills:

Bachelor’s Degree in Software Engineering, computer science, or a related engineering field, or an equivalent combination of education and work experience.

Snowflake Certification is preferred

Excellent presentation, time management, and organizational skills.

Excellent written and oral communication skills.

Experience with working in highly motivated Agile Teams.

Experience mentoring engineers.

Work Authorization: Must be able to verify identity and employment eligibility to work in the U.S.

Other Duties: This job profile is not intended to be an all-inclusive list of job duties and responsibilities, as one may perform additional related duties as assigned in order to meet the needs of the organization.

Physical Demands: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Must be able to lift up to ten pounds. Primary functions require sufficient physical ability and mobility to work in an office setting; to stand or sit for prolonged periods of time; to occasionally stoop, bend, kneel, crouch, reach, and twist; to lift, carry, push, and/or pull light to moderate amounts of weight; to operate office equipment requiring repetitive hand movement and fine coordination including use of a keyboard; and to verbally communicate to exchange information. VISION: See in the normal visual range with or without correction. HEARING: Hear in the normal audio range with or without correction.

[EOE/M/F/D/V. Drug-free workplace.]

Job Type: Full-time

Pay: From $130,000.00 per year

Benefits:

• 401(k)
• Dental insurance
• Health insurance

Schedule:

• 8 hour shift

Experience:

• Snowflake: 5 years (Required)
• Python: 5 years (Preferred)
• Airflow: 5 years (Preferred)
• Data Engineering: 5 years (Preferred)

Work Location: Remote