Prepare for and practice interview questions from Contact government services, llc.

Contact government services, llc Interview Questions

Contact government services, llc 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

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?

Contact government services, llc Salaries by Position

Data Engineer Employment Type: Full-Time, Mid-level Department: Business Intelligence CGS is seeking a passionate and driven Data Engineer to support a rapidly growing Data Analytics and Business Intelligence platform focused on providing solutions that empower our federal customers with the tools and capabilities needed to turn data into actionable insights. The ideal candidate is a critical thinker and perpetual learner; excited to gain exposure and build skillsets across a range of technologies while solving some of our clients' toughest challenges. CGS brings motivated, highly skilled, and creative people together to solve the government's most dynamic problems with cutting-edge technology. To carry out our mission, we are seeking candidates who are excited to contribute to government innovation, appreciate collaboration, and can anticipate the needs of others. Here at CGS, we offer an environment in which our employees feel supported, and we encourage professional growth through various learning opportunities. Skills and attributes for success: -Complete development efforts across data pipeline to store, manage, store, and provision to data consumers. -Being an active and collaborating member of an Agile/Scrum team and following all Agile/Scrum best practices. -Write code to ensure the performance and reliability of data extraction and processing. -Support continuous process automation for data ingest. -Achieve technical excellence by advocating for and adhering to lean-agile engineering principles and practices such as API-first design, simple design, continuous integration, version control, and automated testing. -Work with program management and engineers to implement and document complex and evolving requirements. -Help cultivate an environment that promotes customer service excellence, innovation, collaboration, and teamwork. -Collaborate with others as part of a cross-functional team that includes user experience researchers and designers, product managers, engineers, and other functional specialists. Qualifications: -Must be a US Citizen. -Must be able to obtain a Public Trust Clearance. -7+ years of IT experience including experience in design, management, and solutioning of large, complex data sets and models. -Experience with developing data pipelines from many sources from structured and unstructured data sets in a variety of formats. -Proficiency in developing ETL processes, and performing test and validation steps. -Proficiency to manipulate data (Python, R, SQL, SAS). -Strong knowledge of big data analysis and storage tools and technologies. -Strong understanding of the agile principles and ability to apply them. -Strong understanding of the CI/CD pipelines and ability to apply them. -Experience with relational database, such as, PostgreSQL. -Work comfortably in version control systems, such as, Git Repositories. Ideally, you will also have: -Experience creating and consuming APIs. -Experience with DHS and knowledge of DHS standards a plus. -Candidates will be given special consideration for extensive experience with Python. -Ability to develop visualizations utilizing Tableau or PowerBI. -Experience in developing Shell scripts on Linux. -Demonstrated experience translating business and technical requirements into comprehensive data strategies and analytic solutions. -Demonstrated ability to communicate across all levels of the organization and communicate technical terms to non-technical audiences. Our Commitment: Contact Government Services (CGS) strives to simplify and enhance government bureaucracy through the optimization of human, technical, and financial resources. We combine cutting-edge technology with world-class personnel to deliver customized solutions that fit our client's specific needs. We are committed to solving the most challenging and dynamic problems. For the past seven years, we've been growing our government-contracting portfolio, and along the way, we've created valuable partnerships by demonstrating a commitment to honesty, professionalism, and quality work. Here at CGS we value honesty through hard work and self-awareness, professionalism in all we do, and to deliver the best quality to our consumers mending those relations for years to come. We care about our employees. Therefore, we offer a comprehensive benefits package: -Health, Dental, and Vision -Life Insurance -401k -Flexible Spending Account (Health, Dependent Care, and Commuter) -Paid Time Off and Observance of State/Federal Holidays Contact Government Services, LLC is an Equal Opportunity Employer. Applicants will be considered without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Join our team and become part of government innovation! Explore additional job opportunities with CGS on our Job Board: https://cgsfederal.com/join-our-team/ For more information about CGS please visit: https://www.cgsfederal.com or contact: Email: info@cgsfederal.com $112,597.33 - $152,810.66 a year

