BI Project Analyst Lead

Company Description

Cornerstone Building Brands, headquartered in Cary, North Carolina, is the largest manufacturer of external building products in North America with over $6 billion in annual revenue and an expansive national footprint that includes almost 20,000 employees, operating in +70 manufacturing facilities, supported by a network of +80 distribution and branch office facilities. We have a broad product offering with a well-regarded brand portfolio including the #1 position in windows; vinyl siding; metal accessories; metal roofing and wall systems; and insulated metal panels.

Job Description

The Lead Business Analyst for Business Intelligence will collaborate with the ERP transformation project team, spanning various Aperture business areas and corporate functions. The goal is to develop, support, and implement BI solutions using Power BI and Azure reporting capabilities. This role involves working closely with business stakeholders, IT, and third parties to create solid business requirements documents and project deliverables.

Responsibilities:

• Reporting and Data Gap Analysis: Collaborate with ERP project leaders and business SMEs to identify reporting and data gaps for specific business units.
• Requirements Gathering: Work closely within ERP project and stakeholders to understand their data-related requirements, including data visualization needs, reporting requirements, and data modeling preferences.
• Data Analysis: Analyze data from various sources to identify trends, patterns, and insights that can inform business decisions. Use statistical analysis techniques to extract actionable insights.
• Data Quality Assurance: Ensure the accuracy, completeness, and reliability of data used for visualization and modeling purposes. Address data quality issues through cleansing, validation, and verification processes.
• Documentation and Communication: Document data models, visualization designs, and analytical findings to ensure transparency and knowledge sharing. Communicate complex technical concepts to non-technical stakeholders clearly and concisely.
• Ad Hoc Reporting: Prepare ad hoc reports as needed by various stakeholders.
• Testing and QA: Develop and execute test plans, guide testers during the QA process, determine required testing resources, and manage the issue tracking process.

Knowledge and Skills:

• Excellent oral and written communication skills, with the ability to market and report complex initiatives to non-technical colleagues or business leadership.
• Expertise with Microsoft Power BI, or other BI platform including troubleshooting and automation to streamline operations.
• Familiarity with ERP systems like SAP, Orace JDE , Oracle EBS
• Blend of ERP and business process acumen (e.g., O2C, P2P), consulting abilities, and analytics capabilities to identify needs and develop optimal solutions.
• Strong problem-solving skills and business intuition.
• Proficiency with Azure reporting tools and SQL.

Qualifications

• Bachelor's degree, or similar technical discipline
• 3+ years in leading business intelligence and analytics initiatives
• 5+ years of experience working with data analytics and prior Power BI proven experience, including prior roles as data analyst, data reporter or business analyst.
• Experience in project management and overseeing processes from conception to completion also helpful.
• Must be able to travel up to 20%

Additional Information

All your information will be kept confidential according to EEO guidelines.