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 Director 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.
• 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.
• Ensure data security.

• 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
• 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 and analytical skills
• Ability to organize, analyze, and present data
• Ability to manage multiple priorities

Competencies

• Analytical Thinking: Able to breakdown raw data and undefined problems into specific, workable components. Makes logical conclusions, anticipates obstacles, and considers different approaches that are relevant to the decision-making process.
• Business Function Knowledge: Uses an understanding of business functions to analyze and propose technical strategies for the business. Assesses benefits, risks, and costs.
• Consulting: Uses professional knowledge, experience, and technical expertise to respond to questions, facilitate problem-solving, and generally advise, influence and provide guidance to customers and business partners over whom there is no direct authority.
• Customer Service Orientation: Identifies the ongoing needs of internal and/or external clients. Ensures these needs are met or exceeded.
• Information Seeking: Gathers and analyzes information or data on current and future trends of best practice. Seeks information on issues impacting the progress of organizational and process issues. Translates up to date information into continuous improvement activities that enhance performance.
• Problem Solving: Anticipates, identifies, and defines problems. Seeks root causes. Develops and implements practical and timely solutions.
• Quality Assurance: Applies quality assurance, testing concepts, and methodologies. Constructs comprehensive test plans based on a thorough understanding of business requirements.