Prepare for and practice interview questions from Chenega Corporation.

Chenega Corporation Interview Questions

Chenega Corporation 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

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?

Chenega Corporation Salaries by Position

**Summary** Come join a company that strives for _Extraordinary People and Exceptional Performance_ ! **Chenega Professional & Technical Services, LLC,** a **Chenega Professional Services** company, is looking for a **Business Analyst** for a software application development project with the Department of Energys (DOE), National Nuclear Security Administration (NNSA). In this role, the **Business Analyst** will support the development, deployment, enhancement, and maintenance of the Clearance Action Tracking System (CATS). Our company offers employees the opportunity to join a team where there is a robust employee benefits program, management engagement, quality leadership, an atmosphere of teamwork, recognition for performance, and promotion opportunities. We actively strive to channel our highly engaged employees knowledge, critical thinking, innovative solutions for our clients. **Responsibilities** + Build fully operational applications following a standard prescribed methodology that ensures stringent process management, quality assurance, configuration management, and security conformance control. + Contribute to the continuous improvement of the team processes and efficiency of the application through contributing to all Agile ceremonies including (but not limited to) Scrum, Review, and Retrospective. + Provide maintenance and enhancement services including modernization and feasible customization of business applications. + Troubleshoot and repair customized production applications with requirements analysis, quality assurance testing and updated documentation. + Conduct all maintenance and enhancement efforts following a standard prescribed methodology that ensures stringent project management, quality assurance, configuration management, and security conformance controls. **Qualifications** + Ability to obtain and maintain DOE Q Security Clearance. Applicant will be subject to a US Government investigation. + 4-6 years of ASP.Net, SQL Server experience. + Familiarity with Test Driven Development and CI/CD principles. + Ability to perform effectively as part of a fast-paced mature project team. + Willingness to acquire new skills and master new technologies quickly is required, while a demonstrable eagerness to do so is better still. + Knowledge of working in Iterative Agile software development environments is favorable. + Must be able to read, write, speak, and understand English fluently and possess strong communication skills. _Final salary determination based on skill-set, qualifications, and approved funding._ Many of our jobs come with great benefits Some offerings are dependent upon the role, work schedule, or location, and may include the following: **Paid Time Off** PTO / Vacation 5.67 hours accrued per pay period / 136 hours accrued annually Paid Holidays - 11 California residents receive an additional 24 hours of sick leave a year **Health & Wellness** Medical Dental Vision Prescription Employee Assistance Program Short- & Long-Term Disability Life and AD&D Insurance **Spending Account** Flexible Spending Account Health Savings Account Health Reimbursement Account Dependent Care Spending Account Commuter Benefits **Retirement** 401k / 401a **Voluntary Benefits** Hospital Indemnity Critical Illness Accident Insurance Pet Insurance Legal Insurance ID Theft Protection **Teleworking Permitted?** Yes **Teleworking Details** Full Time Remote **Estimated Salary/Wage** USD $75,000.00/Yr. Up to USD $85,000.00/Yr. Chenega Corporation and family of companies is an EOE. Equal Opportunity Employer/Veterans/Disabled Native preference under PL 93-638. We participate in the E-Verify Employment Verification Program

