Prepare for and practice interview questions from Talent Software Services.

Talent Software Services Interview Questions

Talent Software Services Interview Guides

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

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 you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Talent Software Services Salaries by Position

The Pricing Analyst will be responsible for significant value to the business through the following activities: •Acts as primary contact for pricing systems and tools used within the business and Product Lines. Considered an expert and/or developer of specific pricing processes, approaches, and tools. •Utilizes comprehensive knowledge of best pricing practices and procedures to optimize value for multiple products or sites, and create moderately complex analyses of the data. •Participates on cross-functional product line teams in follow-up, investigation, and documentation of internal and external nonconformances, root causes and corrective actions as well as continued improvement opportunities. •Creates, implements and executes on measures to improve on customer profitability, as well as action plans to improve the value creation on line and customized product offerings. •Accountable for executing pricing adjustments to regional and national product offerings with varying intervals as required by the product line pricing strategy. •Acts as the primary owner of all published location, regional, and national pricelists for assigned products, product lines, or as needed. •May participate in selection of employees and provide input on plans for future team needs. •May provide informal coaching and/or training to pricing analysts and other cross functional teammates, including coaching *** core values. Required Qualifications •Bachelor's degree, preferably in a Business, Finance, Economics or Agriculture related field •2 years related professional experience •Fluent in Microsoft Excel (VBA preferred) •Ability to interpret and work with data to provide analysis •Proven experience working in cross functional environments •Excellent time management, prioritization and organizational skills •Strong collaboration skills, and ability to work effectively within a process-honoring organization •Communication: strong verbal, written, and presentation skills Preferred Qualifications •Tableau experience •Agriculture industry experience •Previous pricing experience for Retail, Client, Consulting Providers

Are you an experienced Data Scientist with a desire to excel? If so, then Talent Software Services may have the job for you! Our client is seeking an experienced Data Scientist to work in Redmond, WA. Position Summary: The main function of a Data Scientist is to coordinate changes to computer databases, test, and implement the database applying knowledge of database management systems. Primary Responsibilities/Accountabilities: <ul><li>Improve AI modeling techniques, including Clustering algorithms, Natural Language Processing etc.</li><li>Work with senior management, technical and client teams in order to determine data requirements, business data implementation approaches, best practices for advanced data manipulation, storage and analysis strategies</li><li>Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions</li><li>Design, implement, automate and maintain large scale enterprise data ETL processes</li><li>Modify existing databases and database management systems and/or direct programmers and analysts to make changes</li><li>Test programs or databases, correct errors and make necessary modifications</li></ul> Qualifications: <ul><li>Bachelor's degree in a technical field such as computer science, computer engineering or related field required</li><li>5-7 years applicable experience required</li><li>Experience with database technologies like MongoDB, Cassandra, Cosmos DB, SQL Server, MySQL, PostgreSQL</li><li>Extensive experience with PowerBI and the use of SQL and KQL for querying.</li><li>Experience in AI Machine learning as a Data Scientist, creating trends/analysis about the business to help the org</li><li>Experience Clustering, Algorithms, Run Large Scale Models (to help create insights for the business org) to inform on business decisions</li><li>Experience in Customer segmentation, sentiment analysis, AI Machine Learning, AI Modeling</li><li>Experience with Python, Spark, Pytorch,Tensorflow, etc.</li></ul>

