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.
ETL DEVELOPER
Data Warehouse and Data Mart Development
- Enhancing and optimizing clients cloud-based data warehouse for scalability and performance.
- Building and refining data marts to support business intelligence and analytics needs.
- Applying dimensional modeling best practices to improve data structure and accessibility.
- All data will stay onshore and will not be accessed by offshore resources
ETL and Data Integration
- Developing and managing ETL processes to integrate, claims, clinical, and quality data
- Performance Tuning and Compliance
- Optimizing queries and workflows to optimize build times
- Ensuring compliance with HIPAA, HITRUST, and internal data security policies.
Required Skills & Experience
The ideal resource(s) should have:
- 5+ years of experience in data warehouse development in healthcare
- Expertise with cloud data warehouse platforms (e.g., AWS Redshift (required) Snowflake, BigQuery, Azure Synapse,).
- Strong ETL development skills, including experience with dbt (required), Apache Airflow, or similar tools.
- Proficiency in SQL(required) and Python for data transformation.
- Experience integrating healthcare data sources (HL7, FHIR, ICD-10, CPT).
- Familiarity with BI tools such as Power BI, Tableau, or Looker.
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.
Top Skills
What We Do
Orion is a leading digital transformation and product development services firm. Headquartered in Edison, NJ, we have a global team of 6,200+ associates, with engineers in 14 major delivery centers across North America, Europe, Asia Pacific and Latin America.
For over 25 years, Orion has been solving complex business problems for our clients. Our transformative business solutions are rooted in digital strategy, experience design, and engineering, empowering our clients to operate with agility at scale.
Our mission is to serve as an agile and trusted partner for business transformation initiatives, providing deep emerging technology, experience design, and domain expertise.
Our business has more than tripled over the last three years.
We have grown aggressively both organically and inorganically, adding new clients, complementary skills, domain expertise, and strengthening our global footprint.
_0.png)
