Software Engineer II
About The Position
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. This position involves designing, building, and testing business application to application data transfer/data integration processes using Informatica. It requires meeting with business users to gather requirements, identifying appropriate targets with source system experts, conducting target system analysis, and creating data analysis and gap analysis reports. The role also includes data validation, process tuning, automation of interface/data transfer processes, and designing/developing/testing application interfaces using application connectors between B2B applications. Additionally, the position involves designing data warehouse ETL processes using IICS, creating detailed ETL specifications, collaborating with offsite and offshore team members, assisting in issue resolution, providing architectural recommendations, participating in the design, development, and maintenance of company websites, mobile applications, and B2B solutions, creating collaterals/visual mock-ups for approved prototypes, managing the lifecycle of Web and mobile application solutions, and improving the efficiency, stability, security, and optimization of FBM’s Information Technology environment. The role is also responsible for the design, execution, and effectiveness of the system of internal controls.
Requirements
- Bachelor’s degree in Electronics Engineering or related field (or foreign equivalent)
- 2 years experience in job offered or as Engagement Lead, Team Lead
- Design, development and implementation of complex data warehouse and business intelligence solutions using Informatica (IICS), Azure Synopsis, Power BI, DAX, SSIS, SSAS, SSRS, T-SQL
- Data modeling in at least three of the following areas: Sales, Purchasing, Finance, Inventory, GA, CRM
- Application integration using Infor CSD, SAP S4 Hana, SAP Ariba, Blackline, Vistex, UltiPro, Dayforce, Microsoft Dynamics 365
- Working with telematics data sourcing from Trimble and Samsara
- Design, develop and implement complex data warehouse and business intelligence solutions using Informatica, Power BI and Tableau
- Sourcing data using application-delivered APIs
- Azure SQL Data Warehouse
- Azure Data Lake
- Azure Data Factory
- Azure Analysis Services
- Google’s Big Query
- Working knowledge of API behavior, security and paging
Responsibilities
- Design, build and test business application to application data transfer/data integration processes using Informatica
- Meet with business users to gather business requirements
- Meet with source System experts to identify appropriate targets
- Conduct detailed Target system analysis and processes to create data analysis report and Gaps analysis
- Data validation, process tuning and automation of interface/data transfer processes
- Design, develop and test application interfaces using application connectors between B2B applications
- Design data warehouse ETL processes using IICS
- Create detailed ETL specifications
- Work with offsite and offshore team members
- Assist in resolving issues identified by the project team
- Provide architectural recommendations to meet business requirements
- Participate in the design, development and maintenance of company websites, Mobile applications and B2B solutions
- Create collaterals/visual mock-ups for approved prototypes
- Manage design, development, testing, implementation, maintenance and support of organization-wide Web and mobile application solutions
- Manage activities to improve efficiency, stability, security and optimization of FBM’s Information Technology environment
- Responsible for design, execution and effectiveness of system of internal controls
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
