
5001 - 10000 employees
Founded 1992
💼 Consulting
🏥 Healthcare
📦 Logistics
💰 Funding Round on 2015-01
Consulting • Healthcare • Logistics
Orion Innovation is a leading digital transformation firm that partners with clients to drive digital innovation. With over 30 years of experience, Orion offers services in cloud and infrastructure management, cybersecurity, data and analytics, and enterprise platform solutions. The company works across various sectors, including telecommunications, media, professional services, financial services, industrial products, medtech, healthcare, and education, helping clients improve operations and enhance customer experiences. Their mission is to inspire and accelerate digital transformation and innovation.
🔥 6 minutes ago
Where this job comes from
Posted on Orion Innovation's careers page, not through a job board
First seen by Remote Rocketship 6 minutes ago
Improve your chances of getting an interview by checking your resume score before you apply.

5001 - 10000 employees
Founded 1992
💼 Consulting
🏥 Healthcare
📦 Logistics
💰 Funding Round on 2015-01
Consulting • Healthcare • Logistics
Orion Innovation is a leading digital transformation firm that partners with clients to drive digital innovation. With over 30 years of experience, Orion offers services in cloud and infrastructure management, cybersecurity, data and analytics, and enterprise platform solutions. The company works across various sectors, including telecommunications, media, professional services, financial services, industrial products, medtech, healthcare, and education, helping clients improve operations and enhance customer experiences. Their mission is to inspire and accelerate digital transformation and innovation.
• 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, 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 and optimize the 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 region, product, channel, and time period • Implement monitoring, alerting, and data quality checks to improve pipeline reliability and data-freshness visibility • Document the architecture, data models, and operational procedures • Support knowledge transfer to the internal team
• 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 • 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
• Dynamic and supporting international teams • Regular assessments and performance reviews • 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
Apply Now