What are the responsibilities and job description for the Senior Data Engineer position at Jobright.ai?
Jobright is an AI-powered career platform that helps job seekers discover the top opportunities in the US. We are NOT a staffing agency. Jobright does not hire directly for these positions. We connect you with verified openings from employers you can trust.
Job Summary:
FairSquare is a growing company that has been serving the small business community since 1999, providing over $3 billion in funding. They are seeking a Senior Data Engineer to focus on data flow integration, ETL processes, and support the data-driven nature of the company while working closely with various teams on data warehouse implementation.
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.
Qualifications:
Required:
• 5 years' experience working as a Data Engineer; data warehousing, ELT, pipelines, governance.
• Expertise in dbt, Snowflake, git and AWS required.
• Expertise in data modeling, ELT, data governance required.
Preferred:
• Experience with Salesforce is a plus.
• 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.
Company:
FairSquare is a holding company built to empower America’s small businesses. Founded in , headquartered in , team size 201-500 employees, currently Growth Stage.
