Senior Power BI Engineer: Cloud BI Modernization & Insights

Orioninnovation; United States; Hybrid; USD 120,000 - 170,000; Full time

Benefits offered by this job

Annual leave

Paid sick leave

Private health insurance

Work equipment

Training access

Sports facility membership

Bonuses potential

Job summary

Orioninnovation seeks a hands-on BI engineer to modernize a finance-focused analytics stack. You will assess ingestion, data warehouses, and Power BI reports, delivering fresher data, lower costs, and stronger self-service metrics.

You’ll optimize AWS Glue, Redshift, and PostgreSQL replication, and build a certified semantic model for executives. The role emphasizes knowledge transfer and ongoing reliability.

Qualifications

• At least seven years in data or BI engineering, including two or more end-to-end BI stack assessments or rebuilds.
• Extensive hands-on Redshift experience at scale, including modeling, workload management, query tuning, and cost optimization.
• Knowledge of PostgreSQL replication internals, including logical replication, WAL, replication slots, and production workload impacts.
• Production experience with AWS Glue and PySpark, plus at least one CDC approach such as AWS DMS, zero-ETL integration, or Debezium.
• Strong Power BI skills across semantic models, DAX, star schemas, refresh modes, row-level security, and large reporting environments.
• Strong SQL and Python; experience comparing data platforms and delivering measurable improvements to freshness, performance, cost, or reporting.
• Clear communication and documentation skills, including explaining trade-offs to technical and non-technical audiences; able to overlap with US Pacific Time.

Responsibilities

• Assess ingestion pipelines, warehouse structures, SQL queries, and existing reports to identify performance, reliability, and cost improvements.
• Compare approaches for warehousing, change data capture, transformation, and reporting; run proofs of concept and recommend solutions based on cost, performance, effort, and migration risk.
• Improve AWS Glue jobs and enable near-real-time replication from PostgreSQL to Amazon Redshift while limiting production impact.
• Tune Redshift schemas, models, distribution and sort keys, workload management, and queries; build data marts for key business areas.
• Rationalize reports and datasets, create a certified Power BI semantic model for shared business measures, and rebuild executive dashboards for flexible analysis.
• Add pipeline monitoring, alerts, and data quality checks; document the architecture and operating practices, and support team knowledge transfer.

Skills

Power BI

Redshift

AWS Glue

PostgreSQL replication

PySpark

SQL

Python

DAX

Data modeling

CDC approaches

Semantic models

Tools

Power BI

Redshift

PostgreSQL

AWS Glue

PySpark

Terraform

Job description

Orioninnovation seeks a hands-on BI engineer to modernize a finance-focused analytics stack. You will assess ingestion, data warehouses, and Power BI reports, delivering fresher data, lower costs, and stronger self-service metrics.

You’ll optimize AWS Glue, Redshift, and PostgreSQL replication, and build a certified semantic model for executives. The role emphasizes knowledge transfer and ongoing reliability.