Analytics Engineer

Title: Analytics Engineer

As an analytics engineer within the data engineering team you will focus on building and optimizing the Extract Load and Transform (ELT) processes for SpotOn's data warehouse. Your responsibilities will include supporting the tooling and practices used by the data analytics team.  In addition you will be a primary contributor to the SpotOn dbt project and heavily influence the structure of the analytical data model. You will be asked to provide leadership and oversight around the expansion, quality, and reliability of data transformation pipelines.

Day to Day:

• Development of analytical models using dbt and optimizing those written by other team members.
• Develop and scale data pipelines using open source tools and vendor platforms.
• Assist in managing our Snowflake instance to scale efficiently.
• Validate and deploy your code.
• Provide an opinion on the direction of SpotOn's data initiatives and data infrastructure.
• Partner with engineers, analysts and business stakeholders from various teams to ensure upstream applications emit high quality source data.
• Ensure reliable and secure dev/production environments and actively improve infrastructure shared across the data and analytics teams.

Technologies you will use:

AWS, Postgres, MongoDB, Python, Github, Airflow, Fivetran, Streamkap, dbt, Snowflake, Metabase, PowerBI

Requirements:

• At least 3 years of experience developing data pipelines on modern, cloud-based infrastructure.  With hands-on experience in using writing and optimizing SQL queries. 
• Experience in custom ELT design, implementation, and maintenance.
• Advanced understanding of data modeling techniques.
• Communication skills, including the ability to identify and communicate data-driven insights.
• Basic understanding of DevOps.  
• Proficiency in at least one programming language (preferably Python).
• Experience with batch and streaming design patterns and tools.

This position is not eligible for work authorization sponsorship by SpotOn

Benefits:  

At SpotOn, we put people above everything else. We’re known for our innovative software and technology solutions, but we stand out because of the hard-working humans behind the tech. We can’t take care of our clients without taking care of our employees first, and that’s why we invest in you with a competitive benefits package which includes:

• Medical, Dental and Vision Insurance 
• 401k with company match
• RSUs
• Paid vacation, 10 company holidays, sick time, and volunteer time off
• Employee Resource Groups to build community and inclusion at work
• Monthly cell phone and internet stipend
• Tuition reimbursement for up to $2,000 per calendar year to assist with your professional development

Compensation:

• Our base pay range starts at $100,000 -$140,000 for this role
• Please note the salary range listed is just one component of a competitive compensation package which includes a company stock plan
• Offers will be reflective of the candidate’s location and experience.