Data Engineer

Job description

Founded over 35 years ago, First Quality is a family-owned company that has grown from a small business in McElhattan, Pennsylvania into a group of companies, employing over 5,000 team members, while maintaining our family values and entrepreneurial spirit. With corporate offices in New York and Pennsylvania and 8 manufacturing campuses across the U.S. and Canada, the companies within the First Quality group produce high-quality personal care and household products for large retailers and healthcare organizations. Our personal care and household product portfolio includes baby diapers, wipes, feminine pads, paper towels, bath tissue, adult incontinence products, laundry detergents, fabric finishers, and dishwash solutions. In addition, we manufacture certain raw materials and components used in the manufacturing of these products, including flexible print and packaging solutions. Guided by our values of humility, unity, and integrity, we leverage advanced technology and innovation to drive growth and create new opportunities. At First Quality, you’ll find a collaborative environment focused on continuous learning, professional development, and our mission to Make Things Better®. We are seeking a Data Engineer for our First Quality Enterprises, LLC working remotely from the Eastern or Central Time Zone. The Enterprise Data and Analytics team provides strategic direction, technical/functional expertise, and product management for First Quality’s Data and Analytics systems and Machine Learning applications. The Data Engineer, as a key member of the Enterprise Data and Analytics team, provides technical leadership for the definition, design, and delivery of First Quality’s data engineering/ETL solutions. The person in this role will interact with all areas of First Quality to define business requirements, scope solutions, develop specifications, and delivery of solutions. This position is the go-to contact for their assigned Analytics system specialization and, as such, serves as the ultimate support escalation point for their assigned system(s). The person in this position owns their assigned system(s) and interacts with all divisions within First Quality. This position will be held accountable for the training, education, and execution of Analytics systems with the goal to fully utilize their capabilities. Primary responsibilities include: Design and implement data architecture and ETL solutions. Collaborate with business stakeholders, data engineers, and data scientists to understand data requirements and design scalable and flexible data models. Develop data ingestion pipelines and frameworks to efficiently capture and integrate data from various sources into data warehouse platform (on-prem & cloud). Define data storage and retrieval mechanisms, including multi-tenant data partitioning, indexing, and compression, to optimize performance and cost efficiency. Create and maintain data pipelines and ETL/ELT processes to transform, cleanse, and integrate data across different data sources. Perform data profiling, analysis, and troubleshooting to identify and resolve data-related issues. Identify technical areas for improvement and present detailed business cases for improvements or new areas of opportunities Work with external and internal teams to resolve infrastructure-related issues when developing integration solutions. Work with IT functional leads to understand the application architecture and setup right integration mechanisms. Follow DevOps practices across all analytics systems Communicate complex ideas in simple terms, and effectively interact with decision makers. The ideal candidate should possess the following: Bachelor’s degree in computer science, Information Technology, Engineering, or a related field. 3 years of experience in designing and implementing data engineering solutions on-prem/cloud. Strong proficiency in SQL, ADF, Azure Databricks or any other ETL tools. Deep understanding of data modeling principles and techniques. Good knowledge of ETL/ELT processes, data integration patterns, and data warehouse concepts. Exposure to any visualization tools (QlikView, Tableau, Power BI etc.) Prior experience in the Manufacturing Industry preferred. Proficiency in SQL and Python. Strong problem-solving and analytical skills with the ability to troubleshoot and resolve complex data-related issues. Excellent communication and collaboration skills to work effectively with stakeholders at all levels. Ability to manage multiple projects and priorities in a fast-paced and dynamic environment. What We Offer You We believe that by continuously improving the quality of our benefits, we can help to raise the quality of life for our team members and their families. At First Quality you will receive: Competitive base salary and bonus opportunities Paid time off (three-week minimum) Medical, dental and vision starting day one 401(k) with employer match Paid parental leave Child and family care assistance (dependent care FSA with employer match up to $2500) Bundle of joy benefit (year's worth of free diapers to all team members with a new baby) Tuition assistance Wellness program with savings of up to $4,000 per year on insurance premiums ...and more! First Quality is committed to protecting information under the care of First Quality Enterprises commensurate with leading industry standards and applicable regulations. As such, First Quality provides at least annual training regarding data privacy and security to employees who, as a result of their role specifications, may come in to contact with sensitive data. First Quality is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, sexual orientation, gender identification, or protected Veteran status.