Business Intelligence Engineer

Balchem; Montvale (NJ); On-site; USD 95,000 - 135,000; Full time

Job summary

Balchem is seeking a Business Intelligence Engineer to design, develop, and support modern data and reporting solutions using Microsoft Fabric and Power BI, transforming data from multiple systems into trusted insights through governed semantic models, dashboards, reports, and analytics.

The role collaborates with business stakeholders and IT to deliver scalable analytics, enterprise reporting capabilities, and self-service solutions while maintaining governance, security, and compliance across

Qualifications

• Bachelor's degree in a related field with at least 3 years' experience.
• Advanced Power BI development, administration, and deployment experience.
• Strong SQL skills, data modeling, and performance tuning.
• Experience with Fabric and analytics platforms.

Responsibilities

• Design, develop, and maintain data solutions within Microsoft Fabric.
• Create enterprise dashboards, KPIs, and self-service analytics with Power BI.
• Develop scalable semantic models for enterprise reporting.
• Build and optimize SQL-based data transformations and reporting datasets.
• Manage data integration between enterprise apps and analytics platforms.
• Collaborate with stakeholders to translate requirements into solutions.

Skills

DAX

Power Query

SQL

Microsoft Fabric

Power BI

Communication

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field

Tools

Microsoft Fabric

Power BI

SQL

Job description

Balchem is an Equal Opportunity Employer and offers a competitive salary and benefits package.

POSITION SUMMARY

As a Business Intelligence Engineer at Balchem, you will 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. You will help transform data from a variety of business systems into trusted, actionable insights through governed semantic models, dashboards, reports, and analytics solutions.

The Business Intelligence Engineer will 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. This role contributes to the development of enterprise reporting capabilities, data integration processes, analytics platforms, and self-service reporting solutions.

The ideal candidate possesses strong technical skills, business acumen, and a passion for solving complex data and reporting challenges. This role requires the ability to work independently, manage multiple priorities, and collaborate effectively across business and IT teams.

ESSENTIAL FUNCTIONS

• 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

• 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.

Balchem is committed to a workplace culture that values and promotes diversity, inclusion, equal employment opportunities, and a work environment free of harassment and hostility.