Senior BI Developer

Company Overview

Foundation Building Materials (FBM) is a leading construction materials distribution company serving the commercial and residential construction markets across United States and conjunction with Unified Door & Hardware Group (UDHG) a premier provider of commercial door frame and hardware solutions FBM supports a broad range of construction and architectural projects nationwide.

Together FBM and UDHGs 8000 Team Members are committed to operational excellence innovation and employee development. By combining scale specialty expertise and a customer-first mindset we deliver high-quality products and services to contractors builders and project teams across diverse markets. As the organization continues to grow and evolve following the recent acquisition by Lowes we are investing in strong forward-thinking talent to support our long-term success.

Position Overview

At Foundation Building Materials (FBM) the Senior BI Developer designs develops administers and supports enterprise BI analytics and modern data platform solutions using Power BI Microsoft Fabric Azure Synapse Analytics Azure SQL Database Azure Data Lake Azure Data Factory Informatica IICS and related technologies. This role partners with business and technology stakeholders to deliver scalable reporting trusted semantic models governed self-service analytics SAP-integrated insights and cloud modernization strategies that improve enterprise decision-making.

• Develop Power BI dashboards reports scorecards wireframes prototypes and advanced visualizations that translate KPIs and operational metrics into actionable insights
• Partner with business leaders to identify analytics opportunities enable self-service reporting and support AI-enabled predictive and democratized analytics initiatives

• Design develop test and optimize enterprise BI and modern data platform solutions using Azure SQL Database Microsoft Fabric Azure Synapse Analytics Azure Data Lake Power BI DAX and SQL
• Evaluate current reporting and data architecture landscapes and recommend scalable cloud-based modernization strategies that improve performance availability security and scalability

• Administer Power BI Service workspaces gateways security roles deployment pipelines semantic models dimensional models and enterprise reporting datasets
• Implement row-level security (RLS) data governance data quality compliance standards documentation data dictionaries and development standards

• Develop and maintain ETL/ELT processes using Azure Data Factory Microsoft Fabric Dataflows Informatica IICS and related data integration tools
• Support hybrid analytics across SAP S/4HANA SAP Datasphere SAP Analytics Cloud Microsoft Power BI Microsoft Fabric and Azure platforms including SAP extractors CDS Views OData services and financial operational supply chain and manufacturing data sources

• Collaborate with business stakeholders onsite/offshore teams and cross-functional partners to gather requirements manage deliverables timelines and project execution
• Lead mentor and support BI developers analysts and technical team members while participating in Agile ceremonies sprint planning code reviews testing and release management

• Stay current with Microsoft technologies analytics trends AI/Copilot capabilities and best practices sharing knowledge and supporting FBMs evolving technology ecosystem and enterprise applications
• Perform other duties as assigned to support information technology analytics and corporate objectives

• Strong Power BI experience including Power BI Service Power Query DAX semantic modeling deployment pipelines workspace administration RLS and governance
• Hands-on experience with Microsoft Fabric Azure Synapse Analytics Azure SQL Database Azure Data Lake Azure Analysis Services Azure Data Factory Informatica IICS Fabric Dataflows or similar technologies
• Experience building enterprise-scale BI and analytics solutions using Power BI SQL Server Tableau SSRS cloud data platforms and large-scale/high-volume transactional datasets
• Strong SQL development query optimization database design performance tuning dimensional modeling data warehousing data lakes medallion architecture MDM and data governance knowledge
• Familiarity with AI-driven analytics Copilot capabilities predictive analytics and self-service BI enablement strategies is highly preferred
• Strong understanding of Agile and traditional SDLC methodologies; ability to participate in planning code reviews testing and release management
• Effective communication with technical and non-technical stakeholders at all levels with strong documentation presentation client-facing analytical troubleshooting organizational and problem-solving skills
• Proven leadership mentoring project coordination prioritization and ability to operate effectively in a fast-paced onsite/offshore delivery model

• Bachelors degree in Computer Science Information Systems Data Analytics or related field; Microsoft certifications in Power BI Azure Data Engineering Fabric or Data Analytics are highly preferred
• Experience with ERP CRM pricing enterprise operational systems Python Spark or advanced analytics tools is a plus
• Experience integrating and reporting against SAP S/4HANA SAP Datasphere SAP Analytics Cloud (SAC) SAP extractors CDS Views OData services and SAP financial operational supply chain or manufacturing reporting is highly preferred

The listed pay range reflects the expected base rate for this position. Within the range individual pay may vary based on experience qualifications and work location within state. This is a full-time position with competitive pay and benefits.

• Base: $125000 - $135000 per year
• Bonus: 10% Target Bonus
• Total Compensation (Base Bonus): The successful candidate could reasonably expect a Total Compensation Package in the range of $131000 - $155000
• Equity: This role is not eligible for equity opportunities awards or grants

At FBM were committed to supporting our employees both personally and professionally. We offer a comprehensive and competitive benefits package designed to help you thrive inside and outside of work. Our excellent package includes:

• Medical Dental and Vision plans with leading national providers
• Health Savings Account (HSA) / Flexible Spending Account (FSA)
• Company Provided Basic Life and Accident Death & Dismemberment (AD&D)
• Voluntary Life and Accidental Death & Dismemberment (AD&D)
• Critical Illness Hospital Indemnity Accident Coverage
• Legal Insurance Plan
• Paid Time Off (PTO) & Paid Company Holidays
• 401(k) plan with generous company match

Equal Opportunity Employer

Foundation Building Materials is an Equal Opportunity Employer and is committed to providing equal employment opportunities to all individuals. We value diversity and inclusion and are dedicated to creating a workplace where all employees feel respected and empowered. All employment decisions are made without regard to race color religion sex pregnancy (including childbirth breastfeeding or related medical conditions) sexual orientation gender identity or expression national origin age disability status genetic information veteran status or any other characteristic protected by federal state or local law.

In accordance with the Americans with Disabilities Act (ADA) and applicable state and local laws we provide reasonable accommodations to qualified individuals with disabilities to help them perform the essential functions of their job. If you need assistance or an accommodation during the application process or while employed please contact Human Resources at

Posting Period

This job will be posted for at least 5 days starting on the initial post date reflected above.