ApplySarthiSenior Power BI Engineer
Orion Innovation
Tailor my CV for this job, freeView job and applyYour CV rewritten for this role, from your real experience. Sign in with Google, nothing to install.
Got this interview? Our apps help you get the job.
Skills named in this job
Read from the description itself, not inferred.
This role on the market
756 open power roles across 95 companies are on ApplySarthi right now, most of them in Bengaluru (50), Chennai (20), Vadodara (5).
- Senior Power BI DeveloperJobgether
- Procurement & Submittals Mgr., AWS, Power and CoolingAmazon
- Data Analytics Lead - Power Platform & Copilot Solutions ArchitectGartner · delhi ncr
- Senior Engineer - Power SystemsWSP · bengaluru
- Sr. DRAM Power ArchitectMicron
What power roles keep asking for: Python (19%) — counted across their open postings here.
AWS jobs · Data modelling jobs · Data warehousing jobs · ETL jobs
Orion Innovation has 66 open roles listed here.
- 206669 - Support Engineer
- Bilingual IT Help Desk Customer Service Representative
- Soporte en sitio - Presencial (AICM)
- 206673 - JAVA BACK JR Developer
- Release Managerchennai
Counted across 14 company job boards, updated as roles open and close.
Preparing for this interview
Interviews for power roles keep coming back to Python. Practise those questions before you sit with Orion Innovation.
Questions you are likely to be asked
- Why do you want to join Orion Innovation?
- What is your experience with AWS? Tell me one thing you learned the hard way.
- How would you explain a surprising number to a manager who does not believe it?
- Tell me about an analysis that changed a decision. What did you find?
- How do you check that your numbers are right before you share them?
Prep Sarthi gives you a free mock interview: an AI interviewer asks you questions like these out loud, from your own CV and this job, and shows your score and your weakest answer.
Practise the Senior Power BI Engineer at Orion Innovation interview free →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.
Requirements
- 7+ years of experience in Data Engineering or BI Engineering, including at least two end-to-end BI stack reviews or rebuilds.
- Strong hands-on experience with Amazon Redshift at scale, including data modeling, distribution and sort keys, workload management, query optimization, and cost reduction.
- Solid understanding of PostgreSQL internals relevant to replication, including logical replication, WAL, replication slots, and the impact of replication on production workloads.
- Production experience with AWS Glue (PySpark) and at least one change data capture (CDC) approach, such as AWS DMS, zero-ETL integration, or Debezium.
- Strong Power BI experience, including semantic models, DAX, star schemas, refresh modes, row-level security, and managing large reporting environments.
- Experience working with multiple data warehouse and BI platforms, with the ability to evaluate alternatives and recommend the right solution based on business and technical requirements.
- Strong SQL and Python skills.
- Experience delivering measurable improvements in data freshness, query performance, infrastructure costs, or reporting capabilities.
- Strong communication and documentation skills, with the ability to explain technical trade-offs to both technical and non-technical stakeholders.
- Availability for an overlap with US Pacific Time.Nice to Have
- Experience with dbt or similar data transformation and testing frameworks.
- Experience with Terraform or equivalent infrastructure-as-code tools.
- Familiarity with data quality tools such as Great Expectations, Soda, or AWS Glue Data Quality.
- AWS Data Engineer – Associate, Microsoft PL-300, DP-600, or equivalent certifications.
- Experience in subscription-based businesses or consumer-device industries, particularly with subscriber and churn metrics.
What we offer:
- Dynamic and supporting international teams
- Regular assessments and performance reviews. You will have the opportunity for promotion, bonuses and a raise in accordance with the pace at which you develop and your performances.
- Remote, hybrid or office work
- Flexible day schedule
- 4 days sick leave (100% paid)
- 20-25 vacation days per year
- Equipment for work, laptop and all necessary additions
- Access to trainings and courses
- Private health insurance
- FIT Pass card for many sports’ facilities
Orion is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, citizenship status, disability status, genetic information, protected veteran status, or any other characteristic protected by law.
Candidate Privacy Policy
Orion Systems Integrators, LLC and its subsidiaries and its affiliates (collectively, “Orion,” “we” or “us”) are committed to protecting your privacy. This Candidate Privacy Policy (orioninc.com) (“Notice”) explains:
- What information we collect during our application and recruitment process and why we collect it;
- How we handle that information; and
- How to access and update that information.
Your use of Orion services is governed by any applicable terms in this notice and our general Privacy Policy.
Match this job to your CV
ApplySarthi scores your CV against this role, shows the skills you are missing, and writes a tailored version for the application.
Check my match →Similar open roles
- AI Tech Lead Orion Innovation · hyderabad
- GenAI Engineer/ Senior EngineerOrion Innovation · pune
- Senior Technical TPH EngineerOrion Innovation · pune
- Azure Data EngineerOrion Innovation
- Computer Systems Validation EngineerOrion Innovation
- Devops ArchitectOrion Innovation
- Director / Vice PresidentOrion Innovation
- Harness CI/CD ArchitectOrion Innovation
Need answers during your interview? Try Live Sarthi.
Live Sarthi, an Interview Sarthi app, shows answer suggestions during the call.
- Hidden from supported screen sharingThe overlay stays out of supported Windows screen captures.
- Answers start in about 1.5 secondsResponse time varies with your connection and model.
- From your own CVYour projects and your experience, not a generic script.
- 30 minutes freeThen ₹149 for a 2-day pass with unlimited calls — you pay for the days you are interviewing, not a subscription.
A Windows app, from the same team as ApplySarthi.
Listed on greenhouse · posted 2026-10-28. ApplySarthi collects openings and links to application pages; the role is advertised by Orion Innovation, not by us.