Business Intelligence Analyst

Profile Films

Grand Rapids (MI)

On-site

USD 85,000 - 120,000

Full time

13 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Competitive compensation
Paid time off
Tuition and certification assistance
401k with match
Employee assistance program
Onsite fitness facilities
Office happy hours

Job summary

Profile Films, a Grand Rapids, MI-based plastics manufacturer, seeks a Business Intelligence Analyst to own Power BI and Fabric environments, migrating from Tableau and building robust semantic models.

You will partner with the Senior Business Systems Manager to define metrics, implement data governance, and deliver trusted dashboards for business teams across departments.

Qualifications

  • Bachelor's degree in data-related field.
  • 3+ years designing and building Power BI dashboards for business stakeholders.
  • Experience building Power BI semantic models with dimensional modeling concepts.
  • Strong DAX skills for reusable measures and calculations.
  • Hands-on SQL skills for data validation and analysis.
  • Experience publishing and managing content in Power BI Service.

Responsibilities

  • Design, build, and maintain Power BI dashboards and reports for clear, actionable insights.
  • Migrate Tableau dashboards to Power BI within Fabric environment.
  • Develop semantic models on Fabric data using star schema concepts.
  • Collaborate with vendors and stakeholders to ensure data quality and KPI consistency.
  • Publish, organize, and manage Power BI workspaces, apps, and data access.

Skills

Analytical thinking
Communication
Ownership

Education

Bachelor's degree in Data Analytics, Business Analytics, Information Systems, or related field

Tools

Power BI
Microsoft Fabric
SQL Server
Tableau
Snowflake

Job description

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 Analyst to add to our business development team. This position will report directly to the Senior Business Systems Manager.

About the Role

The Business Intelligence Analyst will take ownership of Profile's Power BI and Microsoft Fabric environment and lead our transition to Power BI. This is an analyst role focused on data modeling and visualization, with data engineering support from our vendor partner. We're a growing, family-owned manufacturer, and this is a great opportunity for someone who wants to build their skills and grow with us.

What you will do:
  • Design, build, and maintain Power BI dashboards and reports that give business teams clear, accurate, and actionable information.
  • Lead the migration of Profile's existing Tableau dashboards and reports to Power BI, rebuilt on the curated data in Profile's new Microsoft Fabric environment.
  • Apply sound visualization design practices (clear layout, appropriate chart choices, consistent formatting, and intuitive filtering and drill-through) so reports are easy to use and trusted.
  • Manage Power BI workspaces, apps, and publishing, ensuring content is well organized and access permissions are accurate.
Semantic Modeling & Analytics
  • Design, build, and maintain Power BI semantic models on top of Profile's Fabric data, using star schema principles and well-defined relationships.
  • Develop and maintain reusable, well-documented DAX measures so key metrics are defined once and calculated consistently across reports.
  • Work with business stakeholders to clarify and document metric definitions, helping Profile move toward agreed, consistent KPIs.
  • Use Power Query for data shaping where appropriate and move reusable transformation logic into the Fabric Gold layer so it is defined once and shared across models.
  • Monitor and tune semantic model performance, storage modes, and refresh schedules.
  • Validate model and report outputs against source systems and legacy reports so the numbers match what the business expects before and after cutover.
  • Build hands-on data engineering skills over time (for example Fabric dataflows, notebooks, and pipelines) with vendor support, taking on more Silver and Bronze layer work as interest and ability grow.
  • Help design and maintain Gold layer tables in Fabric that feed Profile's Power BI semantic models.
  • Serve as the primary internal point of contact for Profile's data engineering vendor, who owns the Silver and Bronze layers, translating business and reporting needs into clear requirements for new or updated data.
  • Review and test vendor-delivered data and pipeline changes, identifying data quality issues and gaps before they reach reports.
  • Coordinate the cutover of reporting from legacy SQL Server / Snowflake / Mozart sourcing onto Fabric: planning timing, validating results, and retiring legacy reports and data sources.
  • Write SQL against Fabric and SQL Server for analysis, data validation, and troubleshooting.
Business Process & 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.
  • Support new process initiatives by advising on adherence to Profile's data quality & governance standards.
  • Assist in defining data and reporting requirements for systems that are in use, under development, or planned for future development.
