The Chicago Public Schools Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Chicago Public Schools Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Chicago Public Schools? The Chicago Public Schools Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:</p>
<ul>
<li>Know what skills are necessary for Chicago Public Schools Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Chicago Public Schools.</li>
<li>Practice real Chicago Public Schools Business Intelligence interview questions.</li>
</ul>
<p>Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Chicago Public Schools Business Intelligence interview.</p>


Getting ready for an Business Intelligence interview at Chicago Public Schools? The Chicago Public Schools Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Chicago Public Schools Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Chicago Public Schools.
- Practice real Chicago Public Schools Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Chicago Public Schools Business Intelligence interview.
        

Overview

<p>We've gathered this data from parsing thousands of interview experiences sourced from members.</p>

We've gathered this data from parsing thousands of interview experiences sourced from members.

Chicago Public Schools Business Intelligence Interview Process

<p>Suppose your company needs to cut costs due to an economic downturn. During a coffee break, you hear a rumor that a lot of money goes to employees who don’t do their work, and you decide to find out if the rumor is true.</p>

<p>Given two tables: <code>employees</code> and <code>projects</code>, find the sum of the salaries of all the employees who didn’t complete any of their projects.</p>

<p>Clarification:</p>

<p>We will consider a project unfinished if it has no end date (its <code>End_dt</code> is <code>NULL</code>).</p>

<p>Given this, we’ll say an employee didn’t finish any of their projects when:</p>

<ul>
<li>They were assigned at least one project.</li>
<li>None of their projects have an <code>End_dt</code>.</li>
</ul>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>employees</code> table</p>

<table>
<thead>
<tr>
<th>id</th>
<th>salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><code>projects</code> table</p>

<table>
<thead>
<tr>
<th>employee_id</th>
<th>project_id</th>
<th>Start_dt</th>
<th>End_dt</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>INTEGER</td>
<td>DATETIME</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>total_slack_salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Find the total salary of slacking employees.

Slacking Employees Salaries

<p>You’ve been asked to analyze the player’s behaviors at a gaming company.</p>

<p>Write a query to get the number of players who played between 5 and 10 games (5 and 10 excluded), and the number of players who played 10 games or more.</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><strong><code>players</code></strong> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>games_played</td>
<td>INTEGER</td>
</tr>

<tr>
<td>registered_at</td>
<td>TIMESTAMP</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>players_more_than_5_to_10_games</td>
<td>INTEGER</td>
</tr>

<tr>
<td>players_10_plus_games</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Obtain count of players based on games played.

Player Analysis

<p>You have been given a table <code>tbl_numbers</code> with only one column: <code>int_numbers</code>.  It can have one integer number value per row in a sequential manner.</p>

<p>Write a query to return the number repeated by one times its own value.</p>

<p>For example, the integer number 5 would appear five times in the output (1 times 5).</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>tbl_numbers</code> table</p>

<table>
<thead>
<tr>
<th>int_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>seq_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>
</tbody>
</table>


Sequentially Fill in Integers

Chicago Public Schools Business Intelligence Interview Questions

