Data Engineer

Description

Hi, We’re AppFolio

We’re innovators, changemakers, and collaborators. We’re more than just a software company – we’re pioneers in cloud and AI who deliver magical experiences that make our customers’ lives easier. We’re revolutionizing how people do business in the real estate industry, and we want your ideas, enthusiasm, and passion to help us keep innovating.

AppFolio’s Analytics Engineers are creating the Data Platform to power the business’ Analytics and Data Science teams. This key role will work to establish a single source of truth for KPI’s across AppFolio and enable the discovery of impactful insights about our business and customers to inform company strategy. The Analytics Engineer will work cross-functionally with analysts and researchers throughout the business to understand analytics and reporting needs and engineer creative solutions to address these at scale. This will be accomplished through developing and implementing ETL scripts, creating Tableau Dashboards, and contributing to key analytics initiatives requiring a high degree of technical knowledge and skills.

Your Impact

• Create, maintain, and refine business logic ETL (SQL) behind ‘source of truth’ tables and views in Snowflake data warehouse
• Create, maintain, and refine ‘source of truth’ dashboards and data sources for analytics teams and leaders in Tableau Online
• Take on ad-hoc reporting and analytics projects as necessary to support key initiatives across the business
• Ensure data quality by building observability, enforcing access control, and running continuous integration tests in the system
• Play an active role in AppFolio’s cross-functional Analytics & Research Community, helping a group of 40+ Analysts, Data Scientists, and Researchers solve problems and create innovative analytics models and solutions
  
  
  

Qualifications

• Advanced understanding of data modeling principles with experience serving as data steward for business-critical data/reporting assets
• Ability to collaborate and develop positive business relationships with all cross-functional areas within AppFolio
• Highly motivated, resourceful problem solver with the ability to lead and interact effectively with cross-functional teams
• Creative thinker with an entrepreneurial spirit and strong implementation ability
• Proven track record in performing well in a fast-paced environment
  
  
  

Must have

• Bachelor's degree in STEM field (Computer Science, Engineering, etc.)
• 3+ years in Analytics, BI, or Software Engineering roles
• Advanced working knowledge of SQL
• 3+ years experience in Python
• Experience in ETL orchestration tool such as Airflow
• Experience in transformation tool such as dbt
• Experience with design and ownership of reporting layers of BI solution (Looker, Power BI, Tableau) with advanced working knowledge of Tableau required
• Experience with AWS tech stack (S3, EC2, EMR, EKS) required. Experience with Snowflake is ideal
  
  
  

Compensation & Benefits

The base salary that we reasonably expect to pay for this role is $108,000-$149,000.

The actual base salary for this role will be determined by a variety of factors, including but not limited to the candidate’s skills, education, experience, etc.

Please note that base pay is one important aspect of a compelling Total Rewards package. The base pay range indicated here does not include any additional benefits or bonuses that you may be eligible for based on your role and/or employment type.

Regular full-time employees are eligible for benefits - see here.

Why AppFolio

Grow | We enable a culture of high performance, where delivering results is recognized by opportunities for growth and compelling total rewards. Our challenging and meaningful work drive the growth of our business, and ourselves.

Learn | We partner with you to realize your potential by investing in you from the start. We're cultivating a team of big thinkers through coaching and mentorship with our best-in-class leaders, and giving you the time and tools to develop your skills.

Impact | We are creating a world where living in, investing in, managing, and supporting communities feels magical and effortless, freeing people to thrive. We do this by innovating with purpose while cultivating a culture of impact. We learn as much from each other as we do our customers and our communities.

Connect | We excel at hybrid work by fostering an environment that feels flexible, personal and connected, no matter where we are. We create space to fuel innovation and collaboration, and we come together to celebrate, connect, and succeed.

Paddle as One.

Learn more at appfolio.com/company/careers

Statement of Equal Opportunity

At AppFolio, we value diversity in backgrounds and perspectives and depend on it to drive our innovative culture. That’s why we’re a proud Equal Opportunity Employer, and we believe that our products, our teams, and our business are stronger because of it. This means that no matter what race, color, religion, sex, sexual orientation, gender identification, national origin, age, marital status, ancestry, physical or mental disability, or veteran status, you’re always welcome at AppFolio.