Senior BI Developer

Foundation Building Materials LLC
Santa Ana, CA, United States
about 1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Compensation
$125,000.0 - $135,000.0
Working hours
Regular working hours
Job source

Tech stack

SAP Cloud Agile Methodology Artificial Intelligence Business Analytics Applications Data Analysis Microsoft Azure Business Intelligence Development Code Review Information Systems Data Architecture Data Dictionary Data Governance
+39 more
Data Infrastructure Data Integration Extract Transform Load (ETL) Data Warehousing Database Design Dimensional Modeling Python (Programming Language) Microsoft Software Microsoft SQL Server SQL Azure Open Data Protocol Performance Tuning Scrum Methodology Systems Development Life Cycle Query Optimization Release Management Power BI Cloud Services Standard Sql Azure Data Lake SAP (Applications) SAP Financial Management SQL Server Reporting Services Systems Integration Tableau (Software) Website Wireframe Enterprise Software Applications Azure Data Factory Informatica Powercenter Delivery Pipeline Apache Spark Powerquery Microsoft Fabric Data Lakes Information Technology Data Analytics SAP S/4HANA Operational Systems Azure Synapse Analytics

Job description

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

Requirements

Do you have experience in Technical documentation?, Do you have a Bachelor’s degree?, * 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, * 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

Benefits & conditions

Pulled from the full job description

  • AD&D insurance
  • Health insurance
  • 401(k) matching
  • Paid time off
  • Vision insurance
  • Health savings account
  • Dental insurance, 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, 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, Salary Range: Min: USD $125,000.00/Yr., Max: USD $135,000.00/Yr.

About the company

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

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

1:46 min

Traditional data architecture before Microsoft Fabric

Dr. Alexander Wachtel Dr. Alexander Wachtel +1 · WWC 2025

2:21 min

FinLeap Cloud architecture and compliance guidelines

Jan Steffen · LIVE

2:11 min

Evaluating application design patterns in microservices

Paweł Siwek Paweł Siwek · WWC 2025

1:28 min

Building shared Java modules and analyst targeting platforms

Chris Heilmann +2 · LIVE

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader · WWC Europe 2026

Videos

See all

Related articles

See all