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

Collective Health Business Intelligence Interview Guide

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


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

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

Collective Health Business Intelligence Interview Process

<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

<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>You have been given a table <code>tbl_numbers</code> with only one column: <code>int_numbers</code>.  It can have one integer number value per row in a sequential manner.</p>

<p>Write a query to return the number repeated by one times its own value.</p>

<p>For example, the integer number 5 would appear five times in the output (1 times 5).</p>

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

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

<p><code>tbl_numbers</code> table</p>

<table>
<thead>
<tr>
<th>int_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

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

<table>
<thead>
<tr>
<th>seq_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>
</tbody>
</table>


Sequentially Fill in Integers

Collective Health Business Intelligence Interview Questions

At Collective Health, we're transforming how employers and their people engage with their health benefits by seamlessly integrating cutting-edge technology, compassionate service, and world-class user experience design.

At Collective Health, we care about creating a culture of diversity, openness, and transparency, while engaging our intellectual curiosity and problem solving skills. You will be part of the Payments Engineering Team. We are responsible for the financial side of employer sponsored health benefits. We build apps and services to handle the entire process, from invoicing to auditing to payments. As an engineering team, we believe good code is easy to read and understand. We expect all of our engineers to continually teach as well as learn. As a full stack engineer, you'll be working with a talented team of engineers and product managers in all phases of the development process. We are looking for someone who is ready to help lead the way building next-generation services. If you're passionate about solving hard problems while improving the world, we'd love to talk!
What you'll do:

Design and develop scalable, secure, and configurable platform services for the Cost Containment team.
Lead full-stack development and support of services across backend (Java/Spring Cloud), integration platforms, and frontend (React/Angular/GraphQL etc.).
Utilize working knowledge of AI-powered developer tools (e.g., Copilot, Cursor) and actively contribute to AI adoption in development and operational aspects.
Build and enrich APIs and data services to integrate with partners and our claims engine.
Collaborate with product managers, operations analysts, and data teams in building solutions that leverage Business Rules Management Systems (BRMS) like Drools etc.
Actively work with the operations team to create efficient processes through automations to improve SLAs.
Understand architectural decisions and actively drive reusable patterns for cloud-native, AI-enabled backend systems.
To be successful in this role, you'll need:
Experience: 8+ years as a full-stack engineer.
Full Stack Engineering: Strong proficiency in Java & Spring Cloud, with a deep understanding of microservices architecture. Proven experience building UI features using React/Angular with GraphQL.
AI Tools: Regular use of AI-enhanced development tools (e.g., GitHub Copilot, Cursor, WindSurf).
Cloud: Extensive experience with Cloud Technologies (AWS/GCP preferred).
Data: Hands-on experience in data architecture, SQL/PostgreSQL, and developing data-intensive services.
Rules Engines: Experience in working with Business Rules Management Systems (BRMS) like Drools, Kogito etc.
Communication: Excellent communication skills across all levels and teams.
Systems Development: Prior experience in building, launching, and maintaining complex systems.
Work Ethic: Balances efficiency with attention to detail.
Teamwork: Enjoys collaborative work environments with supportive colleagues.
Pay Transparency Statement

This is a hybrid position based out of one of our offices: San Francisco, CA, Plano, TX, or Lehi, UT. Hybrid employees are expected to be in the office two days per week.#LI-hybrid

The actual pay rate offered within the range will depend on factors including geographic location, qualifications, experience, and internal equity. In addition to the salary, you will be eligible for stock options and benefits like health insurance, 401k, and paid time off. Learn more about our benefits at https://jobs.collectivehealth.com/benefits/.

San Francisco, CA Pay Range

$168,000-$210,000 USD

Lehi, UT Pay Range

$134,500-$168,000 USD

Plano, TX Pay Range

$147,800-$185,500 USD

