Analytics Engineer

SpotOn • Raleigh, NC

18d • $100,000 - $140,000

About The Position

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.

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.

Responsibilities

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

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed
• Number of Employees: 1,001-5,000 employees