Data Engineer - San Diego, CA or Orange County, CA

Hybrid 3 days/week, Full time M-F 8am-5pm PST

Being authorized to work in the U.S. is a precondition of employment.

National Funding does not consider candidates requiring 1099 or C2C.

Exempt/Salary: $101,000-$151,000 Bonus

National Funding is continuing to grow its Data Analytics Department and has an exciting opportunity for a Data Engineer. Reporting to the Director of BI, the Data Engineer will help implement a new Snowflake Data Warehouse initiative.

Responsibilities:
• The data engineer will participate in the data warehouse implementation and work closely with the DW team including analysts, BI developers, and SME experts. This includes the full DW lifecycle of requirements gathering, data modeling, data mapping, ETL, reporting and QA.

• The primary responsibility will be ETL work using dbt integrating data, applying business rules and transformations, creating both normalized and de-normalized data.
• They will be creating various ETL frameworks in dbt to semi-automate data transformation. This includes the full life cycle of ETL: applying business rules, data aggregation, data cleansing, and QA.
• Other responsibilities include supporting other data engineers working on administration, data sourcing, data orchestration, notifications, data lineage, and related aws work

Knowledge, Skills and Abilities Required:
• 3 years' experience working as a Data Engineer and 5 years in Data warehouse, ETL, BI projects.
• Must have experience in dbt, or related ETL products.

• Expertise in data modeling, ELT using SQL, implementing complex stored Procedures and standard DWH and ETL concepts.
• Expertise in advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understanding how to use these features.

• Preferably having experience with aws data storage and management technologies such as S3.

Nice to have skills:

• Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, techniques using UDFs.
• Deep understanding of relational data stores, methods, and approaches (star and snowflake, dimensional modeling).
• Snowflake certification a plus.
• Experience in creating frameworks in Snowflake:
 - SCD framework
 - Business Rules Engine
 - Jobs Scheduling
 - Capture Data Errors
 - Data Transformations
 - Snapshot data capture

Physical Demands:
• Working in a temperature-controlled office environment
• Sitting at a desk for prolonged periods of time while viewing multiple computer screen monitors
• Potential lifting of boxes around 5-10lbs

Why National Funding?

• Positive, energetic, passionate, business casual environment with management who commits to your success

• Fantastic benefits package: Our current benefit package includes medical, dental, vision, life, LTD and AD&D insurance as well as a 401(k) Retirement Savings plan with an employer match. Eligibility for all benefits will start at the first of the month following 60 days of employment.
• Numerous employee events throughout the year, including our annual traditions such as a Day at the Del Mar Racetrack, Del Mar Mud Run, Bring Your Kid to Work Day, Holiday Party, Employee and Family Picnic, sporting events and more.

National Funding is one of the leading providers of short-term loans and equipment leasing for small businesses across the United States. In both 2013 and 2014, we were ranked by the San Diego Business Journal as one of the 100 Fastest Growing Private Companies in San Diego and listed on the Inc. 5000 List of America’s Fastest Growing Private Companies. We serve the small business community nationwide by offering a range of financial services and products. Since 1999, we have been in the forefront of the equipment leasing business, working with businesses in hundreds of communities and industries to expand and upgrade their business equipment. As we have grown, so too has our product line, and now we are one of the country’s largest private lenders of small business loans. Our customers call on us to get working capital, merchant cash advances, credit card processing, and of course, equipment leasing.

National Funding is an Equal Opportunity Employer.