VP of Data Accountability and Compliance  Be among the first 25 applicants
Description
Vice President of Data Accountability and Compliance
Mission
The Vice President of Data Accountability and Compliance leads the development, implementation, and enforcement of data governance and compliance strategies across the organization, focusing on PEIMS and state compliance. The VP will ensure that data handling practices align with all applicable regulatory requirements, industry standards, and internal policies while promoting a culture of transparency and accountability in data management.
Supervisory Responsibilities
This is a supervisory position.
Location
This is a full-time remote position based in Texas, with preference given to candidates in Austin, El Paso, Houston, Permian Basin (Midland/Odessa), Rio Grande Valley, San Antonio, and Tarrant County (Fort Worth), or those willing to relocate.
Travel Expectations
Travel to IDEA training events or other related activities may be required.
Essential Duties
Accountabilities
Ensure Data Governance and Compliance
Continuously improve data management practices, resulting in strong data governance and data health.
Achieve excellence in service models to deliver highly available infrastructure and network services.
Create organizational efficiencies and value streams through business process engineering and management.
Additional Duties and Responsibilities
Partner with key departments (Legal, IT, Security, Risk, Operations) to develop and maintain data compliance best practices.
Manage internal and external audits of data handling to ensure compliance with relevant regulations.
Establish and enforce data governance standards across all reporting and data services functions.
Produce operations documentation, standards, and communication strategies.
Assess potential risks to data compliance and develop proactive mitigation strategies.
Knowledge and Skills – Competencies
Make strategic decisions based on complex data analysis, aligning with organizational goals.
Manage work and teams, ensuring resource optimization and mentoring leadership.
Promote growth for self and others through development strategies.
Build a culture of trust and open communication within teams.
Communicate deliberately, facilitating effective team communication and feedback.
Additional Skills
Align data governance and compliance with organizational needs and regulatory standards.
Ensure adherence to data privacy laws such as CCPA, HIPAA, etc.
Leverage vendor partnerships for functionality, customization, and cost efficiencies.
Achieve quarterly data health targets, with continuous improvement.
Collaborate with data stewards and partners to enhance audit and quality tools.
Coordinate with Research & Analysis and Software Development teams to meet strategic data management needs.
Required Experience
Bachelor’s degree in Information Systems, Computer Science, Data Science, or Business Administration.
Intermediate to advanced mastery of Agile and/or Waterfall methodologies.
Exceptional quantitative and technical skills.
5+ years in data management, reporting, analytics, or related fields, with at least 3 years in a leadership role.
Preferred Experience
Master’s degree preferred.
Physical Requirements
This is a sedentary role.
What We Offer
Salary range: $131,000 - $158,500, commensurate with experience. Benefits include health plans, disability, life insurance, parental benefits, flexible spending, vacation, bonuses, professional development, and a 403(b) plan. More info:  https://ideapublicschools.org/careers/benefits/ .
Relocation stipends may be available.
Application Process
Apply online via Jobvite. Applications are reviewed on an ongoing basis until filled. Early applications are encouraged.
Learn more about IDEA and our Core Values at  https://ideapublicschools.org/our-story/#core-values .

#J-18808-Ljbffr

CPS Careers | Search | Apply | Get Hired
Posting Date  Feb 19, 2025, 5:31:38 PM
Primary Location  CPS Non-Union Job Grade: S08
Estimated Annual Salary Range  76,000.00 - 100,500.00
Position Type: Non-Union Position
Overtime Status  Exempt
Final salary offers are dependent upon candidate qualifications.
JOB DESCRIPTION
Chicago Public Schools (CPS) is a district on the rise, serving over 320,000 students in 500+ schools and employing over 44,000 people, most of them teachers. CPS has set ambitious goals to ensure that every student, in every school and every neighborhood, has access to a world-class learning experience that prepares each for success in college, career, and civic life. In order to fulfill this mission, we make three commitments to our students, their families, and all Chicagoans: academic progress, financial stability, and integrity. Six core values are embedded within these commitments – student-centered, whole child, equity, academic excellence, community partnership, and continuous learning.
The Office of Information and Technology Services (ITS) works to build the capacity of schools to use information and technology, digital transformation, maintain network infrastructure, security standards, and support other departments to meet district goals. ITS provides innovative technology solutions that improve the quality of education for students, reduce the administrative burden on educators, facilitate parent interaction, increase community engagement, and support CPS’ mission of transparency by focusing on the ease and equity of access to information.
Job Summary:
Reporting to the Manager, Data Solutions, the Data Engineer is responsible for building and maintaining the District’s data infrastructure and data integration. This includes ensuring high-quality data is integrated between internal applications and our external partners. Additionally, the Data Engineer will be responsible for building and expanding an environment that supports data-informed decision making. This is a full-time, exempt position that will be paid for time worked on a salary basis.
Responsibilities:
Update and maintain the job schedule in Appworx scheduler.
Oversee the code repository, technical documentation store and deployment process.
Maintain the CPS Enterprise Data Warehouse and ODS builds. Model extensions to the existing Data Warehouse.
Design, develop, and deploy data pipelines. Implement data quality checks and validation rules to ensure data accuracy and consistency.
Ingest data from various sources (databases, files, APIs) and transform it into usable formats for analysis and reporting.
Collaborate with business stakeholders to understand data requirements and translate them into technical solutions. Support system and user acceptance testing activities, including issue resolution.
Create Dashboard pages and metrics within Microsoft Power BI and the CPS custom dashboard solution.
Ensure data integrity and data quality within the reporting presentation layer.
Contribute to the development and maintenance of data governance policies and procedures.
Other duties as assigned.
Qualifications:
Education Required:
· Bachelor's degree in Computer Science or related field from an accredited college or university.
Experience Required:
· Minimum of three (3) years of Data Warehouse experience is required.
· Experience with the following is preferred:
Basic exposure to any programming language (C, C++, VB, Python, R etc.).
DevOps engineering experience with Azure DevOps.
ETL tools such as (Azure Data Factory, SSIS, Ab Initio) in a development role.
SQL Objects, stored procedures, views, functions.
SSRS, Power BI or other reporting tools.
SQL Server versions.
Unix and Shell Scripting.
Microsoft Azure cloud technologies, including Data Factory, Synapse Analytics, Data Lake, and Azure SQL Database.
MDM Tools, such as Profisee or Informatica MDM.
Knowledge, Skills, and Abilities:
Strong ANSI SQL knowledge expertise.
Excellent written and oral communication skills, including the ability to present to a group.
Understanding of database objects (entities, attributes, constraints, relationships, joins etc.).
Ability to write SQL DDL and DML queries.
Knowledge of data modeling/Star Schema.
Ability and initiative to learn and research new concepts, ideas, and technologies quickly.
Strong systems/process orientation with demonstrated analytical thinking, organizational skills and problem-solving skills.
Ability to develop and organize high-quality documentation.
Strong interpersonal skills, including the ability to work in a team-oriented, collaborative environment.
Ability to quickly pick up new tools and technologies.
Willingness and ability to train and teach others.
Ability to facilitate meetings and follow up with resulting action items.
Ability to prioritize and execute tasks in a high-pressure environment.
Ability to effectively move forward on tasks even with ambiguous or changing requirements.
Conditions of Employment:
As a condition of employment with the Chicago Public Schools (CPS), employees are required to:
Establish/Maintain Chicago Residency - Employees are required to live within the geographic boundaries of the City of Chicago within six months of their CPS hire date and maintain residency throughout their employment with the district. The Chicago residency requirement does not apply to temporary/part-time positions, however, all CPS employees must be residents of Illinois.
CONNECT WITH US  Keep in touch to hear about our organization.

