Lead Data Engineer

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

• FairSqaure does not consider candidates requiring 1099 or C2C. 

• Exempt/Salary: $130,000-$180,000 + Bonus 

FairSquare is continuing to grow its Data Engineering Department and has an exciting opportunity for a Lead 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 lead 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 designing scalable data models and ETL/ELT process, as well as owning Snowflake warehouse performance, optimization, and governance. 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 reverse ETL pipelines. 

• Other responsibilities include supporting and mentoring other data engineers, managing CI/CD pipelines through git, administrative tasks for project management, data sourcing, responding to and resolving alerts quickly, documentation, and other tasks to support the data driven nature of the company. 

• The lead data engineer will be responsible for translating business requirements into technical specifications and work streams as well as serve as a technical point person for platform-related projects and initiatives. 

Knowledge, Skills and Abilities Required: 

• 7+ years' experience working as a Data Engineer; data warehousing, ETL, pipelines, governance, modeling. 
  Expertise in Snowflake, dbt, 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.