Why Join Us?
Mission-driven culture that values innovation, collaboration, and a commitment to excellence in healthcare
Impactful projects that shape the future of our organization
Opportunities for professional development through internal mobility opportunities, mentorship programs, and courses tailored to your interests
Flexible work arrangements and a supportive work-life balance

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. Collective Health is committed to providing support to candidates who require reasonable accommodation during the interview process. If you need assistance, please contact recruiting-accommodations@collectivehealth.com.
Privacy Notice

For more information about why we need your data and how we use it, please see our privacy policy: https://collectivehealth.com/privacy-policy/.

At Collective Health, we're transforming how employers and their people engage with their health benefits by seamlessly integrating cutting-edge technology, compassionate service, and world-class user experience design.

The Data Engineering Platform team builds and manages the foundational systems that power data at Collective Health-from ingestion and modeling to access and delivery. We support a wide range of data needs across the organization, enabling everything from business analytics and data science to operational reporting and external integrations. The team plays a central role in enabling a data-driven culture and ensuring that high-quality, trustworthy data is available where and when it's needed.

This Senior Manager role will lead the function responsible for the consumption and delivery layer of our data platform. You'll oversee a team of 4-6 data engineers focused on making trusted, modeled data easily accessible to internal teams and external partners. Reporting to the Director of Data Engineering Platforms, you'll help shape how data is exposed and delivered across the company, from building curated datasets for analytics to enabling data exports for clients and partners. This role is ideal for someone who enjoys working at the intersection of data engineering, product enablement, and operational scale-and is excited to lead a growing, high-impact team.
What you'll do:

Manage and mentor a team of 4-6 data engineers focused on delivering high-quality, production-grade data products.
Own the development of data marts, curated datasets, and semantic layers that power dashboards, models, and business workflows.
Design and oversee data delivery mechanisms such as APIs, FTP drops, reverse ETL jobs, and system/database integrations with external stakeholders.
Collaborate with cross-functional partners-including analytics, product, and operations teams-to ensure data products meet business needs.
Establish SLAs, documentation practices, and monitoring to ensure reliability and trust in delivered data.
Drive architectural and technical decisions in the consumption layer, ensuring scalability and maintainability.
Contribute to and help shape broader data platform strategy in partnership with other platform leads.
To be successful in this role, you'll need:
10+ years of experience in data engineering, with at least 3 years leading data engineering teams.
Proven experience designing and operating consumption layers for analytics platforms, including data marts, semantic models, and governed datasets.
Strong expertise with modern data warehouses (e.g., Snowflake, Databricks, BigQuery), ELT patterns, and data modeling (especially dimensional models).
Experience with data delivery mechanisms such as API integrations, FTP/SFTP pipelines, or database syncs to third-party systems.
Solid SQL skills and experience working with large-scale, distributed data systems.
A track record of delivering reliable, well-documented, production-ready datasets that support analytics and business operation
Pay Transparency Statement

This is a hybrid position based out of our San Francisco office, with the expectation of being in office at least two weekdays per week. #LI-hybrid

The actual pay rate offered within the range will depend on factors including geographic location, qualifications, experience, and internal equity. In addition to the salary, you will be eligible for stock options and benefits like health insurance, 401k, and paid time off. Learn more about our benefits at https://jobs.collectivehealth.com/benefits/.

San Francisco, CA Pay Range

$194,670-$243,500 USD

Why Join Us?
Mission-driven culture that values innovation, collaboration, and a commitment to excellence in healthcare
Impactful projects that shape the future of our organization
Opportunities for professional development through internal mobility opportunities, mentorship programs, and courses tailored to your interests
Flexible work arrangements and a supportive work-life balance

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. Collective Health is committed to providing support to candidates who require reasonable accommodation during the interview process. If you need assistance, please contact recruiting-accommodations@collectivehealth.com.
Privacy Notice

For more information about why we need your data and how we use it, please see our privacy policy: https://collectivehealth.com/privacy-policy/.

THE PORT OF LONG BEACH IS SEEKING A MANAGER OF BUSINESS DEVELOPMENT,
(MANAGER OF BUSINESS INTELLIGENCE)
(This is an at-will position)
Salary Range:    $142,844.060 - $199,981.684

