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

Colsa Business Intelligence Interview Guide

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


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

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

Colsa 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

Colsa Business Intelligence Interview Questions

<strong>Job Description</strong><br><br>Develops and applies interdisciplinary methods, algorithms, statistics, and research techniques in the development of data driven solutions to extract knowledge, provide insights, and present information from data in various structures and unstructured forms.<br><br><strong>Principal Duties and Responsibilities (*Essential functions)</strong><br><ul><li>Performs analysis of data systems, such as Big Data systems *</li><li>May perform statistical analysis and provide input for reports and dashboards</li><li>Involved with the development of data products, reports, and dashboards or other display techniques*</li><li>Evaluates data, algorithms, and their interaction to improve algorithm performance*</li><li>May apply advanced statistics, including natural language processing and machine learning to create solutions.</li><li>May assist in data modeling and data virtualization </li><li>May write code to preprocess and clean data</li></ul><br>At COLSA, people are our most valuable resource and centered at our core value. We invite you to unite your talents with opportunity and be a part of our "Family of Professionals!" Learn about our employee-centric culture and benefits here.<br><br><strong>Required Experience</strong><br><br><ul><li>Bachelors' degree in technical/applicable related field or equivalent</li><li>Minimum of 2 years related experience</li><li>Understanding of Artificial Intelligence constructs</li><li>Working knowledge of desktop applications such as word processing, spreadsheet, and database programs, </li><li>Active DoD Top Secret security clearance with eligibility for DIA-SCI access. Candidate selected must successfully pass a DIA CI polygraph within 180 days of hire</li><li>U.S. Citizenship required</li></ul><br><strong>Preferred Qualifications</strong><br><ul><li>Active DoD Security Clearance</li><li>TS/SCI Clearance</li><li>The ability to obtain Security + certification within 6 months of hire</li><li>Python and Dockers experience preferred</li></ul><br>Applicant selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information. COLSA Corporation is an Equal Opportunity Employer, Minorities/Females/Veterans/Disabled. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin.

<p>Join to apply for the <strong>Control Systems Senior Data Analyst</strong> role at <strong>COLSA</strong>.</p><p><strong>General Summary</strong></p><p>The Data Analyst is a highly skilled and analytical <strong>individual who will provide</strong> critical support to a government customer and all teams on the program. This role focuses on delivering comprehensive project assistance and advanced data visualization solutions, particularly for the team on the program focusing on Control Systems. The ideal candidate will utilize their expertise in Power BI and data analytics to transform complex datasets into clear, actionable insights that inform strategic decisions. Success in this position requires a strong blend of technical proficiency, problem-solving abilities, and exceptional organizational skills to effectively meet program objectives and reporting requirements. The Data Analyst will work collaboratively with a multidisciplinary team to develop effective solutions for managing and visualizing large datasets, ensuring complex information is presented in a clear and accessible format.</p><p><strong>Principal Duties and Responsibilities</strong></p><ol><li>Conduct research, planning, analysis, and organization of technical and statistical data for use in briefings, reports, and publications.</li><li>Consolidate and integrate data from multiple sources to generate accurate and actionable data elements.</li><li>Use Power BI to analyze data and develop dynamic dashboards and interactive visual reports to facilitate informed decision-making.</li><li>Use Power BI to design and develop interactive dashboards and reports that provide actionable insights.</li><li>Leverage APIs to connect and integrate data from various sources into Power BI for seamless analysis and visualization.</li><li>Optimize Power BI solutions by creating advanced data models, implementing DAX functions, and enabling dynamic filtering and drill-down capabilities.</li><li>Collaborate with stakeholders to translate business needs into technical specifications and deliver tailored Power BI solutions.</li><li>Ensure dashboards are scalable, user-friendly, and provide real-time updates to support decision-making processes.</li><li>Establish and monitor key performance indicators (KPIs) to ensure alignment with program objectives and performance goals.</li><li>Design, develop, and maintain complex data models to enhance business analysis and reporting capabilities.</li><li>Create, test, and deploy Power BI scripts, leveraging advanced DAX queries and functions to ensure accurate and efficient data visualization.</li><li>Use SQL queries to extract, transform, and analyze data, optimizing it for reporting and visualization needs.</li><li>Document data workflows and processes, including detailed explanations of algorithms, parameters, models, and data relationships, to ensure clarity and reproducibility.</li><li>Coordinate with stakeholders and facilitate stakeholder meetings and working groups to support the objectives of the Control Systems team.</li><li>Track, monitor, and complete tasks in ETMS2, ensuring alignment with program requirements and timelines.</li><li>Maintain program documentation, organize files, and manage schedules for briefings and meetings to ensure efficient program operations.</li><li>Develop and deliver presentations that effectively communicate data insights, enabling stakeholders to make informed decisions.</li><li>Develop clear, concise, and compelling briefing materials that effectively communicate complex data insights to stakeholders.</li><li>Tailor presentations to the needs of diverse audiences, ensuring that key messages are easily understood and aligned with program objectives.</li><li>Use data visualizations, charts, and graphs to enhance the clarity and impact of briefings, making data-driven insights actionable and engaging.</li><li>Collaborate with cross-functional teams to gather input and refine content, ensuring accuracy and relevance of all materials.</li><li>Analyze and optimize existing Extract, Transform, Load (ETL) processes to improve data flow efficiency and reliability.</li><li>Design and implement new ETL systems to streamline data extraction, transformation, and loading, ensuring seamless integration across platforms.</li><li>Maintain the accuracy, integrity, and consistency of data sources, ensuring data is clean, reliable, and suitable for program analysis and reporting needs.</li><li>Collaborate with stakeholders to define data requirements and ensure ETL processes align with program objectives and operational goals.</li></ol><p><em>At COLSA, people are our most valuable resource and centered at our core value. We invite you to unite your talents with opportunity and be a part of our Family of Professionals! Learn about our employee-centric culture and benefits here.</em></p><br/>#J-18808-Ljbffr