Documentation & Data Governance
  • Create and maintain clear documentation for semantic models, measures, reports, and data sources (definitions, parameters, aggregation logic) to reduce single-point-of-failure risk in Profile's BI reporting.
  • Help establish and enforce data governance and data quality standards, ensuring the accuracy, consistency, and security of data across the organization.
  • Ensure reporting solutions comply with internal data privacy and security policies.
  • Bachelor's degree in Data Analytics, Business Analytics, Information Systems, or a related field, or equivalent practical experience.
  • 3+ years of hands‑on experience designing and building Power BI dashboards and reports used by business stakeholders.
  • Experience building Power BI semantic models, with a solid understanding of dimensional modeling (star schema, fact and dimension tables, relationships).
  • Strong DAX skills with the ability to build, validate, and troubleshoot reusable business measures.
  • Hands‑on experience with Microsoft Fabric (Lakehouses, Warehouses, Direct Lake semantic models, Dataflows Gen2), or a comparable platform with the ability to ramp quickly on Fabric.
  • Intermediate to advanced SQL skills, with the ability to write and troubleshoot queries for performance and data validation.
  • Experience publishing and managing content in the Power BI Service (workspaces, apps, scheduled refresh, gateways, and row-level security).
  • A strong eye for data visualization design and the ability to turn business questions into clear, usable reports.
  • Strong analytical and problem‑solving skills, with the ability to troubleshoot data issues independently.
  • Demonstrated ability to document work clearly.
  • Clear communicator who is comfortable working directly with business users and outside vendors.
  • Comfortable taking ownership of work in a growing, fast‑moving environment where priorities can shift and not every project is fully scoped up front.
  • Consistently adhere to all Food Safety, GMP, Personal Safety, and Company Policy standards.
Move to the top if you have (Preferred Qualifications):
  • Microsoft Power BI, Fabric or other relevant certification.
  • Experience with platforms such as SQL Server, Snowflake, Mozart Data, Tableau Cloud, Sage 100, Salesforce, or Claris FileMaker.
  • Experience working with manufacturing, ERP, or operations data.
  • Experience designing or maintaining Gold‑layer (reporting‑ready) tables in a medallion architecture. Silver and Bronze layer engineering experience is not required.
  • Experience with Tableau, especially migrating reports from Tableau or another BI tool to Power BI.
  • Familiarity with ETL/ELT concepts and an interest in growing data engineering skills.
  • Exposure to Python for data analysis or automation.
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 BBQs, Celebrations!
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Business Intelligence Analyst
Senior Business Intelligence Analyst

ServiceLink • Plano (TX)

Hybrid
USD 95,000 - 125,000
Flexible hybrid work
BI Analyst: Build Next-Gen Analytics Platform
BI Analyst: Build Next-Gen Analytics Platform

Nesnah Ventures, LLC • Town of Hamilton (WI)

On-site
USD 80,000 - 105,000
Health insurance
Dental insurance
Life insurance
+7
Senior Business Intelligence Developer – Power BI, Data Modeling & Analytics Architecture 3654429
Senior Business Intelligence Developer – Power BI, Data Modeling & Analytics Architecture 3654429

Axiom Path • Charlotte (NC)

On-site
USD 110,000 - 170,000
Senior Data Analyst - Finance
Senior Data Analyst - Finance

HQ Business Support-GROUP • Minneapolis (MN)

On-site
USD 96,000 - 145,000
Medical and prescription drug plans
Dental plan
401k retirement plan with companymatch
+6
BI Developer
BI Developer

Premier Nutrition • Emeryville (CA)

Hybrid
USD 120,000 - 140,000
Senior Power BI Developer - US
Senior Power BI Developer - US

FormativGroup • United States

Remote
USD 120,000 - 160,000
Business Intelligence Analyst
Business Intelligence Analyst

Nesnah Ventures, LLC • Town of Hamilton (WI)

On-site
USD 80,000 - 105,000
Health insurance
Dental insurance
Life insurance
+7
Senior Full-Stack BI Architect / Fabric Data Engineer
Senior Full-Stack BI Architect / Fabric Data Engineer

Proactive Technology Management • Ferndale (MI)

Remote
USD 140,000 - 180,000
Health insurance
401(k) retirement plan with company
Flexible remote work
Senior Full-Stack BI Architect / Fabric Data Engineer
Senior Full-Stack BI Architect / Fabric Data Engineer

Proactive • Ferndale (MI)

Remote
USD 140,000 - 190,000
Comprehensive health, dental, and/or視s
401(k) retirement plan with company‑s
Business Analyst
Business Analyst

Sotalent • California

On-site
USD 90,000 - 130,000