Power BI Developer and Analyst

Armor Animal Health•Beaver Dam, WI

3d•$1 - $1•Onsite

About The Position

Creates, maintains, and manages interactive data visualizations, reports, and dashboards using Microsoft Power BI. They are responsible for data modeling, writing DAX queries, importing data, and optimizing dashboards for performance to support data-driven decision-making. This role typically involves ETL processes and SQL proficiency. This role owns the full lifecycle of business intelligence delivery, from data extraction and modeling to DAX development and executive-facing reporting. The position combines technical BI development with financial and operational analysis to support data-driven decision-making across sales and leadership teams.

Requirements

Generally 5+ years of experience in business intelligence or data analysis.
Spotfire
Strong SQL knowledge
Proficiency in Power BI Desktop and Power Query
Familiarity with data warehousing concepts.
Ability to analyze large datasets and translate them into actionable business insights.
Familiarity with Fabric, DAX Studio, Tabular Editor, or other SQL tools and performance optimization tools.

Responsibilities

Extracting, cleaning, and transforming raw data from various sources (SQL, Excel, APIs) using Power Query.
Building and maintaining scalable data models, including complex relationships, hierarchies, calculated columns, and advanced DAX measures (e.g., tiered rebates, cumulative calculations, dynamic KPIs).
Build initial report layouts and dashboards, ensuring visual elements like charts and filters are correctly formatted.
Monitor data refresh schedules, troubleshoot simple credential issues, and update existing reports as needed.
Maintain technical records of data sources, transformation steps, report logic, modeling structure, and report definitions.
Improving dashboard efficiency and model performance through proper context management, optimized DAX, and structured data modeling practices.
Meet with business users to translate their abstract needs into specific technical reporting requirements.
Analyze reports to identify trends, patterns, and outliers that can drive business strategy.
Use data to "tell a story" through dashboards that communicate Key Performance Indicators (KPIs) to non-technical stakeholders.
Ensure report accuracy by validating data against the original systems of record and resolving discrepancies.
Perform quick, high-priority data mining using SQL or Excel to answer urgent business questions.