BUSINESS INTELLIGENCE DEVELOPER - Cortland, NY

GUTCHESS LUMBER CO., INC.

BUSINESS INTELLIGENCE DEVELOPER – JOB DESCRIPTION

REPORTS TO: BUSINESS INTELLIGENCE MANAGER

POSITION: EXEMPT

For over 100 years, Gutchess Lumber has been a leading global lumber producer of premium northern hardwoods in a variety of high-end applications and we take pride in our commitment to quality in everything we do. Quality is at the core of our brand promise is the foundation of which our reputation was founded. This quality also extends to our employees, who are hard-working members of the communities around us. We support our employees with quality pay, excellent benefits, company ownership opportunities and appreciation every day and we are recruiting for a new team member.

Description:

This role involves gathering and analyzing user requests, understanding business needs and translating them into actionable reports and dashboards. The BI Developer will leverage data visualization, SQL queries, and analytics to solve problems and provide valuable insights to stakeholders.Must be able to work in the Cortland office several days a month. 

Overview:

The BI Developer is a member of our Business Intelligence team and is responsible for

developing, maintaining, and enhancing SSRS and Tableau reports to support data-driven

decision-making.

Responsibilities:

Strategy & Planning

1. Design, develop, maintain and optimize SQL Server Reporting Services (SSRS) reports.
2. Extract, Transform, Load and Analyze data using Python, R, SQL, Alteryx, Power Query or other equivalent tools.
3. Monitor report performance, identify bottlenecks, optimize queries to maintain fast response times for large datasets, and ensure data accuracy and integrity.
4. Deploy reports to production environments, manage user access, and provide ongoing support for report updates, troubleshooting and users’ requests.
5. Build interactive dashboards and reports in SSRS, Tableau, PowerBI or other equivalent tools to visualize key business metrics.
6. Document all the user requests, changes, and technical processes for all the projects assigned.
7. Automate data and reporting processes to reduce manual effort and improve efficiency.

Data Analytics & Insights

1. Analyze trends, patterns, and anomalies in data to uncover business insights.
2. Interpret business requirements and translate them into effective reporting solutions.
3. Provide recommendations based on data analysis to improve operational and strategic decisions.
4. Work with large datasets to create meaningful reports that highlight key performance indicators (KPIs).

Collaboration & Continuous Improvement:

1. Identify opportunities for improving reporting processes and implementing best practices.
2. Maintain documentation for report development, data sources, and business rules.
3. Train end users on how to interpret and utilize reports effectively.
4. Excellent communication skills to work effectively with stakeholders across all levels of the organization, adapting communication to diverse audiences, including executives, business users, and technical teams, with varying levels of experience, expertise, and backgrounds.

Skills Required:

Knowledge & Experience

1. Experience in the manufacturing industry and Hardwood Lumber industry is a plus.
2. 2- 5years of hands-on experience in SQL with Microsoft SQL Server and SSRS development in Report Builder.
3. Knowledge with various data mart, data warehouse data models, SSAS Cubes preferred.
4. Familiarity with the Epicor Lumber Track ERP system preferred.
5. Proficient with working in Microsoft based software environments.
6. Contribute to the future design and maintenance of the data mart schema, knowledge of dimensional modeling concepts and data mart design principles, ensuring data integrity and efficiency are preferred.

Professional Attributes:

1. Ability to conduct research into data management issues, practices and products.
2. Proven analytical and problem-solving abilities.
3. Ability to effectively prioritize and execute tasks in a high-pressure environment with tight timelines.
4. Strong written and verbal communication skills, including technical documentation and user-friendly presentations.
5. Highly self-motivated and directed, with attention to detail.
6. Strong customer service orientation with experience working in a collaborative environment.

Education and Certification:

Bachelor’s and/or master’s degree in computer science, data analytics, information systems, Business Intelligence, or related fields is a plus. Equivalent experience will also be considered.