Senior BI Developer

Foundation Building Materials LLC
Santa Ana, United States of America
3 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 135K

Job location

Santa Ana, United States of America

Tech stack

SAP Cloud
Agile Methodologies
Artificial Intelligence
Business Analytics Applications
Data analysis
Azure
Business Intelligence
Code Review
Information Systems
Data Architecture
Data Dictionary
Data Governance
Data Infrastructure
Data Integration
ETL
Data Warehousing
Database Design
Dimensional Modeling
Python
Microsoft Software
Microsoft SQL Server
SQL Azure
Open Data Protocol
Performance Tuning
Scrum
Systems Development Life Cycle
Query Optimization
Release Management
Power BI
Cloud Services
Standard Sql
Azure
SAP Applications
SAP Financial Management
SQL Server Reporting Services
Systems Integration
Tableau
Website Wireframe
Enterprise Software Applications
Azure
Informatica Powercenter
Delivery Pipeline
Spark
Powerquery
Microsoft Fabric
Data Lake
Information Technology
Data Analytics
SAP S/4HANA
Operational Systems
Azure

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