Junior Business Intelligence Analyst

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.

ESSENTIAL DUTIES AND 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.

EDUCATION AND EXPERIENCE 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.
• Experience with Microsoft Power Apps or SAP S4 is a plus.

QUALIFICATIONS AND PREFERRED SKILLS:

• 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.
• Any experience with advanced analytic techniques (e.g., predictive models, regression models, cluster analysis etc.) is a plus.
• 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.

A Career with Lansing Building Products offers:

• Coverage to support your overall well-being: Medical, Dental, Vision, HSA with company contributions, Health Advocate and EAP
• Investment in your future: Competitive 401k, Employer Match of 50% up to 15% of salary
• Culture: Great Place to Work Certified every year since 2019
• Work/Life Balance: Paid Vacation & Sick Days
• Growth/Development: Tuition Reimbursement & Training Programs

Other Added Benefits:

• Company Paid Parental Leave
• Company Paid Life Insurance
• Short Term & Long-Term Disability
• Paid Holidays
• Health and Wellness program
• Volunteer Time

Lansing Building Products is proud to be an equal opportunity workplace committed to building a diverse team of qualified individuals.