Sr. Data Engineer Employment Type: Full-Time, Mid-level Department: Business Intelligence CGS is seeking a passionate and driven Data Engineer to support a rapidly growing Data Analytics and Business Intelligence platform focused on providing solutions that empower our federal customers with the tools and capabilities needed to turn data into actionable insights. The ideal candidate is a critical thinker and perpetual learner; excited to gain exposure and build skillsets across a range of technologies while solving some of our clients' toughest challenges. CGS brings motivated, highly skilled, and creative people together to solve the government's most dynamic problems with cutting-edge technology. To carry out our mission, we are seeking candidates who are excited to contribute to government innovation, appreciate collaboration, and can anticipate the needs of others. Here at CGS, we offer an environment in which our employees feel supported, and we encourage professional growth through various learning opportunities. Skills and attributes for success: -Complete development efforts across data pipeline to store, manage, store, and provision to data consumers. -Being an active and collaborating member of an Agile/Scrum team and following all Agile/Scrum best practices. -Write code to ensure the performance and reliability of data extraction and processing. -Support continuous process automation for data ingest. -Achieve technical excellence by advocating for and adhering to lean-agile engineering principles and practices such as API-first design, simple design, continuous integration, version control, and automated testing. -Work with program management and engineers to implement and document complex and evolving requirements. -Help cultivate an environment that promotes customer service excellence, innovation, collaboration, and teamwork. -Collaborate with others as part of a cross-functional team that includes user experience researchers and designers, product managers, engineers, and other functional specialists. Qualifications: -Must be a US Citizen. -Must be able to obtain a Public Trust Clearance. -7+ years of IT experience including experience in design, management, and solutioning of large, complex data sets and models. -Experience with developing data pipelines from many sources from structured and unstructured data sets in a variety of formats. -Proficiency in developing ETL processes, and performing test and validation steps. -Proficiency to manipulate data (Python, R, SQL, SAS). -Strong knowledge of big data analysis and storage tools and technologies. -Strong understanding of the agile principles and ability to apply them. -Strong understanding of the CI/CD pipelines and ability to apply them. -Experience with relational database, such as, PostgreSQL. -Work comfortably in version control systems, such as, Git Repositories. Ideally, you will also have: -Experience creating and consuming APIs. -Experience with DHS and knowledge of DHS standards a plus. -Candidates will be given special consideration for extensive experience with Python. -Ability to develop visualizations utilizing Tableau or PowerBI. -Experience in developing Shell scripts on Linux. -Demonstrated experience translating business and technical requirements into comprehensive data strategies and analytic solutions. -Demonstrated ability to communicate across all levels of the organization and communicate technical terms to non-technical audiences. Our Commitment: Contact Government Services (CGS) strives to simplify and enhance government bureaucracy through the optimization of human, technical, and financial resources. We combine cutting-edge technology with world-class personnel to deliver customized solutions that fit our client's specific needs. We are committed to solving the most challenging and dynamic problems. For the past seven years, we've been growing our government-contracting portfolio, and along the way, we've created valuable partnerships by demonstrating a commitment to honesty, professionalism, and quality work. Here at CGS we value honesty through hard work and self-awareness, professionalism in all we do, and to deliver the best quality to our consumers mending those relations for years to come. We care about our employees. Therefore, we offer a comprehensive benefits package: -Health, Dental, and Vision -Life Insurance -401k -Flexible Spending Account (Health, Dependent Care, and Commuter) -Paid Time Off and Observance of State/Federal Holidays Contact Government Services, LLC is an Equal Opportunity Employer. Applicants will be considered without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Join our team and become part of government innovation! Explore additional job opportunities with CGS on our Job Board: https://cgsfederal.com/join-our-team/ For more information about CGS please visit: https://www.cgsfederal.com or contact: Email: info@cgsfederal.com $144,768 - $209,109.33 a year