ABOUT US
The Port of Long Beach, one of the world's busiest seaports, is an international gateway for the reliable, efficient, and sustainable movement of goods and is a leader in environmental stewardship. Credited with moving approximately $200 billion in trade, the Port serves as a critical hub for international commerce and is a major transportation center. East Asian trade accounts for the bulk of Long Beach shipments. Port-related international trade has a wide-ranging economic impact, supporting millions of jobs that benefit the region and the entire country.
THE TEAM
The Business Development Division serves as the key contributor to the Port’s commercial growth by increasing cargo volume in all market segments and generating incremental revenue by extensively canvassing all possible opportunities. The purpose of the Business Development Division is to maximize Port of Long Beach revenue opportunities and sustain market share growth by engaging all customer segments, tracking industry trends, analyzing cargo data, identifying new business opportunities, anticipating market direction, and aligning our strategies to market conditions.
THE ROLE
Under the direction of the Director and Assistant Director of Business Development, the Manager of Business Intelligence will manage the Division’s business and market intelligence platforms development, implementation, reporting, and analytics activities. This includes continuous development of the Supply Chain Information Highway (SCIH) platform and related digital tools, utilizing existing data sources, researching, evaluating, and incorporating new data sources, as well as developing data analytics tools and reports to support the Business Development Division and Port Management in policy and decision-making activities. This person will also provide guidance in the further development of the Port’s digitalization projects, as well as critical project management. This position supports the division’s functions, including customer engagement, revenue and operational optimization, creating periodic reports and presentations, conducting data analytics, and other sales, marketing, and commercial activities.
CANDIDATE CONNECT (INFORMATION SESSION)
To learn more about this exciting career opportunity and the Port of Long Beach, please join our virtual inf  ormation session on  Tuesday,July 22, 2025, @ 5:00 pm PDT via  MS Teams. This is a unique opportunity to hear first-hand about the position, speak directly with hiring leaders, ask questions, and learn why the Port of Long Beach is your employer of choice! Candidates are not required to be on camera. Candidates who call in will not be able to see the presentation.  To join audio only, call +1 323-451-1087, Phone Conference ID:   948 153 35# .    Click here to join the meeting     .
HOW YOU GET TO CONTRIBUTE:
Manage key projects and programs, including, but not limited to, Supply Chain Information Highway (SCIH), business intelligence tools, Customer Relationship Management (CRM) systems, green shipping initiatives, and future digitization efforts.
Oversee SCIH by enhancing functionality, coordinating data sources, and managing partners, stakeholders, and vendors.
Lead projects from planning to delivery, including scope definition, budgeting, resource allocation, and timelines.
Support customer engagement by attending meetings, maintaining CRM data, and generating regular reports.
Assist sales and marketing efforts to grow cargo volume, market share, and revenue.
Recommend and implement strategies to optimize Port land use and revenue; collaborate on leasing and development opportunities.
Prepare reports, presentations, infographics, and respond to trade-related information requests.
Manage project and department budgets; negotiate and oversee project bids.
Represent the division through correspondence, meetings, tours, events, and conferences; respond to inquiries and engage with new/existing customers.
Supervise staff: hire, train, evaluate, and coach performance; address issues as needed.
Keep leadership informed on key updates; maintain strong working relationships with internal teams and external partners.
Serve as Acting Director in the absence of leadership.
Perform other duties as assigned.
EDUCATION, KNOWLEDGE & EXPERIENCE:
Bachelor’s Degree in Computer Science, Data Science, Business, or a related field (required).
Certification in data science, data management, or data analytics (required).
Minimum of five years of experience in database management, data analysis, business intelligence, or project management.
Minimum of three years of direct supervisory experience.
Must be able to obtain and maintain a TWIC.
TECHNICAL SKILLS NEEDED:
Broad knowledge of management principles and public administration practices.
Familiarity with goods movement, logistics, maritime, and business development terminology.
Ability to quickly understand the core needs of Port users and stakeholders.
Experience with Business Intelligence tools and market data systems (e.g., PIERS).
High proficiency in MS Office (Word, Excel, Outlook) and adaptability to new software.
Strong research, analytical, and problem-solving skills.
Excellent business writing, document preparation, and presentation skills.
DESIRABLE:
Master’s degree in Computer Science, Data Science, Business, or a related field.
Knowledge of public enterprise fund and port authority management.
Knowledge of consultant contracting and public records management.
Second language proficiency.
Familiarity with advanced Microsoft Excel, Access, SQL Server, or Python computer language is desired.

