Business Intelligence & Integration Specialist at Curtis Lumber Co Inc. | Ballston Spa, NY, US | Rezi

Business Intelligence & Integration Specialist at Curtis Lumber Co Inc.

Business Intelligence & Integration Specialist

Curtis Lumber Co Inc. · Ballston Spa, NY, US

Today

Business Intelligence & Integration Specialist

Curtis Lumber Co Inc. · Ballston Spa, NY, US

a day ago
Resume preview

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

Oversees and manages the organization’s data systems, including the design, implementation, and maintenance of databases, ensuring data integrity, security, and accessibility. Collaborates with leadership to develop actionable solutions and leverage data analytics for informed decision-making. Provides technical guidance and support, contributing to technology solutions that align with business needs and enhance sales and operational efficiency.

Responsibilities

  • Design, develop, maintain, and support dashboards, reports, scorecards, visualizations, and analytical solutions.
  • Support Power BI, SSRS, Crystal Reports, and related reporting technologies.
  • Collaborate with stakeholders to define reporting requirements, KPIs, and analytical needs.
  • Analyze business data to identify trends, opportunities, and performance improvements.
  • Ensure accurate, reliable, and accessible reporting across the organization.
  • Promote self-service reporting and data-driven decision-making.
  • Develop reporting solutions supporting operational, financial, sales, and strategic objectives.
  • Create meaningful visualizations and executive reporting tools that support informed business decisions.
  • Design, develop, maintain, and troubleshoot enterprise integrations, APIs, and automated workflows.
  • Support data exchange between ERP, finance, HR, logistics, eCommerce, manufacturing, and third-party systems.
  • Develop and maintain ETL processes, data synchronization, transformation, and validation routines.
  • Monitor integration performance and proactively resolve interface and data movement issues.
  • Utilize Power Automate and related technologies to streamline workflows and business processes.
  • Identify opportunities to improve operational efficiency through automation, analytics, and system integration.
  • Ensure integrations and automation solutions are secure, scalable, reliable, and properly documented.
  • Support implementation of new applications, integrations, and process improvements as business requirements evolve.
  • Support enterprise data governance, stewardship, quality, security, and compliance initiatives.
  • Promote data consistency, accountability, accessibility, and protection across organizational systems.
  • Maintain appropriate security controls, access management practices, and data protection measures.
  • Assist with audit, cybersecurity, risk management, and regulatory compliance efforts related to enterprise data assets.
  • Evaluate, implement, and support emerging technologies, including AI-enabled analytics, automation, and advanced reporting solutions.
  • Identify opportunities to leverage artificial intelligence and advanced analytics to improve business processes, reporting, and operational efficiency.
  • Prepare and maintain enterprise data structures that support future AI and analytics initiatives.
  • Promote responsible, secure, and business-focused adoption of new technologies.
  • Administer, maintain, and support Microsoft SQL Server environments.
  • Design, develop, and maintain databases, data warehouses, data structures, and supporting architecture.
  • Develop, optimize, and support SQL queries, views, stored procedures, functions, and automated processes.
  • Monitor database performance, backups, storage, security, growth, and system availability.
  • Manage database permissions, access controls, retention policies, and governance standards.
  • Troubleshoot database-related issues including performance, storage, backup, and data integrity concerns.
  • Integrate and maintain data from multiple business systems within centralized and accessible data structures.
  • Support databases utilized by enterprise applications and operational systems.
  • Coordinate with vendors, business partners, and service providers on database and application-related issues.
  • Maintain technical documentation related to database configurations, processes, and support procedures.
  • Provide advanced technical support for business applications, databases, reporting platforms, integrations, mobile devices, and related technologies.
  • Troubleshoot and resolve technical issues impacting users and business systems.
  • Train and assist users in effectively utilizing business applications, reports, dashboards, and technology solutions.
  • Develop and maintain technical documentation, support procedures, and knowledge base materials.
  • Collaborate with internal departments, vendors, consultants, and business partners to achieve organizational objectives.
  • Participate in project planning, testing, implementation, deployment, and ongoing support activities.
  • Provide backup support and assistance to other Information Systems team members as needed.
  • Participate in on-call support, maintenance activities, after-hours work, and emergency response efforts when required.

Requirements

  • Bachelor's degree in Information Systems, Computer Science, Data Analytics, Business Intelligence, or a related field; equivalent experience considered.
  • 5+ years of experience in business intelligence, data analytics, database administration, data engineering, systems integration, reporting, or related technical disciplines.
  • Advanced experience with Microsoft SQL Server administration and development.
  • Experience designing complex SQL queries, stored procedures, views, functions, and data models.
  • Experience with APIs, ETL processes, application integrations, and automated workflows.
  • Experience with Power BI, SSRS, Crystal Reports, or similar reporting and analytics platforms.
  • Experience with Microsoft Power Platform, including Power Automate.
  • Strong analytical, troubleshooting, communication, documentation, organizational, and project management skills.
  • Working knowledge of data governance, cybersecurity principles, and enterprise application ecosystems.
  • Experience with AI-assisted analytics, automation technologies, and advanced reporting solutions preferred.

Skills

  • Microsoft SQL Server
  • SQL queries
  • Stored procedures
  • Views
  • Functions
  • Data models
  • APIs
  • ETL processes
  • Application integrations
  • Automated workflows
  • Power BI
  • SSRS
  • Crystal Reports
  • Microsoft Power Platform
  • Power Automate
  • Data governance
  • Cybersecurity principles
  • Enterprise application ecosystems
  • AI-assisted analytics
  • Automation technologies
  • Advanced reporting solutions

Location

  • Onsite

Work Type

  • Full-time

Experience Level

  • 5+ years of experience

Education Level

  • Bachelor's degree in Information Systems, Computer Science, Data Analytics, Business Intelligence, or a related field; equivalent experience considered.

Benefits

  • Comprehensive Benefit Package - Medical, Dental, Vision
  • Competitive Wages
  • 401k with Company Match
  • Ideal Retail Hours
  • Paid Holidays & PTO
  • Bereavement Pay
  • Profit Sharing
  • 529 College Savings
  • Employee Assistance Program
  • Tuition Reimbursement
  • Boot Reimbursement
  • Employee Discount
  • Community Events
  • Employee Referral Program

About the Company

  • Founded in 1890, Curtis Lumber is a family owned and operated building materials retailer, one of 100 largest and fastest-growing in the nation.
  • Our employees enjoy competitive pay and excellent benefits coupled with ideal business hours allowing for a healthy work life balance.
  • We recognize our employees hard work and dedication are the driving force of our success, and we continually look for ways to reward them.
  • At Curtis Lumber we embrace a culture of accountability and safety. Join us, and you’ll quickly see everything that sets us apart is also what brings us together.