Business Analyst Employment Type: Full-Time, Experienced Department: Information Technology CGS is looking for business analysts to work with a large federal agency! As a Business Analyst in Business operations and Content Strategy for CGS, you will partner with internal business owners and external partners to understand new business opportunities and define functional requirements. CGS brings motivated, highly skilled, and creative people together to solve the government's most dynamic problems with cutting-edge technology. To carry out our mission, we are seeking candidates who are excited to contribute to government innovation, appreciate collaboration, and can anticipate the needs of others. Here at CGS, we offer an environment in which our employees feel supported, and we encourage professional growth through various learning opportunities. Skills and attributes for success: - Support the development of briefings, agendas, and other general documentation support as directed, including training material and demonstration sessions for new and existing technologies to various stakeholders. - Document and analyze business and functional requirements so that they may be accurately translated into process maps and technical system requirements - Develop comprehensive documentation that meets organizational standards, to include but not limited to basic system architectural diagrams/wireframes, concepts of operations, monthly status reports - Create high-level briefings and communications materials for customers, management, and executive stakeholders - Work with the government and team members to identify, recommend, and implement opportunities for service delivery improvement and new technology implementation - Evaluate program materials and develop innovative approaches for improvement - Independently gather information from subject matter experts to develop, organize, and write procedure manuals, technical specifications, and process documentation - Develop and implement a deep understanding of Microsoft and Atlassian products and services (Teams, SharePoint, Visio, Jira, Confluence) to translate complex product information into simple, polished, and engaging content - Research, outline, write, and edit new and existing content, working closely with various team members to understand project requirements - Develop content in various media forms for maximum usability, with a consistent and cohesive voice across all documentation - Perform risk management, including identifying, prioritizing, and mitigating risks, and communicating and escalating risks and issues - Support a continuous improvement process by providing recommendations on improving products, services, and processes. - Manage client interaction and expectations regarding team efforts - Identify and coordinate cross-team dependencies and collaboration - Continually seek opportunities to increase customer satisfaction, develop and deepen long-lasting client relationships Qualifications: - Must be a U.S. Citizen - Bachelor's Degree (Computer Science, or engineering) - Must be able to successfully complete a stringent Background Investigation and obtain required Government Security clearance - 7+ years of experience in business analysis, systems analysis, and/or design of information systems programs and related business processes - Experience working with phase-based and Agile delivery methods - Experience with Jira or other Agile tools - Ability to clearly communicate technical concepts to both technical and non-technical users. - Must be able to work well both in a team environment and independently. - Must possess exceptional attention to detail - Excellent interpersonal and communication skills - Familiarity with government projects and policy/procedures teams - Demonstrates ability to interact comfortably with Senior Leadership and/or Government Executives and staff on a day-to-day basis - Experience in managing client requirements and small teams - Excellent analytical skills and business presentation skills Ideally, you will also have: - Experience supporting DHS HQ or other US Federal Agencies - Experience tracking and reporting project or program delivery progress and budget execution - Experience developing project briefs and reports for non-technical audiences - Knowledge of the federal acquisition lifecycle - Familiarity with Business Intelligence and Data Analytics - Project Management, Agile, and/or Cyber Certifications (PMP / ACP / CSM / SAFe / CISM) Our Commitment: Contact Government Services (CGS) strives to simplify and enhance government bureaucracy through the optimization of human, technical, and financial resources. We combine cutting-edge technology with world-class personnel to deliver customized solutions that fit our client's specific needs. We are committed to solving the most challenging and dynamic problems. For the past seven years, we've been growing our government contracting portfolio, and along the way, we've created valuable partnerships by demonstrating a commitment to honesty, professionalism, and quality work. Here at CGS we value honesty through hard work and self-awareness, professionalism in all we do, and to deliver the best quality to our consumers mending those relations for years to come. We care about our employees. Therefore, we offer a comprehensive benefits package. - Health, Dental, and Vision - Life Insurance - 401k - Flexible Spending Account (Health, Dependent Care, and Commuter) - Paid Time Off and Observance of State/Federal Holidays Contact Government Services, LLC is an Equal Opportunity Employer. Applicants will be considered without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Join our team and become part of government innovation! Explore additional job opportunities with CGS on our Job Board: https://cgsfederal.com/join-our-team/ For more information about CGS please visit: https://www.cgsfederal.com or contact: Email: info@cgsfederal.com $102,890.67 - $139,637.34 a year

