The Granicus Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Granicus Business Intelligence Interview Guide

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


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

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

Overview

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

Granicus 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>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>What are the logistic and softmax functions? What is the difference between the two?</p>

<p>What makes them useful for use in logistic regression?</p>


<p>In logistic regression, how is the predicted class determined based on the logistic function?</p>


In logistic regression, how is the predicted class determined based on the logistic function?

Softmax vs Logistic II

<p>What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?</p>


What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

Softmax vs Logistic I

What are the logistic and softmax functions? What is the difference between the two?

Softmax vs Logistic

Granicus Business Intelligence Interview Questions

The Company Serving the People Who Serve the People Granicus is driven by the excitement of building, implementing, and maintaining technology that is transforming the Govtech industry by bringing governments and their constituents together. We are on a mission to support our customers by meeting the needs of their communities and implementing our technology in ways that are equitable and inclusive. Granicus has consistently appeared on the GovTech 100 list over the past 5 years and has been recognized as the best companies to work on BuiltIn. Over the last 25 years, we have served 5,500 federal, state, and local government agencies and more than 300 million citizen subscribers powering an unmatched Subscriber Network that uses our digital solutions to make the world a better place. With comprehensive cloud-based solutions for communications, government website design, meeting and agenda management software, records management, and digital services, Granicus empowers stronger relationships between government and residents across the U.S., U.K., Australia, New Zealand, and Canada. By simplifying interactions with residents, while disseminating critical information, Granicus brings governments closer to the people they serve-driving meaningful change for communities around the globe. Want to know more? See more of what we do here. The Senior Software Engineer - Fullstack is a key technical person in the shared services team. Granicus shared services team is on a journey of developing platform services which will be used across Granicus product portfolio. This a front-runner team who evaluates latest technologies, embraces and evangelize the solutions across Granicus for adoption. The Senior Software Engineer is a go-to technical resource for anyone in the broader Granicus technology organization. They fully understand the deployment and support of applications in all environments and are an excellent mentor to groups and individuals within and outside of the development team. What your impact will look like here: Opportunity to continuously work on cutting-edge technologies. Build highly scalable distributed systems and services. Be a core maintainer of multiple services within the Granicus shared services platform. Collaborate with product management and business stakeholders to deliver SaaS based solutions. Evolve as an expert in multi-discipline such as Cloud, Microservices, Platform Engineering and DevOps. You will love this job if you have: 4 - 8 years of experience developing, testing, shipping, and supporting production-quality PaaS/SaaS solutions. Strong understanding of AWS services, including SES, Pinpoint, Lambda, RDS, API Gateway, and DynamoDB, AWS EKS. Full-stack development experience with React, Java, and GoLang. Hands-on engineer who can develop microservices and deploy it on Kubernetes. Strong exposure to Kafka Streams and both NoSQL and SQL databases (PostgreSQL preferred). Experience building and maintaining CI/CD pipelines. Strong analytical and problem-solving skills Passion for learning new things and the ability to do so quickly. Ability to serve as a technical leader of an open, collaborative, and extraordinarily skilled software development team The Process - Assessment - Take a quick assessment. - Phone screen - Speak to one of our talented recruiters to ensure this could be a fit. - Coding - Take a quick coding test online. - Hiring Manager/Panel interview - Talk to the hiring manager so they can learn more about you and you about Granicus. Meet more members on the team! Learn more and share more. - Reference checks - Provide 2 references so we can hear about your awesomeness. - Verbal offer - Let's talk numbers, benefits, culture and answer any questions. - Written offer - Sign a formal letter and get excited because we sure are! Benefits at Granicus India Along with the challenges of the job, Granicus offers employees an attractive benefits package which includes - - Hospitalization Insurance Policy covering employees and their family members including parents - All employees are covered under Personal Accident Insurance & Term Life Insurance policy - All employees can avail annual health check facility - Eligible for reimbursement of telephone and internet expenses - Wellness Allowance to avail health club memberships and/or access to physical fitness centres - Wellbeing Wednesdays which includes 1x global Unplug Day and 2x No Meeting Days every quarter - Memberships for 'meditation and mindfulness ' apps including on-demand mental health support 24/7 - Access to learning management system Say., Udemy Learning Premium account membership & many more - Access to Rewards & recognition portal and quarterly recognition program Don't have all the skills/experience mentioned above? At Granicus, we are trying to build diverse, inclusive teams. We do not have degree requirements for most of our roles. If you don't meet every requirement above but are excited to learn more, we encourage you to apply. We might just be able to find another role that could be a perfect fit! Security and Privacy Requirements - Responsible for Granicus information security by appropriately preserving the Confidentiality, Integrity, and Availability (CIA) of Granicus information assets in accordance with the company's information security program. - Responsible for ensuring the data privacy of our employees and customers, their data, as well as taking all required privacy training in a timely manner, in accordance with company policies. The Team - We are a remote-first company with a globally distributed workforce across the United States, Canada, United Kingdom, India, Armenia, Australia, and New Zealand. The Culture - At Granicus, we are building a transparent, inclusive, and safe space for everyone who wants to be a part of our journey. - A few culture highlights include - Employee Resource Groups to encourage diverse voices - Coffee with Mark sessions - Our employees get to interact with our CEO on very important and sometimes difficult issues ranging from mental health to work-life balance and current affairs. - Microsoft Teams communities focused on wellness, art, furbabies, family, parenting, and more.-=- - We bring in special guests from time to time to discuss issues that impact our employee population The Impact - We are proud to serve dynamic organizations around the globe that use our digital solutions to make the world a better place - quite literally. We have so many powerful success stories that illustrate how our solutions are impacting the world. See more of our impact here. Granicus is committed to providing equal employment opportunities. All qualified applicants and employees will be considered for employment and advancement without regard to race, color, religion, creed, national origin, ancestry, sex, gender, gender identity, gender expression, physical or mental disability, age, genetic information, sexual or affectional orientation, marital status, status regarding public assistance, familial status, military or veteran status or any other status protected by applicable law. GovDelivery is committed to providing equal employment opportunities without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.

Granicus Business Intelligence Interview Guide

Overview

Granicus Business Intelligence Salary

Granicus Business Intelligence Interview Process

Granicus Business Intelligence Interview Questions

Granicus Business Intelligence Jobs