[ref. n58678504] Business Intelligence Developer

Overview:

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.

FLSA Status: Exempt

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

Business Intelligence Developer Salary Range: $85,274.80 - 102,329.76

Responsibilities:

ESSENTIAL DUTIES & RESPONSIBILITIES

Reasonable Accommodations Statement

• 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.

• Team Oriented – Ability to get along with others and to work well in a team environment.
• Customer Focus - Knows who internal customers are. Identifies opportunities that benefit the customer (internal and external). Establishes and maintains effective relationships. Delivers products that meet customer expectations.
• Results Oriented - Works as a productive and cooperative member of a cohesive group. Persists in accomplishing objectives despite obstacles and setbacks. Pushes self and helps others achieve results. Solution vs. problem oriented. Demonstrates ability to adjust when obstacles arise.
• Communicates Effectively - Communicates proactively and with purpose and professionally, in a concise and straightforward manner. Attentively listens to others. Communicates to those involved, especially if agreements cannot be kept.
• Accountability - Takes personal responsibility for decisions, behaviors, actions and failures, and commits to necessary corrective action. Able to admit limitations of knowledge, yet demonstrate a willingness to do what is needed to improve. Proactively seeks feedback without being defensive. Does what is right because it is the right thing to do. Leaves personal circumstances outside of work in order to remain engaged in the task at hand. Maintains a positive attitude despite adversity.
• Reliability - Demonstrates reliable and predictable attendance and punctuality.
• Strategic Thinking – Advanced ability to synthesize complex data concepts, design scalable data architectures, and translate technical solutions into business value
• Technical Aptitude – Proficient in applying advanced technical skills to develop robust data solutions, with expertise in Python, SQL, and AI integration
• Database Management – Comprehensive experience in multi-layered data engineering, including complex ETL processes, data warehouse design, and cross-source data blending
• AI and Automation – Strong capability in implementing machine learning models, AI-assisted analytics, and automated data processing solutions
• Analytics – Expert-level proficiency in Tableau, SQL, and Python, with a passion for transforming raw data into actionable business intelligence
• Continuous Improvement – Deep understanding of data optimization techniques, LEAN methodologies, and emerging technologies in data science. Always looking for new ideas and innovative ways to improve.
• Project Management – Proven ability to lead complex data projects from conception to implementation, with experience in mentoring and guiding technical teams
• Statistical Analysis –Skills in applying statistical models and machine learning techniques to derive meaningful insights
• Leadership – Demonstrated success in guiding technical teams, managing intern programs, and driving innovation in data strategy
• Communication – Exceptional ability to translate complex technical concepts into clear, accessible language for non-technical stakeholders
• Collaborative Mindset – Skill in working across cross-functional departments to align data solutions with broader business objectives
• Analytical - adept at synthesizing difficult concepts, seeing patterns, and creating frameworks.
• Designer - strong understanding of digital UI design principles including layout, color, typography, etc.

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.
• Passion for, and experience in, woodworking is a plus
• Passion for, and experience in, playing guitar is a plus.