KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
JD #4159
Applications open Full-Time Job

Business Analyst

LPI Global LLC

  • Atlanta, Georgia, United States
  • USD 65,000 per annum (approx.)
  • Fresher (0-1 Yrs)
  • Posted Today
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

LPI Global LLC is a fast‑growing technology‑enabled services firm that partners with construction and distribution companies to streamline their operations through data‑driven solutions. With a presence across North America and a focus on digital transformation, LPI leverages cloud platforms, advanced analytics, and automation to help clients reduce manual effort, improve project visibility, and achieve cost efficiencies. The company culture emphasizes continuous learning, cross‑functional collaboration, and a results‑oriented mindset, making it an attractive destination for fresh talent eager to make an impact.

The Business Analyst role at LPI Global is a pivotal entry‑level position designed for recent graduates who are passionate about turning raw data into actionable insights. Reporting to the Construction & Distribution Operations lead, the analyst will be the bridge between business teams and technology solutions, ensuring that data flows seamlessly from vendors and clients into structured repositories that power reporting, forecasting, and decision‑making. This role offers exposure to both construction project management and distribution logistics, providing a holistic view of end‑to‑end supply chain processes.

Key Responsibilities

  • Collaborate with Construction and Distribution teams to collect, organize, and validate project‑related data such as costs, schedules, estimates, procurement details, material inventories, and labor records.
  • Develop and enforce standardized data structures, naming conventions, and documentation practices to ensure consistency across all business units.
  • Identify and remediate duplicate, incomplete, or outdated records through data cleaning and validation activities.
  • Build and maintain centralized data repositories (e.g., SharePoint, Azure Data Lake) that improve accessibility and long‑term usability for stakeholders.
  • Analyze existing workflows to pinpoint manual bottlenecks and propose automation opportunities using tools like Power Automate, Python scripts, or low‑code platforms.
  • Assist in designing and delivering dashboards and visual reports (Power BI, Tableau) that provide real‑time insights into project performance and inventory health.
  • Support the rollout of digital solutions, including document management systems and procurement portals, by gathering requirements and conducting user acceptance testing.
  • Conduct regular data audits and generate quality reports to track improvements in data integrity and process efficiency.
  • Liaise with cross‑functional teamsβ€”Procurement, Accounting, Project Managementβ€”to understand reporting needs and translate them into technical specifications.
  • Participate in occasional site visits to warehouses, construction sites, or client locations to gather contextual information and validate data capture processes.

Tech Stack & Tools: Microsoft Excel (advanced), Power Query, Power BI/Tableau, SQL, Python (basic scripting), Azure Data Services, SharePoint, Power Automate, Jira/Confluence for documentation.

Growth Path: Starting as a Business Analyst, high performers can progress to Senior Analyst, Data Governance Lead, or Product Owner roles within two to three years. The exposure to both construction and distribution domains equips analysts with versatile skill sets, opening pathways to Project Management, Operations Strategy, or specialized analytics positions.

Why Join LPI Global: The company offers a dynamic environment where fresh graduates can work on real‑world projects from day one, receive mentorship from seasoned professionals, and contribute to digital transformation initiatives that have measurable business impact. Competitive compensation, a collaborative culture, and clear career progression make LPI an ideal launchpad for aspiring analysts.

Eligibility & process

Who can apply

Bachelor's degree in Computer Science, Data Science, Information Systems, Engineering, or related field. Minimum aggregate of 60% (or CGPA 6.5/10). Open to graduates of 2023, 2024, or 2025 batches. No active backlogs at the time of joining.

Skills & stack

Data Analysis Advanced Excel SQL Python Power BI Tableau Data Cleaning Documentation

Selection process

  1. Round 1: Online aptitude & logical reasoning test
  2. Round 2: Technical interview (data handling, Excel, SQL, case study)
  3. Round 3: HR interview (fitment, communication, career goals)

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 (Data Analysis, Advanced Excel, SQL, Python, Power BI, Tableau, Data Cleaning, Documentation) & 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 LPI Global LLC 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 LPI Global LLC as a Business Analyst?
Highlight LPI Global LLC's market reputation, recent tech innovations, and how your skills in Data Analysis 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.
LPI Global LLC USD 65,000 per annum (approx.)
Recruiter Resume Apply
Chat Chat with Kashii