You will need strong project management skills, strategic thinking, and the ability to lead cross-functional teams in a dynamic environment. Success in this role requires clear communication, adaptability, and the ability to build effective relationships with stakeholders, customers, and internal teams. You must be comfortable working in both office and field settings, navigating varying physical conditions while maintaining a high level of professionalism, initiative, and attention to detail.
If you require accommodation because of a disability in order to participate in any phase of the application/selection process, please contact (562) 283-7500 or email   Careers@polb.com    .
The Port of Long Beach will consider qualified applicants with a criminal history pursuant to the California Fair Chance Act. You are not required to disclose your criminal history or participate in a background check until you receive a conditional job offer. If the Port of Long Beach has concerns about a conviction that is directly related to the job after making a conditional job offer and conducting a background check, you will have the opportunity to explain the circumstances surrounding the conviction, provide evidence to mitigate concerns or challenge the accuracy of the background report. Find out more about the Fair Chance Act by visiting  https://calcivilrights.ca.gov/fair-chance-act or https://www.longbeach.gov/hr/about-us/talent-acquisition/the-fair-chance-act/.
The final filing date for this recruitment is Friday, August 1, 2025, at 4:30 p.m. PDT.
To be considered for this opportunity,   please submit a cover letter and resume with your application in PDF format. Incomplete applications (without a cover letter and resume) will not be considered.
Individuals who are most qualified for the position will be invited to participate in the selection process, which may include a work-related assessment to evaluate candidate qualifications further. First and second-round panel interviews are tentatively scheduled for  Wednesday, August 13, 2025  and Thursday, August 21, 2025 (in-person) . Candidates should ensure availability on both dates. The successful candidate will be appointed shortly thereafter. References will be completed for finalist candidates; an employment offer is contingent on conducting a comprehensive background check.
The Port reserves the right to extend the closing date without notice in order to accept additional applications. Those individuals determined to be most qualified for the position will be invited to participate in the selection process.

