Jobs
>
San Diego

    Data Engineer - San Diego, United States - National Funding

    National Funding
    National Funding San Diego, United States

    2 weeks ago

    Default job background
    Description

    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.

  • The Shipyard

    Associate Director of Data Engineering

    1 week ago

    The Shipyard San Diego, United States

    The Shipyard is a leading, independent agency that builds performance-driven brands audiences can't help but love. · Our ability to align bold creativity with individual consumer motivations lets us do more than hope for brand love - we methodically engineer it throughout the con ...

  • ACL Digital

    Data Engineer

    1 week ago

    ACL Digital San Diego, United States

    Job Title: Data Engineer · Location: San Diego, CA (Onsite) · Duration: Contract Project · Job Description: · Top 5 Required Skills: · 1. AWS · 2. Data Engineering · 3. SQL · 4. Python · 5. Informatica · Technologies: · • AWS, Redshift, Apache Airflow, Glue, Python, Informatic ...

  • Qualcomm

    Data Engineer

    3 weeks ago

    Qualcomm San Diego, United States

    Title: Data Engineer · Duration: Contract (Possible extension) · Location: Onsite (San Diego, CA) · Job Summary: · Job Description: Data engineer to design, process for and build automation for test data analytics and data structure. · Engineer is also responsible for injecting ...

  • OwnBackup

    Data Engineer

    1 week ago

    OwnBackup San Diego, United States

    Own is the leading data platform trusted by thousands of organizations to protect and activate SaaS data to transform their businesses. Own empowers customers to ensure the availability, security and compliance of mission-critical data, while unlocking new ways to gain deeper ins ...

  • ACL Digital

    Data Engineer

    6 days ago

    ACL Digital San Diego, United States

    Job Title: Data Engineer · Like the look of this opportunity Make sure to apply fast, as a high volume of applications is expected Scroll down to read the complete job description. · Location: San Diego, CA (Onsite) · Duration: Contract Project · Job Description: · Top 5 Re ...

  • ASCENDING LLC

    Data Engineer

    2 weeks ago

    ASCENDING LLC San Diego, United States

    Description: · Top 3 Required Skills: · • Hands-on experience creating automated data pipelines using Pega DataFlow and other modern technology stacks for batch ETL or API · • Hands-on experience with Pega 8.X, Postgres and Cassandra · • Knowledge and experience with configur ...

  • OwnBackup

    Data Engineer

    2 weeks ago

    OwnBackup San Diego, United States

    Own is the leading data platform trusted by thousands of organizations to protect and activate SaaS data to transform their businesses. Own empowers customers to ensure the availability, security and compliance of mission-critical data, while unlocking new ways to gain deeper ins ...

  • Qualcomm

    Data Engineer

    4 weeks ago

    Qualcomm San Diego, United States

    Title: Data Engineer · Duration: Contract (Possible extension) · Location: Onsite (San Diego, CA) · Job Summary: · Job Description: Data engineer to design, process for and build automation for test data analytics and data structure. · Engineer is also responsible for injec ...

  • Diverse Lynx

    Data Engineer

    2 weeks ago

    Diverse Lynx San Diego, United States

    Role: Senior Data Engineer with Snowflake/Informatica IICS or Azure ADF · Location: Fontana, CA (Hybrid model / 2-3 days onsite) · Duration: 12+ Months · Qualifications: · 6+ years of professional experience in data & analytics technologies/solutions as data engineer or rela ...

  • San Diego Community Power

    Data Engineer

    1 week ago

    San Diego Community Power San Diego, United States

    Job Description · Job DescriptionWe are looking for talented and motivated professionals to join our team We invite you to apply for our open position(s) below. · OPEN POSITION ANNOUNCEMENT · Data Engineer · Open until filled. · Posted 05/14/2024 San Diego County – hybrid work sc ...

  • Classy

    Data Engineer

    1 week ago

    Classy San Diego, United States

    Classy, an affiliate of GoFundMe, is a Public Benefit Corporation and giving platform that enables nonprofits to connect supporters with the causes they care about. Classy's platform provides powerful and intuitive fundraising tools to convert and retain donors. Since 2011, Class ...

  • ASCENDING

    Data Engineer

    2 weeks ago

    ASCENDING San Diego, United States

    Job Description · Job DescriptionDescription: · Top 3 Required Skills: · • Hands-on experience creating automated data pipelines using Pega DataFlow and other modern technology stacks for batch ETL or API · • Hands-on experience with Pega 8.X, Postgres and Cassandra · • Knowledge ...

  • Axos Financial, Inc.

    Data Engineer

    1 week ago

    Axos Financial, Inc. San Diego, United States

    As our Data Engineer you will work within the Enterprise Data Management group using SQL, SSIS, MS SQL Server, python, etc. to create revenue generating enterprise data solutions. Responsibilities:Work with Technical and business team to understand t Data Engineer, Engineer, Tech ...

  • Gunderson Dettmer

    Data Engineer

    2 weeks ago

    Gunderson Dettmer San Diego, United States

    Job Description · Job DescriptionGunderson Dettmer is the only business law firm of its kind - exclusively serving the global venture capital and emerging technology marketplace. With 400 attorneys in eleven offices - from Silicon Valley to Singapore - we innovate for innovators, ...

  • eTeam

    Data Engineer

    3 weeks ago

    eTeam San Diego, United States

    Data Engineer 4-5 years of experience with building end-to-end Data Lake using AWS technologies (S3, Glue, Athena, RedShift) · Design, develop and support data pipelines in a hybrid cloud environment to enable advanced analytics · Experience with scheduling data pipelines usi ...

  • National Funding

    Data Engineer

    1 week ago

    National Funding San Diego, United States

    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 ...

  • San Diego Community Power

    Data Engineer

    1 week ago

    San Diego Community Power San Diego, United States

    We are looking for talented and motivated professionals to join our team We invite you to apply for our open position(s) below. · OPEN POSITION ANNOUNCEMENT · Data Engineer · Open until filled. · Posted 05/14/2024 San Diego County - hybrid work schedule set by SDCP · About th ...

  • ATR International

    Data Engineer

    3 weeks ago

    ATR International San Diego, United States

    Engineer, Senior| – · San Diego, CA 92121 · 5 Months Contract · The ideal candidate will possess the following qualities. · Data engineer to design, process for and build automation for test data analytics and data structure. · Engineer is also responsible for injecting domain k ...

  • Qualcomm

    Data Engineer

    2 weeks ago

    Qualcomm San Diego, United States

    Title: Data Engineer · Duration: Contract (Possible extension) · Location: Onsite (San Diego, CA) · Job Summary: · Job Description: Data engineer to design, process for and build automation for test data analytics and data structure. · Engineer is also responsible for injecting ...

  • NavAide

    Data Engineer

    2 weeks ago

    NavAide San Diego, United States Full time

    Job Summary · The ideal data analyst candidate will leverage government-provided software and tools to assist in various mission requirements such as Services/Category Management and Program Analysis. They will be responsible for developing and maintaining configuration files, s ...