Senior FOIA Disclosure Product Manager Employment Type: Full-Time, Experienced Department: Information Technology CGS is seeking a Senior FOIA Disclosure Product Manager to join our team supporting the IT mission of a large federal agency. This position will allow candidates to demonstrate expertise in performing product management and product marketing tasks. CGS brings motivated, highly skilled, and creative people together to solve the government's most dynamic problems with cutting-edge technology. To carry out our mission, we are seeking candidates who are excited to contribute to government innovation, appreciate collaboration, and can anticipate the needs of others. Here at CGS, we offer an environment in which our employees feel supported, and we encourage professional growth through various learning opportunities. Skills and attributes for success: - Drive the SecureRelease product and business-planning process across cross-functional teams of the company - Analyze consumer needs, current market trends, and potential partnerships from an ROI and build vs. buy perspective - Assess current competitor offerings, seeking opportunities for differentiation - Analyze product requirements and develop appropriate programs to ensure they're successfully achieved - Develop, implement, and maintain production timelines across multiple departments - Drive the execution of the SecureRelease product, including product research, market research, competitive analysis, planning, positioning, roadmap development, requirements development, and product launch - Translate product strategy into detailed requirements for prototype construction and final product development by engineering teams - Create product strategy documents that describe business cases, high-level use cases, technical requirements, revenue, and ROI - Analyze market data to develop sales strategies, and define product objectives for effective marketing communications plans - Collaborate closely with engineering, production, marketing, and sales teams on the development, QA, and release of products and balance of resources to ensure success for the entire organization - Develop product positioning and messaging that differentiates Deloitte and its features across primary market segments - Manage and deliver Release Notes - Schedule walkthroughs - Manage client notifications - Schedule product deployment - Manage the feature requests queue and priorities Qualifications: - Bachelor's degree in product design or engineering - Strong experience in a dynamic product management role - Proven experience overseeing all elements of the product development lifecycle - Highly effective cross-functional team management - Previous experience delivering finely-tuned product marketing strategies - Exceptional writing and editing skills combined with strong presentation and public speaking skills Ideally, you will also have: - Master's degree in product design or engineering - Previous software and web development experience - Proven experience working as a product developer in a non-managerial role Our Commitment: Contact Government Services (CGS) strives to simplify and enhance government bureaucracy through the optimization of human, technical, and financial resources. We combine cutting-edge technology with world-class personnel to deliver customized solutions that fit our client's specific needs. We are committed to solving the most challenging and dynamic problems. For the past seven years, we've been growing our government-contracting portfolio, and along the way, we've created valuable partnerships by demonstrating a commitment to honesty, professionalism, and quality work. Here at CGS we value honesty through hard work and self-awareness, professionalism in all we do, and to deliver the best quality to our consumers mending those relations for years to come. We care about our employees. Therefore, we offer a comprehensive benefits package. - Health, Dental, and Vision - Life Insurance - 401k - Flexible Spending Account (Health, Dependent Care, and Commuter) - Paid Time Off and Observance of State/Federal Holidays Contact Government Services, LLC is an Equal Opportunity Employer. Applicants will be considered without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Join our team and become part of government innovation! Explore additional job opportunities with CGS on our Job Board: https://cgsfederal.com/join-our-team/ For more information about CGS please visit: https://www.cgsfederal.com or contact: Email: info@cgsfederal.com $149,760 - $216,320 a year

Senior FOIA Disclosure Product Manager Employment Type: Full-Time, Experienced Department: Information Technology CGS is seeking a Senior FOIA Disclosure Product Manager to join our team supporting the IT mission of a large federal agency. This position will allow candidates to demonstrate expertise in performing product management and product marketing tasks. CGS brings motivated, highly skilled, and creative people together to solve the government's most dynamic problems with cutting-edge technology. To carry out our mission, we are seeking candidates who are excited to contribute to government innovation, appreciate collaboration, and can anticipate the needs of others. Here at CGS, we offer an environment in which our employees feel supported, and we encourage professional growth through various learning opportunities. Skills and attributes for success: - Drive the SecureRelease product and business-planning process across cross-functional teams of the company - Analyze consumer needs, current market trends, and potential partnerships from an ROI and build vs. buy perspective - Assess current competitor offerings, seeking opportunities for differentiation - Analyze product requirements and develop appropriate programs to ensure they're successfully achieved - Develop, implement, and maintain production timelines across multiple departments - Drive the execution of the SecureRelease product, including product research, market research, competitive analysis, planning, positioning, roadmap development, requirements development, and product launch - Translate product strategy into detailed requirements for prototype construction and final product development by engineering teams - Create product strategy documents that describe business cases, high-level use cases, technical requirements, revenue, and ROI - Analyze market data to develop sales strategies, and define product objectives for effective marketing communications plans - Collaborate closely with engineering, production, marketing, and sales teams on the development, QA, and release of products and balance of resources to ensure success for the entire organization - Develop product positioning and messaging that differentiates Deloitte and its features across primary market segments - Manage and deliver Release Notes - Schedule walkthroughs - Manage client notifications - Schedule product deployment - Manage the feature requests queue and priorities Qualifications: - Bachelor's degree in product design or engineering - Strong experience in a dynamic product management role - Proven experience overseeing all elements of the product development lifecycle - Highly effective cross-functional team management - Previous experience delivering finely-tuned product marketing strategies - Exceptional writing and editing skills combined with strong presentation and public speaking skills Ideally, you will also have: - Master's degree in product design or engineering - Previous software and web development experience - Proven experience working as a product developer in a non-managerial role Our Commitment: Contact Government Services (CGS) strives to simplify and enhance government bureaucracy through the optimization of human, technical, and financial resources. We combine cutting-edge technology with world-class personnel to deliver customized solutions that fit our client's specific needs. We are committed to solving the most challenging and dynamic problems. For the past seven years, we've been growing our government-contracting portfolio, and along the way, we've created valuable partnerships by demonstrating a commitment to honesty, professionalism, and quality work. Here at CGS we value honesty through hard work and self-awareness, professionalism in all we do, and to deliver the best quality to our consumers mending those relations for years to come. We care about our employees. Therefore, we offer a comprehensive benefits package. - Health, Dental, and Vision - Life Insurance - 401k - Flexible Spending Account (Health, Dependent Care, and Commuter) - Paid Time Off and Observance of State/Federal Holidays Contact Government Services, LLC is an Equal Opportunity Employer. Applicants will be considered without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Join our team and become part of government innovation! Explore additional job opportunities with CGS on our Job Board: https://cgsfederal.com/join-our-team/ For more information about CGS please visit: https://www.cgsfederal.com or contact: Email: info@cgsfederal.com $149,760 - $216,320 a year

