Senior Power BI Engineer

Orion Innovation is a premier, award-winning, global business and technology services firm. Orion delivers game-changing business transformation and product development rooted in digital strategy, experience design, and engineering, with a unique combination of agility, scale, and maturity. We work with a wide range of clients across many industries including financial services, professional services, telecommunications and media, consumer products, automotive, industrial automation, professional sports and entertainment, life sciences, ecommerce, and education.

Senior Power BI Engineer

About the Project

We are looking for an experienced Senior Data / BI Engineers to support a project focused on reviewing, optimizing, and modernizing an existing Business Intelligence (BI) stack. The current environment includes PostgreSQL, AWS Glue, Amazon Redshift, and Power BI. The goal is to improve data freshness, optimize performance and costs, and enable finance and executive teams to access reliable, consistent data through flexible, self-service reporting.

This is a hands-on engagement that combines technical assessment, solution evaluation, implementation, and knowledge transfer to the internal team.

Key Responsibilities

• Review the existing BI architecture, including data ingestion pipelines, warehouse structures, queries, and Power BI reports, identifying opportunities to improve performance, reliability, and cost efficiency. • Evaluate the current technology stack and assess alternative solutions for data warehousing, ingestion, change data capture (CDC), transformation, and BI reporting. • Conduct hands-on proofs of concept to compare shortlisted solutions and provide recommendations based on cost, performance, implementation effort, and migration risk. • Optimize AWS Glue jobs and implement near-real-time data replication from PostgreSQL to Amazon Redshift while minimizing the impact on production systems. • Review and optimize Redshift schemas, data models, distribution and sort keys, workload management, and query performance. • Develop and optimize data marts for core business areas. • Review the existing Power BI reporting environment, identifying dashboards and datasets to retain, consolidate, or retire. • Build a certified Power BI semantic model with consistent definitions for core business metrics, including revenue, subscribers, and cost. • Rebuild executive dashboards using the certified model, enabling business stakeholders to explore data across dimensions such as region, product, channel, and time period. • Implement monitoring, alerting, and data quality checks to improve pipeline reliability and visibility into data freshness. • Document the architecture, data models, and operational procedures, and support knowledge transfer to the internal team.