Prepare for and practice interview questions from Marathon Ts.

Marathon Ts Interview Questions

Marathon Ts Interview Guides

<p>Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.</p>

<p>What factors could have biased this result, and what would you look into?</p>


<p>What could potentially bias the average boarding time in favor of an airline that only flies domestically?</p>

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

<p>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.</p>

<p>Write a query to randomly sample a row from this table.</p>

<p><strong>Input:</strong></p>

<p><code>big_table</code> table</p>

<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

<p>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.</p>

<p>How would you assess the validity of the result?</p>


Experiment Validity

Marathon Ts Salaries by Position

<h3>Job Description</h3><div>Job Description<div><p>Data Engineer is responsible for supporting our enterprise data warehouse for our Supply Chain Operations. As a Data Engineer, you will be part of a dynamic team with engineers of all experience levels who help each other build and grow technical and leadership skills while creating, deploying, and supporting production applications. In addition, Data Engineer IIs may be involved in configuration, security, resilience, performance tuning and production monitoring.</p><p>Key Responsibilities:</p><p>· 60% Delivery and Execution - Collaborates and pairs with other product team members (UX, engineering, and product management) to create secure, reliable, scalable software solutions; Documents, reviews and ensures that all quality and change control standards are met; Works with Product Team to ensure user stories that are developer-ready, easy to understand, and testable; Writes custom code or scripts to automate infrastructure, monitoring services, and test cases; Writes custom code or scripts to do destructive testing to ensure adequate resiliency in production; Program <span class="long-word">configuration/modification</span> and setup activities on large projects using HD approved methodology; Configures commercial off the shelf solutions to align with evolving business needs Creates meaningful dashboards, logging, alerting, and responses to ensure that issues are captured and addressed proactively</p><p>· 20% Learning - Actively seeks ways to grow and be challenged using both formal and informal development channels; Learns through successful and failed experiment when tackling new problems</p><p>· 20% Plans and Aligns - Collaborates with other team members in agile processes; Assists in creating new and better ways for the team to be successful; Relates openly and comfortably with diverse groups of people; Builds partnerships and works collaboratively with others to meet shared objectives</p><p>- Must have experience with: Python, SQL, and GCP/Big Query</p></div>Company Description<div>Marathon TS provides a full range of professional services for clients that require support from professionals with specialized skills and experience in a specific technical area or subject matter. Marathon TS also provides IT solutions, including strategy, operations, transformation and mission support.</div></div><h3>Company Description</h3><div>Marathon TS provides a full range of professional services for clients that require support from professionals with specialized skills and experience in a specific technical area or subject matter. Marathon TS also provides IT solutions, including strategy, operations, transformation and mission support.</div>