FOIA Disclosure Product Manager Employment Type: Full-Time, Experienced Department: Information Technology CGS is seeking a FOIA Disclosure Product Manager to join our team supporting the IT mission of a large federal agency. This position will allow candidates to demonstrate expertise in performing product management and product marketing tasks. CGS brings motivated, highly skilled, and creative people together to solve the government's most dynamic problems with cutting-edge technology. To carry out our mission, we are seeking candidates who are excited to contribute to government innovation, appreciate collaboration, and can anticipate the needs of others. Here at CGS, we offer an environment in which our employees feel supported, and we encourage professional growth through various learning opportunities. Skills and attributes for success: - Drive the SecureRelease product and business-planning process across cross-functional teams of the company - Analyze consumer needs, current market trends, and potential partnerships from an ROI and build vs. buy perspective - Assess current competitor offerings, seeking opportunities for differentiation - Analyze product requirements and develop appropriate programs to ensure they're successfully achieved - Develop, implement, and maintain production timelines across multiple departments - Drive the execution of the SecureRelease product, including product research, market research, competitive analysis, planning, positioning, roadmap development, requirements development, and product launch - Translate product strategy into detailed requirements for prototype construction and final product development by engineering teams - Create product strategy documents that describe business cases, high-level use cases, technical requirements, revenue, and ROI - Analyze market data to develop sales strategies, and define product objectives for effective marketing communications plans - Collaborate closely with engineering, production, marketing, and sales teams on the development, QA, and release of products and balance of resources to ensure success for the entire organization - Develop product positioning and messaging that differentiates Deloitte and its features across primary market segments - Manage and deliver Release Notes - Schedule walkthroughs - Manage client notifications - Schedule product deployment - Manage the feature requests queue and priorities Qualifications: - Bachelor's degree in product design or engineering - Strong experience in a dynamic product management role - Proven experience overseeing all elements of the product development lifecycle - Highly effective cross-functional team management - Previous experience delivering finely-tuned product marketing strategies - Exceptional writing and editing skills combined with strong presentation and public speaking skills Ideally, you will also have: - Master's degree in product design or engineering - Previous software and web development experience - Proven experience working as a product developer in a non-managerial role Our Commitment: Contact Government Services (CGS) strives to simplify and enhance government bureaucracy through the optimization of human, technical, and financial resources. We combine cutting-edge technology with world-class personnel to deliver customized solutions that fit our client's specific needs. We are committed to solving the most challenging and dynamic problems. For the past seven years, we've been growing our government-contracting portfolio, and along the way, we've created valuable partnerships by demonstrating a commitment to honesty, professionalism, and quality work. Here at CGS we value honesty through hard work and self-awareness, professionalism in all we do, and to deliver the best quality to our consumers mending those relations for years to come. We care about our employees. Therefore, we offer a comprehensive benefits package. - Health, Dental, and Vision - Life Insurance - 401k - Flexible Spending Account (Health, Dependent Care, and Commuter) - Paid Time Off and Observance of State/Federal Holidays Contact Government Services, LLC is an Equal Opportunity Employer. Applicants will be considered without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Join our team and become part of government innovation! Explore additional job opportunities with CGS on our Job Board: https://cgsfederal.com/join-our-team/ For more information about CGS please visit: https://www.cgsfederal.com or contact: Email: info@cgsfederal.com $116,480 - $158,080 a year

Contact government services, llc Interview Questions

Contact government services, llc Interview Guides

Contact government services, llc Interview Questions

Contact government services, llc Salaries by Position

Contact government services, llc Opening Jobs