Overview

The Business Intelligence Developer will architect and implement data and AI solutions that drive strategic insights across all departments at Taylor. This highly technical yet collaborative role will be principally responsible for designing and maintaining data architecture that unifies disparate sources across the business into standardized, reliable data models. The role involves creating robust ETL pipelines, developing and maintaining data warehouse structures, writing complex SQL queries, and building Python applications - with an emphasis on leveraging AI and automation to enhance these processes. This position bridges technical data engineering with business analytics, requiring both strong coding skills and the ability to translate business needs into automated, intelligent solutions.

Department: Business Intelligence

FLSA Status: Exempt

Work Schedule: Monday – Friday 8:00am-5:00pm

Salary Range: $85,274.80 - 102,329.76

Responsibilities

ESSENTIAL DUTIES & RESPONSIBILITIES

• Design and implement data models that support all departments of the business.
• Develop and maintain scalable data warehouse architecture and ETL processes to support analytics needs across the organization.
• Create and optimize SQL queries and stored procedures for complex data transformations and analysis.
• Develop Python scripts and applications for data processing, automation, and advanced analytics.
• Lead initiatives to modernize legacy data systems and improve data infrastructure through automation.
• Implement AI solutions using tools like ChatGPT API to automate routine analytics tasks and enhance data processing.
• Design and deploy machine learning models to improve forecasting and anomaly detection.
• Build and maintain Tableau dashboards that provide actionable insights for sales, marketing, manufacturing, supply chain, facilities, and business operations.
• Integrate AI-powered solutions for automated data cleaning and standardization.
• Create automated data quality checks and monitoring systems.
• Continue data governance standards and best practices for data quality, documentation, and accessibility.
• Collaborate with IT to integrate various data sources including ERP, RFID, and other systems.
• Document technical specifications, data lineage, and architectural decisions.
• Develop AI-assisted coding solutions to accelerate development processes.
• Mentor analysts and interns in SQL, Python, and emerging AI tools and technologies.
• Champion data-driven and AI-enhanced decision making across the organization.

Qualifications

POSITION QUALIFICATIONS

Education & Experience: Bachelor's degree, preferably in statistics, mathematics, economics, finance, engineering, or sciences. At least 3+ years of experience in developing and managing BI tools, project management, and strategizing data architecture.

Technical Skills/Qualifications:

• Advanced experience of SQL and Python
• Advanced experience using BI tools (preferably Tableau certified)
• Experience working with Syspro (or any ERP) via SQL is preferred
• Advanced knowledge and experience using MS Excel and MS Power Point
• Certification and/or Experience working in Continuous Improvement disciplines
• Experience working with MRP systems is preferred
• Experience working with RFID production tracking systems is preferred
• Agile Project Management and/or LEAN or Six Sigma training is a plus
• Experience in consumer products manufacturing is a plus.