THE BENEFITS:
The Port of Long Beach has established an annual salary range of  $142,844.060  - $199,981.684 (placement depends on qualifications).
An attractive package of executive-level benefits is included with the opportunity to work in one of the most diverse and dynamic areas of the United States:
Auto Allowance – $550.00 per month
Executive Leave – 40 hours per year.
Retirement – For new employees, the CalPERS retirement formula is 2.0% at 62, coordinated with Social Security. Currently, member contribution is 8.00% for CalPERS, and 6.2% for social security, paid by the employee. For employees with previous CalPERS status, Central Payroll will review and determine the formula. For previous employees with a break in service, this could be 2.0% at 62, coordinated with Social Security.
Pay for Performance – Pay for Performance is awarded based on employee performance as demonstrated through achievement of individual goals, demonstration of required competencies, and available budget funds.
Deferred Compensation – The City matches a percentage of base salary for qualified members contributing to the 457(b) plan.
Group Health Insurance – Medical and dental options (HMO and PPO). Free vision coverage.
Life Insurance – City-paid life insurance policy of $20,000 plus executive insurance benefit equal to three times annual salary up to a maximum of $500,000.
Disability Insurance – City-paid short- and long-term disability insurance.
Vacation – Vacation is accrued at the equivalent of two weeks on an annual basis. Vacation can be used after six months of service. An employee’s vacation accrual may be adjusted upon hire to provide credit for previous full-time employment at a public service agency. Credit for public service shall only be given for completed years of service as a full-time permanent employee. Public Service credit shall not apply to any other benefits.
Sick Leave – Accrued at 8 hours per month. Accruals may be converted upon retirement to cash credit toward health and /or dental insurance premiums or retirement service credits.
Paid Parental Leave – After six (6) months of City employment, the City pays up to 30 consecutive days (160 hours) for eligible employees to take paid time to bond with the child upon birth, adoption, or foster placement of a child, up to the age of 17.
Holidays – 11 scheduled holidays per calendar year and four (4) personal holidays.
Education Reimbursement – Tuition reimbursement allows employees to obtain additional education or training.
Annual Physical – Eligible to receive an annual physical examination at the city's expense through the city-provided program.
Public Student Loan Forgiveness – As the Harbor Department of the City of Long Beach, a governmental agency, the Port of Long Beach is a qualifying employer for the Public Student Loan Forgiveness (PSLF) program.
529 college savings plan  – The ScholarShare529 plan is an account that allows employees to invest specifically for future education expenses through the Long Beach City Employees Federal Credit Union. Funds can be used from your 529 savings plan to send your grandkids, kids, or even yourself to any accredited public or private U.S. college or university – or two-year technical or vocational institution.
The Port of Long Beach is an Equal Opportunity Employer
We do not discriminate based on race, religion, color, national origin, sexual orientation, gender, gender identity, gender expression, age, status as an individual with a disability, or other applicable legally protected characteristics.
www.polb.com
For technical support with your governmentjobs.com application, please contact (855) 524-5627.
#J-18808-Ljbffr

Salary :  $142,844.06 - $199,981.68 Annually
Location :  City of Long Beach, CA
Job Type:  Unclassified - Full-Time, Permanent
Job Number:  HDE25-022
Department:  Harbor - (UC)
Division:  HARBOR-COMML SVCS-BUS DEVEL
Opening Date:  07/11/2025
Closing Date:  8/1/2025 4:30 PM Pacific

DESCRIPTION
THE PORT OF LONG BEACH IS SEEKING A MANAGER OF BUSINESS DEVELOPMENT,

(MANAGER OF BUSINESS INTELLIGENCE)

(This is an at-will position)

Salary Range:   $142,844.060 - $199,981.684
ABOUT US

The Port of Long Beach, one of the world's busiest seaports, is an international gateway for the reliable, efficient, and sustainable movement of goods and is a leader in environmental stewardship. Credited with moving approximately $200 billion in trade, the Port serves as a critical hub for international commerce and is a major transportation center. East Asian trade accounts for the bulk of Long Beach shipments. Port-related international trade has a wide-ranging economic impact, supporting millions of jobs that benefit the region and the entire country.
THE TEAM

The Business Development Division serves as the key contributor to the Port's commercial growth by increasing cargo volume in all market segments and generating incremental revenue by extensively canvassing all possible opportunities. The purpose of the Business Development Division is to maximize Port of Long Beach revenue opportunities and sustain market share growth by engaging all customer segments, tracking industry trends, analyzing cargo data, identifying new business opportunities, anticipating market direction, and aligning our strategies to market conditions.
THE ROLE

Under the direction of the Director and Assistant Director of Business Development, the Manager of Business Intelligence will manage the Division's business and market intelligence platforms development, implementation, reporting, and analytics activities. This includes continuous development of the Supply Chain Information Highway (SCIH) platform and related digital tools, utilizing existing data sources, researching, evaluating, and incorporating new data sources, as well as developing data analytics tools and reports to support the Business Development Division and Port Management in policy and decision-making activities. This person will also provide guidance in the further development of the Port's digitalization projects, as well as critical project management. This position supports the division's functions, including customer engagement, revenue and operational optimization, creating periodic reports and presentations, conducting data analytics, and other sales, marketing, and commercial activities.
CANDIDATE CONNECT (INFORMATION SESSION)

