Prepare for and practice interview questions from City and county of denver.

City and county of denver Interview Questions

the secret is out: denver is the nation’s top place to live, work, and play. u.s. news and world report ranked denver as the best place to live in the united states in its 2016 best places to live study. denver boasts 300 days of sunshine annually, the largest city park system in the nation with 2,500 acres of natural areas, the second largest performing arts center in the country, and so much more! being the best place to live isn’t easy; maintaining such a reputation means we need the best people working for the residents of denver. people who want to make a difference; people who want to give back; people who want to be at the heart of the city and have a hand in creating its future. be a part of the city that you love. where denver works. for our social media privacy policy, please visit https://www.denvergov.org/content/denvergov/en/city-of-denver-home/terms-of-use.html

the secret is out: denver is the nation’s top place to live, work, and play. u.s. news and world report ranked denver as the best place to live in the united states in its 2016 best places to live study. denver boasts 300 days of sunshine annually, the largest city park system in the nation with 2,500 acres of natural areas, the second largest performing arts center in the country, and so much more! being the best place to live isn’t easy; maintaining such a reputation means we need the best people working for the residents of denver. people who want to make a difference; people who want to give back; people who want to be at the heart of the city and have a hand in creating its future. be a part of the city that you love. where denver works. for our social media privacy policy, please visit https://www.denvergov.org/content/denvergov/en/city-of-denver-home/terms-of-use.html

Overview

City and county of denver Interview Guides

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</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>

Write a query to randomly sample a row from a big table.

Random SQL Sample

Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

City and county of denver Salaries by Position

About Our Job Are you excited about the idea of building new systems? Looking for a chance to be creative? Want to wear multiple hats and get involved in different technical areas? Looking for a fun team to support you? Can you play nice with both humans and machines? Are you an ardent learner who is always looking to improve? This is the place for you! The Denver County Court (DCC) is seeking an Associate IT Business Analyst to join our specialized team. Who We Are The mission of Denver County Court is to administer justice fairly, efficiently, and effectively; provide excellent customer service, and foster a positive environment where employees enjoy their work. The City and County of Denver's third branch of government is comprised of 19 judges, 4 full-time magistrates, and 300 staff members. Case types include state, civil, small claims, traffic, criminal, and other general sessions cases within the City and County of Denver. The Denver County Court proudly serves the community and continually seeks ways to incorporate procedural fairness and evidence-based practices. The Division The Court IT Department team consists of 4 System Administrators, 4 Developers, Data and Business Analysts, Infrastructure Supervisor, and an IT Director. As a small team, we strive to create a culture that fosters open communication, goal orientation and results. The team supports each other while providing a fun environment. Our employees value teamwork, customer service, a positive work environment, collaboration, learning, process improvement, and problem-solving. We are committed to helping people, creating, and maintaining an accurate court record, and providing support services to the Judicial Officers. For more information, please visit the Denver County Court website at https://www.denvercountycourt.org. What We Offer The City and County of Denver offers a competitive salary commensurate with education and experience. The salary range for this position is $70,765.00 - $116,762.00. We also offer generous benefits for full-time employees which include but is not limited to: <ul><li>A guaranteed life-long monthly pension, once vested after 5 years of service </li> <li>457B Retirement Plan </li> <li>132 hours of PTO earned within first year </li><li>11 Paid Holidays per year, plus 1 personal holiday, and 8 hours of Denver Good Deeds volunteer time </li><li>Education Refund Program (ERP) - a chance for the city to support your continued learning and career growth by investing in your future with the city </li><li>Care Bank - 8 weeks of Paid Family Leave (after the probation period is passed) </li><li>Free RTD Eco Pass </li><li>Competitive medical, dental and vision plans effective within 1 month of start date </li> </ul>Location The office hours are Monday through Friday 8:00AM - 5:00PM, with the possibility for two work from home days a week upon the successful completion of probation. This position will work at the Denver Post Building 101 W Colfax Ave. Denver, CO 80202. The Job As an Associate IT Business Analyst, you can expect to: <ul> <li>Perform requirements gathering, functional decomposition, workflow analysis and logical design tasks </li><li>Be a part of a dynamic, collaborative, and specialized team </li><li>Interpret and analyze IT impacts regarding legislative changes </li><li>Assists with internal and external data requests including Colorado Open Records Act (CORA) </li><li>Serve as a customer liaison for technology services </li><li>Perform some QA testing and auditing for data integrity </li><li>Collaborate with various internal and external stakeholders </li><li>Work closely with the Court Data Management Analyst </li><li>Perform some lead work </li></ul>Perks <ul> <li>Training provided for you to stay up to date in the ever-changing technology era </li><li>Ability to be cross functional and learn about multiple areas within IT </li><li>Ability to be creative and find solutions </li><li>FUN team! </li></ul>What You'll Bring The ideal candidate must be able to communicate effectively and be open to new technology and innovative ideas. Additionally, the candidate will have the following: <ul> <li>Experience with SQL Server </li><li>Experience writing queries, working in Power BI, and stored procedures </li><li>Desire to always learn and improve </li><li>Collaborative and supportive team spirit </li></ul>Required Minimum Qualifications We realize your time is valuable so please do not apply if you do not have at least the following required minimum qualifications: <ul> <li>Education requirement: Bachelor's Degree in Computer Science, Information Systems or a related field. </li><li>Experience Requirement: Two (2) years of professional level experience working on an integrated technology software system development and/or production support team. </li><li>Education/Experience Equivalency: One (1) year of the appropriate type and level of experience may be substituted for each required year of post-high school education. Additional appropriate education may be substituted for the minimum experience requirements. </li><li>License/Certifications: Must obtain Criminal Justice Information Services (CJIS) clearance within the probationary period. </li> <li>Licenses and certifications must be kept current as a condition of employment. </li></ul>To be considered for this position, you must include the following on your job application (upload the multiple attachment(s) to the Resume/CV section on the My Experience tab): <ul> <li>Resume - Required </li><li>Cover Letter - Required </li></ul> Application Deadline This position is expected to stay open until Monday, November 11, 2024. Please submit your application as soon as possible and no later than November 11, 2024, at 11:59PM to ensure consideration. About Everything Else Job Profile CI3126 IT Business Analyst Associate To view the full job profile including position specifications, physical demands, and probationary period, click here. Position Type Unlimited Position Salary Range $70,765.00 - $116,762.00 Starting Pay Based on education and experience Agency Denver County Court The City and County of Denver provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, national origin, sex, sexual orientation, gender identity, national origin, disability, genetic information, age, or any other status protected under federal, state, and/or local law. It is your right to access oral or written language assistance, sign language interpretation, real-time captioning via CART, or disability-related accommodations. To request any of these services at no cost to you, please contact Jobs@Denvergov.org with three business days' notice. Applicants for employment with the City and County of Denver must have valid work authorization that does not require sponsorship of a visa for employment authorization in the U.S. For information about right to work, click here for English or here for Spanish.

City and county of denver Interview Questions

Overview

City and county of denver Interview Guides

City and county of denver Interview Questions

City and county of denver Salaries by Position

City and county of denver Opening Jobs