Business Intelligence Engineer

COMPANY OVERVIEW Balchem is committed to making the world a healthier place by delivering trusted innovative and science based solutions for the health and nutritional needs of the world Balchem employs approximately 1400 employees worldwide who provide the service quality and technology that enables our customers to win with their customers We have built a reputation for delivering results to all of our stakeholders Founded in 1967 Balchem a Maryland corporation became a publicly traded company in 1970 and is listed on Nasdaq under the symbol BCPC Our corporate headquarters is located in Montvale New Jersey and we have a broad network of sales offices manufacturing sites and R&D centers primarily located in the US and Europe The Company consists of three business segments Human Nutrition and Health Animal Nutrition and Health and Specialty Products POSITION SUMMARY As a Business Intelligence Engineer at Balchem you will play a key role in the companys 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 ModelsCreate and maintain enterprise reporting solutions dashboards KPIs and self service analytics capabilities using Power BIDesign publish and maintain scalable semantic models to support enterprise reporting and analyticsDevelop and optimize SQL based data transformations data structures and reporting datasetsBuild and support data integration processes between enterprise applications and analytics platformsCollaborate with business stakeholders to gather requirements and translate them into scalable reporting and analytics solutionsEnsure reporting solutions align with company data governance security and compliance standardsMonitor and troubleshoot data refreshes data pipelines semantic models and reporting solutionsManage Power BI workspaces applications security access deployments and usage monitoringParticipate in enterprise data architecture initiatives and contribute to analytics platform strategyWork with users and team members across multiple business functions to improve reporting capabilities and data accessibilityMaintain 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 toolsCreate and maintain technical documentation solution designs and operational support proceduresStay current on Microsoft Fabric Power BI Data Engineering and Analytics best practices and recommend improvements where appropriateREQUIREMENTS Bachelors degree in Computer Science Information Systems Data Analytics or a related field with at least 3 years experienceStrong communication skills with the ability to effectively engage both technical and non technical stakeholdersAdvanced experience with Microsoft Power BI development administration semantic modeling and deploymentStrong SQL skills including complex queries views stored procedures data transformations and performance tuningStrong experience building semantic models data models and enterprise reporting solutionsStrong DAX and Power Query skillsStrong analytical troubleshooting and problem solving abilitiesExperience with Microsoft Fabric and modern analytics platformsExperience with data integration ETLELT processes and analytics solution developmentExperience designing and supporting enterprise scale reporting environmentsExperience with Fabric technologies including lakehouses warehouses data pipelines notebooks and semantic modelsExperience working with large datasets and multiple data sourcesExperience supporting enterprise reporting and analytics initiatives across multiple business functionsKnowledge of data warehousing dimensional modeling and analytics architectureKnowledge of enterprise data governance security and compliance practicesExperience with PySpark Spark SQL or related data engineering technologies is a plusAbility to work independently while managing multiple prioritiesBalchem is committed to a workplace culture that values and promotes diversity inclusion equal employment opportunities and a work environment free of harassment and hostility