To learn more about this exciting career opportunity and the Port of Long Beach, please join our virtual information session on  Tuesday, July 22, 2025, @ 5:00 pm PDT via  MS Teams. This is a unique opportunity to hear first-hand about the position, speak directly with hiring leaders, ask questions, and learn why the Port of Long Beach is your employer of choice! Candidates are not required to be on camera. Candidates who call in will not be able to see the presentation.  To join audio only, call +1 323-451-1087, Phone Conference ID:   948 153 35# . Click here to join the meeting .

EXAMPLES OF DUTIES
HOW YOU GET TO CONTRIBUTE:
Manage key projects and programs, including, but not limited to, Supply Chain Information Highway (SCIH), business intelligence tools, Customer Relationship Management (CRM) systems, green shipping initiatives, and future digitization efforts.
Oversee SCIH by enhancing functionality, coordinating data sources, and managing partners, stakeholders, and vendors.
Lead projects from planning to delivery, including scope definition, budgeting, resource allocation, and timelines.
Support customer engagement by attending meetings, maintaining CRM data, and generating regular reports.
Assist sales and marketing efforts to grow cargo volume, market share, and revenue.
Recommend and implement strategies to optimize Port land use and revenue; collaborate on leasing and development opportunities.
Prepare reports, presentations, infographics, and respond to trade-related information requests.
Manage project and department budgets; negotiate and oversee project bids.
Represent the division through correspondence, meetings, tours, events, and conferences; respond to inquiries and engage with new/existing customers.
Supervise staff: hire, train, evaluate, and coach performance; address issues as needed.
Keep leadership informed on key updates; maintain strong working relationships with internal teams and external partners.
Serve as Acting Director in the absence of leadership.
Perform other duties as assigned.
REQUIREMENTS TO FILE
EDUCATION, KNOWLEDGE & EXPERIENCE:     Bachelor's Degree in Computer Science, Data Science, Business, or a related field (required).
Certification in data science, data management, or data analytics (required).
Minimum of five years of experience in database management, data analysis, business intelligence, or project management.
Minimum of three years of direct supervisory experience.
Must be able to obtain and maintain a TWIC.
TECHNICAL SKILLS NEEDED:     Broad knowledge of management principles and public administration practices.
Familiarity with goods movement, logistics, maritime, and business development terminology.
Ability to quickly understand the core needs of Port users and stakeholders.
Experience with Business Intelligence tools and market data systems (e.g., PIERS).
High proficiency in MS Office (Word, Excel, Outlook) and adaptability to new software.
Strong research, analytical, and problem-solving skills.
Excellent business writing, document preparation, and presentation skills.
DESIRABLE:     Master's degree in Computer Science, Data Science, Business, or a related field.
Knowledge of public enterprise fund and port authority management.
Knowledge of consultant contracting and public records management.
Second language proficiency.
Familiarity with advanced Microsoft Excel, Access, SQL Server, or Python computer language is desired.
You will need strong project management skills, strategic thinking, and the ability to lead cross-functional teams in a dynamic environment. Success in this role requires clear communication, adaptability, and the ability to build effective relationships with stakeholders, customers, and internal teams. You must be comfortable working in both office and field settings, navigating varying physical conditions while maintaining a high level of professionalism, initiative, and attention to detail.

If you require accommodation because of a disability in order to participate in any phase of the application/selection process, please contact (562) 283-7500 or email  Careers@polb.com .

The Port of Long Beach will consider qualified applicants with a criminal history pursuant to the California Fair Chance Act. You are not required to disclose your criminal history or participate in a background check until you receive a conditional job offer. If the Port of Long Beach has concerns about a conviction that is directly related to the job after making a conditional job offer and conducting a background check, you will have the opportunity to explain the circumstances surrounding the conviction, provide evidence to mitigate concerns or challenge the accuracy of the background report. Find out more about the Fair Chance Act by visiting  https://calcivilrights.ca.gov/fair-chance-act or https://www.longbeach.gov/hr/about-us/talent-acquisition/the-fair-chance-act/.

