KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
JD #4160
Applications open Internship

Data Analyst

Serco

  • Rock Island, Illinois, US, 61201
  • $67,889.77 - $105,000
  • 1 Year
  • Posted Today
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

Serco Inc. is a leading provider of public services and solutions across defence, citizen services and transportation. With more than 9,000 employees in North America, Serco partners with the U.S. military, federal agencies and international governments to deliver mission‑critical services that improve efficiency and citizen experience. The company’s culture blends a strong sense of purpose with a collaborative environment, encouraging employees to innovate, take ownership and grow their careers across a wide range of domains.

The Data Analyst role sits within the Global Logistics Augmentation and Support Services (GLASS) team, supporting the Army Sustainment Command (ASC) at Rock Island Arsenal. This position works on high‑visibility logistics projects that directly influence materiel readiness for the U.S. Army.

The analyst will translate complex data sets into actionable insights, develop algorithms, and recommend process improvements that drive cost‑effective readiness solutions.

Key Responsibilities

  • Perform advanced data analysis and develop algorithms to recommend business process improvements.
  • Identify impediments to materiel readiness and propose data‑driven solutions using cost‑benefit analysis.
  • Design and deliver analytics and process solution sets that prioritize simplicity and economic savings.
  • Create formal use cases, software change requests, and documentation for technology insertion into logistics support software.
  • Interface with software program offices, contractors, and stakeholders to ensure seamless integration of analytical outputs.
  • Conduct stakeholder analysis and produce briefing materials, information papers, and executive summaries.
  • Utilize logistics and analytical systems such as DST, GCSS‑A, LMP, GFEBs, and the Microsoft Office suite for reporting and decision support.
  • Apply qualitative analytics techniques including multi‑criteria decision analysis, game theory, and supply‑chain modeling.
  • Develop interactive dashboards and visualizations using Tableau, Power BI, or similar tools to communicate insights.
  • Travel up to 10% to support on‑site meetings, workshops, and stakeholder engagements.

Tech Stack: Python, Java, R, MATLAB, SQL, Tableau, Power BI, Excel, Access, PowerPoint, DST, GCSS‑A, LMP, GFEBs.

Growth Path: Successful analysts can progress to Senior Data Analyst, Logistics Data Scientist, or Program Manager roles within Serco’s defence portfolio, gaining exposure to larger contracts and leadership responsibilities.

Why Join Serco: The role offers the chance to work on mission‑critical defence projects, collaborate with seasoned logistics experts, and leverage cutting‑edge analytical tools. Employees benefit from a supportive culture, competitive compensation, and a clear pathway for professional advancement while contributing to national security objectives.

Eligibility & process

Who can apply

US Citizenship; Ability to obtain a DoD Secret security clearance; Bachelor’s degree in Data Science, Mathematics, Statistics, Economics, Computer Science, Engineering or related quantitative discipline; Minimum 1 year of hands‑on experience on a data science team; Minimum 60% academic score or equivalent GPA; No pending backlogs; Ability to travel up to 10% of the time.

Skills & stack

Python Java MATLAB SQL Tableau Power BI Advanced Excel Data Visualization

Selection process

  1. Round 1: Online assessment (aptitude, logical reasoning, basic data concepts)
  2. Round 2: Technical interview (programming, analytics case studies, tools proficiency)
  3. Round 3: HR interview (fit, motivation, security clearance discussion)

Prep kit

20 resources
Study material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
Round 1: Online Assessment (OA) Aptitude, Quantitative Logic & 2 Coding Problems Focus on accuracy and speed. Practice arrays, strings, and standard arithmetic puzzles.
Round 2: Technical Interview 1 Core Tech Stack (Python, Java, MATLAB, SQL, Tableau, Power BI, Advanced Excel, Data Visualization) & Live Code Tracing Explain your thought process aloud. Analyze time & space complexities before coding.
Round 3: System Design & Problem Solving Database Schemas, APIs & Architecture Basics Clarify edge cases, diagram schemas cleanly, and discuss scalability trade-offs.
Round 4: HR & Cultural Fit Discussion Serco Core Values, Learning Agility & Offer Terms Demonstrate passion, strong communication, and readiness for full-time collaboration.
Technical questions 5
What is the difference between WHERE and HAVING clauses in SQL? Answer
Model answer: WHERE filters rows before any groupings are applied, while HAVING filters aggregated groups after GROUP BY has executed.
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer
Model answer: ROW_NUMBER() assigns unique sequential integers. RANK() assigns identical ranks to ties and skips ranks. DENSE_RANK() assigns identical ranks to ties without skipping rank numbers.
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer
Model answer: Use .isna().sum() to identify missing values. Impute with mean/median using .fillna() or remove with .dropna(subset=[...]) depending on variance impact.
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer
Model answer: Star Schema has denormalized dimension tables directly connected to the central Fact table. Snowflake Schema normalizes dimension tables into sub-dimensions to minimize redundancy.
How do you calculate MoM (Month-over-Month) growth in SQL? Answer
Model answer: Use LAG(revenue, 1) OVER (ORDER BY month) to fetch the previous month's revenue and compute (revenue - prev_revenue) / prev_revenue * 100.
Behavioural & HR questions 3
Why do you want to join Serco as a Data Analyst?
Highlight Serco's market reputation, recent tech innovations, and how your skills in Python directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
How do you handle strict deadlines or sudden scope changes?
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.
Serco $67,889.77 - $105,000
Recruiter Resume Apply
Chat Chat with Kashii