Overview
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 Overview : The Data Engineer 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 Sr. Manager of Business Intelligence.
This position is located at our Radnor, PA headquarters on a hybrid model and will in office on Monday, Tuesday and Thursday.
Responsibilities
- Design, implement and maintain data warehouse solutions including data migration tools, robust data models, data integration, data warehousing and database design.
- Develop ETL processes, optimize data pipelines, and ensure data quality and security.
- Built high-performance algorithms, prototypes, predictive models, and proof of concepts.
- Collaborate with BI Analyst and stakeholders to deliver scalable data architecture supporting analytics and business intelligence.
- Review and improve business processes, best practices, and data quality, efficiency, and reliability. Establish solutions that democratize data throughout the organization.
- Ensure data quality through automated techniques and implementing data privacy and compliance measures.
- Drive engagement, organizational assessment, impact analysis, learning/training, communications, business readiness, deployment, and adoption measurement throughout projects
- Apply Agile and waterfall methodologies to deliver outcomes continuously and promote user adoption.
- Develop and maintain technical documentation.
- Troubleshoot and resolve data-related issues and performance bottlenecks
Qualifications
- Bachelor’s degree in computer science, Information Systems, or specialized training/certification, or equivalent work experience
- 4-6+ years of experience as a Data Engineer
- The candidate should have hands-on development experience with various Azure services including but not limited to. Azure Data factory, Azure Blob storage, Azure SQL DB, Azure synapse, Azure Data Lake and Azure logic app or similar.
- Advanced SQL skills and Python. Experience with creating/maintaining stored procedures & structured views
- Knowledge of enterprise-class business applications including ERP systems (e.g SAP ECC, S/4 HANA) similar, financial systems, manufacturing applications, HR and others.
- Experience with Big data tools
- Experience with Microsoft Analysis Services (SSAS), Microsoft Reporting Services (SSRS) and Microsoft SQL Server Integration Services (SSIS).
- SQL Server Management Studio (SSMS)
- Scripting, secure API development, Web connectors
- OLAP (Online analytical processing)
- 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
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.
- Ability to manage multiple priorities
- 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.
Key words