Business Intelligence Engineer

Profile Films; Grand Rapids (MI); Vor Ort; USD 90.000 - 130.000; Vollzeit

Benefits dieser Stelle

Competitive compensation

Paid time off

401k with match

Onsite fitness facilities

Office Happy Hours

Zusammenfassung

Profile Films, a Grand Rapids, MI-based extruder and converter of plastic film, seeks a Business Intelligence Engineer to build data pipelines, integrate sources, and deliver dashboards for actionable insights. You will support governance, collaborate with cross-functional teams, and optimize BI workflows in a modern data stack.

The role emphasizes transitioning Tableau dashboards to Fabric, designing scalable data models, and ensuring data quality across platforms.

Qualifikationen

• Bachelor’s degree required in data analytics, engineering, science, information systems, or related field.
• Experience with Tableau and/or Power BI data visualization tools.
• Intermediate to advanced SQL proficiency with ability to write, optimize and troubleshoot queries.
• Proficiency with Python or similar language for data manipulation/automation.
• Hands-on experience with Microsoft Fabric or comparable cloud data platform (Azure Synapse, Snowflake, Databricks).
• Experience designing dashboards/reports in Tableau and/or Power BI.

Aufgaben

• Build and maintain data pipelines, integrating diverse data sources and optimizing databases for performance.
• Create front-end client-facing models to highlight process opportunities and operational insights.
• Design, build, and maintain user-facing dashboards and reports for data-driven decisions.
• Lead migration of Tableau dashboards/reports onto Fabric backend and evaluate BI toolset (Tableau/Power BI).
• Develop data models and automation to improve data ingestion, cleaning, and transformation.
• Document data pipelines, models, and transformations to ensure knowledge sharing.

Ausbildung

Bachelor’s degree in Data Analytics, Data Engineering, Data Science, Information Systems, or related field

Tools

Tableau

Power BI

SQL

Python

Microsoft Fabric

Azure Synapse

Snowflake

Databricks

Tableau Online/Cloud

Power BI Service

Salesforce

Jobbeschreibung

Profile Films is a highly respected, customer-focused extruder and converter of plastic film located in Grand Rapids, Michigan. For over 25 years, Profile has succeeded by providing exceptional customer service and value-added product solutions for our customers while creating a great place for our employees to work and contribute. At Profile, we don’t just sell custom plastic packaging; we sell trust and dependability. Our team members provide quality products and exceptional service for our customers every day. At Profile you will find a great work environment in a beautiful modern facility and the opportunity to be an important part of well-established, but rapidly growing company.

We are looking for an enthusiastic Business Intelligence Engineer to add to our business development team. This position will report directly to the Senior Business Systems Manager.

About the Role

The Business Intelligence Engineer is responsible for building and maintaining data pipelines, integrating diverse data sources, optimizing databases for performance, and creating front end client facing models that highlight process opportunities and operational insights. This role supports business intelligence and data governance while collaborating with multiple teams to deliver critical business performance understanding.

Key Responsibilities:

Business process and software

• Work directly with internal customers and Profile’s Senior Business Systems Manager to learn Profile’s key business processes, support our software platforms, and ensure the data captured is properly structured.
• Provide process guidance, customization, and troubleshooting support for Profile’s primary software platforms – with a focus on Sage 100 and Claris FileMaker.
• Support new process initiatives by advising on adherence to Profile’s data quality and governance standards.
• Assist in defining data requirements for systems that are in use, under development or planned for future development.

Business Intelligence and Data Visualization

• Design, build and maintain user-facing dashboards and reports that give business teams clear, accurate and actionable information.
• Lead the transition of Profile's existing Tableau dashboards and reports onto Profile's new Fabric backend.
• Work closely with analysts and business teams to understand data needs and deliver solutions that enable data-driven decision making.
• Ensure published data source and report structures are well organized and have accurate permissions.
• Support the ongoing evaluation of Profile's BI toolset, including our current use of Tableau and possible transition to Power BI.
• Maintain and evolve dashboard/report documentation (definitions, parameters, aggregation logic) to reduce single-point-of-failure risk in BI reporting.

Data pipeline development and modeling

• Own and continue the building out of Profile's Microsoft Fabric medallion architecture (Bronze, Silver, Gold) designing scalable, reliable pipelines that move and transform data from source systems into the Fabric analytics hub.
• Lead the transition of data sourcing for existing reports and dashboards off legacy SQL Server/Snowflake/Mozart pipelines and onto a new Fabric-based architecture.
• Integrate datasets from internal and external sources, ensuring data quality, consistency, and accessibility for business intelligence use cases.
• Design and implement data models for reporting, analytics, and operational systems that support business requirements, focusing on efficiency, accuracy and scalability.
• Create and implement automation techniques for data ingestion, cleaning, and transformation processes to reduce manual effort and improve data pipeline efficiency.

Data management and governance

• Assist in administering and optimizing relational and non-relational databases ensuring high availability, performance tuning, and storage optimization.
• Help establish and enforce data governance and data quality frameworks, ensuring the accuracy, consistency, and security of data across the organization.
• Create and maintain comprehensive documentation for data pipelines, infrastructure, data models, and transformations to ensure clear communication and knowledge sharing.
• Ensure data solutions comply with internal data privacy and security policies.
• Bachelor’s degree in Data Analytics, Data Engineering, Data Science, Information Systems, or related field.
• Experience with Tableau and/or Power BI data visualization tools.
• Intermediate to advanced understanding of SQL with the ability to write, optimize, and troubleshoot queries.
• Understanding of data modeling principles, including normalization, star schema, and medallion (Bronze/Silver/Gold) architecture.
• Proficiency with Python or a similar language for data manipulation and automation.
• Hands‑on experience with Microsoft Fabric or a comparable modern cloud data platform (Azure Synapse, Snowflake, Databricks) with the ability to ramp quickly on Fabric specifically.
• Direct experience designing and building dashboards and reports in Tableau and/or Power BI.
• Strong analytical and problem‑solving skills, with the ability to troubleshoot and debug data issues independently.
• Ability to learn quickly and adapt to new technologies and tools as needed.
• Demonstrated ability to document technical work clearly.
• Experience administering data/software platforms such as SQL Server, Snowflake, Mozart Data, Tableau Online/Cloud, Power BI Service, Salesforce, or similar is a plus.
• Consistently adhere to all Food Safety, GMP, Personal Safety, and Company Policy standards.

Core Strengths & Mindset (Essential for success!):

• Eagerness to learn and grow
• Positive and collaborative mindset
• Strong sense of ownership and accountability
• Ability to balance technical work with business needs
• Attention to quality, reliability, and maintainability

What you can expect from Profile:

• Competitive compensation
• Paid time off
• Tuition and professional certification assistance
• 401k with match
• Employee Assistance program
• Clean, modern work environment in newly redesigned office space
• Onsite fitness facilities
• Office Happy Hours, Summer BBQ’s, Celebrations!