Business Intelligence Engineer

Job Responsibilities

• Assess, refactor, and enhance existing Power BI semantic models, including models built by third parties, to ensure clarity, performance, and long-term maintainability.
• Standardize business logic by migrating calculations and transformations from individual reports into reusable, governed semantic models.
• Publish and maintain certified datasets and shared measure sets to ensure leadership-approved metric definitions are implemented consistently across teams.
• Create core enterprise dashboards to improve usability, performance, and clarity.
• Design and maintain role-based reporting experiences (e.g., executive, operational).
• Optimize report performance through model optimization, DAX tuning, visual optimization, and reliable refresh configurations.
• Inventory existing reports and dashboards to identify redundancy, conflicting narratives, and opportunities for consolidation.
• Recommend and support dashboard consolidation or retirement plans.
• Establish lightweight standards for determining when a new dashboard is warranted versus enhancing existing reporting.
• Maintain KPI catalogs and metric documentation, including definitions, measure logic, assumptions, and usage guidance.
• Implement and follow structured release and change practices, including testing checklists, versioning, and impact documentation.
• Monitor data freshness, reliability, and refresh behavior; troubleshoot failures and address recurring root causes.
• Apply best practices for data validation, refresh scheduling, and maintaining source-of-truth consistency.
• Conduct structured discovery for core dashboards by gathering requirements, understanding decision use cases, and defining success criteria.
• Partner with business stakeholders to iterate on reporting solutions based on feedback and evolving needs.
• Collaborate with data and source system owners to resolve data quality and integration issues.
• Contribute to documentation and training materials; deliver enablement or usage training as needed.

Job Requirements

• Proven end-to-end delivery experience in Power BI, including semantic modeling, DAX measure development, and dashboard/report design.
• Strong expertise in: Semantic model design (relationships, star schema concepts, reusable measures), DAX development (measure patterns, performance tuning, calculation logic), Row-Level Security (RLS) and permissioning patterns, Power Query (M) and connecting to multiple data sources, Microsoft Fabric capabilities for data ingestion and curation.
• Strong SQL proficiency, including writing and troubleshooting queries (joins, aggregations, filters) and validating results.
• Experience standardizing, documenting, and governing KPI definitions and metrics.
• Experience maintaining certified/shared datasets, documentation, naming conventions, and change control practices.
• Ability to translate business questions into clear reporting requirements, success criteria, and realistic implementation plans.
• Strong communication skills with the ability to explain tradeoffs, assumptions, and definitions to technical and non-technical stakeholders.
• Strong attention to detail, planning, organization, and time management skills.
• Ability to moderate competing inputs, align stakeholders on priorities, and set clear expectations on scope and limitations.
• Willingness to assume new or additional responsibilities as needed.
• Ability to work autonomously and to collaborate fully as a team player.
• Ability to pay close attention to details, and present good planning, organization, and time management skills.
• Ability to maintain regular attendance as per work schedule agreed with the manager (may require working an adjusted work schedule based on project assigned and work overtime if warranted).
• Ability to comply with applicable laws and regulations and Company policies and procedures.