Sr. Software Engineer - Data Query

Job Description

Job Description

Who we are looking for :

We are hiring a Senior Software Engineer in our Data Query (analytics data ingestion and data access) team to build out and enhance Appfolio’s data streaming and data access systems. Our Analytics Data will be widely used to power customer facing dashboards, reports, BI integrations, and AI powered agents. Appfolio supports a significant part of the real estate market in the United States and our data can be used to unlock many insights for our customers and can be the basis for new tools and capabilities that deliver value for our customers. The first need for the analytics data will be enhanced performance metrics for our 20,000+ customers in the real estate property management industry. This will allow our customers to see trends in their operations and act accordingly to improve and grow their business.

We see a future where our Data Query system provides a uniform, robust, and flexible access to data in Appfolio powering a variety of applications, all enhancing the lives and businesses of property managers. This role is pivotal to the creation and adoption of such a system - ultimately unlocking tremendous potential for the real estate industry in the coming years.

Responsibilities :

Build a deep understanding of our data structure and systems - enabling you and your team to build on top of and modify the existing architecture.

Research and determine key architecture and design decisions to build a scalable, robust, yet simple data access layer - this will involve some combination of leveraging our existing technology, refactoring existing systems, including off the shelf systems, or starting from scratch when it makes sense.

Participate in customer research / discovery with Product to understand current problems, needs, and estimate technical feasibility of various potential solutions.

Work in a truly agile fashion to turn a massive, unruly problem into thinly sliced deliverables and execute quickly against them while limiting work in progress.

Hold a high bar of engineering excellence and always look for ways to raise it. Adopt our engineering best practices, provide and receive in-depth code reviews, and participate in healthy debate as a team. Evangelize your own expertise and experience among your teammates and the rest of the organization.

Together with your team, you ensure the data flowing through our data pipelines is tested with appropriate unit and integration tests to ensure the correct data makes it to our customers.

Together with your team, your deliverables are always well-instrumented. Queries and dashboards are easily accessible and regularly used to drive decisions as well as measure progress.

Enthusiastically participate in a high performing, empowered team with high levels of mutual trust and respect. Along with the team, you will take ownership of your problem space - reflecting and growing from our failures and celebrating our successes.

Design and implement systems responsible for high concurrency access to large data sets

Identify gaps, deficiencies and inefficiencies in the system. Propose and implement solutions.

You know you're the right fit if…

Experience building data pipelines at a company with large data sets especially with multi-tenant data in an agile SaaS environment.

Experience working on platform teams or building platform services, whose customers are other internal teams.

Proven experience working across all levels of the development stack.

Proven experience with object oriented languages (python, ruby, JS, Java, C#, etc.)

Strong SQL proficiency with ability to suggest optimization for query performance and cost efficiency

Strong familiarity with REST APIs and web-based APIs

Familiarity with core architecture principles of at scale systems

Familiarity with public cloud, such as AWS, GCP, Azure

Strong familiarity with Agile software development processes : Scrum or Kanban

Creativity and proactivity - an ability to solve complex problems without a roadmap

You love to learn about and use new tech, but understand the value of continuing to leverage existing technology when it gets the job done.

You care about the long-term maintainability of the codebase and advocate for refactoring and code cleanliness.

You can identify and resolve code-smells through sensible refactoring.

Additional Skills and Knowledge :

5+ years of experience working in software engineering teams

Comfortable working with remote team members

Ability to think pragmatically and effectively balance business outcomes with technical goals

Ability to establish strong working relationships with peers across other platform development teams

If you are interested in creating exceptional SaaS products and being part of a successful public company, apply today!

Compensation & Benefits

The base salary that we reasonably expect to pay for this role is $114,400 - $143,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 / commissions that you may be eligible for based on your role and / or employment type.

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