Business Intelligence Engineer

Balchem Corporation

Business Intelligence Engineer at Balchem delivering enterprise analytics solutions using Microsoft Fabric and Power BI. Collaborating with stakeholders to transform data into actionable insights.

Posted 7/21/2026full-timeMontvale • New Jersey • 🇺🇸 United StatesMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and developing data solutions using Microsoft Fabric and Power BI, with a strong focus on data integration, semantic modeling, and enterprise reporting. Proficient in SQL and analytics best practices to support data-driven decision-making across organizations.

Highest-signal resume keywords

Microsoft Power BI DevelopmentSQL Data TransformationsSemantic ModelingData Integration ProcessesMicrosoft Fabric Technologies

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLDAXPower QueryData ModelingData WarehousingETL/ELT ProcessesAnalytics Solution DevelopmentData PipelinesLakehousesNotebooks

Soft Skills

Strong Communication SkillsAnalytical AbilitiesProblem-Solving SkillsCollaboration

Tools & Technologies

Microsoft FabricPower BIPySparkSpark SQL

Industry Keywords

Data GovernanceSecurity PracticesCompliance StandardsEnterprise ReportingAnalytics Architecture

Tech Stack

Tools & technologies

ETLPySparkSparkSQL

About the role

Key responsibilities & impact

Play a key role in the company's enterprise analytics strategy by designing, developing, and supporting modern data and reporting solutions using Microsoft Fabric and Power BI.
Help transform data from a variety of business systems into trusted, actionable insights through governed semantic models, dashboards, reports, and analytics solutions.
Work closely with business stakeholders and technical teams to deliver scalable, secure, and maintainable analytics solutions that support data-driven decision making across the organization.
Contributes to the development of enterprise reporting capabilities, data integration processes, analytics platforms, and self-service reporting solutions.
Design, develop, and maintain data solutions within Microsoft Fabric, including Lakehouses, Warehouses, Data Pipelines, Notebooks, and Semantic Models.
Create and maintain enterprise reporting solutions, dashboards, KPIs, and self-service analytics capabilities using Power BI.
Design, publish, and maintain scalable semantic models to support enterprise reporting and analytics.
Develop and optimize SQL-based data transformations, data structures, and reporting datasets.
Build and support data integration processes between enterprise applications and analytics platforms.
Collaborate with business stakeholders to gather requirements and translate them into scalable reporting and analytics solutions.
Ensure reporting solutions align with company data governance, security, and compliance standards.
Monitor and troubleshoot data refreshes, data pipelines, semantic models, and reporting solutions.
Manage Power BI workspaces, applications, security access, deployments, and usage monitoring.
Participate in enterprise data architecture initiatives and contribute to analytics platform strategy.
Work with users and team members across multiple business functions to improve reporting capabilities and data accessibility.
Maintain and version control all BI and data engineering assets including Power BI reports, semantic models, SQL scripts, notebooks, and data pipelines using established source control processes and tools.
Create and maintain technical documentation, solution designs, and operational support procedures.
Stay current on Microsoft Fabric, Power BI, Data Engineering, and Analytics best practices and recommend improvements where appropriate.

Requirements

What you’ll need

Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field with at least 3 years' experience.
Strong communication skills with the ability to effectively engage both technical and non-technical stakeholders.
Advanced experience with Microsoft Power BI development, administration, semantic modeling, and deployment.
Strong SQL skills including complex queries, views, stored procedures, data transformations, and performance tuning.
Strong experience building semantic models, data models, and enterprise reporting solutions.
Strong DAX and Power Query skills.
Strong analytical, troubleshooting, and problem-solving abilities.
Experience with Microsoft Fabric and modern analytics platforms.
Experience with data integration, ETL/ELT processes, and analytics solution development.
Experience designing and supporting enterprise-scale reporting environments.
Experience with Fabric technologies including lakehouses, warehouses, data pipelines, notebooks, and semantic models.
Experience working with large datasets and multiple data sources.
Experience supporting enterprise reporting and analytics initiatives across multiple business functions.
Knowledge of data warehousing, dimensional modeling, and analytics architecture.
Knowledge of enterprise data governance, security, and compliance practices.
Experience with PySpark, Spark SQL, or related data engineering technologies is a plus.
Ability to work independently while managing multiple priorities.

Benefits

Comp & perks

Competitive salary and benefits package