<h3>Job Description</h3><div>Job Description<div><p>Marathon TS is looking for a Junior-Level Business Analyst that will support our client. This role involves gathering and analyzing business requirements, identifying process improvements, and ensuring alignment between business strategies and IT solutions. The Business Analyst will work closely with stakeholders to document and translate business needs into actionable solutions, facilitate workshops, and support technical integration and transition activities.</p><p><strong>Responsibilities:</strong><strong> </strong><br />Requirement Gathering and Analysis:</p><ul><li>Assist in conducting analysis of business requirements and processes to identify improvement opportunities.</li><li>Help collect and document current state architectures for applications, systems, or platforms to support retirement assessments.</li><li>Support the mapping of system requirements from the current state to the modernized state to ensure scope of retirement.</li></ul><p>Business Strategy and Alignment:</p><ul><li>Assist in the development of enterprise-wide strategies and architectures.</li><li>Help align business strategies with IT solutions and capabilities.</li><li>Provide support for decision-making related to transition planning and architectural alignment with the IRS's long-term business and technology vision.</li></ul><p>Process Improvement:</p><ul><li>Analyze business processes and workflows to identify inefficiencies and areas for improvement.</li><li>Assist in developing and documenting business cases for process improvements and new initiatives.</li><li>Work with stakeholders to implement process changes and monitor their impact.</li></ul><p>Documentation and Reporting:</p><ul><li>Prepare business requirement documents, functional specifications, and process flow diagrams.</li><li>Maintain project documentation, including status reports and meeting minutes.</li><li>Ensure all documentation is up-to-date and accessible to relevant stakeholders.</li></ul><p>Stakeholder Engagement:</p><ul><li>Facilitate workshops and meetings with business and IT stakeholders to gather requirements and discuss solutions.</li><li>Communicate effectively with stakeholders to ensure a clear understanding of business needs and project goals.</li><li>Develop presentations and reports to share findings and recommendations with senior analysts and leadership.</li></ul><p>Technical Integration Support:</p><ul><li>Assess the impact of target and transition states on ongoing modernization programs like Digitalization, IMF Modernization, BMF Modernization, ECM, EDA, API, and CES.</li><li>Support gaining concurrence and alignment from related programs.</li><li>Assist in transition activities for the IDRS program to execute the delivered solution architecture.</li><li>Work with the IDRS Retirement Program Office to share target and transition state solution architecture and roadmap for executive socialization and approval.</li></ul><p><br />Marathon TS is committed to the development of a creative, diverse and inclusive work environment. In order to provide equal employment and advancement opportunities to all individuals, employment decisions at Marathon TS will be based on merit, qualifications, and abilities. Marathon TS does not discriminate against any person because of race, color, creed, religion, sex, national origin, disability, age or any other characteristic protected by law (referred to as "protected status ").<br />#CJJOBS</p></div>Company Description<div>Marathon TS provides a full range of professional services for clients that require support from professionals with specialized skills and experience in a specific technical area or subject matter. Marathon TS also provides IT solutions, including strategy, operations, transformation and mission support.</div></div><h3>Company Description</h3><div>Marathon TS provides a full range of professional services for clients that require support from professionals with specialized skills and experience in a specific technical area or subject matter. Marathon TS also provides IT solutions, including strategy, operations, transformation and mission support.</div>

<h3>Job Description</h3><div>Job Description<div><p><strong>Marathon TS<br />Data Engineer – TS/SCI<br />Bethesda, MD or Arlington, VA</strong></p><p>Marathon TS is seeking experienced Data Engineer Data Engineer supporting the National Media Exploitation Center (NMEC) under our 10-year DOMEX Technology Platform (DTP) contract. Have impact as part of a mission focused, solutions oriented, and adaptive team that values innovation, collaboration, and professional development. Your job will be to design, implement, maintain, and monitor data pipelines, both in support of R&D prototypes and production pipelines. You succeed through effective cross functional collaboration in areas such as, but not limited to, development, product, and QA in a dynamic and fast paced environment. While most work is conducted on-site at our client location in Arlington, VA, we offer a flexible schedule and, some unclassified development tasks. Come join our award-winning organization and work with some of the most talented and brightest minds in the GovCon industry.</p><p>Responsibilities:</p><p>As a senior member of the team, you bring deep expertise in data engineering and will work closely with other infrastructure and network engineers, data scientists, and system engineers on the following key tasks:</p><ul><li>Perform Database builds, installs, configuration, administration, and troubleshooting of database systems (e.g., MariaDB/MySQL, Postgres, Elasticsearch, Qdrant, Milvus, etc.)</li><li>Ensure data integrity by performing employing data engineering best practices</li><li>Maintain database and data pipeline documentation, data dictionaries, and system diagrams</li></ul><p> </p><p>Minimum Requirement:</p><ul><li>Bachelor's Degree and 12+ years of prior relevant experience or Masters with 10+ years of prior relevant experience. Additional years of experience will be considered in lieu of degree</li><li>Experience with SQL, NoSQL, and vector databases such as MSSQL, MySQL, PostgreSQL, Redis, FAISS, Milvus, Qdrant, etc.</li><li>Experience designing and maintaining ETL and ELT pipelines with technologies such as Spark, Airflow, Dagster, Prefect, Argocd, Metaflow, Kubeflow, etc.</li><li>Experience with DevOps / MLOps, using CI/CD methodology with data pipelines, and cloud-native deployment paradigms</li><li>Must possess TS/SCI clearance with the ability to obtain and maintain TS/SCI with Polygraph</li><li>Experience with database design, implementation, maintenance, monitoring, performance tuning, and optimization</li><li>Expertise in data profiling techniques and understanding the content from both a data quality and business perspective</li><li>Experience with data quality and accuracy evaluation techniques</li><li>Experience with Agile practices</li><li>Development experience with Python</li><li>Experience on data model development, modification and migration, and maintenance.</li><li>Strong verbal and written communication skills</li><li>Enthusiastic with the ability to work well on a team and a self-starter who can work independently</li></ul><p>Preferred Qualifications:</p><ul><li>An active TS/SCI with Polygraph clearance</li><li>Experience supporting data teams and data scientists</li><li>Experience on a production/ enterprise system</li><li>Experience in air-gapped environments</li><li>Application development and deployment in an AWS environment</li><li>AWS certifications</li></ul><p>#cjjobs<br><br>Marathon TS is committed to the development of a creative, diverse and inclusive work environment. In order to provide equal employment and advancement opportunities to all individuals, employment decisions at Marathon TS will be based on merit, qualifications, and abilities. Marathon TS does not discriminate against any person because of race, color, creed, religion, sex, national origin, disability, age or any other characteristic protected by law (referred to as "protected status ").</p></div>Company Description<div>Marathon TS provides a full range of professional services for clients that require support from professionals with specialized skills and experience in a specific technical area or subject matter. Marathon TS also provides IT solutions, including strategy, operations, transformation and mission support.</div></div><h3>Company Description</h3><div>Marathon TS provides a full range of professional services for clients that require support from professionals with specialized skills and experience in a specific technical area or subject matter. Marathon TS also provides IT solutions, including strategy, operations, transformation and mission support.</div>