**Req ID:** 33364 **Summary** **Business Analyst, Intermediate** **Albuquerque, NM** Are you ready to enhance your skills and build your career in a rapidly evolving business climate? Are you looking for a career where professional development is embedded in your employers core culture? If so, Chenega Military, Intelligence & Operations Support (MIOS) could be the place for you! Join our team of professionals who support large-scale government operations by leveraging cutting-edge technology and take your career to the next level! At Cyberstar, we aim to analyze and boost human and business performance through the implementation of business process redesign and information technology (IT) modernization to include data analytics and cloud computing. We offer an alternate solution to improving the quality and effectiveness of business operations. In an ever-changing economy, Cyberstar helps companies better read and understand their market data through the synchronization of process innovation, human dynamics, analysis, and the integration of data technology capabilities, to ensure functional optimization in their business. The **Business Analyst, Intermediate** Supports the management consulting activities alongside the project/program manager, technical staff, and federal clients for IT strategy and business support services. The **Business Analyst, Intermediate** is responsible for the technical, contractual, administrative, and financial aspects of the assigned task(s) as assigned by the Federal Task Lead. Duties may include high-level analysis and support related to statutory requirements and compliance, assignments to support the Bureau mission/strategic goals, business process reengineering, implementation plans, configuration management, change management, IT asset management, IT service request fulfillment, and/or integration of IT investment processes to other procedures and disciplines. **Responsibilities** + Assist Senior Business Analysts in providing internal and external analysis services to + management and technical staff with supporting IT investments and solving complex IT + project management issues in accordance with federal laws, regulations, and procedures. + Help plan and conduct research and development work on projects of major + complexity with the origination and application of new and best practices techniques. + Identify best practices and create and assess performance measurements. + Assist in reviewing and analyzing cost, schedule, and performance requirements for federal IT investments. + Apply consistent management approaches to IT Portfolio Management to increase the data quality of data through best practices and documentation. + Other duties as assigned. **Qualifications** + Bachelors degree OR + High school diploma or GED and 4+ years of equivalent experience + 5+ years of relevant experience required + Background check required, with the ability to obtain a Public Trust Clearance **Knowledge, Skills, and Abilities:** + Knowledge of and experience with federal IT Investment laws, regulations, and processes including, but not limited to, FITARA, the Clinger-Cohen Act of 1996, Title III of the EGovernment Act of 2002, and FISMA. + Ability to review and analyze cost, schedule, and performance requirements for federal IT investments. + Knowledge of OMB reporting requirements and adapting internal reporting to align with applicable external. + Ability to apply consistent management approaches to IT Portfolio Management that increase the quality of data through best practices and documentation. + Excellent verbal and written communication skills and leadership skills + Strong coordination, organization, teaming, and communication skills. + Must have excellent organizational, scheduling, and prioritization skills. + Must have the ability to maintain a high level of confidentiality, ethics, and integrity. + Ability to work well individually or in a group setting. + Ability to interact with co-workers to develop a team environment. + Ability to work under pressure and time constraints. + Ability to work independently without direct supervision or guidance. **How youll grow** At Chenega MIOS, our professional development plan focuses on helping our team members at every level of their careers to identify and use their strengths to do their best work every day. From entry-level employees to senior leaders, we believe theres always room to learn. We offer opportunities to help sharpen skills in addition to hands-on experience in the global, fast-changing business world. From on-the-job learning experiences to formal development programs, our professionals have a variety of opportunities to continue to grow throughout their careers. **Benefits** At Chenega MIOS, we know that great people make a great organization. We value our team members and offer them a broad range of benefits. Learn more about what working at Chenega MIOS can mean for you. **Chenega MIOSs culture** Our positive and supportive culture encourages our team members to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them be healthy, centered, confident, and aware. We offer well-being programs and continuously look for new ways to maintain a culture where we excel and lead healthy, happy lives. **Corporate citizenship** Chenega MIOS is led by a purpose to make an impact that matters. This purpose defines who we are and extends to relationships with our clients, our team members, and our communities. We believe that business has the power to inspire and transform. We focus on education, giving, skill-based volunteerism, and leadership to help drive positive social impact in our communities. Learn more about Chenegas impact on the world. Chenega MIOS News- https://chenegamios.com/news/ **Tips from your Talent Acquisition Team** We want job seekers exploring opportunities at Chenega MIOS to feel prepared and confident. To help you with your research, we suggest you review the following links: Chenega MIOS web site - www.chenegamios.com Glassdoor - https://www.glassdoor.com/Overview/Working-at-Chenega-MIOS-EI_IE369514.11,23.htm LinkedIn - https://www.linkedin.com/company/1472684/ Facebook - https://www.facebook.com/chenegamios/ #Cyberstar, LLC Chenega Corporation and family of companies is an EOE. Equal Opportunity Employer/Veterans/Disabled Native preference under PL 93-638. We participate in the E-Verify Employment Verification Program

