Prepare for and practice interview questions from Simmons Bank.

Simmons Bank Interview Questions

Simmons Bank Interview Guides

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

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

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

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

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

Random SQL Sample

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

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

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

Hundreds of Hypotheses

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

Simmons Bank Salaries by Position

It's fun to work in a company where people truly BELIEVE in what they're doing! We're committed to bringing passion and customer focus to the business. If you are a Data Product Manager (DPM), Simmons Bank invites you to collaborate in an agile team of peers developing cloud-based analytics platform integrating data from broad number of systems, transforming data and driving product strategy to enable next-gen analytical data products. The Product Manager is accountable for the ongoing planning, development, implementation of various product initiatives and enhancements across multiple business units of the bank. The Product Manager utilizes their deep understanding of the product to collaborate with our strategic business partners, develop an understanding of customer needs, identify ideal partner experiences, and incorporate feedback from technical or engineering teams and the vendor to offer innovative solutions that are valuable to our partners. This requires a both a product roadmap and focused product backlog that is aligned and prioritized with the Simmons Bank competencies, goals, and initiatives. The Product Manager must navigate the interrelationship between these areas and be decisive in their prioritization to ensure the product team is always focused on delivering high value to the organization. The Product Manager advances maturity of the people, processes, and technology for their product by working closely with internal and external stakeholders, vendors, consultants, and team members. Responsibilities Product Management: <ul><li>Maintains product roadmap and product backlog across different business units and concurrent tracks inputs from business partners through demand management channel and by pro-actively finding opportunities for business enhancements and strategy</li><li>Leads, plans, coordinates, and executes the application program and associated projects with a clear focus on communication, risk, schedule and budget management in a dynamic environment.</li><li>Define a vision and strategy for the product, in support of Simmons Bank organizational competencies, goals, and initiatives.</li><li>Provide operational leadership and understanding of the development path for the product.</li><li>Ensure the product roadmap and product backlog are visible, clearly ordered, and actively maintained to ensure work is focused on achieving the established product vision and strategy.</li><li>Perform continual assessment of available technologies and software to facilitate continuous improvements to meet operational goals.</li><li>Monitor satisfaction with their product, identify opportunities, and implement changes to drive solution delivery.</li><li>Ensure the product is well maintained, minimizing technical debt, to enable long-term stability of its services.</li><li>Ensure product bac.klogs, user stories, implementation plans are documented and maintained as per agile principles</li></ul> Cross Functional Team Leadership: <ul><li>Lead cross-functional teams among stakeholders and ensure these cross functional teams support the goals for deriving value from the product.</li><li>Works closely with business leads, subject matter experts, and other data products end user to understand opportunities.</li><li>Works closely with cross functional business and internal IT team to maximize the value of the product requirements and working to remove conflicts between dependencies.</li><li>Serve as the leader of the product team, providing direction and accountability for advancing the value of the product.</li><li>Works with a right balance of technical project management skills to manage data product development lifecycle and ensuring process, governance aligns with agile principles or business agreed execution methodology.</li></ul> Organizational Change Management & Communication: <ul><li>Leads or ensures appropriate change management efforts while adapting to the needs of the business, and project(s) by engaging with appropriate teams on proper approach, style, usage of tools, and standards.</li><li>Owns standards for the release cycle updates for the product.</li><li>Develops and maintains overall strategy for timeline, planning, testing, dependencies, considerations, and communication plan across operational teams for each update cycle.</li><li>Utilizes understanding of change management processes, principles, and methodologies.</li></ul> Execution & Optimization: <ul><li>Engages with product teams, business stakeholders, and vendors to align best practices within individual business needs.</li><li>Maintains updated optimization plan across the application to achieve maximum value from the product.</li><li>Utilizes existing governance channels and processes to inform and escalate key issues within overall sustainment and optimization decisions across teams and systems.</li></ul> Your expertise in one or more of the following areas is highly valued: <ul><li>Experience and in depth understanding of waterfall and agile delivery models.</li><li>Experience of project management involving transformation or cloud migration scope.</li><li>In depth understanding of development lifecycle and Operations handover.</li><li>Experience with a testing framework.</li><li>Experience with Business Intelligence tools like PowerBI, Cognos or Looker and Understanding of Datawarehouse fundamentals.</li></ul> What sets you apart: <ul><li>Experience in complex migrations from legacy data warehousing solutions or on-prem datalakes to GCP.</li><li>Any management certification - PMP, CSM etc.</li><li>Any cloud certification for understanding of Cloud Fundamentals (Fundamental knowledge)</li></ul> Education: <ul><li>BS/BA degree in IT or any other stream.</li><li>6-8 years relevant experience in managing product planning and delivery</li><li>Any certification or additional course on production management delivery or strategy</li></ul> Equal Employment Opportunity Information: Simmons First National Corporation and its subsidiaries are committed to a policy of equal employment with respect to a person's race, color, religion, sex, ancestry, sexual orientation, gender identity, national origin, covered veterans, military status, physical or mental disability or any other legally protected classifications. Simmons First National Corporation and its subsidiaries are committed to Affirmative Action Programs consisting of results-oriented procedures to ensure equal employment opportunities. These programs require positive action in lieu of neutral non-discrimination and merit hiring/performance policies.

Simmons Bank Interview Questions

Simmons Bank Interview Guides

Simmons Bank Interview Questions

Simmons Bank Salaries by Position

Simmons Bank Opening Jobs