The BI Systems Developer is responsible for building and maintaining Power BI dashboards, integrating Encompass reports via Snowflake, and developing clean, efficient data models to support business intelligence operations. This role requires strong skills in Power BI, DAX, SQL, and data modeling, along with experience in Encompass reporting (preferred). The ideal candidate is highly organized, technically proficient, and able to collaborate closely with analysts and stakeholders to deliver scalable, high-performance reporting solutions.
Essential Job Functions:
- Develop and maintain Power BI dashboards with professional-grade visuals, navigation, and performance optimization.
- Apply best practices in DAX, Power Query (M), bookmarks, themes, and layout consistency.
- Manage Power BI Service assets, including workspaces, dataset refreshes, and user permissions.
- Integrate and manage Encompass reports through Snowflake pipelines, including data mapping, scheduling, and modeling.
- Build and maintain SQL views and semantic models to support reporting and data analysis.
- Collaborate with analysts to ensure data accuracy, usability, and visualization effectiveness.
- Enforce data modeling standards, naming conventions, and data lineage documentation.
- Optimize performance in both Snowflake and Power BI environments