Senior Snowflake Data Engineer - San Diego, CA (La Jolla/UTC area)
Hybrid or Remote, Full time M-F 8am-5pm PST, Working Onsite in San Diego from time to time
Being authorized to work in the U.S. is a precondition of employment.
National Funding is not considering candidates requiring 1099 or C2C.
Exempt/Salary: $117k-175k + Bonus
National Funding is continuing to grow its Data Science Department and has an exciting opportunity for a Senior Snowflake Data Engineer. Reporting to the Director, Data Science, the Senior Snowflake Data Engineer will help streamline our data science workflows, adding value to our product offerings and building out lifecycle and retention models. In addition, work closely with data science and business intelligence teams to develop data models and pipelines for research, reporting and machine learning.
•The data engineer will work closely with the DW team including analysts, BI developers, and SME experts who will provide “Source to Target” data mapping and required business transformations. Most of the data will be in the change data capture format.
•They will be responsible for creating in Snowflake a physical data model based on Source to Target data mapping, including business transformations provided.
•They will be creating various frameworks in Snowflake to semi-automate the creation of the transformed tables. This includes real time change data capture and QA.
•The data engineer will schedule various jobs for CDC and Snapshot data capture.
Knowledge, Skills and Abilities Required:
•3+ years' experience working as a snowflake data Engineer and 7+ years in Data warehouse, ETL, BI projects.
•Must have experience in implementing end to end Snowflake cloud data warehouses, including real time change data capture.
•Expertise in Snowflake – data modeling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts.
•Expertise in Snowflake 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.
•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).
•Experience with Snowflake data security and data access controls and design.
•Preferably having experience with AWS data storage and management technologies such as S3.
•Experience in creating frameworks in Snowflake:
- SCD framework
- Business Rules Engine
- Jobs Scheduling
- Capture Data Errors
- Data Transformations
- Snapshot data capture
•Working in a temperature-controlled office environment
•Sitting at a desk for long periods of time while viewing multiple computer screen monitors
•Potential lifting of boxes around 5-10lbs
Why National Funding?
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.