Jobless Developer
Software Engineer IIFoundation Building Materials · Santa Ana

Software Engineer II

Santa AnaOn-site$127k–$145k

AI Summary

Designs, develops, tests and maintains data integrations, data warehouse ETL processes, and web and mobile applications supporting business operations at a construction materials distributor. Also takes on ad hoc tasks for management and team members.

About this role

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, we are investing in strong, forward-thinking talent to support our long-term success.

Overview

Position Overview

At Foundation Building Materials (FBM), the Software Engineer II supports business operations by designing, developing, testing, and maintaining data integrations, data warehouse processes, and web and mobile applications.

As a Software Engineer II, the ideal candidate would be a strong self-starter and team player that is willing to adapt to change in a fast-paced environment. We are a growing company, and while this role will be responsible for several recurring tasks, this role will also regularly take on ad hoc tasks needed by upper management and/or other team members to advance the company’s interests. The flexibility, time management, and maturity to handle the ebb and flow of assignments is as important as the technical and analytical skills required to be successful in this position.

Responsibilities and Qualifications

Key Responsibilities Data Integration and Data Warehousing
  • Responsible for designing, building and testing business application to application data transfer / Data Integration processes using Informatica that includes various acquisition integration
  • Responsible for Data validation, process tuning and automation of interface / data transfer processes
  • Responsible for design, develop and test application interfaces using various application connectors between B2B applications.
  • Responsible for design data warehouse ETL processes using IICS
  • Responsible for Creating detailed ETL specifications for the development team in offshore
  • Responsible for Data validation, process tuning and automation of data warehouse ETL processes
Business Requirements and Solution Architecture
  • Meet with business users and gather business requirements
  • Responsible for meeting with source System experts to identify the appropriate sources, conduct detailed Source system analysis and processes to create a detailed data analysis report and Gaps analysis
  • Responsible for meeting with Target System experts to identify the appropriate targets, conduct detailed Target system analysis and process to create a detailed data analysis report and Gaps analysis
  • Evaluates the existing landscape and underlying data layers to provide architectural recommendations to meet business requirements.
Web and Mobile Application Development
  • Participate in the design, development, and maintenance of our corporate websites, Mobile applications and B2B solutions Responsible for creating Wireframes
  • Responsible for creating the collaterals/visual mock-ups for the approved prototypes
  • Manage design, development, testing, implementation, maintenance, and support of organization-wide Web and mobile Application solutions.
Technology Operations and Internal Controls
  • Manage activities to improve efficiency, stability, security and optimization of FBM’s Information Technology environment.
  • Responsible for the design, execution and effectiveness of a system of internal controls that provides reasonable assurance that services are effective, efficient and assets are safeguarded.
Project Delivery and Professional Development
  • Responsible for working with offsite and offshore team members and manage their deliverables
  • Provide help in resolving issues identified by the project team
  • Ensures that his/her skills are up-to-date on the latest tools, techniques and knowledge and that the knowledge is shared among other Business Analysts and Developers.
  • Willing to learn and work on FBM’s technology stack
Additional Responsibilities & Miscellaneous
  • Perform other duties as assigned to support Information Technology and corporate objectives.
Qualifications
  • Must have at least 5+ years of hands-on experience in Azure skills including Azure SQL Data Warehouse, Azure Data Lake, Azure Data Factory, Azure Analysis Services and Google’s Big Query.
  • Must have at least 5+ years of hands-on experience on design, develop and implement complex data warehouse and business Intelligence solutions using Informatica (IICS), Azure Synopsis, Power BI, DAX, SSIS, SSAS, SSRS, T-SQL
  • Must have at least 5+ years of data modeling experience in Sales, Purchasing, Finance, Inventory, GA, and CRM; at least three functional area experience is a must
  • Must have at least 5+ years of application Integration experience utilizing Infor CSD, SAP S4 Hana, SAP Ariba, Blackline, Vistex, UltiPro, Dayforce and Microsoft Dynamics 365
  • Should have completed at least 4 data migration project successfully which migrate data from Infor SX.e/CSD to centralized data lake or data warehouse using Informatica IICS
  • Must have at least 2+ years of experience working with telematics data sourcing from Trimble and Samsara.
  • Ability to design, develop and implement complex data warehouse and business Intelligence solutions using Informatica, Power BI and Tableau are required
  • Experience in sourcing data using application delivered APIs. Understanding of API behavior, security, paging etc. is required
  • Strong background in Data Integration design, develop and implement complex solutions using Informatica is required
  • Strong practical knowledge of traditional and agile SDLC methodologies required
  • Proficiency in office-based applications including word processing, spreadsheet and presentation software required
  • Excellent communication and client handling skills and ready to work in offshore-onsite mode
  • Successful team management experience
  • Ability to operate calmly in a high-pressure environment
  • Bachelor’s degree in IT, Business Administration or related field of study (Information Technology).
  • 5+ years relevant work experience quality control.
  • Strong communication (oral and written), interpersonal, and organizational skills required. Must demonstrate ability to successfully interact effectively with all levels in the organization.
  • High level of initiative and critical thinking to formulate business issues into analytical problems and devise actionable solutions.
  • Comfortable working with multiple projects of data and diligence when managing detail.
  • Excellent analytical skills.
  • Time management and ability to complete work under tight deadlines.
  • Possess intellectual curiosity and a desire to learn and be challenged
  • Maintain a positive attitude and be able to adapt to changes
  • Strong work ethic and detail oriented

Compensation and Benefits

Reports ToVP IT Integration & Application Support 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: $127,250-$145,000 per year
  • Bonus: 10%
  • Total Compensation (Base + Bonus): The successful candidate could reasonably expect a Total Compensation Package in the range of $133,500-$174,000
  • Equity: Not Eligible for Lowe's LTI
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.

Posting Period

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

Skills

Azure Analysis ServicesAzure Data FactoryAzure Data LakeAzure SQL Data WarehouseData ModelingDAXDayforceETLGoogle BigQueryIICSInfor CSDInformaticaMicrosoft Dynamics 365Power BIREST APISAP AribaSAP S/4HANASSASSSISSSRSTableauT-SQL

Explore related jobs

Browse these categories

Market data for software engineer roles

All reports →