<p>Position Title: Azure Data Engineer
Location: Remote in Washington, DC
Clearance: Candidate must be a U.S. Citizen with an active clearance or able to obtain a clearance. DOT cleared or Public Trust Cleared is preferred.
Marathon TS is seeking an experienced Azure Data Engineer to support the FHWA in the Washington, DC area. The ideal candidate has 8 years of experience that includes hands-on Data engineering activities, such as testing, integration, and building data pipelines. They must have demonstrated experience in cloud-native services such as Azure Web Services, experience working in diverse technical configurations, technologies and processing environments, and experience working in modern data architectures and software engineering and product development methodologies, including iterative software development techniques. A candidate with interpersonal skills with customers and the ability to guide technical conversations utilizing excellent written and verbal communication will thrive in this role. This is a direct-hire, full-time position with salary and benefits. A comprehensive benefits package will be provided including Medical, Dental, Vision, 401k with match, Flexible Spending Account, and Paid Time Off (PTO)-including vacation and holiday pay.
Your future duties and responsibilities: Designing, implementing, and maintaining scalable data pipelines and data integration solutions on the Azure platform.
Developing ETL processes to extract, transform, and load data from various sources into Azure data services such as Azure Data Lake Storage, Azure SQL Database, or Azure Synapse Analytics.
Reviewing the work of others for architectural compliance.
Building and optimizing data models and data structures to support analytical and reporting needs.
Collaborating with data scientists, analysts, and other stakeholders to understand data requirements and implement solutions that meet business needs.
Monitoring and optimizing data performance and troubleshooting issues as they arise.
Implementing security and compliance measures to protect sensitive data in accordance with company policies and regulatory requirements.
Documenting data processes, workflows, and system architectures.
Staying up-to-date with emerging technologies and best practices in data engineering and cloud computing.
Required qualifications to be successful in this role: BS in Computer Science, Information Systems, Engineering, Business, or other related scientific, technical, or functional discipline with 8 years of experience, of which at least 6 years must be specialized in system functional analysis.
Microsoft Certified Azure Developer.
Azure Cloud Development experience such as Azure App/Function/Storage/Batch.
Azure Data Factory.
Microsoft Test Framework for Unit and UI test, especially Selenium for .Net Core.
Microsoft SQL Server and Dedicated Pool.
Azure Synapse including Data Lake, Pipelines and Visualization Tools.
Version Control and Product Management of User stories: Azure DevOps.
Experience working in an Agile Environment.
Database: SQL Server 2017, Oracle 19c, Azure Data Lake.
IDE: Microsoft Visual Studio Enterprise.
UI Extension: Syncfusion Studio Enterprise.
Telerik Reporting.
Azure Data Factory.
Nice-to-have's: Prior/current support to FHWA.
Marathon TS is committed to the development of a creative, diverse and inclusive work environment. In order to provide equal employment and advancement opportunities to all individuals, employment decisions at Marathon TS will be based on merit, qualifications, and abilities. Marathon TS does not discriminate against any person because of race, color, creed, religion, sex, national origin, disability, age or any other characteristic protected by law (referred to as "protected status").

