Orange County, California, United States · On-site
$125k–$135k/yr
Senior
About Us Company Overview Foundation Building Materials (FBM) is a leading construction materials distribution company serving the commercial and residential construction markets across United States and Canada. In conju…
Skills: Power BI, Microsoft Fabric, Azure Synapse Analytics, Azure SQL Database, Azure Data Lake
About Us Company Overview Foundation Building Materials (FBM) is a leading construction materials distribution company serving the commercial and residential construction markets across United States and Canada. In conju…
Skills: CDL Class A or B, Vehicle Operation, DOT Compliance, Forklift Operation, Customer Service
About Us Company Overview Foundation Building Materials (FBM) is a leading construction materials distribution company serving the commercial and residential construction markets across United States and Canada. In conju…
Santa Fe Springs, California, United States · On-site
$20/hr–$27/hr
Mid level
About Us Company Overview Foundation Building Materials (FBM) is a leading construction materials distribution company serving the commercial and residential construction markets across United States and Canada. In conju…
Skills: CDL Class A, CDL Class B, Vehicle Operation, DOT Compliance, Forklift Operation
Orange County, California, United States · On-site
$35/hr–$40/hr
Senior
About Us Company Overview Foundation Building Materials (FBM) is a leading construction materials distribution company serving the commercial and residential construction markets across United States and Canada. In conju…
Skills: Calendar Management, Travel Coordination, Executive Support, Microsoft Office, Microsoft Teams
About Us Company Overview Foundation Building Materials (FBM) is a leading construction materials distribution company serving the commercial and residential construction markets across United States and Canada. In conju…
Skills: CDL Class A or B, Vehicle Operation, DOT Compliance, Forklift Operation, Customer Service
About Us Company Overview Foundation Building Materials (FBM) is a leading construction materials distribution company that serves the commercial and residential construction markets across North America. With a commitme…
Skills: Vehicle Operation, Forklift Operation, Pre-trip and Post-trip Inspections, Load Securing, Customer Service
About Us Company Overview Foundation Building Materials (FBM) is a leading construction materials distribution company serving the commercial and residential construction markets across United States and Canada. In conju…
Skills: Pricing Analysis, Market Analysis, Data Interpretation, Financial Modeling, Excel
About Us Company Overview Foundation Building Materials (FBM) is a leading construction materials distribution company serving the commercial and residential construction markets across United States and Canada. In conju…
About Us Company Overview Foundation Building Materials (FBM) is a leading construction materials distribution company serving the commercial and residential construction markets across United States and Canada. In conju…
About Us Company Overview Foundation Building Materials (FBM) is a leading construction materials distribution company serving the commercial and residential construction markets across United States and Canada. In conju…
Skills: Material Handling, Inventory Management, OSHA Compliance, Forklift Operation, Customer Service
About Us Company Overview Foundation Building Materials (FBM) is a leading construction materials distribution company serving the commercial and residential construction markets across United States and Canada. In conju…
Skills: CDL Class A or B, Vehicle Operation, DOT Compliance, Forklift Operation, Customer Service
About Us Company Overview Foundation Building Materials (FBM) is a leading construction materials distribution company serving the commercial and residential construction markets across United States and Canada. In conju…
About Us Company Overview Foundation Building Materials (FBM) is a leading construction materials distribution company serving the commercial and residential construction markets across United States and Canada. In conju…
Skills: CDL Class A, Vehicle Operation, Forklift Operation, DOT Compliance, Customer Service
About Us Company Overview Foundation Building Materials (FBM) is a leading construction materials distribution company serving the commercial and residential construction markets across United States and Canada. In conju…
Skills: Boom Truck Operation, CDL Class A or B, Vehicle Inspection, DOT Compliance, Forklift Operation
About Us Company Overview Foundation Building Materials (FBM) is a leading construction materials distribution company serving the commercial and residential construction markets across United States and Canada. In conju…
Skills: Branch Operations, Team Leadership, Inventory Control, Budgeting, Sales Forecasting
About Us Company Overview Foundation Building Materials (FBM) is a leading construction materials distribution company serving the commercial and residential construction markets across United States and Canada. In conju…
Skills: Material Handling, Loading and Unloading, Inventory Management, OSHA Safety Compliance, DOT Standards
About Us Company Overview Foundation Building Materials (FBM) is a leading construction materials distribution company serving the commercial and residential construction markets across United States and Canada. In conju…
About Us Company Overview Foundation Building Materials (FBM) is a leading construction materials distribution company serving the commercial and residential construction markets across United States and Canada. In conju…
Skills: Customer Service, Inside Sales, Upselling, Cross-selling, Order Management
About Us Company Overview Foundation Building Materials (FBM) is a leading construction materials distribution company serving the commercial and residential construction markets across United States and Canada. In conju…
Skills: Material Handling, Inventory Management, OSHA Compliance, Forklift Operation, Customer Service
Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.
$125k–$135k/yr
Other
bachelor degree, professional certificate
Medical Insurance, Dental Insurance, Vision Insurance, Health Savings Account (HSA), Flexible Spending Account (FSA), Basic Life Insurance
Posted 2d ago
Apply by Jun 26
~40 hrs/week
Responsibilities
The Senior BI Developer designs and supports enterprise BI and modern data platform solutions using the Microsoft Azure stack and Informatica. The role involves creating Power BI dashboards, managing data governance, and integrating SAP-based insights to improve enterprise decision-making.
Requirements
Candidates need strong expertise in Power BI, SQL, and Azure data services, along with experience in dimensional modeling and ETL processes. A bachelor's degree in a technical field and experience with SAP integration are highly preferred.
Full job description
About Us
Company Overview
Foundation Building Materials (FBM) is a leading construction materials distribution company serving the commercial and residential construction markets across United States and Canada. In 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 UDHG's 8,000+ 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 Lowe's, we are investing in strong, forward-thinking talent to support our long-term success.
Overview
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.
Responsibilities and Qualifications
Key ResponsibilitiesBI, Reporting & Visualization
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
Data Platform Design & Modernization
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
Power BI Administration, Governance & Quality
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
Data Integration & Enterprise Systems
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
Stakeholder Partnership & Delivery
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
Technology Enablement & Continuous Improvement
Stay current with Microsoft technologies, analytics trends, AI/Copilot capabilities, and best practices, sharing knowledge and supporting FBM's evolving technology ecosystem and enterprise applications
Perform other duties as assigned to support information technology, analytics, and corporate objectives
QualificationsEssential Knowledge and Skills
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
Preferred Qualifications
Bachelor's 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
Compensation and Benefits
Reports ToVice President of IT
Compensation
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: $125,000 - $135,000 per year
Bonus: 10% Target Bonus
Total Compensation (Base + Bonus): The successful candidate could reasonably expect a Total Compensation Package in the range of $131,000 - $155,000
Equity: This role is not eligible for equity opportunities, awards or grants
Benefits
At FBM, we're 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)
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 [email protected].
Posting Period
This job will be posted for at least 5 days, starting on the initial post date reflected above.
Supplying North America with Quality Building Materials
Industry
Wholesale Building Materials
Company size
5,001-10,000 employees
Founded
2011
Headquarters
Santa Ana, California
LinkedIn followers
19,446
Foundation Building Materials (FBM) is North America's leading specialty building materials distributor, operating 370+ locations across the US and Canada. Since 2011, we've served 60,000+ customers through our comprehensive family of brands including RIS, PacSource, and Unified Door and Hardware Group. Together, we provide essential construction materials including gypsum wallboard, suspended ceilings, metal framing, insulation, and more.
At FBM, we're not just in the business of providing building materials—we're in the business of building relationships. Our team members are the cornerstone of the FBM experience, embodying our commitment to service, integrity, and community.
Connect with FBM to learn how we can support your construction projects with quality materials, innovative business platforms, and unmatched expertise.
Offices: 2520 Red Hill Ave, Santa Ana, California 92705, US
Building MaterialsDrywallSteel StudsAcoustical CeilingsInsulationTools and FastenersStuccoLath and PlasterInsulationWallboard
Supplying North America with Quality Building Materials
Industry
Wholesale Building Materials
Company size
5,001-10,000 employees
Founded
2011
Headquarters
Santa Ana, California
LinkedIn followers
19,446
Foundation Building Materials (FBM) is North America's leading specialty building materials distributor, operating 370+ locations across the US and Canada. Since 2011, we've served 60,000+ customers through our comprehensive family of brands including RIS, PacSource, and Unified Door and Hardware Group. Together, we provide essential construction materials including gypsum wallboard, suspended ceilings, metal framing, insulation, and more.
At FBM, we're not just in the business of providing building materials—we're in the business of building relationships. Our team members are the cornerstone of the FBM experience, embodying our commitment to service, integrity, and community.
Connect with FBM to learn how we can support your construction projects with quality materials, innovative business platforms, and unmatched expertise.
Offices: 2520 Red Hill Ave, Santa Ana, California 92705, US
Building MaterialsDrywallSteel StudsAcoustical CeilingsInsulationTools and FastenersStuccoLath and PlasterInsulationWallboard