Armor Animal Health - Power BI Developer and Analyst

Data Analyst is needed in Beaver Dam, United States.

Client: Armor Animal Health

Location: Beaver Dam, WI

Contract: undefined

Job Description

Creates, maintains, and manages interactive data visualizations, reports, and dashboards using Microsoft Power BI. Responsible for data modeling, writing DAX queries, importing data, and optimizing dashboards for performance to support data-driven decision-making. This role involves ETL processes and SQL proficiency, owning 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

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

Key Responsibilities and Duties

Power BI Developer

• Data Preparation: Extracting, cleaning, and transforming raw data from various sources (SQL, Excel, APIs) using Power Query.
• Data Modeling: Building and maintaining scalable data models, including complex relationships, hierarchies, calculated columns, and advanced DAX measures (e.g., tiered rebates, cumulative calculations, dynamic KPIs).
• Report Creation: Build initial report layouts and dashboards, ensuring visual elements like charts and filters are correctly formatted.
• Maintenance & Support: Monitor data refresh schedules, troubleshoot simple credential issues, and update existing reports as needed.
• Documentation: Maintain technical records of data sources, transformation steps, report logic, modeling structure, and report definitions.
• Performance Optimization: Improving dashboard efficiency and model performance through proper context management, optimized DAX, and structured data modeling practices.

Power BI Analyst

• Requirements Gathering: Meet with business users to translate their abstract needs into specific technical reporting requirements.
• Data Interpretation: Analyze reports to identify trends, patterns, and outliers that can drive business strategy.
• Visual Storytelling: Use data to “tell a story” through dashboards that communicate Key Performance Indicators (KPIs) to non-technical stakeholders.
• Data Validation: Ensure report accuracy by validating data against the original systems of record and resolving discrepancies.
• Ad-hoc Analysis: Perform quick, high-priority data mining using SQL or Excel to answer urgent business questions.

Additional Information

This role typically requires collaboration with sales and leadership teams to support data-driven decision-making. The applicant should be skilled in both technical BI development and analytical roles to effectively bridge the gap between data presentation and strategic insight.