ZipRecruiter

Log In

1

Query Processing Jobs in Illinois (NOW HIRING)

AppFolio

IL

$126K - $166K/yr

We are hiring a Senior Software Engineer in our Platform Data Query team to operate, maintain ... Strong familiarity with Agile software development processes: Scrum or Kanban. * Creativity and ...

FiniteHR Consulting

Sr.IT Developer(ERP)

Alsip, IL

... query, store procedures, triggers etc. Proven ERP experience; multiple full ERP implementations preferred. Ability to read, analyze and interpret general business processes, professional journals ...

Walgreens

Business Process Manager

Deerfield, IL · On-site

$86K - $138K/yr

Designs and implements processes to predict and prevent future issues. Develops and maintains an ... Experience working with SQL (query optimization, data extraction), Python (data manipulation ...

CYNET SYSTEMS

Senior Data Analyst

Lake Zurich, IL · On-site

$38 - $43/hr

Expert in Excel/Power Query/Access required. * Working SQL knowledge and experience working with ... Experience performing root cause analysis on internal and external data and processes to answer ...

PROLIM Global Corporation

ETL Developer

Rosemont, IL · On-site

$49.75 - $65/hr

Perform large-scale data processing and apply query optimization techniques for high performance. * Implement audit, balance, and control mechanisms to ensure data accuracy and integrity.

United Airlines

Data Modeling - SQL Engineer

Chicago, IL · On-site

$118K - $141K/yr

Query and manage data from Snowflake tables and other enterprise data sources * Perform advanced ... Fetch and process data from Snowflake OneLake and other internal external applications * Extract ...

next page

Showing results 1-20

All JobsQuery Processing JobsQuery Processing Jobs in Illinois

Query Processing information

What is query processing?

Query processing refers to the series of steps a database management system (DBMS) takes to interpret and execute a user's query. This process involves parsing the query, translating it into a suitable internal representation, optimizing it for efficient execution, and finally retrieving the requested data from the database. Effective query processing is crucial for ensuring fast and accurate results, especially in large and complex databases. It typically includes techniques like indexing, query rewriting, and using execution plans to improve performance.

How does a Query Processing professional typically collaborate with database administrators and software developers?

Query Processing professionals play a vital role in optimizing how databases handle and execute queries. They work closely with database administrators to analyze performance bottlenecks, suggest indexing strategies, and ensure efficient data retrieval. Collaboration with software developers is also common, as these professionals help design application queries that are both effective and resource-efficient. This teamwork ensures that end-users receive fast, accurate results while maintaining the stability and scalability of database systems.

What are the key skills and qualifications needed to thrive as a Query Processing Specialist, and why are they important?

To thrive as a Query Processing Specialist, you need a solid understanding of database management, information retrieval, and data analysis, often supported by a degree in computer science or a related field. Familiarity with SQL, search algorithms, data warehousing solutions, and query optimization tools is typically required. Strong analytical thinking, problem-solving abilities, and effective communication skills help you interpret data needs and collaborate with stakeholders. These competencies are crucial for efficiently handling and optimizing queries to ensure accurate, timely access to data and support business decision-making.

What is the difference between Query Processing vs Data Analyst?

AspectQuery ProcessingData Analyst
Required CredentialsKnowledge of databases, SQL, and data retrieval techniquesDegree in statistics, data science, or related fields; SQL knowledge often required
Work EnvironmentDatabase systems, data warehouses, IT departmentsBusiness environments, analytics teams, reporting tools
Industry UsageIT, software development, database managementFinance, marketing, healthcare, and other sectors relying on data insights

Query Processing focuses on retrieving and managing data efficiently within databases, often involving technical skills like SQL and database management. Data Analysts interpret data, generate reports, and provide insights for decision-making. While both roles work with data, Query Processing is more technical and system-oriented, whereas Data Analysts focus on analysis and business applications.

What are popular job titles related to Query Processing jobs in Illinois? For Query Processing jobs in Illinois, the most frequently searched job titles are:
What job categories do people searching Query Processing jobs in Illinois look for? The top searched job categories for Query Processing jobs in Illinois are:
What cities in Illinois are hiring for Query Processing jobs? Cities in Illinois with the most Query Processing job openings:
Query Processing jobs near you

Sr Software Engineer - Platform Data Query

AppFolio

IL

$126K - $166K/yr

Full-time

Re-posted 23 days ago

AppFolio rating

7.2

Company rating: 7.2 out of 10

Based on 8 frontline employees who took The Breakroom Quiz

184th of 246 rated software companies

Job description

Who we are looking for: We are hiring a Senior Software Engineer in our Platform Data Query team to operate, maintain, scale, and enhance Appfolio's data streaming and data access systems. Must have experience with modern data lake architectures, as you will be directly working with Iceberg data lakes, Trino, and real-time streaming using Apache Flink and Kafka. Our data is 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 unlocks many insights for our customers and is the basis for new tools and capabilities that deliver value for our customers. The data provides enhanced performance metrics for our 20,000+ customers in the real estate property management industry. This allows our customers to see trends in their operations and act accordingly to improve and grow their business. Our Platform 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 ongoing operation, scaling, and enhancement of that 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 maintain, scale, and add on to the existing architecture.
  • Maintain, optimize, and scale our robust data access layer on top of our Iceberg data lake, taking ownership of under-the-hood optimizations like data compaction for performance and storage efficiency.
  • Design, build, and operate a robust API on top of our data tech stack, ensuring secure data access and seamless integration for downstream applications and platform services.
  • Collaborate with Product to understand current operational needs, troubleshoot issues, and design technical add-ons or enhancements to our existing solutions.
  • Work in a truly agile fashion to turn scaling challenges and feature enhancements 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.
  • Operate, optimize, and scale systems responsible for high concurrency access to large data sets, requiring hands-on execution and deep knowledge of data access and query optimization with distributed query engines like Trino and AWS Athena. Identify gaps, deficiencies, and inefficiencies in the system. Propose and implement solutions.
You know you're the right fit if...
  • Must have experience operating, scaling, and enhancing data pipelines at a company with large data sets using Apache Flink and Kafka, especially with multi-tenant data in an agile SaaS environment.
  • Must have foundational experience operating, tuning, and maintaining Iceberg data lakes, including deep knowledge of table maintenance and data compaction strategies.
  • Experience working on platform teams or maintaining 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 and deep knowledge of data access/query optimization, requiring the ability to optimize query performance and cost efficiency at scale using distributed engines like Trino and AWS Athena.
  • Familiarity with core architecture principles of at-scale systems.
  • Must have strong familiarity with public cloud infrastructure, particularly AWS (including native tools like AWS Glue, AWS S3, and AWS Athena).
  • Strong familiarity with Agile software development processes: Scrum or Kanban.
  • Creativity and proactivity - an ability to solve complex scaling and operational problems. You love to learn about and use new tech, but understand the value of continuing to leverage and optimize 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 $138,400 - $173,000.   
   
The actual base salary for this role will be determined by a variety of factors, including b

What AppFolio employees say

Pay

Benefits

Hours and flexibility

Workplace

Get the full story on Breakroom

Apply