The Role

We’re seeking exceptional analytics engineers excited to scale their knowledge of data modeling and schema design to hundreds of companies. As an analytics engineer in a product organization, you will be tasked with understanding our customers’ needs and the transformations that will be deployed as part of Preql’s core engine.

What we're looking for

• You have strong opinions about data modeling, live in your text editor, and love to push SQL to the limits
• You’re a skilled collaborator, excited to partner with folks on the product, design, and engineering  side of the business
• You love tackling complex problems and getting creative when developing solutions
• You’ve had experience writing SQL transformations for D2C brands (nice to have)

Responsibilities

• Own a core portion of our SQL backend and provide key determinations on technical architecture
• Collaborate with software engineers, product managers, designers, and analysts
• Speak directly with customers alongside team members to understand and deliver solutions
• Balance speed and quality with a focus on tangible results
• Share knowledge, promote best practices, and collaborate with fellow engineers
• Bind our services together while delivering testable, maintainable, and high-quality code

Qualifications

• 3-5 years experience in an analytics engineering, data engineering, business intelligence, or technical data analytics role
• Advanced expertise in SQL, SQL optimization techniques, experience with cloud-based data warehouses (Snowflake, BigQuery, Redshift), experience with data ingestion tools (e.g. Fivetran, Stitch), knowledge of common cloud service vendors and their data models (Stripe, Shopify, Google Analytics, Facebook Ads)
• Experience with data pipeline management technologies, dependency checking (e.g. Airflow, dbt), schema design, and dimensional data modeling
• Ability to leverage tools, business intuition, and attention to detail for data validation and QA
• Excellent communication skills, particularly when explaining more complex technical topics to business users
• Proven record of shipping features on time and on budget
• Self-starter and detail-oriented