Business Intelligence Engineer

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

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