Senior BI Developer

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 Responsibilities BI, 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

Qualifications Essential 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 To Vice 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)
• Critical Illness, Hospital Indemnity, Accident Coverage
• Legal Insurance Plan
• Paid Time Off (PTO) & Paid Company Holidays
• 401(k) plan with generous company match

Statements

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 Talent@myfbm.com.

Posting Period

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

Salary Range

Min: USD $125,000.00/Yr., Max: USD $135,000.00/Yr.