Data Engineer
Company: Norstella
Location: Remote, Gurugram, India
Date Posted: Mar 6, 2025
Employment Type: Full Time
Job ID: R-396
About Norstella
At Norstella, our mission is simple: to help our clients bring life-saving therapies to market quicker—and help patients in need. Founded in 2022, but with history going back to 1939, Norstella unites best-in-class brands to help clients navigate the complexities at each step of the drug development life cycle and get the right treatments to the right patients at the right time.
Each organization under Norstella delivers essential solutions for strategic and commercial decision-making:
- Citeline – Accelerates the drug development cycle.
- Evaluate – Brings the right drugs to market.
- MMIT – Identifies barriers to patient access.
- Panalgo – Turns data into insights faster.
- The Dedham Group – Provides strategic insights for specialty therapeutics.
By combining expertise, cutting-edge data solutions, and advanced technologies such as real-world data, machine learning, and predictive analytics, Norstella operates globally in the USA, UK, The Netherlands, Japan, China, and India.
Job Description
Norstella is seeking an experienced Data Engineer with a background in Data Warehouse & Technology to manage and integrate business applications into the data warehouse. The Data Engineer will be responsible for designing, implementing, deploying, and supporting various data management technologies and architectures.
You will play a crucial role in collecting and ingesting data, developing data models and data engines, automating data pipelines, and ensuring they are production-ready. Additionally, you will integrate applications, accelerate data delivery, and improve enterprise data quality.
Key Duties and Responsibilities
- Analyze data sources and prepare data ingestion pipelines.
- Stage, assess, and cleanse data.
- Design and implement ETL jobs and transformations for a data lake and data warehouse.
- Integrate data pipelines with the enterprise data warehouse following architecture principles.
- Monitor and optimize data loads for reporting and extraction.
- Administer the data warehouse (manage space, indexing, performance monitoring, database integrity).
- Monitor data retrieval trends to maintain high-quality control.
- Administer user access based on data governance policies.
- Participate in data workshops and collaborate with business and technology teams.
Key Requirements
- 4+ years of experience in cloud technology, especially AWS stack.
- Hands-on experience with AWS Glue and Apache Airflow.
- Strong development skills in Python, T-SQL, and C# (minimum 4 years).
- Expertise in data modeling for data warehouse concepts (fact tables, lookup tables, views, stored procedures, row-level security).
- 4+ years of experience working with Data Lakehouse (especially Snowflake).
- Strong analytical skills with the ability to learn quickly.
- Experience working in fast-paced projects with tight deadlines.
- Strong verbal and written communication skills.
- Excellent debugging, problem-solving, and testing skills.
- Good interpersonal skills with the ability to work independently and in a team.
- BS degree in Computer Science, Information Systems, or equivalent experience.
Preferred Experience
- Real-time data processing with Apache Kafka.
- Experience working with or supplying data to visualization tools (Qlik, Tableau, Power BI).
- Understanding of data integration patterns.
- Exposure to software development for analytic applications.
Our Guiding Principles for Success at Norstella
- Bold, Passionate, Mission-First – We prioritize our mission and our clients.
- Integrity, Truth, Reality – We value honesty, learning, and realistic goal-setting.
- Kindness, Empathy, Grace – We foster collaboration with positivity and open communication.
- Resilience, Mettle, Perseverance – We embrace challenges and recover from setbacks.
- Humility, Gratitude, Learning – We continuously learn and adapt to improve.
Benefits
- Health Insurance
- Provident Fund
- Reimbursement of Certification Expenses
- Gratuity
- 24x7 Health Desk
Norstella is an equal opportunities employer and does not discriminate based on gender, race, nationality, religion, disability, or age. We promote diversity and inclusion, ensuring a workplace where everyone can thrive.
If you feel passionate and excited about this role, we encourage you to apply regardless of self-doubt. We welcome all backgrounds and perspectives.