SELECTION PROCEDURE
The final filing date for this recruitment is Friday, August 1, 2025, at 4:30 p.m. PDT.

To be considered for this opportunity,  please submit a cover letter and resume with your application in PDF format. Incomplete applications (without a cover letter and resume) will not be considered.

Individuals who are most qualified for the position will be invited to participate in the selection process, which may include a work-related assessment to evaluate candidate qualifications further. First and second-round panel interviews are tentatively scheduled for  Wednesday, August 13, 2025   and Thursday, August 21, 2025 (in-person) . Candidates should ensure availability on both dates. The successful candidate will be appointed shortly thereafter. References will be completed for finalist candidates; an employment offer is contingent on conducting a comprehensive background check.

The Port reserves the right to extend the closing date without notice in order to accept additional applications. Those individuals determined to be most qualified for the position will be invited to participate in the selection process.
THE BENEFITS:

The Port of Long Beach has established an annual salary range of  $142,844.060   - $199,981.684  (placement depends on qualifications).

An attractive package of executive-level benefits is included with the opportunity to work in one of the most diverse and dynamic areas of the United States:     Auto Allowance  - $550.00 per month
Executive Leave  - 40 hours per year.
Retirement  - For new employees, the CalPERS retirement formula is 2.0% at 62, coordinated with Social Security. Currently, member contribution is 8.00% for CalPERS, and 6.2% for social security, paid by the employee. For employees with previous CalPERS status, Central Payroll will review and determine the formula. For previous employees with a break in service, this could be 2.0% at 62, coordinated with Social Security.
Pay for Performance  - Pay for Performance is awarded based on employee performance as demonstrated through achievement of individual goals, demonstration of required competencies, and available budget funds.
Deferred Compensation  - The City matches a percentage of base salary for qualified members contributing to the 457(b) plan.
Group Health Insurance  - Medical and dental options (HMO and PPO). Free vision coverage.
Life Insurance  - City-paid life insurance policy of $20,000 plus executive insurance benefit equal to three times annual salary up to a maximum of $500,000.
Disability Insurance  - City-paid short- and long-term disability insurance.
Vacation  - Vacation is accrued at the equivalent of two weeks on an annual basis. Vacation can be used after six months of service. An employee's vacation accrual may be adjusted upon hire to provide credit for previous full-time employment at a public service agency. Credit for public service shall only be given for completed years of service as a full-time permanent employee. Public Service credit shall not apply to any other benefits.
Sick Leave  - Accrued at 8 hours per month. Accruals may be converted upon retirement to cash credit toward health and /or dental insurance premiums or retirement service credits.
Paid Parental Leave  - After six (6) months of City employment, the City pays up to 30 consecutive days (160 hours) for eligible employees to take paid time to bond with the child upon birth, adoption, or foster placement of a child, up to the age of 17.
Holidays  - 11 scheduled holidays per calendar year and four (4) personal holidays.
Education Reimbursement  - Tuition reimbursement allows employees to obtain additional education or training.
Annual Physical  - Eligible to receive an annual physical examination at the city's expense through the city-provided program.
Public Student Loan Forgiveness  - As the Harbor Department of the City of Long Beach, a governmental agency, the Port of Long Beach is a qualifying employer for the Public Student Loan Forgiveness (PSLF) program.
529 college savings plan  - The ScholarShare529 plan is an account that allows employees to invest specifically for future education expenses through the Long Beach City Employees Federal Credit Union. Funds can be used from your 529 savings plan to send your grandkids, kids, or even yourself to any accredited public or private U.S. college or university - or two-year technical or vocational institution.
The Port of Long Beach is an Equal Opportunity Employer

We do not discriminate based on race, religion, color, national origin, sexual orientation, gender, gender identity, gender expression, age, status as an individual with a disability, or other applicable legally protected characteristics.

