Anduril · boards.greenhouse.io · checked today
Analytics Engineer, Sentry
<div class="content-intro"><p>Anduril Industries is a defense technology company with a mission to transform U.S. and allied military capabilities with advanced technology. By bringing the expertise, technology, and business model of the 21st century’s most innovative companies to the defense industry, Anduril is changing how military systems are designed, built and sold.
Skills, with evidence
- Python
Proficient in at least one additional programming language such as Python, SQL, R, TypeScript or similar, for analysis, data visualization, and automation.
must have - SQL
Proficient in at least one additional programming language such as Python, SQL, R, TypeScript or similar, for analysis, data visualization, and automation.
must have - Data quality
Document and champion data quality.
must have - Dashboards & BI
Develop dashboards and analytics that shape production decisions.
must have · not practised here - Data modelling
Design data workflows that ingest, transform, and model data from ERP, MRP, MES, PLM, inventory, and quality systems, ensuring data quality, freshness, and accessibility for the teams that depend on them.
must have - Cost & performance
Our comprehensive, competitive benefits package (available at little to no cost to employees) ensures you’re supported in health, recovery, and whatever comes next. </span><em><span data-contrast="auto">For more information, <a href="https://www.anduril.com/careers">Explore Our Benefits</a>.</span></em></p>
- Streaming
You will design, implement, and maintain the data systems that give Manufacturing and Supply Chain leaders real-time visibility into what we are building, what we need, and where we are constrained.
- Governance & security
Use of this provider helps to ensure compliance with applicable laws and protect technology, intellectual property, and organizational security.</span></p></div>
not practised here
Your plan
- The SQL screen: correct, then fast≈ 1 h
SQL · Data quality
- Average order value by countryFoundations
- Line items per orderFoundations
- Revenue by buyer countryFoundations
- Customers who never orderedFoundations
- Hiring funnel by roleFoundations
- Python: the data-wrangling round≈ 2 h
Python
- Clean spreadsheet headers into column namesFoundations
- Events normalization jobFoundations
- List the distinct composite keysFoundations
- Deduplicate rows, first one winsFoundations
- Render a byte count for humansFoundations
- Data modelling: the round most people fail≈ 2 h
Data modelling
- Marketplace core entitiesFoundations
- Cinema seat bookingFoundations
- City parking baysFoundations
- Dating app matchesFoundations
- Food delivery ordersFoundations
- Pipeline design: safe to run twice≈ 4 h
Streaming
- Which day does it belong to?Foundations
- Parcel tracking pipelineIntermediate
- Five minutes behind the sourceIntermediate
- The source will not let youIntermediate
- The fact arrived firstIntermediate
- Spark: read the plan Spark actually ran≈ 2 h
Cost & performance
- HAVING vs WHERE: where does a filter after groupBy actually run?Foundations
- partitionBy("country"): what does partition pruning look like in the plan?Foundations
- Predicate pushdown: equality, ranges, and the filter that cannot be pushedFoundations
- Revenue by country: read the DAG behind one groupByFoundations
- Too many small files: where do they cost you, and how does compaction help?Foundations
- Say it out loud≈ 1 h
25 drills · Foundations + Intermediate≈ 11 hours
Not covered by the plan: Dashboards & BI, Governance & security.
Readiness
Counted from drills you have completed anywhere on D8LooP.
leaves in 13 dremoved the moment Anduril closes it