> Markdown version of [/jobs/ext/538728-power-bi-developer-and-analyst](https://www.wearedevelopers.com/jobs/ext/538728-power-bi-developer-and-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Power BI Developer and Analyst - **Company:** Armor Animal Health - **Location:** Beaver Dam, WI, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Adaptable Database Systems, Application Programming Interfaces (APIs), Data Analysis, Business Intelligence Development, Big Data, Data Validation, Data Cleansing, Extract Transform Load (ETL), Data Transformation, Data Mining, Data Warehousing, Database Queries, Performance Tuning, Power BI, SQL Databases, Visual Analytics, Powerquery, Spotfire - **Published:** June 4, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=1d63ef491269db9c ## About the Role Do you have experience in Visual storytelling?, * 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. ## Description 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., 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. ## Related Videos - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Dev Digest 162: AI careers, MCP, AWS best practices & floppy sweaters](https://www.wearedevelopers.com/magazine/571-dev-digest-162-ai-careers-mcp-aws-best-practices-floppy-sweaters) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany)