Data Engineer, National Funding

$101-151k

Plus bonus

SQL

AWS

Snowflake

dbt

Senior level

Los Angeles

More information about location

3 days a week in office (Irvine, CA)

Small business funding

Job no longer available

Small business funding

101-200 employees

B2BLendingInvestingFinancial Services

Job no longer available

$101-151k

Plus bonus

SQL

AWS

Snowflake

dbt

Senior level

Los Angeles

More information about location

3 days a week in office (Irvine, CA)

101-200 employees

B2BLendingInvestingFinancial Services

Company mission

To evolve their people, enrich their community and strengthen small businesses.

Job

Company

Role

Who you are

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
National Funding does not consider candidates requiring 1099 or C2C

Desirable

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

What the job involves

Reporting to the Director of BI, the Data Engineer will help implement a new Snowflake Data Warehouse initiative
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
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

Our take

Without capital to smooth out bumps in the road, otherwise viable small businesses can easily fail. Temporary overruns on payroll, inventory or premises fees on a slow month can put employers out of business and employees out of work. Without collateral it can be difficult to know where to turn, but since 1999 National Funding has been there to support US businesses with a financial solution.

There are a plethora of companies that will make unsecured loans to small and medium businesses, but the sector is rife with bad actors. National Funding prides itself on its customer orientation - ensuring that customers are getting the right product to support them, rather than pressuring them into larger loans they can ill afford. This approach has been appreciated by its customers: it has made more than $4.5 billion in loans to 80,000 businesses, and its TrustPilot reviews are glowing.

Having closed a $125 million securitization and established a new digital lending division, it is poised to move into lending to digital and mobile-focused businesses.