**Req ID:** 33010 **Summary** **Junior Business Analyst** **Albuquerque, NM** Are you ready to enhance your skills and build your career in a rapidly evolving business climate? Are you looking for a career where professional development is embedded in your employers core culture? If so, Chenega Military, Intelligence & Operations Support (MIOS) could be the place for you! Join our team of professionals who support large-scale government operations by leveraging cutting-edge technology and take your career to the next level! At Cyberstar, we aim to analyze and boost human and business performance through the implementation of business process redesign and information technology (IT) modernization to include data analytics and cloud computing. We offer an alternate solution to improving the quality and effectiveness of business operations. In an ever-changing economy, Cyberstar helps companies better read and understand their market data through the synchronization of process innovation, human dynamics, analysis, and the integration of data technology capabilities, to ensure functional optimization in their business. The **Junior Business Analyst** works alongside the project/program manager, technical staff, and federal clients for IT strategy and business support services. The **Junior Business Analyst** is responsible for the technical, contractual, administrative, and financial aspects of the assigned task(s) as assigned by the Federal Task Lead. Work may include analysis and support related to statutory requirements and compliance, assignments to support the agency mission/strategic goals, business process reengineering, implementation plans, configuration management, change management, IT asset management, IT service request fulfillment, and/or integration of IT investment processes to other procedures and disciplines. **Responsibilities** + Assist the Senior Business Analyst in providing internal/external analysis services to management and technical staff with supporting IT investments and solving complex IT project management issues in accordance with federal laws, regulations, and procedures. + Help plan, and conduct research, and development work on projects of major complexity with the origination and application of new and best practices techniques. + Identify best practices and create and assess performance measurements. + Assist in reviewing and analyze cost, schedule, and performance requirements for federal IT investments. + Apply consistent management approaches to IT Portfolio Management to increase data quality of data through best practices and documentation. + Other duties as assigned. **Qualifications** + Bachelors degree + High school diploma or GED equivalent with 4+ years of experience may be substituted in lieu of a degree + 3+ years of relevant experience + Background check required with the ability to obtain a public trust **Knowledge, Skills and Abilities:** + Knowledge of and experience with supporting project management office operations regarding the management, planning, implementation, and all phases of the capital planning and strategic planning processes. + Knowledge of process improvement and reengineering methodologies and principles as applied to process modernization + Knowledge of configuration management, ITIL Framework, change management, IT asset management, and IT service request fulfillment. + Proven experience in activity and data modeling, developing modern business methods, identifying best practices, and creating and assessing performance measurements. + Ability to provide group facilitation, interviewing, training, and other forms of knowledge transfer. + Ability to meet cost, schedule, and performance requirements for federal IT + investments. + Knowledge of FITARA, SDLC, FEA, Capital Planning, and FISMA. + Strong verbal and written communication skills with the ability to communicate effectively to a diverse group of team members, stakeholders, and senior leadership. + Must have excellent organizational, scheduling, and prioritization skills. + Must have the ability to maintain a high level of confidentiality, ethics, and integrity. + Ability to work well individually or in a group setting. + Ability to interact with co-workers to develop a team environment. + Ability to work under pressure and time constraints. + Ability to work independently without direct supervision or guidance. **How youll grow** At Chenega MIOS, our professional development plan focuses on helping our team members at every level of their careers to identify and use their strengths to do their best work every day. From entry-level employees to senior leaders, we believe theres always room to learn. We offer opportunities to help sharpen skills in addition to hands-on experience in the global, fast-changing business world. From on-the-job learning experiences to formal development programs, our professionals have a variety of opportunities to continue to grow throughout their careers. **Benefits** At Chenega MIOS, we know that great people make a great organization. We value our team members and offer them a broad range of benefits. Learn more about what working at Chenega MIOS can mean for you. **Chenega MIOSs culture** Our positive and supportive culture encourages our team members to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them be healthy, centered, confident, and aware. We offer well-being programs and continuously look for new ways to maintain a culture where we excel and lead healthy, happy lives. **Corporate citizenship** Chenega MIOS is led by a purpose to make an impact that matters. This purpose defines who we are and extends to relationships with our clients, our team members, and our communities. We believe that business has the power to inspire and transform. We focus on education, giving, skill-based volunteerism, and leadership to help drive positive social impact in our communities. Learn more about Chenegas impact on the world. Chenega MIOS News- https://chenegamios.com/news/ **Tips from your Talent Acquisition Team** We want job seekers exploring opportunities at Chenega MIOS to feel prepared and confident. To help you with your research, we suggest you review the following links: Chenega MIOS web site - www.chenegamios.com Glassdoor - https://www.glassdoor.com/Overview/Working-at-Chenega-MIOS-EI_IE369514.11,23.htm LinkedIn - https://www.linkedin.com/company/1472684/ Facebook - https://www.facebook.com/chenegamios/ #Cyberstar, LLC Chenega Corporation and family of companies is an EOE. Equal Opportunity Employer/Veterans/Disabled Native preference under PL 93-638. We participate in the E-Verify Employment Verification Program

