Job SummaryThe Power BI & Analytics Engineer will be an integral member of the Software Development team and will be responsible for developing governed semantic models, dashboards, reports, and self-service analytics solutions. The individual will work with business owners to define KPIs, understand reporting requirements, validate results, and deliver clear and reliable business insights. The role will support the development, testing, deployment, performance tuning, maintenance, and ongoing operation of Power BI solutions using approved enterprise data sources, including Microsoft Fabric, Snowflake, SQL, data warehouses, and application systems. The Power BI & Analytics Engineer must also ensure that calculations, data models, security, refresh processes, and reporting outputs are accurate, documented, supportable, and aligned with certified enterprise data definitions.
ESSENTIAL FUNCTIONS:
Analytics Solution Design - Able to identify, analyze, and translate business reporting and analytics needs into secure, scalable, and maintainable Power BI solutions.
- Work with business owners and subject-matter experts to understand reporting needs, business processes, data requirements, and expected outcomes.
- Translate business requirements into dashboards, reports, governed semantic models, KPIs, and self-service analytics solutions.
- Design dimensional data models that support accurate calculations, reporting performance, usability, and future expansion.
- Define relationships, hierarchies, measures, calculated columns, and business logic within semantic models.
- Evaluate available enterprise data sources and determine the appropriate source for each analytics solution.
- Participate in peer design reviews and incorporate feedback from business and technical teams.
- Identify opportunities to reuse existing semantic models, certified data, business definitions, and reporting components.
Power BI Development - Able to develop, test, troubleshoot, and maintain Power BI solutions that provide accurate and actionable information.
- Develop Power BI dashboards, reports, semantic models, scorecards, and executive analytics.
- Develop and maintain DAX measures, calculated columns, Power Query transformations, hierarchies, filters, bookmarks, and drill-through experiences.
- Create reusable calculations, measures, parameters, and reporting components where appropriate.
- Connect Power BI solutions to approved SQL databases, data warehouses, Microsoft Fabric, Snowflake, APIs, application systems, and other enterprise data sources.
- Develop reports that support both detailed operational analysis and summarized executive-level reporting.
- Modify and enhance existing dashboards, reports, semantic models, and data connections as business needs change.
- Troubleshoot and resolve report, model, calculation, data, refresh, connectivity, and performance issues.
- Evaluate the use of embedded Power BI, custom visuals, and other specialized capabilities when appropriate for the business need.
Dashboard Design and Data Storytelling - Able to present complex business information in a clear, useful, and visually effective manner.
- Design dashboards and reports that clearly communicate performance, trends, exceptions, risks, and opportunities.
- Select visualizations that appropriately represent the underlying data and intended business message.
- Organize report layouts, navigation, filters, drill-through capabilities, and interactions to support usability.
- Apply consistent design standards, terminology, calculations, and formatting across analytics solutions.
- Balance the need for detailed information with the need for clear and concise reporting.
- Design reports for the intended audience, including operational users, business managers, and executives.
- Work with business users to confirm that reports provide the information needed to support decisions and daily operations.
Data Modeling and Transformation - Able to prepare, model, and organize data for reporting and analytical use.
- Develop dimensional models using appropriate fact tables, dimension tables, relationships, hierarchies, and levels of detail.
- Use Power Query to connect, cleanse, transform, combine, and prepare data for analytics.
- Develop DAX calculations that accurately represent approved KPIs, business rules, and reporting requirements.
- Evaluate model size, relationship design, data granularity, and calculation complexity to support performance and maintainability.
- Identify and address data-quality issues that may affect reports, calculations, or business decisions.
- Coordinate with data warehouse, application, and Data & Analytics resources when source-system or upstream data changes are needed.
- Reuse FALv3 definitions and certified enterprise data where available rather than recreating existing business logic or data sources.
Data Validation and Reconciliation - Ensures dashboards, semantic models, calculations, and reporting results accurately reflect approved data sources and business definitions.
- Develop and document test scenarios to validate data models, transformations, DAX measures, filters, security, and reporting results.
- Reconcile report results to approved source systems, enterprise data warehouses, and existing business records.
- Investigate and resolve differences between analytics results and source or operational systems.
- Validate calculations, KPIs, assumptions, filters, and expected results with business owners before deployment.
- Confirm that reports behave as expected under different filters, user roles, drill-through paths, and reporting scenarios.
- Retest analytics solutions following changes to data sources, calculations, models, business rules, or security.
- Clearly explain calculations, data sources, assumptions, and reconciliation results to business users.
Security and Access Management - Able to implement and maintain appropriate access and data-security controls for Power BI solutions.
- Configure and maintain row-level security and other Power BI access controls.
- Manage or support Power BI workspaces, applications, audiences, permissions, and content distribution.
- Validate that users can access the appropriate reports and data based on their assigned roles.
- Work with business owners and IT resources to define report access and data-security requirements.
- Protect sensitive or restricted information through approved security and governance practices.
- Review access and security configurations as reports, users, responsibilities, and business requirements change.
Deployment, Refresh, and Production Support - Able to deploy, monitor, maintain, and support Power BI solutions throughout their lifecycle.
- Configure and support gateways, data connections, credentials, scheduled refreshes, and related dependencies.
- Use deployment pipelines and approved release processes to move Power BI content between development, testing, and production environments.
- Monitor refresh activity, gateway availability, dataset performance, and production reporting issues.
- Troubleshoot failed or incomplete refreshes, connectivity problems, credential issues, and data-source changes.
- Coordinate testing and deployment activities with business owners, application teams, and Data & Analytics resources.
- Support existing dashboards, reports, and semantic models through maintenance, issue resolution, and ongoing enhancements.
- Communicate production issues, business impacts, workarounds, and resolution status to affected users.
Performance Monitoring and Optimization - Able to analyze and improve the performance, scalability, and reliability of Power BI solutions.
- Monitor dashboard, report, semantic model, query, gateway, and refresh performance.
- Review DAX measures, Power Query logic, relationships, visual interactions, and data volumes to identify performance issues.
- Optimize semantic models and reports to improve response times, refresh duration, and overall usability.
- Reduce unnecessary calculations, data duplication, model complexity, and report-level processing.
- Work with data warehouse and source-system teams when performance issues originate outside Power BI.
- Consider future data growth, user volume, refresh requirements, and reporting complexity when developing solutions.
- Document material performance limitations, dependencies, or recommended improvements.
Data Governance and Documentation - Able to develop analytics solutions that use approved data, established definitions, and supportable documentation.
- Use approved data warehouses, Microsoft Fabric, Snowflake, SQL, application sources, and certified enterprise datasets where applicable.
- Follow established standards for naming, workspace organization, semantic modeling, security, deployment, and documentation.
- Document data sources, transformations, relationships, measures, calculations, definitions, ownership, lineage, dependencies, refresh schedules, and support procedures.
- Maintain documentation as reports, models, calculations, and data sources change.
- Identify duplicate or conflicting reports, measures, KPIs, and business definitions and recommend a consistent approach.
- Support the certification, endorsement, and governance of reusable semantic models and analytics content.
- Work with Data & Analytics teams, application owners, and business users to resolve questions involving data ownership, definitions, quality, lineage, and availability.
Business Partnership and Requirements Gathering - Able to work directly with business users to develop analytics solutions that address practical operational and decision-making needs.
- Lead or participate in requirements-gathering discussions with business owners and subject-matter experts.
- Ask appropriate questions to clarify the business purpose, intended audience, required measures, level of detail, and expected use of an analytics solution.
- Define KPIs and reporting requirements in terms that can be understood and validated by both business and technical teams.
- Identify gaps, inconsistencies, and assumptions in reporting requirements before development begins.
- Present prototypes and interim results to business users and incorporate feedback throughout development.
- Explain technical limitations, data constraints, risks, and alternative approaches in clear business terms.
- Support user acceptance testing, deployment, adoption, and ongoing improvement of analytics solutions.
Provide Accurate Project Effort Estimates - Able to estimate, manage, and complete assigned analytics development and support activities.
- Develop reasonable effort estimates for assigned analysis, design, development, testing, documentation, deployment, and support activities.
- Identify data, access, technical, business, and resource dependencies that may affect delivery.
- Manage assigned work and meet agreed project milestones and delivery commitments.
- Communicate progress, issues, risks, scope changes, and dependencies in a timely manner.
- Coordinate work with business owners, Data & Analytics teams, application owners, and other technical resources.
- Follow approved project, development, testing, and change-management practices throughout the solution lifecycle.
Technology Evaluation and Continuous Improvement - Able to evaluate emerging analytics and development capabilities and identify practical uses within the organization.
- Maintain current knowledge of Power BI, Microsoft Fabric, Snowflake, Azure DevOps, APIs, embedded Power BI, custom visuals, and related analytics technologies.
- Evaluate new Power BI and analytics capabilities for practical use in reporting, semantic modeling, deployment, governance, and self-service analytics.
- Use AI-assisted or agentic development tools, where appropriate and approved, to support development, testing, documentation, troubleshooting, and productivity.</