BUSINESS ANALYST Job Summary: Talent Software Services is in search of a Business Analyst for a contract position in St. Paul/Hybrid, MN. Opportunity will be Six months with a strong chance for a long-term extension. Primary Responsibilities/Accountabilities: <ul> <li>Elicit requirements using interviews, document analysis, requirements workshops, storyboards, surveys, site visits, business process descriptions, use cases, scenarios, event lists, business analysis, competitive product analysis, task and workflow analysis, and/or viewpoints.</li> <li>Write requirements specifications according to standard templates, using natural language simply, clearly, unambiguously, and concisely. Represent requirements using alternative views, such as analysis models (diagrams), prototypes, or scenarios, where appropriate.</li> <li>Plan and facilitate project discovery sessions.</li> <li>Decompose high-level business and user requirements into functional requirements specifying an appropriate level of detail suitable for use by those that must base their work on the requirements.</li> <li>Identify the current- and future-client's business processes; define quality attributes, external interfaces, constraints, and other nonfunctional requirements.</li> <li>Perform requirements analysis and verification, ensuring that requirement statements are complete, consistent, concise, comprehensible, traceable, feasible, unambiguous, and verifiable, and that they conform to standards.</li> <li>Translate business requirements to System/Functional specifications, and pass them on to Application Developers.</li> <li>Coordinate Business Validation to verify that a set of end-to-end business processes function as intended.</li> <li>Participate in peer reviews and inspections of user story maps, epics, user stories, requirements documents, and work products derived from those artifacts to ensure that the requirements were interpreted correctly.</li> <li>Manage requirements traceability information and track requirements status throughout the project.</li> <li>Work with product owners to align with priorities and build product backlog with refined stories for the development team.</li> <li>Create user story maps, write user stories with relevant acceptance criteria, and review/update with the development team at refinement sessions and scrum events as needed.</li> <li>Conduct refinement sessions at various levels for scrum teams in preparation for story pointing and sprint planning.</li> <li>Plan, manage, and track team work items.</li></ul> Qualifications: <ul> <li>Seven years of experience in an IT Business Analyst role</li> <li>Three years of experience working as an IT Business Analyst on Agile project/product teams</li></ul> Preferred: <ul> <li>Experience working with Law Enforcement or Criminal Justice Systems</li> <li>Business Analyst Certification (IIBA certification or equivalent)</li> <li>Scrum Master experience</li> <li>Certified Scrum Master</li> <li>Experience working with Product Owners on backlog management, story writing, and story refinement.</li> <li>Experience working with Agile work management tools such as JIRA.</li> <li>Analyzing, defining and documenting requirements for object oriented applications, relational databases, complex queries, interfaces, extraction processes, reports, and dashboards using multi-system data.</li> <li>Leading the design and implementation for multi-faceted, complex, application development projects involving multiple stakeholders and IT functions.</li> <li>Problem-solving skills in problem definition, information gathering and research, alternatives analysis, applying creative solutions to unique and/or immediate problems, and appropriate resolution implementation.</li> <li>Ability to communicate clearly, present complex information to users in a comprehensive style, and translate technical and system information for non-technical stakeholders.</li> <li>Ability to collaborate, work effectively as part of a team and maintain working relationships with all levels of business customers and technology staff.</li> <li>Leadership, mentoring and coaching skills for IT professionals.</li> <li>Experience performing, and advanced knowledge of, Quality Assurance and Project Management activities.</li></ul> If this job is a match for your background, we would be honored to receive your application! Providing consulting opportunities to TALENTed people since 1987, we offer a host of opportunities including contract, contract to hire and permanent placement. Let's talk!

Job Summary The Oncology Bioinformatics team in the Computational Biology and Translation Pillar of gRED Computational Sciences (gCS) is seeking a highly motivated data scientist to support extraction, interpretation, analysis, and workflow implementation of -omics datasets. Qualifications: Educational Background: Minimum of a Bachelor's degree in Bioinformatics, Data Sciences, Computational Biology, Computer Science, Molecular Biology, or a related field Requirements: Advanced Python Programming: Proficient in Python programming, particularly within Linux-based High-Performance Computing (HPC) environments. Expertise in Workflow Language: Strong knowledge of workflow languages such as WDL, Nextflow, and/or Snakemake for automating and managing computational workflows. Version Control with Git: Experienced in tracking and managing code using Git for version control. Extensive Experience in Data Analysis: Proven ability to analyze complex datasets and derive meaningful insights. Proficiency in X-Omics Technologies: Familiarity with x-omics technologies and their applications in data analysis. Excellent Communication Skills: Ability to effectively communicate technical concepts and results to both technical and non-technical audiences.

Are you an experienced Workday Reporting Analyst with a desire to excel? If so, then Talent Software Services may have the job for you! Our client is seeking an experienced Workday Reporting Analyst to work at their company in Marietta, GA. Position Summary: This role offers an exciting opportunity to leverage your expertise in Workday Reporting and contribute to our organization's success. You'll work in a fast-paced environment, collaborating with various teams to meet the evolving reporting needs of our business. Primary Responsibilities/Accountabilities:<ul><li>Analyze reporting requirements to determine development methods, development templates, and report design.</li><li>Be a Workday Reporting expert with deep knowledge of the Workday ecosystem, including HCM, Recruiting, Benefits, Talent, Payroll, and Absence and Time Tracking.</li><li>Use best practices and industry standards in developing custom reports and calculated fields.</li><li>Partner with other report developers and functional experts to understand current demands of the business.</li><li>Work with technology/security teams to define and create calculated fields, security policies, and other Workday objects to support the evolving reporting needs of the organization.</li><li>Troubleshoot report-related day-to-day transactions and provide tier II support for any requests that may come in from various teams, resolving issues in a timely manner.</li><li>Maintain proper change management documentation to satisfy the company’s internal/external audit controls.</li><li>Mentor less experienced team members on the team in writing reports and building calculated fields.</li></ul> Qualifications:<ul><li>3 years of hands-on experience in Report Writing, preferably with an existing and up-to-date Workday Advanced Reporting certification.</li><li>Proficient in Advanced, Matrix, and Composite Reports.</li><li>Experience with Workday Dashboards, Worksheets, Prism, and Discovery Board.</li><li>Advanced proficiency in building complex calculated fields.</li><li>Proficiency in using the Workday Enterprise Interface Builder (EIB), BIRT, and Workday Studio.</li><li>Ability to work independently in a fast-paced environment.</li><li>Workday Pro certification desired.</li></ul>

Talent Software Services Interview Questions

Talent Software Services Interview Guides

Talent Software Services Interview Questions

Talent Software Services Salaries by Position

Talent Software Services Opening Jobs