Solution Architect – Data Engineering
Job Description
First Quality was founded in 1989 and has grown to be a global privately held company with over 4,000 employees. Its corporate offices are located in Great Neck, New York, with manufacturing facilities and offices in Pennsylvania, South Carolina, Georgia, and Canada. First Quality is a diversified family of companies manufacturing consumer products ranging from Absorbent Hygiene (adult incontinence, feminine care, and baby care), Tissue (bath and towel), and Industrial (print and packaging materials), serving institutional and retail markets throughout the world. First Quality focuses on private label and branded product lines.
We are seeking a Solution Architect – Data Engineering for our First Quality Enterprise located remotely. 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 Solution Architect – Data Engineering, as a key member of the Enterprise Data and Analytics team, provides functional and technical leadership for the definition, design, and delivery of First Quality’s Analytics systems. This position is responsible for architecture, product management, and delivery of analytics systems.
The Solution Architect – Data Engineering is responsible for maintaining standards and best practices for enterprise Analytics tools and solutions. The incumbent will design and develop reporting frameworks of varied levels of complexity working directly with end users and other Solution Architects to create reporting requirements, design patterns, and implementations. 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, integration 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.
- Implement data governance and data management practices to ensure data quality, consistency, and compliance with relevant regulations.
- Collaborate with security and compliance teams to establish and enforce data security measures, including data encryption, access controls, and data masking.
- Perform data profiling, analysis, and troubleshooting to identify and resolve data-related issues.
- Stay up to date with the latest advancements in Cloud data services and recommend innovative solutions to enhance data architecture capabilities.
- Provide technical guidance and mentorship to junior team members and promote best practices in data engineering design and implementation.
- 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 modules.
- Partner with the business teams to evaluate and perform application development and/or business process change requests under minimal direction.
- Work with IT functional leads to understand the application architecture and setup right integration mechanisms.
- Implement DevOps practices and CI/CD pipelines across all analytic systems.
- Ability to communicate complex ideas in simple terms, and effectively interact with decision makers.
- Knowledge of machine learning and AI and its integration with data
- May need to travel to manufacturing sites and other First Quality locations to address IT analytics needs
The ideal candidate should possess the following:
- Bachelor’s degree in computer science, Information Technology, Engineering, or a related field.
- Extensive experience in designing and implementing data engineering solutions on-prem and cloud.
- Strong proficiency in SQL, ADF, ADLS, Azure Databricks or any other ETL tools.
- Deep understanding of data modeling principles and techniques.
- Solid knowledge of ETL/ELT processes, data integration patterns, and data warehouse concepts.
- Experience with data governance, data security, and compliance practices
- 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.
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.
EWJP2