#J-18808-Ljbffr

u00A0
Data Analyst
u00A0
Mission:
Data Analysts provide data reporting and analysis, visualization, and dashboarding that typically supports one primary functional area at IDEA. The Data Analyst ensures that analytics used to inform decision-makers is rigorous, timely, clear, and reproducible. Data Analyst s work cross-functionally: they are formally on the Research and Analytics (R&A) team, which is responsible for their technical and professional development, and are connected to a functional team that partners on prioritizing and supporting management of their day-to-day work including recurring analyses, ad-hoc requests, and longer research projects.
Location:
This is a full-time remote position based in Texas, with preference given to candidates who live in Austin, El Paso, Houston, Permian Basin (Midland/Odessa), Rio Grande Valley, San Antonio, and Tarrant County (Fort Worth), or who are willing to relocate.
u00A0
Travel Expectations:u00A0u00A0u00A0u00A0
This role is generally remote, but travel to IDEA training events or step-backs maybe required.
u00A0
What Youu2019ll Do u2013 Accountabilities
u00A0
Essential Duties:
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Create clear analysis (e.g., descriptive, predictive, and causal) that highlights trends, relationships, and opportunities for improvement throughout the organization. u00A0
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Partner with Information Systems and Software Development to verify that data sources available for analyses and reporting are populated with u00A0 accurate u00A0 and u00A0 timely u00A0 data. u00A0
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Ensure that repeated analyses and reports (e.g., compensation reports) are designed in a reproducible, replicable manner which reduces u00A0 subsequent u00A0 re-analysis burdens. u00A0
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Provide u00A0 rapid turnaround for ad-hoc data analysis requests from stakeholders. u00A0
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Gather requirements and use cases from key stakeholders for each report/analysis/data request. u00A0
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Utilize project management best practices to set expectations with business partners and deliver against them. u00A0
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Use both data visualization and reporting best practices to share findings with partners and stakeholders. u00A0
u00A0
Additional Duties and Responsibilities:
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Utilize checkpoints during product and design to u00A0 solicit u00A0 adjusting feedback. u00A0
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Ensure that R&A products are easy to find and access. u00A0
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Create reports that u00A0 provide u00A0 clear, actionable, and time-sensitive recommendations. u00A0
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 100% of data sources used by R&A are documented, including how to access initial data sources, ETL process, and key transformations and metric calculations. u00A0
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 100% of statistical methods used and modeling choices are documented, including why the method was selected. u00A0
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 For ongoing products and reports (e.g., analytical summaries), the analysis lifecycle for ETL to final report is documented, in version control, and reproducible. u00A0
u00A0
Knowledge and Skills u2013 Competencies
Make Strategic Decisions: This individual is able to gather relevant information, consider various options, and make choices that are in line with their current responsibilities and the teamu2019s goals.
Manage Work and Teams: This individual focuses on managing their own work effectively. They develop skills in time management, task prioritization, and self-organization, ensuring that they meet their personal objectives and contribute effectively to their teams.
Grow Self and Others: This individual actively seeks feedback, embraces challenges as learning opportunities, and engages in professional development activities to enhance their own skills and performance.
Build a Culture of Trust:u00A0 This individual offers empathy and active listening to build deeper one-on-one relationships in their direct work with others. They are capable of coaching others and emphasizing importance of psychological safety in their interactions.
Communicate Deliberately : This individual can express ideas clearly and listen actively. They have developing skills in empathetic listening and responsive speaking, with ability to tailor messages for individual direct reports or peers with the aim to build stronger, more effective relationships.
u00A0
Additional Skills:
Data analysis and statistics:
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Analytical and problem-solving skills
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Experience with basic statistical analysis.
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Identify or collect data that is relevant to the problem/task/project
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Construct rapid, ad-hoc analyses to support district, regional, and school leadership u00A0 u00A0
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Introductory knowledge of predictive analytics and modeling/times series forecasting, causal inference, experimental research design and analysis, independent research, frequentist and Bayesian methods, natural language processing/large language models, demography/GIS

