Produce core design artifacts: source-to-target mappings, analytical requirement documents, Bronze, Silver Gold-layer logical data models.
Technical build and data modeling
Hands on understanding of of Databricks tools, (PySpark, Spark SQL, Delta Lake, etc.)
Apply platform standards for Unity Catalog cataloging, table design and clustering, performance tuning, data quality controls, and CI/CD through Git.
Data Product data modeling
Offshore/Vendor Engagement
Day-to-day work of an offshore engineering pod in Hyderabad, India — backlog grooming, task assignment, design review, and code review.
Provide technical direction to systems integrator and consulting partners working on the same domains, and hold their deliverables to company standards.
Review vendor work products against statement-of-work scope and flag gaps early.
REQUIRED QUALIFICATIONS
6–10+ years in data engineering
Databricks experience
Strong data product and data modeling skills. Proven experience defining and delivering data products with business stakeholders, not just executing handed-down specifications.
Demonstrated hands-on Databricks experience: PySpark, Spark SQL, Delta Lake, and experience with medallion architecture (Bronze/Raw, Silver/Refined, Gold/Published) including what logic belongs in which layer and why.
Experience with Unity Catalog: catalogs and schemas, access control, and data classification.
Experience leading distributed and offshore teams, with demonstrated ability to get quality output from an India-based delivery pod.
Advanced SQL, Python, and a Git-based development workflow.
Excellent written and verbal communication; able work independently with business stakeholders
Self-directed. This team needs people who can take an ambiguous business ask and drive it to released data products
PREFERRED QUALIFICATIONS
Pharmaceutical or life sciences commercial data experience, and familiarity with industry data sources such as IQVIA, Symphony Health, Komodo, Flatiron, specialty pharmacy and distributor data, Veeva CRM, and marketing or digital engagement platforms.
Understanding of commercial analytics use cases: field force performance, customer, patient journey and line of therapy
Familiarity with data governance concepts: data ownership, stewardship, critical data elements, and data quality frameworks.
Experience in a regulated environment with audit, privacy, and access-control requirements
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.