Balchem logo
BalchemPosted 1 month ago

Business Intelligence Engineer

On-siteMontvale, New Jersey, United States

Full TimeLarge

Job Summary

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. Develop and optimize SQL-based data transformations, data structures, and reporting datasets while building data integration processes between enterprise applications and analytics platforms. Collaborate with business stakeholders to gather requirements and ensure reporting solutions align with company data governance, security, and compliance standards. Monitor and troubleshoot data refreshes, pipelines, and reporting solutions; manage Power BI workspaces, applications, security access, deployments, and usage monitoring. Maintain version control for all BI assets and create technical documentation. Participate in enterprise data architecture initiatives and stay current on Microsoft Fabric best practices.

Required Qualifications

  • Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field
  • 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
  • Ability to work independently while managing multiple priorities

Desired Qualifications

  • Experience with PySpark, Spark SQL, or related data engineering technologies

Hiring someone like this?

Get your role in front of qualified candidates on Sorce.

Get started

Apply to this job in one click with Sorce

Apply on Sorce