RWD Delivery Architect

• The RWD Delivery Architect will be a core technical contributor to Norstella's Real-World Data platform, responsible for designing, building, and maintaining mission-critical data pipelines that power commercial, market access, and HEOR analytics for leading pharmaceutical and biotech clients.
• You will bring expert-level command of Apache Airflow and Python to a team that builds at the intersection of healthcare data complexity and enterprise-scale engineering - contributing directly to the reliability and innovation of Norstella's RWD delivery infrastructure.

• Expert-level experience designing, developing, scheduling, monitoring, and maintaining complex data pipelines and workflow orchestration solutions.
• Strong hands-on expertise building scalable and reusable DAGs, custom operators, sensors, hooks, and task dependencies.
• Extensive experience managing Airflow environments - including deployment, configuration, monitoring, troubleshooting, and performance optimization.
• Deep understanding of Airflow scheduling, task execution, retries, SLA management, logging, alerting, and workflow recovery mechanisms.

Python Development

• Expert-level proficiency developing robust, maintainable, and production-grade data engineering solutions.
• Strong experience with Python libraries and frameworks commonly used for data processing, API integration, file handling, and automation.
• Experience writing clean, modular, testable, and efficient Python code following coding standards and best practices.
• Strong knowledge of ETL/ELT pipeline development, orchestration, and automation using Airflow and Python.

Cloud & AWS

• Hands-on experience with cloud-based data ecosystems and core AWS services, including:
• Amazon S3 for cloud storage and data lake management
• Amazon Redshift for data warehousing, transformation, and analytics workloads
• Redshift Data Shares and cross-account data-sharing implementations
• SFTP integrations for secure file transfer and external data ingestion
• Experience integrating Airflow with AWS Lambda, Glue, CloudWatch, IAM, and Secrets Manager

Engineering Practices

• Strong understanding of pipeline monitoring, error handling, retry strategies, and production operational support.
• Experience with structured and semi-structured data formats: CSV, JSON, Parquet, and Avro.
• Ability to design scalable, reliable, and fault-tolerant data workflows supporting enterprise-level processing requirements.
• Strong understanding of CI/CD processes, version control (Git), and deployment automation for Airflow and Python applications.

Healthcare Domain Knowledge

• Strong domain knowledge in healthcare/medical claims data, including:
• Claims processing, adjudication, eligibility, and provider/member data
• ICD/CPT codes and healthcare reporting requirements
• Healthcare compliance and regulatory standards
• Claims reconciliation and healthcare analytics processes

Collaboration & Communication

• Experience collaborating with cross-functional teams including Data Engineers, Business Analysts, QA, Architects, DevOps, and business stakeholders.
• Ability to gather business requirements and translate them into technical workflow and data integration solutions.
• Excellent verbal and written communication skills with the ability to explain technical concepts to both technical and non-technical audiences.
• Strong analytical and problem-solving skills with the ability to troubleshoot complex workflow and data integration issues efficiently.
• Excellent attention to detail with a focus on data accuracy, consistency, and reliability across pipelines.
• Ability to work independently in fast-paced environments, manage multiple priorities, and deliver high-quality solutions within tight timelines.

Please Note - All candidates must be authorized to work in the United States. We do not provide visa sponsorship or transfers. We are not currently accepting candidates who are on an OPT visa.

The expected base salary for this position ranges from $100,000 to $150,000. It is not typical for offers to be made at or near the top of the range. Salary offers are based on a wide range of factors including relevant skills, training, experience, education, and, where applicable, licensure or certifications obtained. Market and organizational factors are also considered. In addition to base salary and a competitive benefits package, successful candidates are eligible to receive a discretionary bonus.

Norstella is a premier and critical global life sciences data and AI solutions provider dedicated to improving patient access to life-saving therapies. Norstella supports pharmaceutical and biotech companies across the full drug development lifecycle - from pipeline to patient. Our mission is simple: to help our clients bring therapies to market faster and more efficiently, ultimately impacting patient lives. Norstella unites market-leading brands - Citeline, Evaluate, MMIT, Panalgo, Skipta and The Dedham Group and delivers must-have answers and insights, leveraging AI, for critical strategic, clinical, and commercial decision-making. We help our clients: * Accelerate the drug development cycle * Assess competition and bring the right drugs to market * Make data driven commercial and financial decisions * Match and recruit patients for clinical trials * Identify and address barriers to therapies Norstella serves most pharmaceutical and biotech companies around the world, along with regulators like the FDA, and payers. By providing critical proprietary data supporting AI-driven workflows, Norstella helps clients make decisions faster and with greater confidence. Norstella's investments in AI are transforming how data is consumed and decisions are made, disrupting inefficient legacy workflows and helping the industry become more efficient, innovative, and responsive to patient needs.