u00A0
Computational skills:
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Experience with BI and dashboarding tools like PowerBI , Tableau
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Experience with programming or scripting languages
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Experience handling large data sets and querying relational databases
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Support district compliance efforts by exporting and analyzing data from our data warehouse as well as other data systems u00A0 u00A0
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Work reproducibly (using literate programming practices like Rmarkdown /Quarto/ Jupyter Notebooks as well as version control (via Git/GitHub) so colleagues can support and extend your work u00A0
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Basic familiarity with computational languages such as R, Python, Julia, STATA, SQL, Matlab . u00A0 u00A0
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Basic familiarity with data visualization tools like ggplot2, Shiny, matplotlib, D3.js/Observable.js, PowerBI , Tableau u00A0 u00A0 u00A0
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Version control systems like git (preferred) or Subversion u00A0
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Familiarity with survey platforms like Microsoft Forms u00A0

u00A0
Domain knowledge:
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Perform analyses of education-related data (e.g., data on student performance, school operations, alumni outcomes, family sentiments, staff opinions, and staffing outcomes). u00A0 u00A0 u00A0

u00A0
Communication:
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Create clear reports for non-technical audiences, including insightful statistical visualizations that help non-statisticians make valid inferences u00A0 u00A0 u00A0
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Share learnings with internal and external stakeholders u00A0
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Strong verbal and written communication skills including creating, developing, and delivering presentations u00A0
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Ability to work collaboratively in a group environment as well as independently u00A0
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Reporting and data visualization skills
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Clear and concise interpretation of analytical reports
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Draw and contextualize conclusions derived from analysis

u00A0
Professional skills and ethics:
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Excellent customer service skills, both written and oral, and maintain confidentiality in all matters
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Ability to work in high-pressure situations
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Ability to work with stakeholders to assess potential risks
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Ability to set and meet deadlines
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Ability to backwards plan a project given a goal
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Ability to make sense of solve complex problems.
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Excellent attention to detail
u00A0
Required experience:
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Education: Bachelor's Degree required
u00A0
Preferred experience:
u00B7 u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0u00A0 Experience: 2+ years of professional work experience in a data analysis and management role
u00A0 u00A0 u00A0 u00A0 u00A0 u00A0 u00A0 u00A0 u00A0 u00A0 u00A0  Please note:  We are unable to sponsor work visas at this time.
Physical Requirements:
None
u00A0***Please provide cover letter with application***
What We Offer:
Compensation & Benefits:  u00A0 Salaries for people entering this role typically fall between $74,700 and $87,100, commensurate with relevant experience and qualifications and in alignment with internal equity.This role is also eligible for performance pay based on organizational performance and goal attainment. u00A0 u00A0 Additionally, we offer medical, dental, and vision plans, disability, life insurance, parenting benefits, flexible spending account options, generous vacation time, referral bonuses, professional development, and a 403(b) plan. You can find more information about our benefits at  https://ideapublicschools.org/careers/benefits/  . u00A0 * IDEA may offer a relocation stipend to defray the cost of moving for this role, if applicable. u00A0 u00A0  Application process:  Submit your application online through Jobvite. Please note that applications will be reviewed on an ongoing basis until the position is filled. Applicants are encouraged to apply as early as possible. u00A0 u00A0  Learn more about IDEA  u00A0 u00A0 At IDEA the Staff Culture and Belonging Team uses our Coreu00A0Values to promote human connection and a culture of integrity, respect, and belonging for all Team and Family members.u00A0 Learn more about our Commitment to Core Values here:  https://ideapublicschools.org/our-story/#core-values  u00A0 u00A0
u00A0

#J-18808-Ljbffr

Join to apply for the  Data Analyst - Growth (25-26)  role at  IDEA Public Schools
1 day ago Be among the first 25 applicants
Join to apply for the  Data Analyst - Growth (25-26)  role at  IDEA Public Schools
Mission

Data Analysts provide data reporting and analysis, visualization, and dashboarding that typically supports one primary functional area at IDEA. The Data Analyst ensures that analytics used to inform decision-makers is rigorous, timely, clear, and reproducible. Data Analysts work cross-functionally: they are formally on the Research and Analytics (R&A) team, which is responsible for their technical and professional development, and are connected to a functional team that partners on prioritizing and supporting management of their day-to-day work including recurring analyses, ad-hoc requests, and longer research projects.
Description

Data Analyst

Mission

Data Analysts provide data reporting and analysis, visualization, and dashboarding that typically supports one primary functional area at IDEA. The Data Analyst ensures that analytics used to inform decision-makers is rigorous, timely, clear, and reproducible. Data Analysts work cross-functionally: they are formally on the Research and Analytics (R&A) team, which is responsible for their technical and professional development, and are connected to a functional team that partners on prioritizing and supporting management of their day-to-day work including recurring analyses, ad-hoc requests, and longer research projects.

Location:

This is a full-time remote position based in Texas, with preference given to candidates who live in Austin, El Paso, Houston, Permian Basin (Midland/Odessa), Rio Grande Valley, San Antonio, and Tarrant County (Fort Worth), or who are willing to relocate.

Travel Expectations

This role is generally remote, but travel to IDEA training events or step-backs maybe required.

Essential Duties

What You’ll Do – Accountabilities

Create clear analysis (e.g., descriptive, predictive, and causal) that highlights trends, relationships, and opportunities for improvement throughout the organization.
Partner with Information Systems and Software Development to verify that data sources available for analyses and reporting are populated with accurate and timely data.
Ensure that repeated analyses and reports (e.g., compensation reports) are designed in a reproducible, replicable manner which reduces subsequent re-analysis burdens.
Provide rapid turnaround for ad-hoc data analysis requests from stakeholders.
Gather requirements and use cases from key stakeholders for each report/analysis/data request.
Utilize project management best practices to set expectations with business partners and deliver against them.
Use both data visualization and reporting best practices to share findings with partners and stakeholders.

Additional Duties And Responsibilities

Utilize checkpoints during product and design to solicit adjusting feedback.
Ensure that R&A products are easy to find and access.
Create reports that provide clear, actionable, and time-sensitive recommendations.
100% of data sources used by R&A are documented, including how to access initial data sources, ETL process, and key transformations and metric calculations.
100% of statistical methods used and modeling choices are documented, including why the method was selected.
For ongoing products and reports (e.g., analytical summaries), the analysis lifecycle for ETL to final report is documented, in version control, and reproducible.

Knowledge and Skills – Competencies

Make Strategic Decisions: This individual is able to gather relevant information, consider various options, and make choices that are in line with their current responsibilities and the team’s goals.
Manage Work and Teams: This individual focuses on managing their own work effectively. They develop skills in time management, task prioritization, and self-organization, ensuring that they meet their personal objectives and contribute effectively to their teams.
Grow Self and Others: This individual actively seeks feedback, embraces challenges as learning opportunities, and engages in professional development activities to enhance their own skills and performance.
Build a Culture of Trust: This individual offers empathy and active listening to build deeper one-on-one relationships in their direct work with others. They are capable of coaching others and emphasizing importance of psychological safety in their interactions.
Communicate Deliberately: This individual can express ideas clearly and listen actively. They have developing skills in empathetic listening and responsive speaking, with ability to tailor messages for individual direct reports or peers with the aim to build stronger, more effective relationships.

Additional Skills

Data analysis and statistics:

Analytical and problem-solving skills
Experience with basic statistical analysis.
Identify or collect data that is relevant to the problem/task/project
Construct rapid, ad-hoc analyses to support district, regional, and school leadership
Introductory knowledge of predictive analytics and modeling/times series forecasting, causal inference, experimental research design and analysis, independent research, frequentist and Bayesian methods, natural language processing/large language models, demography/GIS

Computational Skills

Experience with BI and dashboarding tools like PowerBI, Tableau
Experience with programming or scripting languages
Experience handling large data sets and querying relational databases
Support district compliance efforts by exporting and analyzing data from our data warehouse as well as other data systems
Work reproducibly (using literate programming practices like Rmarkdown/Quarto/Jupyter Notebooks as well as version control (via Git/GitHub) so colleagues can support and extend your work
Basic familiarity with computational languages such as R, Python, Julia, STATA, SQL, Matlab.
Basic familiarity with data visualization tools like ggplot2, Shiny, matplotlib, D3.js/Observable.js, PowerBI, Tableau
Version control systems like git (preferred) or Subversion
Familiarity with survey platforms like Microsoft Forms

Domain Knowledge

Perform analyses of education-related data (e.g., data on student performance, school operations, alumni outcomes, family sentiments, staff opinions, and staffing outcomes).

Communication

Create clear reports for non-technical audiences, including insightful statistical visualizations that help non-statisticians make valid inferences
Share learnings with internal and external stakeholders
Strong verbal and written communication skills including creating, developing, and delivering presentations
Ability to work collaboratively in a group environment as well as independently
Reporting and data visualization skills
Clear and concise interpretation of analytical reports
Draw and contextualize conclusions derived from analysis

Professional Skills And Ethics

Excellent customer service skills, both written and oral, and maintain confidentiality in all matters
Ability to work in high-pressure situations
Ability to work with stakeholders to assess potential risks
Ability to set and meet deadlines
Ability to backwards plan a project given a goal
Ability to make sense of solve complex problems.
Excellent attention to detail

Required Experience

Education: Bachelor's Degree required

Preferred Experience

Experience: 2+ years of professional work experience in a data analysis and management role

Please note:  We are unable to sponsor work visas at this time.

Physical Requirements

None

***Please provide cover letter with application***

What We Offer

Compensation & Benefits:

Salaries for people entering this role typically fall between $74,700 and $87,100, commensurate with relevant experience and qualifications and in alignment with internal equity. This role is also eligible for performance pay based on organizational performance and goal attainment.

Additionally, we offer medical, dental, and vision plans, disability, life insurance, parenting benefits, flexible spending account options, generous vacation time, referral bonuses, professional development, and a 403(b) plan. You can find more information about our benefits at https://ideapublicschools.org/careers/benefits/.

IDEA may offer a relocation stipend to defray the cost of moving for this role, if applicable.

Application Process

Submit your application online through Jobvite. Please note that applications will be reviewed on an ongoing basis until the position is filled. Applicants are encouraged to apply as early as possible.

Learn More About IDEA

At IDEA the Staff Culture and Belonging Team uses our Core Values to promote human connection and a culture of integrity, respect, and belonging for all Team and Family members. Learn more about our Commitment to Core Values here: https://ideapublicschools.org/our-story/#core-values
Seniority level    Seniority level Mid-Senior level
Employment type    Employment type Full-time
Job function    Job function Information Technology
Industries Education Administration Programs
Referrals increase your chances of interviewing at IDEA Public Schools by 2x
Get notified about new Data Analyst jobs in  Hidalgo County, TX .
Data Annotator (No Prior Experience Needed)  Data Annotator (No Prior Experience Needed)  Data Annotator (No Prior Experience Needed)  San Juan, TX $140,000.00-$185,000.00 2 days ago
McAllen, TX $175,000.00-$230,000.00 1 day ago
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr

Question	Topic	Difficulty	Ask Chance
Slacking Employees Salaries	SQL	Medium	Very High
Player Analysis	SQL	Easy	Very High
Sequentially Fill in Integers	SQL	Hard	Very High

Chicago Public Schools Business Intelligence Interview Guide

Overview

Chicago Public Schools Business Intelligence Interview Process

Chicago Public Schools Business Intelligence Interview Questions

Chicago Public Schools Business Intelligence Jobs