www.polb.com

For technical support with your governmentjobs.com application, please contact (855) 524-5627.
Employee Benefits
The City of Long Beach offers its employees opportunities to grow personally and professionally. As a permanent employee, you are eligible to receive fringe benefits that include:     Retirement:  California Public Employees' Retirement System (PERS) defined benefit retirement plan, which is coordinated with Social Security. The benefit is 2.5% @55 for "Classic" members and 2%@62 for new members as defined by PEPRA. Subject to employee contribution. Both the City and the employee contributes toward CalPERS retirement contributions. The city also participates in Social Security.
Health and Dental Insurance:  The City offers the choice of HMO and PPO plans. The city pays major portion of the premium for employee and dependents depending on the health/ dental plan selected.
Life Insurance:  City-paid term life insurance policy equal to three (3) times annual salary to a maximum of $500,000.
Disability Insurance:  City-paid short-term and long-term disability insurance.
Management Physical:  Annual City-paid physical examination.
Vacation:  Twelve (12) vacation days after the first year of service; 15 days after four years, six months of service; 20 days after 19 years, six months of service.
Executive Leave:  Forty (40) hours Executive Leave per year. The City Manager has discretion to grant an additional 40 hours each year.
Sick Leave:  One day earned per month; unlimited accumulation; conversion upon retirement to cash credit toward health and/or dental insurance premiums, or to pension credits.
Holidays:  Eleven (11) designated holidays per year, plus four personal holidays to be used at the employee's discretion.
Transportation Allowance:  Monthly allowance is allocated by classifications below;   Department Head $650.00
Deputy Director/Manager $550.00
Chief of Staff / Administrator / Principal DCA: $450.00
Executive Support Staff: $300.00

Deferred Compensation Plan:  Optional for employee contribution to a supplementary retirement savings program available through Mission Square Retirement formerly ICMA-RC Retirement Corporation). City contributes 1% of employee's base pay to the employee's 401(a) plan; effective September 30, 2022, the City will contribute 2% of employee's base pay to the employee's 401(a) account. Employees may opt to contribute up to the IRS annual limits as well.
Flexible Spending Account (FSA):  Optional election for employees to reduce taxable income for payment of allowable childcare or medical expenses.
Flexible/Hybrid Work Schedule:  Available (subject to City Manager approval).
Paid Parental Leave:  After six (6) months of City employment; up to 30 calendar days (160 hours) of PPL, taken in full-day increments, in connection with the birth, adoption, or foster placement of a child, up to the age of seventeen (17).
Management positions -  Refer to the Job Posting brochure included in the job posting.
01

Do you have a Bachelor's Degree in Computer Science, Data Science, Business, or a related field?    Yes
No

02

Do you have a certification in data science, data management, or data analytics?    Yes
No

03

Do you have a minimum of five years of experience in database management, data analysis, business intelligence, or project management?    Yes
No

04

Do you have a minimum of three years of direct supervisory experience?    Yes
No

05

To be considered for this opportunity, a cover letter and resume is required. Incomplete applications (without a cover letter and resume) will not be considered. Did you attach a cover letter and resume to your application?    Yes
No

Required Question

THE PORT OF LONG BEACH IS SEEKING A MANAGER OF BUSINESS DEVELOPMENT, (MANAGER OF BUSINESS INTELLIGENCE)(This is an at-will position) Salary Range: $142,844.060 - $199,981.684 ABOUT US - The Port of Long Beach, one of the world's busiest seaports, is Manager, Business, Business Development, Intelligence, Development, Data Science

Question	Topic	Difficulty	Ask Chance
Slacking Employees Salaries	SQL	Medium	Very High
Player Analysis	SQL	Easy	Very High
Sequentially Fill in Integers	SQL	Hard	Very High

Collective Health Business Intelligence Interview Guide

Overview

Collective Health Business Intelligence Interview Process

Collective Health Business Intelligence Interview Questions

Collective Health Business Intelligence Jobs