Position SummaryFisher's is seeking a skilled and driven Power BI Data Analyst (level l or ll depending on experience) to join our growing Analytics team. In this role, you will be responsible for designing, developing, and maintaining Power BI reports and dashboards that empower both internal business stakeholders and external clients to make data-driven decisions. You will work closely with clients, data engineers, business leaders, and IT teams to ensure data accuracy, accessibility, and actionable insights across every engagement. You'll be joining a well-established, high-performing Analytics Team that has already built a strong foundation. Bring your skills into an environment where great work is already happening and the best is still to come.
The ideal candidate has hands-on experience with the Microsoft data ecosystem, including Azure, Microsoft Fabric, and SQL Server, and brings a strong eye for data storytelling and visualization best practices.
Experience in PowerBI is required. This role will report directly into the Data & Analytics team whom reports directly to the President of Fisher's Technology.
Primary ResponsibilitiesPower BI Development - Design, build, and publish interactive Power BI reports, dashboards, and scorecards.
- Develop and maintain complex DAX measures, calculated columns, and KPIs.
- Implement row-level security (RLS) and manage Power BI workspace permissions.
- Optimize data models for performance, including star-schema design and aggregations.
- Manage report deployment pipelines (Dev, Test, Production) within Power BI Service.
Data Modelling & Engineering - Write efficient T-SQL queries, stored procedures, and views in SQL Server / Azure SQL.
- Build and maintain dataflows, semantic models, datasets, and data warehouses within Power BI and Microsoft Fabric.
- Connect to and integrate data from a wide variety of sources including SQL Server, Azure Synapse Analytics, Azure Data Lake, SharePoint, Excel, CSV files, REST APIs, cloud applications, and third-party business systems.
- Design and develop scalable semantic models by combining data from multiple source systems into a single, well-structured business model that supports enterprise reporting and self-service analytics.
- Develop ETL/ELT processes using Power Query, Fabric Dataflows, Data Pipelines, and other Microsoft technologies to cleanse, transform, and standardize data from disparate sources.
- Create and maintain relationships, hierarchies, calculated tables, and business logic to ensure accurate reporting across multiple data sources.
- Collaborate with data engineers and business stakeholders to define data warehouse schemas, dimensional models, and reporting standards.
- Optimize semantic models for performance, scalability, and maintainability through proper star-schema design, aggregations, and incremental refresh strategies.
Microsoft Fabric & Azure - Leverage Microsoft Fabric capabilities including Lakehouses, Warehouses, Data pipelines, and/or Notebooks.
- Assist Data Engineers in migrating legacy BI solutions to Fabric-native architecture where appropriate.
Client Engagement & Delivery - Partner with clients to understand their reporting needs, business objectives, and KPIs - translating these into effective Power BI solutions.
- Lead discovery workshops and requirements-gathering sessions with client stakeholders (internal & external).
- Design and prototype dashboard layouts and report wireframes for client review and sign-off prior to development.
- Develop and deliver client-facing Power BI reports and dashboards from initial build through to deployment and handover.
- Maintain ongoing client relationships, managing feedback, change requests, and iterative improvements post-launch.
- Provide training and documentation to empower clients in self-service analytics and day-to-day report use.
Stakeholder & Governance - Assist in gathering and translating business requirements into technical specifications and report designs.
- Conduct data quality validation and support business users in self-service analytics.
- Document data models, report logic, and data dictionaries to support governance standards.
- Present findings and dashboard walkthroughs to both technical and non-technical audiences.
RequirementsRequired Qualifications - 2-7+ years of experience in a BI, data analyst, or reporting analyst role. Show us what you've built!
- Intermediate-level proficiency in Power BI Desktop and Power BI Service.
- Strong command of DAX for measures, time intelligence, and advanced calculations.
- Solid SQL skills - T-SQL query writing, joins, CTEs, window functions, and performance tuning.
- Hands-on experience with Azure services (Azure SQL, Synapse Analytics, Data Factory, or Data Lake).
- Familiarity with Microsoft Fabric (Lakehouse, Warehouse, Pipelines, Notebooks, or Mirroring).
- Experience with Power Query (M language) for data transformation.
- Understanding of data modelling concepts: star schema, fact/dimension tables, cardinality.
- Experience working directly or indirectly with clients or end users to gather requirements, design solutions, and deliver Power BI reports and dashboards.
- Ability to work independently and manage multiple projects in a fast-paced technology environment.
Preferred Qualifications - Associate or Bachelor degree in Business, Computer Science, Information Technology, Business Technology, related field of study, or equivalent work experience.
- Microsoft Certified: Data Analyst Associate (PL-300).
- Knowledge of Azure DevOps or Git for version control of Power BI assets (PBIP format).
- Exposure to Python or PySpark for data transformation within Fabric Notebooks.
- Knowledge of CI/CD practices for BI report deployment.
- Experience with Paginated Reports (SSRS / Power BI Paginated).
- Background in financial, operational, or sales analytics is a plus.
Why Work for Us? - Top Workplace
- Career Advancement
- Employer Paid Life Insurance and Disability
- Paid Time Off, Paid Sick Time, Volunteer Time, Holidays, Bereavement, and Parental Leave
- Benefits Package including FSA, Medical, Dental, and Vision
- 401K with Employer Match
- Tuition Reimbursement
