The Texas education agency Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Texas education agency Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Texas education agency? The Texas education agency 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 Texas education agency Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Texas education agency.</li>
<li>Practice real Texas education agency 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 Texas education agency Business Intelligence interview.</p>


Getting ready for an Business Intelligence interview at Texas education agency? The Texas education agency Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Texas education agency Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Texas education agency.
- Practice real Texas education agency 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 Texas education agency Business Intelligence interview.
        

Overview

Texas education agency Business Intelligence Salary

<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.

Texas education agency Business Intelligence Interview Process

<p>We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.</p>

<p>Write a query to get the total three-day rolling average for deposits by day.</p>

<p><em>Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout</em></p>

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

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

<p><code>bank_transactions</code> table</p>

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

<tbody>
<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

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

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

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Rolling Bank Transactions

<p>Write a query to identify the manager with the biggest team size.</p>

<p>You may assume there is only one manager with the largest team size.</p>

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

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

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

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

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

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

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>managers</code> table</p>

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

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

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

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

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

<tbody>
<tr>
<td><code>manager</code></td>
<td>VARCHAR</td>
</tr>

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


Manager Team Sizes

<p>Write a query to show the number of users, number of transactions placed, and total order amount per month in the year 2020. Assume that we are only interested in the monthly reports for a single year (January-December).</p>

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

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

<p><code>transactions</code> table</p>

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

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

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>products</code> table</p>

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

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

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

<tr>
<td><code>price</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><code>users</code> table</p>

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

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

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

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

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

<tbody>
<tr>
<td><code>month</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_customers</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_orders</code></td>
<td>INTEGER</td>
</tr>

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


Monthly Customer Report

Texas education agency Business Intelligence Interview Questions

<p>MISSION: The Texas Education Agency (TEA) will improve outcomes for all public-school students in the state by providing leadership, guidance, and support to school systems.

Core Values We are Determined: We are committed and intentional in the pursuit of our main purpose, to improve outcomes for students.
We are People-Centered: We strive to attract, develop, and retain the most committed talent, representing the diversity of Texas, each contributing to our common vision for students.
We are Learners: We seek evidence, reflect on success and failure, and try new approaches in the pursuit of excellence for our students.
We are Servant Leaders: Above all else, we are public servants working to improve opportunities for students and provide support to those who serve them.
Salary Range: The posted salary range budgeted for this position is between $6,681.16 and $8,990.33 monthly. New hires will typically be brought into the agency at a starting salary between the posted minimum and the average pay of employees in their same classification in the Office of Technology. Offers will be commensurate with the candidate’s experience and qualifications and will thoughtfully consider internal pay equity for agency staff who perform similar duties and have similar qualifications.

Position Overview: The Business Analyst Supervisor position at the Texas Education Agency (internally referred to as the PMO Business Analyst Supervisor) works on multiple applications that serve teachers and school districts, gather student and school data, manage funding, and provide compliance oversight (such as the Foundation School Funding and Educator Certification) for all Texas public schools. These applications help TEA improve outcomes for all of Texas’ 5 million plus students.

The PMO Business Analyst Supervisor serves as the conduit between the program/customer community and the software development team. Work involves managing and overseeing the gathering, development, and documentation of user requirements; mentoring team members; the review, assessment, and development of business processes; the performance of post-implementation support of systems; and support of the systems development life cycle. Supervise the work of up to three (3) direct reports. This position will report to the PMO Business Analysis Manager and works under the Senior Director of Data Standards, Data Quality, and Business Analysis within the Office of Information Technology.

Flexible work location within the state of Texas may be considered for qualified candidates.

Application Requirements: A cover letter, resume, and short answer responses are required attachments for applying to this position. Incomplete applications will not be considered. Applicants who are strongly being considered for employment must submit to a national criminal history background check.

Essential Functions: Oversight – Supervises, oversees, assesses, and reviews user requirements and deliverables to automate or improve software systems.
Mentoring – Supervises and mentors staff on policies, processes, and procedures.
Elicitation & Analysis – Elicits requirements using various methods including interviews, workshops, and document analysis.
Requirements Writing – Transforms information from elicitation sessions into business and functional requirements.
Managing Work - Uses initiative and independent judgment to actively participate in the software development lifecycle.
Qualifications:
MINIMUM QUALIFICATIONS:
Education: Graduation from an accredited four-year college or university.

Experience: At least six (6) years of experience as a dedicated business analyst, including: Eliciting requirements from interviews with customers.
Writing system requirements documents for large and complex project(s).
Leading a complete and detailed analysis of business processes.
And at least one (1) year of experience working as a Lead BA, or in a lead or supervisory role.

Substitutions: Each additional year of related experience above the required minimum may substitute for education on a year-for-year basis.

Other Qualifications: Experience with software development life cycle concepts.
Understanding of requirements engineering according to software lifecycle methodologies.
Experience in developing creative solutions to complex problems.
Ability to communicate technical concepts to professional, non-technical clients.

As an equal opportunity employer, we hire without consideration to race, religion, color, national origin, sex, disability, age or veteran status.
No phone calls or emails, please. Only candidates selected for interview will be contacted.
#J-18808-Ljbffr</p>

Texas education agency Business Intelligence Interview Guide

Overview

Texas education agency Business Intelligence Salary

Texas education agency Business Intelligence Interview Process

Texas education agency Business Intelligence Interview Questions

Texas education agency Business Intelligence Jobs