#J-18808-Ljbffr</p>

<h3>Job Description</h3><div>Job Description<div><p>Marathon TS is looking to hire a Cognos Data Analyst supporting the USAF in Quantico, VA. All candidates should have the following background:</p><ol><li>Assist with customer requirements for Cognos Data Modules, Reports and Dashboards.</li><li>Ensure that all application deliverables and systems comply with applicable DISA Security Technical Implementation Guides (STIGs) or Security Requirements Guides.</li><li>Assist with IBM Cognos Security and Administration functions.</li></ol><p><br />Qualifications:<br />2+ years experience using Cognos Analytics software or a similar program.<br />Bachelor's degree in a related field desired.<br />Must be certified at IAT Level II (e.g., Security+, or other certification satisfying DoD 8140 certification requirements).<br />Cognos Analytics Security and Administration certification a plus.<br />Experience installing, configuring, and maintaining IBM Cognos.<br />Strong knowledge of SQL scripting and data relationships.<br />Must have experience with applying STIGs.<br />Knowledge of Windows Server 2019/2022 and Oracle 19 databases.<br />Strong knowledge of Microsoft Windows technologies, including Active Directory, server cert management, and IIS is a plus.<br />Experience creating, reviewing, and revising security documentation and artifacts.<br />Experience in a DoD or law enforcement environment desired.<br />Strong attention to detail.<br />Strong organizational skills and the ability to multi-task.<br />Able to work independently and with a team.<br />Must be a US citizen and hold a current Top Secret clearance.<br><br>#CJJOBS<br><br>Marathon TS is committed to the development of a creative, diverse and inclusive work environment. In order to provide equal employment and advancement opportunities to all individuals, employment decisions at Marathon TS will be based on merit, qualifications, and abilities. Marathon TS does not discriminate against any person because of race, color, creed, religion, sex, national origin, disability, age or any other characteristic protected by law (referred to as "protected status ").</p><p><br /> </p></div>Company Description<div>Marathon TS provides a full range of professional services for clients that require support from professionals with specialized skills and experience in a specific technical area or subject matter. Marathon TS also provides IT solutions, including strategy, operations, transformation and mission support.</div></div><h3>Company Description</h3><div>Marathon TS provides a full range of professional services for clients that require support from professionals with specialized skills and experience in a specific technical area or subject matter. Marathon TS also provides IT solutions, including strategy, operations, transformation and mission support.</div>