**Summary** **AJANTA CONSULTING, LLC** Wright Patterson AFB **THIS POSITION IS CONTINGENT UPON BID AWARD** The **Research Data Scientist SME** will serve as a Subject Matter Expert (SME) in research design, data management, and data analysis to be located within the Operational Support Team (FESO) branch of the Aerospace Medicine Studies and Analysis (FES) Division and facilitate and support the collaboration between Air and Space Human Performance Branch (RHBA) and FESO by understanding the FESO data sources, the Operational Support Teams research needs, and translating those to the RHBA team so that RHBA can develop associated research programs. **Responsibilities** + Assist in designing, formulating, conducting, and leading data analysis of operational studies on health surveillance data/health records/other relevant military records and risk reduction of negative health outcomes affecting the DAF total force population. + Use judgement and originality in developing innovative approaches to define and resolve highly complex situations. + Assist in the management of the retrieval and integration of health information data, personnel records, deployment-related records, health surveillance registries, and other military-related data into useable format for end-users. + Shall assist in data collection in support of the RHBA and FESO collaborative research. + Draft reports, prepare, and/or present reports, documents, and/or presentations pertaining to the status of the research and data analysis as requested, and meet RHBA projected suspense dates. + Present results of studies or investigations through briefings, technical reports, and publication into scientific journals. + Apply knowledge of science/technology to analyze and resolve multifaceted issues/problems with minimal guidance and collaborate with technical area stakeholders to develop strategies for effective execution within a particular technology area. + Support the RHBA mission by coordinating the RHBA and FESO collaborative research projects. + Conduct any other functions and duties recognized as being necessary to conduct their primary role within the scope of the effort. + Other duties as assigned. **Qualifications** + Masters degree in Epidemiology, Statistics, Data Science, or Bioinformatics + Minimum five (5) years of demonstrated experience in advanced analytical skills to include visual analytics in population health and health data surveillance. **Knowledge, Skills and Abilities** + Ability to design, formulate, conduct, and lead data analysis of operational studies on health surveillance data/health records/other relevant military records and risk reduction of negative health outcomes affecting the DAF total force population. + Proficient in the Microsoft Office suite of applications, Adobe Acrobat, and SharePoint, and shall have experience to demonstrate expert knowledge in descriptive statistics, as well as SAS/SAS EG. + Possess demonstrated experience with writing technical documentation, research and development programs, and research reports. Examples may include functional requirements documents, test plans, human subjects protocols, technical reports, and training material. + Possess experience within a health analytics related field and working with DAF related data. + Ability to complete Collaborative Institutional Training Initiative human subject use training (CITI training) and DAF Health Insurance Portability and Accountability Act (HIPAA) training within the first month and maintain annual currency thereafter. The primary duties for this position cannot be carried out without this training. This course is required for investigators and staff conducting research with human subjects. + Ability to sign a Non-Disclosure Agreement (NDA) based on the potential access to confidential, proprietary, and/or sensitive information **Physical Demands** _:_ (The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.) + Contractor will be required to travel when authorized to participate in customer business line-related travel, including meetings and conferences, to fulfill respective mission goals. + While performing the duties of this Job, the employee is regularly required to sit and talk or hear. The employee may use repeated motions that include the arms, wrists, hands and/or fingers. The employee is occasionally required to walk, stand, climb, balance, stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision. _Any estimated salary provided by this job board may not align with Chenega's compensation program. Please apply to connect with a recruiter who can provide more details._ **Executive Order 13495, The Non Displacement of Qualified Workers Under Service Contracts provide first right of refusal to incumbents on contracts. If the position is accepted by the incumbent on the job, other application/resume of non-incumbents will not be reviewed.** Chenega Corporation and family of companies is an EOE. Equal Opportunity Employer/Veterans/Disabled Native preference under PL 93-638. We participate in the E-Verify Employment Verification Program

Chenega Corporation Interview Questions

Chenega Corporation Interview Guides

Chenega Corporation Interview Questions

Chenega Corporation Salaries by Position

Chenega Corporation Opening Jobs