The City Of Philadelphia Business Intelligence interview guide, interview questions, salary data, and interview experiences.

City Of Philadelphia Business Intelligence Interview Guide

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


Getting ready for an Business Intelligence interview at City Of Philadelphia? The City Of Philadelphia Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

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

Overview

City Of Philadelphia 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.

City Of Philadelphia 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 identify customers who placed more than three transactions each in both 2019 and 2020.</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>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>
</tbody>
</table>
<p> 
<strong>Output:</strong></p>

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

<tbody>
<tr>
<td><code>customer_name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>


<p>Which of the following queries will return a list of customers and the total amount they have spent on orders?</p>


Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

City Of Philadelphia Business Intelligence Interview Questions

<strong>Company Description</strong><br><br>A best-in-class city that attracts best-in-class talent, Philadelphia is an incredible place to build a career. From our thriving arts scene and rich history to our culture of passion and grit, there are countless reasons to love living and working here. With a workforce of over 30,000 people, and more than 1,000 different job categories, the City of Philadelphia offers boundless opportunities to make an impact.<br><br>As an employer, the City of Philadelphia values inclusion, integrity, innovation, empowerment, and hard work above all else. We offer a vibrant work environment, comprehensive health care and benefits, and the experience you need to grow and excel. If you're interested in working with a passionate team of people who care about the future of Philadelphia, start here.<br><br><strong>What we offer</strong><br><ul><li><strong>Impact </strong>- The work you do here matters to millions. </li><li><strong>Growth</strong> - Philadelphia is growing, why not grow with it? </li><li><strong>Diversity & Inclusion</strong> - Find a career in a place where everyone belongs.</li><li><strong>Benefits</strong> - We care about your well-being.</li></ul><br><strong>Agency Description</strong><br><br>The mission of the Department of Revenue is to collect tax and non-tax revenue due to the City and tax revenue due to the School District of Philadelphia while providing service to customers that is fair and efficient and ensuring that the City provides services that the residents can see, touch, and feel. The Department's collections enable the Administration to invest in the Mayor's strategic priorities, including housing, education, and making Philadelphia the safest, cleanest, and greenest big city in the nation with economic opportunity for everyone.<br><br><strong>Job Description</strong><br><br><strong>Position Summary:</strong><br><br>The Business Analyst or (Philadelphia Revenue Information System Manager (PRISM) Support Liaison (PSL)) will join an established, experienced, and dynamic team responsible for the continuous improvement of PRISM, the Department of Revenue's tax software system. The PRISM team works in a supportive and cooperative environment that values asking questions, new ideas, and continuous learning. PSLs develop expertise in a particular functional area of PRISM through teamwork and work with their counterpart subject matter experts in Department of Revenue operational units.<br><br>The PRISM Support Liaison is responsible for daily coordination with operations to collect, understand, and analyze information related to the organization and its processes to apply Revenue's Tax System (PRISM) practicality. Work with the selected vendor to analyze processing problems so the vendor may develop and implement solutions to system issues. The position functions and primary subject matter expert to connect PRISM system functions with practical applications for end users. The position recommends solutions or alternative practices to improve systems or communication, including developing letters for taxpayers. Gathering and organizing information about problems or procedures to be improved and partnering with stakeholders to resolve problems is a significant aspect of the work.<br><br>Day-to-day work includes responding to requests for system changes, testing software improvements before they are rolled out, and participating in design sessions for version updates. The PSL team also supports business users directly through consultation, needs assessment, troubleshooting, and training in partnership with the training team.<br><br><strong>Essential Functions:</strong><br><ul><li>Assist in creating/maintaining Standard Operating Procedures for each unit.</li><li>Perform testing of SQRs or identification of appropriate testing resources.</li><li>Assist with the maintenance of training guides and help topics.</li><li>Participate in Letters and Forms Committees by applying PRISM subject matter expertise.</li><li>Coordinate with Revenue business units to collect, understand, and analyze data related to organizational processes and implementation of PRISM applications.</li><li>Work with Revenue business units to recommend, plan, prioritize, and implement changes for system improvement.</li><li>Build test data, identify resources, and perform testing of software, customer accounts, and scenarios that evaluate product functionality and imitate end-user experiences.</li><li>Perform quality assurance testing to</li><li>Verify the functionality of products, product updates, and new features before public release.</li><li>Ensure improvements meet organizational quality standards.</li><li>Identify and remedy operational defects within the software production processes before migration into production.</li><li>Collaborate with Revenue business units and external end-users to investigate, identify and validate customer complaints and product issues.</li><li>Facilitate and lead design sessions (including letters) to analyze work processes and develop strong requirements to meet stakeholder goals.</li><li>Analyze and design updates related to Gentax service pack enhancements, new versions of Gentax, business or legislative changes, tickets, and other projects.</li><li>Provide internal customer support for Revenue business units.</li><li>Communicate and advocate for business process changes that project goals and initiatives necessitate.</li><li>Work with users to ensure compliance and consistency in executing newly implemented processes.</li><li>Build and maintain collaborative and consultative relationships with system developers, Revenue business users, and OIT staff.</li></ul><br><strong>Competencies, Knowledge, Skills and Abilities:</strong><br><ul><li>Knowledge of business and personal taxes and how they are applied in a tax system.</li><li>Knowledge of laws, rules, regulations, and procedures concerned with municipal revenue collections.</li><li>Ability to prepare for and lead small group meetings through a defined agenda to achieve team goals.</li><li>Interest in analytically deconstructing issues and brainstorming potential solutions.</li><li>Flexibility for a dynamic project-like work environment where one day is never the same as the next</li><li>Desire to learn new things, grow skills, and support team members in doing the same.</li><li>Proficient in Microsoft Office applications and interested in learning new software tools.</li><li>Knowledge of Revenue collection operations, processes, and procedures</li><li>Skilled in informing and communicating with others on Revenue-related business or operational matters.</li><li>Skilled in conducting research and preparing reports.</li><li>Skilled in training personnel in organizational or compliance procedures</li><li>Ability to establish effective relationships with staff, vendors, strategic partners, the public, and their representatives.</li><li>Able to handle complaints, settle disputes, and resolve grievances and conflicts or otherwise negotiate with others.</li><li>Ability to build effective relationships and a strong commitment to working collegially and collaboratively with constituents at all levels in a diverse and distributed environment.</li><li>Ability to provide guidance and expert advice to management or other groups on technical, systems, or process-related topics.</li></ul><br><br><strong>Qualifications</strong><br><br>The ideal candidate will have at least three years of experience in a large organization or division involved in revenue collection, working on and/or leading project teams.<br><br><strong>Additional Information</strong><br><br><strong>TO APPLY:</strong> <strong>Interested candidates must submit a resume.</strong><br><br>Salary Range: $60,000 - $75,000<br><br><strong>Discover the Perks of Being a City of Philadelphia Employee:</strong><br><ul><li><strong>Transportation</strong>: City employees get unlimited <strong>FREE</strong> public transportation all year long through SEPTA's Key Advantage program. Employees can ride on SEPTA buses, subways, trolleys, and regional rail for their daily commute and more.</li><li>Parental Benefits: The City offers its employees 6 weeks of paid parental leave.</li><li>We offer Comprehensive health coverage for employees and their eligible dependents.</li><li>Our wellness program offers eligibility into the discounted medical plan</li><li>Employees receive paid vacation, sick leave, and holidays</li><li>Generous retirement savings options are available</li><li><strong>Pay off your student loans faster</strong> - As a qualifying employer, City of Philadelphia employees are eligible to participate in the Public Service Loan Forgiveness program. Join the ranks of hundreds of employees who have already benefited from this program and achieved student loan forgiveness.</li><li><strong>Unlock Tuition Discounts and Scholarships</strong> - The City of Philadelphia has forged partnerships with over a dozen esteemed colleges and universities in the area, ensuring that our employees have access to a wide range of tuition discounts and scholarships. Experience savings of 10% to 40% on your educational expenses, extending not only to City employees but in some cases, spouse and dependents too!</li></ul><br>Join the City of Philadelphia team today and seize these incredible benefits designed to enhance your financial well-being and personal growth!<br><br><strong>*The successful candidate must be a city of Philadelphia resident within six months of hire</strong><br><br>Effective May 22, 2023, vaccinations are <strong>no longer required</strong> for new employees that work in non-medical, non-emergency or patient facing positions with the City of Philadelphia. As a result, only employees in positions providing services that are patient-facing medical care (ex: Nurses, doctors, emergency medical personnel), must be fully vaccinated.<br><br>The City of Philadelphia is an Equal Opportunity employer and does not permit discrimination based on race, ethnicity, color, sex, sexual orientation, gender identity, religion, national origin, ancestry, age, disability, marital status, source of income, familial status, genetic information or domestic or sexual violence victim status. If you believe you were discriminated against, call the Philadelphia Commission on Human Relations at 215-686-4670 or send an email to faqpchr@phila.gov.<br><br>For more information, go to: Human Relations Website: http://www.phila.gov/humanrelations/Pages/default.aspx

City Of Philadelphia Business Intelligence Interview Guide

Overview

City Of Philadelphia Business Intelligence Salary

City Of Philadelphia Business Intelligence Interview Process

City Of Philadelphia Business Intelligence Interview Questions

City Of Philadelphia Business Intelligence Jobs