<p>This organization is a leading provider of risk mitigation solutions for spend management at large enterprises and a data-driven company with a suite of data analytics products that analyze billions of dollars in spend and financial transactions every year for some of the most innovative companies, universities, and government agencies in the world. <br><br>Leveraging AI and machine learning, This organizations platform works across their customer's financial systems to continuously monitor and analyze all spend transactions for fraud, waste, and misuse. With a consolidated view of risk across their enterprise, customers can prevent financial loss and optimize spend while strengthening the controls that improve compliance. <br><br><strong>Position Overview</strong> <br><br>As a Product Manager, you will lead the design, execution and delivery for all product functionality related to your assigned product line and determine the best ways for users to interact with our product. You will work with our engineers and data scientists to assess the existing product offering and explore new ways to deliver the best product experience for our customers. You will be working across teams to build and launch products and features that align with their vision, strategy and product roadmap. <br><br><strong>Responsibilities</strong><br><br></p><ul> <li>Own the overall product experience for your product line including user-facing analytics models, workflow applications, and BI dashboards and advocate on behalf of the customer to build a best-in-class user experience.</li> <li>Define product roadmap and deliver market-leading offering to our customers.</li> <li>Manage day-to-day product execution: collaborate with customers, conduct user research, define use cases, lead requirements sessions, track and prioritize enhancement requests, coordinate product releases.</li> <li>Define business requirements and functional specifications and work with engineering, UX, and data science teams throughout the product development life cycle.</li> <li>Track enhancement requests and work with engineering to continuously prioritize product backlog for sprint planning in Jira.</li> <li>Understand user/buyer needs to identify product enhancements.</li> <li>Analyze and evaluate complementary and competitive products, technologies, and solutions and maintain a product competitive advantage.</li> <li>Support product launch planning, go-to-market activities and partner with marketing and sales teams to provide necessary support to ensure sales success.</li> <li>Act as a product evangelist to build awareness and understanding throughout the company and provide product demos as needed. </li></ul><strong>Required Qualifications </strong> <ul> <li>3+ years of experience as a product manager building and managing data-driven software products for end-users (preferably SaaS B2B).</li> <li>Bachelor's degree in Science, Engineering, Math, Finance, Business, Economics</li> <li>Product management experience with delivering successful software products including the full product development life cycle: planning, requirements, development, release, go-to-market.</li> <li>Ability to lead and collaborate across teams and influence product direction.</li> <li>Ability to prioritize feature development using qualitative and quantitative analysis.</li> <li>Ability to communicate functions and benefits for complex product features to customers and internal employees.</li> <li>Ability to present product functionality and represent the product team throughout the organization.</li> <li>Experience with Agile, Scrum and Jira or related tracking tools </li></ul><strong>Preferred Qualifications </strong><ul> <li>MBA or graduate studies in data analytics, risk management, finance, or accounting.</li> <li>Familiarity with financial business processes such as Accounts Payable, Expense Management, Accounts Receivable, Order-to-Cash, Procurement, General Ledger.</li> <li>Experience leading enterprise SaaS products.</li> <li>Solid understanding of software UI/UX best practices.</li> <li>Experience launching products and features that use AI/Client.</li> <li>Experience identifying new product concepts and features through extensive market and user research.</li> <li>Track record of partnering with data engineering and data science teams.</li> <li>Experience with workflow applications and BI dashboards.</li> <li>Experience with UX design and user research.</li> <li>Experience developing risk focused products. </li></ul> <br><br>#CJJob <br><br>Marathon TS is committed to the development of a creative, diverse and inclusive work environment. In order to provide equal employment and advancement opportunities to all individuals, employment decisions at Marathon TS will be based on merit, qualifications, and abilities. Marathon TS does not discriminate against any person because of race, color, creed, religion, sex, national origin, disability, age or any other characteristic protected by law (referred to as "protected status ").

<p>Senior Data Analyst Job Summary Marathon TS is seeking a Senior Data Analyst to join a contract with a federal government client in support of an important mission. In this role, you will have the opportunity to work with a great team while supporting the team. Responsibilities

