BI Systems Developer

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

Experiential and skill requirements:

Required:

• 3+ years of Power BI development (Desktop & Service).
• Proficient in DAX, Power Query (M), and SQL.
• Strong understanding of data modeling and BI best practices.
• Organized, collaborative, and responsive to business needs.

Preferred:

• Experience with beverage distribution or Encompass sales systems.
• Experience with Snowflake and Encompass reporting
• Familiarity with BI tools (e.g., Git, ALM Toolkit, dbt, CI/CD pipelines).
• Comfortable in agile or fast-paced development environments.

Education & Experience Requirements:

• Bachelor’s degree in computer science, Information Systems, Data Analytics, or related field (or equivalent experience).
• Core competencies in Business Math and Personal Computers.

Physical / Sensory requirements:

• Prolonged periods of sitting and working on a computer
• Strong Visual acuity for screen-based data visualization work
• Clear communication skills for collaboration with technical and non-technical stakeholders
• Ability to utilize standard personal computer input/output devices.
• Ability to obtain and hold a Class C driver's license.

Competencies:

• Conceptual Thinking
• External (Strategic Awareness)
• Data Gathering and Analysis
• Strategic Thinking
• Entrepreneurship/Intrapreneurship