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

Here Business Intelligence Interview Guide

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


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

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

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

<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

Here Business Intelligence Interview Questions

<h3>What's the role?</h3><br/><p>You will be working on a range of projects by exploring, analysing, and visualising the worlds largest spatial data store. You will analyse valuable geographic data sources to detect hidden insights and develop new applications for HEREs extensive library of global spatial data. Additionally, you will have the opportunity to visualise these insights across various platforms, enabling effective storytelling for HERE and our customers.</p><br/><h3>Responsibilities include:</h3><br/><ol><br/><li>Working across projects that cover the full extent of the HERE data library.</li><br/><li>Deepening your knowledge of the automotive, transport, and logistics industries.</li><br/><li>Exploring geospatial software and platforms such as the HERE Platform, Esri suite, QGIS, FME, and open-source options.</li><br/><li>Building machine learning models to make predictions or identify clusters using statistical methods on geospatial data.</li><br/></ol><br/><h3>Who are you?</h3><br/><h3>Skills</h3><br/><ul><br/><li>Bachelor's or Master's degree, preferably in GIS, Computer Science, or related fields.</li><br/><li>Strong understanding of data science, especially geodata science and statistical skills.</li><br/><li>Ability to tell stories and deliver insights through visualisation tools.</li><br/><li>Experience with machine learning techniques applied to spatial data.</li><br/><li>Familiarity with QGIS, FME, ArcGIS, or similar tools for data analysis and visualisation.</li><br/><li>Curiosity and eagerness for knowledge and exploration.</li><br/><li>Ability to work well in a team and communicate effectively in English.</li><br/><li>Documenting and presenting work clearly.</li><br/></ul><br/><p>Dont worry if you dont meet all the skills listed. We value a passion for learning and a unique skill set. Bring your enthusiasm and skills, and lets explore what you can achieve!</p><br/><h3>About HERE</h3><br/><p>HERE is a global leader in map making for automotive and multi-industry applications. Our technology is integrated into vehicles, smartphones, and third-party apps worldwide. We are committed to moving people, businesses, and cities forward through innovative location data and technology. Join us to work with a dynamic, fun, and innovative team exploring new geospatial frontiers.</p><br/>#J-18808-Ljbffr

What's the role?

Continuously seek out best practices and develop skills.

Work on multidisciplinary teams of data engineers, software engineers, and business subject-matter experts to deliver complex projects on time and within budgets.

Work with a mentor to translate ambiguous and complex business problems into project charters identifying technical risks and project scope.

Take ownership of the data science workflow including exploratory data analysis, model development, and potential deployment.

Independently handle issues with minimal supervision, while working closely with a mentor for more complex issues.

Other duties as assigned

Who are you?

Currently enrolled in a Masters or PhD program in Data Science, Machine Learning, Computer Science, Data Engineering Statistics, Mathematics, Engineering, Physics, or related fields

Proficiency in Python and SQL

Excellent communication skills, both written and verbal

Interested in learning model deployment in a production setting

This is a full-time paid internship (20 to 40 hours per week) with a fixed hourly rate of depending on your level of education as follows:

Undergraduate Students: $25/hr

Graduate Students: $30/hr

PhD Students: $35/hr

Life at HERE comes with generous benefits to support your health and overall wellness. Benefits available to US-based HERE employees include health (Medical/Dental/Vision) insurance and retirement savings plans.

Pursuant to the San Francisco Fair Chance Ordinance and the Los Angeles Fair Chance Initiative for Hiring, HERE will consider for employment qualified applicants with arrest and conviction records.

HERE is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, age, gender identity, sexual orientation, marital status, parental status, religion, sex, national origin, disability, veteran status, and other legally protected characteristics.

Under Section 503 of the Rehabilitation Act of 1973 and VEVRAA, we have developed an affirmative action program (AAP) for individuals with disabilities and protected veterans. Portions of the AAP are available for review by applicants and employees through our People Team.

#LI-AG3

Who are we?
HERE Technologies is a location data and technology platform company. We empower our customers to achieve better outcomes – from helping a city manage its infrastructure or a business optimize its assets to guiding drivers to their destination safely.

At HERE we take it upon ourselves to be the change we wish to see. We create solutions that fuel innovation, provide opportunity and foster inclusion to improve people’s lives. If you are inspired by an open world and driven to create positive change, join us. Learn more about us on our YouTube Channel.

What's the role?  In this role you will:
Design and publish interactive dashboards on Tableau Server, ensuring data accuracy and availability.
Collaborate with data science and engineering teams to standardize and clean data for business requirements.
Create and edit SQL queries for data extraction and analysis.
Manage ETL processes to ensure data is properly transformed and loaded for reporting.
Review and improve existing reporting systems, integrating new solutions where needed.
Provide end-user support, maintaining technical documentation for dashboards and workflows.
Design and visualize KPIs and metrics, optimizing dashboards for performance, especially with large datasets.
Use advanced Tableau features such as calculated fields, LOD expressions, table calculations, data blending, and dynamic filters.
Build data narratives through dashboards, making complex insights accessible to non-technical users.
Manage Tableau workbooks, including permissions, access control, and data refresh schedules.
Who are you?  You are a team-player who collaborates well within a diverse team. A fast learner and are comfortable working with little direction. You take initiative and bring up ideas. In addition you have the following:
BS or MS in Mathematics, Computer Science, Information Systems, or related field
Five to eight years of working experience including 4-5 years of work experience in data visualization and development and maintenance of databases, ETL systems, and user tools.
Extensive experience in developing, maintaining and managing Tableau driven dashboards & analytics and working knowledge of Tableau administration/architecture
Experience in data blending, data transformation, and ETL processes.
Strong SQL skills for creating complex queries and working with databases.
Proficient in querying relational databases, optimizing data for Tableau reporting and visualization, and designing efficient database schemas with a focus on normalization and performance.
Experience integrating Tableau with cloud services (AWS - Redshift, S3, Athena; Azure - SQL Database, Data Lake, Synapse) to scale solutions and ensure performance, security, and high availability.
Familiarity with big data and skilled in integrating large data sources with Tableau, along with troubleshooting connectivity and performance issues.
What we offer?
We offer an opportunity to work in a cutting-edge technology environment with challenging problems to solve! You can make a direct impact on delivery of company´s strategic goals and the freedom to decide how to perform your work. We will support you in delivering your day to day tasks and achieving your personal goals and developing your skills. Personal development is highly encouraged at HERE. You can take different courses and training at our online University and join cross-functional team projects within our Talent Platform.
HERE is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, age, gender identity, sexual orientation, marital status, parental status, religion, sex, national origin, disability, veteran status, and other legally protected characteristics.
Who are we?  HERE Technologies is a location data and technology platform company. We empower our customers to achieve better outcomes – from helping a city manage its infrastructure or a business optimize its assets to guiding drivers to their destination safely. At HERE we take it upon ourselves to be the change we wish to see. We create solutions that fuel innovation, provide opportunity and foster inclusion to improve people’s lives. If you are inspired by an open world and driven to create positive change. Join us. Learn more about us. Watch video
In this role you will be part of our Analytics and Tools team within the End-to-End Product Quality Design and Architecture group. This team ensures that every solution and service we deliver not only meets but exceeds customer expectations through an unwavering commitment to quality. We focus on building and optimizing backend infrastructure, including ETL processes and data pipelines.

#J-18808-Ljbffr

Here Business Intelligence Interview Guide

Overview

Here Business Intelligence Interview Process

Here Business Intelligence Interview Questions

Here Business Intelligence Jobs