Business Intelligence Analyst II
Job Type
Full-time
Description

Who we are


FloraCraft Corporation is a family-owned, Michigan-based company and the world’s leading manufacturer of foam products for the craft and floral industries. For over 75 years we have been dedicated to making it easy for creators everywhere through our innovative and high-quality products. 


At FloraCraft, we pride ourselves on our commitment to excellence, diversity, and sustainability. Our team is the heartbeat of our organization, driving innovation and providing exceptional products to our customers. 


We believe in giving back to our community by supporting the arts, education, sports, and other initiatives that make Ludington a wonderful place to live and work. Our mission is to honor our heritage by delivering superior products and services, fostering a fun and inclusive workplace, and contributing positively to our community. 

Join us at FloraCraft, where creativity and innovation come to life! 


What you’ll do 


In this cross functional role, you will be responsible for developing insights to help determine the success and health of the business. 

In this role you will manage data sources, both internal and external, building and maintaining reporting dashboards. You will assist and support internal team data analysis within Business Intelligence (Power BI) tools. This role has an expectation to be onsite and potential to travel.


Essential duties include:

  • Planning, design, and implementation of ETL (Extract, Transform and Load) processes
  • Monitors and maintains data integrity
  • Interacts with API’s and other external data sources
  • Oversee design and development of Reporting Dashboards & Apps
  • Manages data access and providence
  • Project management in a fast paced and changing environment
  • Database administration

Displays proficiency in the following competencies: 

  • Initiative – the understanding of what action needs to be taken and completing these tasks while seeking the perspective of others; 
  • Personal Accountability – taking personal responsibility for mistakes; does what he/she commits to and is honest and forthright; 
  • Collaboration – gets along with others and works as a team player to make a difference within the business and expresses gratitude and appreciation to others who have provided information, assistance and support; and
  • Willingness to Learn – handles change through taking advantage of lifelong learning opportunities and is open-minded and curious to face new challenges.

What you’ll need 

  • ERP experience preferred, Plex® experience a plus
  • Experience with Common Languages/Functions (e.g., SQL - Structured Query Language, Rest API – HTTP Requests, DAX - Data Analysis Expressions)
  • Experience with standard Star Schema databasing
  • Strong technical skills with SQL, R/Python for data analysis and visualization tools such as Tableau, Qlik, PowerBI, etc.
  • Experience with Azure Data Factory, Azure Data Warehouse, Azure Synapse and Visual Studio Code.
  • Experience with Microsoft Excel, Microsoft Power Apps, Microsoft Power Automate, and Sharepoint. Expectation of standard abilities in other Microsoft Office products.

  • Experience working in a manufacturing environment (preferred)

Why Join Us 

  • Competitive wages & Bonus potential 
  • Opportunity to work with a great culture 
  • Great Benefits - vacation, medical, dental, vision, FSA, company-provided life insurance      and short-term disability, company sponsored long-term disability, job-related tuition reimbursement, 401(k) and profit sharing 
Requirements

Bachelor’s Degree in Information Technology, Computer Science, or Management Information Systems (preferred), or related studies, and/or 3-5 years’ related experience or training; or equivalent combination of education and experience.


Please note that this position is based on site at our Ludington headquarters in Ludington, MI. Remote work options are not available for this role.