Business Analyst
LPI Global LLC
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
Selection process
- Round 1: Online aptitude & logical reasoning test
- Round 2: Technical interview (data handling, Excel, SQL, case study)
- Round 3: HR interview (fitment, communication, career goals)
Prep kit
20 resourcesStudy material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
Technical questions 5
What is the difference between WHERE and HAVING clauses in SQL? Answer
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer
How do you calculate MoM (Month-over-Month) growth in SQL? Answer
Behavioural & HR questions 3
Highlight LPI Global LLC's market reputation, recent tech innovations, and how your skills in Data Analysis directly solve their team's objectives.
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.