Data Engineer

DescriptionHi, We’re AppFolioWe’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 ImpactCreate, maintain, and refine business logic ETL (SQL) behind ‘source of truth’ tables and views in Snowflake data warehouseCreate, maintain, and refine ‘source of truth’ dashboards and data sources for analytics teams and leaders in Tableau OnlineTake on ad-hoc reporting and analytics projects as necessary to support key initiatives across the businessEnsure data quality by building observability, enforcing access control, and running continuous integration tests in the systemPlay 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 solutionsQualificationsAdvanced understanding of data modeling principles with experience serving as data steward for business-critical data/reporting assetsAbility to collaborate and develop positive business relationships with all cross-functional areas within AppFolioHighly motivated, resourceful problem solver with the ability to lead and interact effectively with cross-functional teamsCreative thinker with an entrepreneurial spirit and strong implementation abilityProven track record in performing well in a fast-paced environmentMust haveBachelor's degree in STEM field (Computer Science, Engineering, etc.)3+ years in Analytics, BI, or Software Engineering rolesAdvanced working knowledge of SQL3+ years experience in PythonExperience in ETL orchestration tool such as AirflowExperience in transformation tool such as dbtExperience with design and ownership of reporting layers of BI solution (Looker, Power BI, Tableau) with advanced working knowledge of Tableau requiredExperience with AWS tech stack (S3, EC2, EMR, EKS) required. Experience with Snowflake is idealCompensation & BenefitsThe 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 AppFolioGrow | 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/careersStatement of Equal OpportunityAt 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.

#J-18808-Ljbffr