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?
- Growing, successful company preparing to almost double in size over the next three years (this is your opportunity to get in on the ground floor)
- Positive, energetic, passionate, business casual environment with management who committed to your success
- Fantastic benefits package including a 401(k) match
- Numerous employee events throughout the year, including our annual traditions such as a Day at the Del Mar Racetrack, Holiday Party, Employee and Family Picnic, sporting events and more.
National Funding serves the small business community. Since 1999, we have provided more than $3 billion in funding to over 50,000 customers to support their working capital and equipment financing needs. We are one of the country's largest private providers of small business loans, having funded more than $3 billion to help small businesses grow. Our personal approach helps strengthen small business owners and we pride ourselves on being a resource they can trust. We are believers in small business owners.
National Funding is an Equal Opportunity Employer.
#J-18808-Ljbffr