Jr. Business Intelligence Analyst

Lansing Building Products Recruiting Team•Richmond, VA

5d•$55,000 - $65,000•Onsite

About The Position

Lansing Building Products has supplied professional contractors with high-quality building products since its founding in 1955. Led by third generation President & CEO Hunter Lansing, we remain true to the family values and mission of Respect, Service and Excellence in everything we do. A certified Great Place To Work™, Lansing has nearly 2,000 associates in 112 branches serving customers in 35 states along with Home Office locations in Richmond, VA and Waltham, MA. We exist to make a positive impact in people’s lives and are focused on delivering a best-in-class experience to our associates and our customers.

Requirements

Bachelor’s degree in business, Accounting/Finance, Computer Science, or a related field.
1-2 years of experience in Business Intelligence and Analytics, Data Analytics or related field.
Proficient in data visualization tools like SAP’s Analytics Cloud and Power BI.
Skilled in SQL, Python, and similar languages for building and optimizing database queries.
Proficient in data cleaning and transformation techniques, including handling duplicates, managing missing values, and standardizing data formats for analysis.
Advanced Excel skills, with expertise in complex formulas, data analysis tools, spreadsheet optimization, and data validation to ensure accuracy and efficiency.
Knowledgeable in statistics, with experience using statistical packages and analyzing large datasets across multiple platforms.
Strong analytical and problem-solving skills, with a passion for working with data and finding actionable insights.
Creative, self-motivated, and eager to tackle complex challenges.
Effective verbal and written communication skills for conveying insights and collaborating with team members.
Team-oriented and open to learning from experienced professionals, with a commitment to contributing to a positive, values-driven work culture at Lansing’s Home Office.

Nice To Haves

Experience with Microsoft Power Apps or SAP S4 is a plus.
Any experience with advanced analytic techniques (e.g., predictive models, regression models, cluster analysis etc.) is a plus.

Responsibilities

Maintain interactive dashboards, reports, and data visualizations using BI tools like Power BI and similar platforms.
Work with data models, database queries, and create insightful, accessible reports and visualizations.
Collect, clean, and analyze data from various sources to ensure data integrity and uncover trends, patterns, and insights.
Identify, design, and implement process improvements, including automation of manual tasks and optimization of data workflows.
Troubleshoot data discrepancies, assess criticality, and impact, and provide effective resolutions and workarounds.
Monitor and analyze key business performance metrics, offering insights and recommendations to enhance processes and drive growth.
Collaborate with cross-functional teams—such as analysts, business stakeholders, and IT—to understand data needs and deliver impactful data analysis and reporting.
Respond to customer’s ad-hoc report requests with impactful data and solutions.
Perform additional duties as assigned.