This role necessitates the employee to be based in the San Antonio area for on-site work at Fort Sam Houston.
Conduct highly complex data mining, statistical analysis, trend analysis, and causal analysis.
Act as a technical lead, responsible for monitoring and delivering monthly contract reports and deliverables.
Integrate multiple disciplines within an operations research team, translating methodologies into a language understandable by operational managers.
Review and ensure quality control of products.
Develop and update training materials to educate newly assigned personnel on key analytic tools, procedures, and methodologies.
Transform structured and unstructured data into cohesive analytical products for a contracting functional business area audience.
Utilize pattern analysis methods to formulate recommendations for operational managers by identifying patterns in past, current, and anticipated operational environments. Education and Experience
A minimum of 8 years of experience in a technical field required.
A Bachelor's degree in computer science, engineering, applied mathematics, statistics, or a related field is preferred. Required Skills
Experience advising senior DoD decision makers on methodologies, results, and conclusions from applied operations research.
Proficiency in various research tools, including but not limited to Logistics Management Program, Vantage, Virtual Contracting Enterprise, General Fund Enterprise Business System (GFEBS), SAP Business Objects/Web Intelligence Reports, Microsoft SharePoint, Army-specific contract writing systems (Procurement Desktop Defense (PD2) and Procurement Automated Data and Document System (PADDS)), and various Government and Commercial business process automation systems.
Strong data manipulation and problem-solving skills. Desired Skills
Proficiency in statistics, programming languages like R or Python, SQL (Structured Query Language), data visualization, and data cleaning and preparation.
Effective communication skills and strong problem-solving ability. Security Clearance Eligibility to obtain a federal Security Clearance. #CJJOBS Marathon TS is committed to the development of a creative, diverse and inclusive work environment. In order to provide equal employment and advancement opportunities to all individuals, employment decisions at Marathon TS will be based on merit, qualifications, and abilities. Marathon TS does not discriminate against any person because of race, color, creed, religion, sex, national origin, disability, age or any other characteristic protected by law (referred to as "protected status").

#J-18808-Ljbffr</p>

<p>Marathon TS is seeking a Data Analyst to support a federal client in Huntsville, AL.<br> <br> This position requires employees to be located in the Huntsville, AL area in order to report to work on-site at Redstone Arsenal.<br> <br> <strong> Responsibilities</strong></p><ul> <li> Provide highly complex data mining, statistical analysis, trend analysis, and causal analysis.</li> <li> Perform as a technical lead responsible for monitoring and providing monthly contract reports and deliverables.</li> <li> Responsible for integrating multiple disciplines in an operations research team and translating applicable methods into language and application understandable by operational managers throughout the organization. Review and provide quality control methods on products.</li> <li> Prepare and update training materials to ensure newly assigned personnel gain an understanding of key analytic tools, procedures, and methodologies used.</li> <li> Take structured and unstructured data and distill the information into a cohesive analytical product for a contracting functional business area audience.</li> <li> Support pattern analysis methods to formulate recommendations to operational managers based upon exploiting patterns in the past, current, and anticipated operational environment.</li> </ul> <strong> Education and Experience</strong><ul> <li> 4+ years in a technical field</li> <li> BA/BS in a relevant field is required.</li> </ul> <strong> Required Skills</strong><ul> <li> Have experience advising senior DoD decision makers on methodologies, results, and conclusions from applied operations research.</li> <li> Have experience with the primary tools used for research services include, but are not limited to, Logistics Management Program, Vantage, Virtual Contracting Enterprise, General Fund Enterprise Business System (GFEBS), SAP Business Objects/Web Intelligence Reports, Microsoft SharePoint, Army-specific contract writing systems (Procurement Desktop Defense (PD2) and Procurement Automated Data and Document System (PADDS)), and various Government and Commercial business process automation systems.</li> <li> Personnel should have strong data manipulation and problem-solving skills.</li> <li> Must have strong technical skills in areas such as statistics, programming languages like R or Python, SQL (Structured Query Language), data visualization, and data cleaning and preparation.</li> <li> Have good communication skills and problem-solving ability.</li> </ul> <strong> Security Clearance</strong><ul> <li> Active Secret clearance is required.</li> </ul> <br> #CJJOBS<br> <br> Marathon TS is committed to the development of a creative, diverse and inclusive work environment. In order to provide equal employment and advancement opportunities to all individuals, employment decisions at Marathon TS will be based on merit, qualifications, and abilities. Marathon TS does not discriminate against any person because of race, color, creed, religion, sex, national origin, disability, age or any other characteristic protected by law (referred to as "protected status ").

Marathon Ts Interview Questions

Marathon Ts Interview Guides

Marathon Ts Interview Questions

Marathon Ts Salaries by Position

Marathon Ts Opening Jobs