Develops and applies interdisciplinary methods, algorithms, statistics, and research techniques in the development of data driven solutions to extract knowledge, provide insights, and present information from data in various structures and unstructured forms.
Principal Duties and Responsibilities (*Essential functions)
Performs analysis of data systems, such as Big Data systems *
May perform statistical analysis and provide input for reports and dashboards
Involved with the development of data products, reports, and dashboards or other display techniques*
Evaluates data, algorithms, and their interaction to improve algorithm performance*
May apply advanced statistics, including natural language processing and machine learning to create solutions.
May assist in data modeling and data virtualization
May write code to preprocess and clean data
At COLSA, people are our most valuable resource and centered at our core value. We invite you to unite your talents with opportunity and be a part of our “FamilyofProfessionals!”Learn about our employee-centric culture and benefitshere .
Required Experience    Requirements
Bachelors degree or higher in computer science, data science, engineering, math, statistics, operations research or related field or equivalent experience
Minimum of 5 - 8 years related experience
Familiarity with advanced machine learning, data science techniques and mathematical approaches
Working knowledge of current operating systems and programming languages
Active DoD Top Secret security clearance with eligibility for DIA-SCI access. Candidate selected must successfully pass a DIA CI polygraph within 60 days of hire
Preferred Qualifications
Master's degree in Computer Science, Data Science, Engineering, Math, Statistics, Operations Research or related field or equivalent experience
Proactive self-starter capable of finding and solving problems with little guidance
Experience implementing and utilizing Generative AI (such as large language models (LLMs))
Experience designing, building, and maintaining scalable, reliable data pipelines (ETL/ELT workflows)
Familiarity with MLOps best practices
Knowledge of containerization (Docker, Podman)
Applicant selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information.COLSA Corporation is an Equal Opportunity Employer, Minorities/Females/Veterans/Disabled. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin.
The salary range, if referenced, represents a good faith estimate. COLSA considers various factors when determining base salary offers, but not limited to, location, the role, function and associated responsibilities, a candidate’s particular combination of education, knowledge, skills, competencies, and experience, as well as contract-specific affordability and organizational requirements.
COLSA offers a comprehensive and customizeable benefits program which includes Medical, Dental, Vision, Life Insurance, Short-Term Disability, Long-Term Disability, Accidental Death & Dismemberment, Supplemental Income Protection Programs, 401(k) with company match, Flexible Spending Accounts, Employee Assistance Program, Education & Certification Reimbursement, Employee Discount Program, Paid Time Off and Holidays.
This position will be posted for a minimum of 3 business days. If a candidate has not been selected at that time, it will continue to be posted until a suitable candidate is selected or the position is closed.

#J-18808-Ljbffr

Johnson, Mirmiran & Thompson is a dynamic, 100% employee-owned consulting firm of more than 2,000 professionals that provides a full range of multi-disciplined engineering, architecture, information technology, and related services to public agencies and private clients throughout the United States. JMT, is currently ranked #59 on Engineering News-Record’s list of the Top 500 Design Firms.
Position summary:  Responsible for providing technical assistance to professional engineering staff.
Essential Functions and Responsibilities
Follow direction from professional staff to provide assistance on project work
Nonessential Functions and Responsibilities
Perform other related duties as assigned
Required Skills
Proficient in Microsoft Office
Written and oral communication skills
Required Experience
Associates Degree in Civil Engineering Technology, Construction Management, Computer Aided Drafting Design Technology, preferred
Working Conditions
Work is performed within a general office environment 95% of the time. Office work is generally sedentary in nature but may require occasional standing and walking. Lighting and temperature are adequate and there are no hazardous or unpleasant conditions caused by noise, dust, etc. within the office environment.
Work is performed in the field 5% of the time. Ability to extensively perform bending, kneeling, standing, shoveling, and lifting and carrying objects weighing up to 25 lbs. and walking project limits as needed. Work may be conducted outside in heat/cold, wet/humid, and dry/arid conditions.
JMT is an Equal Opportunity Employer M/F/Disability/Vet/Sexual Orientation/Gender Identity, and we are proud to be building an inclusive and diverse workforce.
\ #LI-JP1
Qualifications:

Proficient in Microsoft Office
Written and oral communication skills

#J-18808-Ljbffr

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

Colsa Business Intelligence Interview Guide

Overview

Colsa Business Intelligence Interview Process

Colsa Business Intelligence Interview Questions

Colsa Business Intelligence Jobs