Job Description

Senior Data Engineer  - San Diego, CA, Irvine, CA, Orlando, FL, or Atlanta, GA.

• Hybrid 3 days/week, Full time M-F 8am-5pm PST/EST
• Being authorized to work in the U.S. is a precondition of employment.
• FairSquare does not consider candidates requiring 1099 or C2C.
• Exempt/Salary: $101,000-$161,000 + Bonus

FairSquare is continuing to grow its Data Engineering Department and has an exciting opportunity for a Senior Data Engineer. Reporting to the Manager, Data Engineering, the Data Engineer will be focusing on understanding the data flow across source systems, assisting in integrating data for operational use and creating an intuitive and highly integruous data environment to support modeling, analytics and reporting.

Responsibilities:

• The data engineer will participate in the on-going data warehouse implementation and work closely with the data and risk teams including analysts, data scientists, and business stakeholders. This includes the full DW lifecycle of requirements gathering, data modeling, data mapping, ETL, QA and maintenance.
• The primary responsibility will be ETL work using dbt integrating data, applying business rules and transformations, creating both normalized and de-normalized data. Additionally, there will be tasks to create pipelines within AWS for varying data sources and destinations. This role will also be involved in the design, development and maintenance of operational applications.
• Other responsibilities include supporting other data engineers, managing CI/CD pipelines through git, administrative tasks for project management and platform maintenance, data sourcing, responding to and resolving alerts quickly, documentation, AWS work and other tasks to support the data driven nature of the company.

Knowledge, Skills and Abilities Required:

• 5+ years' experience working as a Data Engineer; data warehousing, ETL, pipelines, governance.
  Expertise in dbt, Snowflake, git and AWS required.
• Expertise in data modeling, ETL, data governance required.
• Experience with Salesforce is a plus.

Nice to Have Skills:

• Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, techniques using UDFs.
• Experience in Snowflake administration (resource monitors, RBAC, virtual warehouse sizing, query performance tuning, time travel).
• Experience with designing and implementing data quality metrics.
• Experience in git integrations with dbt and JIRA.

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 FairSquare?

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

FairSquare and it's family of brands has been serving 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.

FairSquare is an Equal Opportunity Employer.

Job Tags

Similar Jobs