Data Engineer

WHY PRODRIVEN GLOBAL BRANDS? BECAUSE WE ARE THE PROFESSIONAL’S CHOICE!  You will find our market leading products and brands on job sites all over the world.

Focusing on end users' needs and delivering exceptional customer experience drives our success. Our entire process—from research to engineering to manufacturing to commercialization—creates products that ensure ease of use, productivity, durability and safety for the end user. On jobsites across the world, ProDriven brands are most preferred.

ProDriven Brands is seeking a skilled and motivated Data Engineer with a passion for leveraging data, innovative technologies, and artificial intelligence (AI) to elevate our business processes. This role will support efforts to understand business needs, gathering detailed requirements, and translating them into robust, scalable integration and automation solutions across our enterprise systems. The ideal candidate will possess strong analytical skills and have a comprehensive understanding of data integration principles and technologies. This position also involves exploring opportunities to harness data insights and contribute to AI-driven enhancements.

ESSENTIAL JOB FUNCTIONS AND RESPONSIBILITIES

Business Requirements Gathering and Analysis:

• Collaborate effectively with cross-functional teams, including business analysts and application owners, to gather and document detailed integration requirements and deliver solutions.
• Translate business needs into clear, detailed, and actionable technical specifications for integration development.

Solution Design and Development:

• Design and create data integration solutions based on business requirements and technical specifications.
• Build and maintain ETL/ELT pipelines using Matillion and Fivetran to ensure the quality and transformation of data within Snowflake for analytical purposes.
• Develop, implement, and maintain real-time and batch integration workflows and APIs using Jitterbit or equivalent platforms
• Collaborate with Salesforce developers and administrators to build and maintain integrations with other enterprise systems.
• Work with the ERP (JDE) team to understand data structures and build effective integrations utilizing appropriate methods.
• Utilize HVR for configuring and monitoring real-time data replication and change data capture (CDC) processes.
• Develop and execute comprehensive test plans for integration solutions to ensure data accuracy, performance, and reliability.
• Participate in code reviews and ensure adherence to integration standards and best practices.
• Create and maintain a comprehensive integration documentation library, including data dictionaries, pipeline flowcharts, and SLA definitions, ensuring audit-readiness and long-term maintainability.
• Performs other duties as assigned within the scope of responsibilities and requirements of the job
• Performs Essential job functions and duties with or without reasonable accommodation

Continuous Improvement:

• Proactively identify opportunities to optimize existing data pipelines and integration processes for enhanced efficiency, data quality, and business value.
• Stay abreast of advancements in integration technologies, data management trends, and emerging AI capabilities relevant to data integration.
• Contribute to the development of data engineering and integration standards and guidelines, promoting best practices and innovation.
• Support efforts to evaluate new tools, including AI/ML, to enhance our data integration capabilities and drive data-driven insights.
• Assist in assessing emerging technologies that can enhance data integration, automation, or AI-driven insights in alignment with evolving business needs and industry best practices.

Education, Licenses, and Certifications

• Bachelor's degree in Computer Science, Information Technology or related field preferred or equivalent work experience required

Preferred certifications: In relevant integration or cloud technologies.

Years of Experience and Knowledge

• 3-5 years of experience in data engineering, with a strong focus on building and maintaining data pipelines and implementing enterprise-wide data integration and automation solutions.
• 3-5 years of hands-on experience in Snowflake Data Warehouse, Matillion ETL, Power BI, HVR, Jitterbit, SQL, and other scripting/development tools (e.g., Python).

Skills and Abilities

• Intermediate level Microsoft Outlook, Word, PowerPoint skills
• Intermediate level Microsoft Excel skills
• Strong understanding of data integration patterns, warehousing principles, and API design.
• Ability to work independently and as part of a team in a fast-paced environment.
• Excellent analytical, problem-solving, and troubleshooting skills with a business-oriented mindset.
• Demonstrated interest in and understanding of AI/ML's potential applications in data integration and automation.
• Experience with Agile or other project management methodologies, preferably in a manufacturing environment.eneral Azure knowledge and experience with Azure DevOps.

Preferred Qualifications:

• Experience with other integration tools and technologies (e.g., MuleSoft) is a plus
• Knowledge of DevOps practices, including building and maintaining CI/CD pipelines using tools like Azure DevOps for deploying ETL and data integration workflows.
• Experience with AI/ML platforms.
• Experience working with JDE data structures and business processes, including implementing integrations using APIs or change data capture (CDC) for reporting or automation purposes.
• Understanding of Salesforce APIs (REST, SOAP, Bulk), data models, and integration patterns.

Travel Requirements

• 0% ~ 10% travel domestically required

ProDriven Brands is committed to fostering, cultivating, and preserving a culture of diversity, equity and inclusion. ProDriven Brands  is an equal opportunity employer and prohibits discrimination and harassment of any kind. All qualified applicants to ProDriven Brands are considered for employment without regard to age, color, disability, ethnicity, family or marital status, gender identity or expression, language, national origin, physical and mental ability, political affiliation, race, religion, sexual orientation, socio-economic status, veteran status or any other protected characteristic.  ProDriven Brands will not tolerate discrimination or harassment of any kind based on these characteristics.

#LI-Hybrid

#LI-RR1