Business Intelligence Engineer

Percheron, LLC is seeking a Business Intelligence Engineer to enhance data-driven decision-making across the organization. This role involves designing, building, and maintaining enterprise reporting solutions using Power BI, while ensuring clarity and consistency in reporting metrics.

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
• Design, redesign, and maintain core enterprise dashboards to improve usability, performance, and clarity
• Create role-based reporting experiences (e.g., executive, operational) and avoid overly complex 'do-everything' dashboards
• 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
• Other duties as assigned

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
• Understanding of API integrations and data ingestion patterns
• 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