BI Developer - FXI Inc

Building our Future Together. FXI is a leading producer of foam innovation in the Bedding, Furniture, Industrial, Home & Office, Healthcare, and Transportation markets. We have made it our mission to provide tailored solutions that delight our customers and consumers. With our corporate headquarters, high-tech research and development facility, and multiple manufacturing locations in North America, FXI has built a culture of innovation and achievement that is recognized by customers, suppliers and peers. Our products include finished goods, sub-assemblies, services, and raw materials for OEMs, fabricators, and retailers. You will find FXI’s foam innovations inside, around, and under yourself in countless applications. Everywhere foam goes, FXI’s innovations lead the way! Won’t you join us?

Job Responsibilities

The BI Developer will be a core member of the IT team which maintains the enterprise data warehouse for FXI data across multiple applications. The role will report to the Manager of Business Intelligence.  Specific responsibilities include:

• Design, implement and maintain data warehouse solutions including data migration tools, data modeling, data integration, data warehousing and database design.
• Design and shape the business intelligence architecture including recommendations for new tools & capabilities.
• Collaborate with BI Analyst and stakeholders to translate functional requirements into technical specifications.
• Troubleshoot and maintain data warehouse solutions including data migration tools, data modeling, data integration, and data warehousing.
• Develop and maintain technical documentation.
• Manage Power BI semantic models.
• Assist BI Analysts with complex DAX measures and optimization of measures to improve performance.
• Collaborate with cross functional teams to understand and execute data requirements including the integration of data from all key applications.
• Troubleshoot and resolve data-related issues, performance bottlenecks, and dashboard responsiveness problems.
• Lead projects to improve performance and functionality.

• Bachelor’s degree in computer science, Information Systems, or specialized training/certification, or equivalent work experience
• 3-5 years of experience as a BI Developer or Architect using an enterprise class business intelligence and analytics solution
• Experience with Power BI: semantic models, Power Query
• Advanced DAX (Data Analysis Expressions) skills
• Advanced SQL skills. Experience with creating/maintaining stored procedures & structured views
• Experience with Microsoft Analysis Services (SSAS), Microsoft Reporting Services (SSRS) and Microsoft SQL Server Integration Services (SSIS).
• SQL Server Management Studio (SSMS)
• Experience with ETL/ELT tools, specifically Azure Data Factory and Azure SQL cloud databases.
• Cloud to cloud integration
• Scripting, API development, Web connectors
• Data Lake design
• OLAP (Online analytical processing)
• Knowledge of ERP systems, SAP ECC or S/4Hana a plus
• Strong organizational and time management skills
• Translate complex business problems into technical specifications
• Excellent problem-solving, analytical and communication skills
• Ability to organize, analyze, and present data
• Ability to manage multiple priorities