Lead Data Engineer Job at FairSquare, Orlando, FL

WUR5SWxib3FnOURoZWpyakFuaE1EU2ZXaEE9PQ==
  • FairSquare
  • Orlando, FL

Job Description

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. 

Job Tags

Full time, Casual work, Work at office, 3 days per week,

Similar Jobs

Purple Drive

Mainframe Developer Job at Purple Drive

 ...Experience: 8+ years Mainframe: ~8-10 years of experience in designing and developing Mainframe applications ~ Experience in COBOL (Modify existing programs to handling new business logic, Create new programs to validate the data etc.) ~ Experience in DB2 -... 

Kanroad

Custodian Job at Kanroad

 ...and sanitizing sinks, toilets, showers and restocking the disposables. Wiping and cleaning windows and mirrors. Maintain the outdoors by mowing the lawn, watering plants and cleaning the entrances. Reporting major damages and managing repairs. Securing the... 

Vetted Solutions

Travel Nurse - RN - Ambulatory Care Job at Vetted Solutions

We are hiring a Travel Nurse - RN for Ambulatory Care in Kent, WA. Earn $2,482/week while providing high-quality patient care in a dynamic outpatient setting. Deliver comprehensive ambulatory nursing care, including assessments, treatments, and patient education... 

TechBiz Global GmbH

Tableau Developer (SAP Financial data BI) Job at TechBiz Global GmbH

 ...We are currently seeking a Tableau Developer (SAP Financial data BI) to join one of our clients ' teams. If you're looking for an...  ...translate SAP FI data into actionable insights using Tableau or Power BI . Design, develop, and maintain BI dashboards and reports... 

Brentwood Park Townhomes and Apartments

Assistant Property Manager Job at Brentwood Park Townhomes and Apartments

 ...Summary The Assistant Property Manager plays an integral role in the success of our team, our community and creating a place our residents...  ...with excellent time management skills Education and Experience High School Diploma or GED Equivalent One year of hospitality...