Description

About us:

Why Norstella?Norstella unites market-leading companies that all have a shared goal of improving patient access. Each organization (Evaluate, MMIT, Panalgo, The Dedham Group) delivers must-have answers for critical strategic and commercial decision-making.

Together, we help our clients:

• Assess the market need and competitive landscape
• Know precisely which drugs to prioritize in their portfolios
• Find out where the launch difficulties will bebefore theyre difficulties
• Track and improve market access post-launch

By combining the efforts of each organization under Norstella, we can offer an even wider breadth of expertise, cutting-edge data solutions and expert advisory services alongside advanced technologies such as real-world data, machine learning and predictive analytics. At Norstella, we dont just deliver information and insights. We deliver answers you can act on.

Responsibilities:

• Create data engineering pipelines to load Norstella core entities and ontologies data into AWS OpenSearch
• Collaborate with our data engineering team to design, develop, and maintain data pipelines on AWS using services such as Amazon S3, Glue, Airflow and Snowflake
• Assist in the implementation and optimization of data workflows in Snowflake, including data loading, transformations, and querying.
• Work closely with cross-functional teams to understand data requirements and translate them into scalable solutions.
• Participate in troubleshooting and resolving data-related issues in a timely manner.
• Contribute to the documentation of data processes, best practices, and standard operating procedures.
• And other duties as assigned.

Qualifications:

• Currently pursuing a Bachelor's or Masters degree in Computer Science, Data Science, Data Engineering, or a related field.
• Solid understanding of programming fundamentals and data structures.
• Familiarity with cloud computing concepts, particularly AWS services.
• Basic knowledge of SQL and database management systems.
• Excellent problem-solving skills and attention to detail.
• Strong communication and teamwork abilities.

Preferred Qualifications:

• Experience with Python, Apache Airflow a plus
• Experience with AWS OpenSearch or Elastic search a plus
• Previous coursework or projects involving data engineering, ETL processes, or cloud technologies.
• Exposure to Snowflake or other data warehouse platforms

Location: US East Coast Preferred

What an internship at Norstella can offer you

A successful internship typically involves a combination of personal growth, skill development, and meaningful contributions to the organization. Here's what to expect during your time at Norstella:

Learning Opportunities: You will be provided with ample opportunities for learning and skill development. Youll gain new knowledge about your field of study or interest through hands-on experience, mentorship, training sessions, and exposure to real-world projects.

Meaningful Projects: You can expect challenging tasks and projects that are relevant to your skills and interests, allowing you to make meaningful contributions to the organization. These projects will range dependent upon department and experience.

Mentorship and Guidance: As a Norstella intern, you will be assigned a buddy, outside of your department, who will help navigate challenges, set goals, and develop professionally.

Networking Opportunities: Networking can lead to future job opportunities and valuable professional relationships. During your time with Norstella, you will participate in a 3-day professional learning onsite conference to connect with fellow interns and other professionals within the Norstella organization.

Growth Through Feedback and Evaluation: Regular feedback sessions are essential to understand strengths, areas for improvement, and progress toward your goals. Frequent and meaningful feedback will help develop your skills, ensuring you make the most of your internship experience.

Overall, a successful internship at Norstella is one where you will have the opportunity to gain valuable skills and experiences, contributes meaningfully to the organization, and leaves with a positive impression of both the company and the field in which you are interning.

The Guiding Principles for success at Norstella:

01: Bold, Passionate, Mission-First

We have a lofty mission to Smooth Access to Life Saving Therapies and we will get there by being bold and passionate about the mission and our clients. Our clients and the mission in what we are trying to accomplish must be in the forefront of our minds in everything we do.

02: Integrity, Truth, Reality

We make promises that we can keep, and goals that push us to new heights. Our integrity offers us the opportunity to learn and improve by being honest about what works and what doesnt. By being true to the data and producing realistic metrics, we are able to create plans and resources to achieve our goals.

03: Kindness, Empathy, Grace

We will empathize with everyone's situation, provide positive and constructive feedback with kindness, and accept opportunities for improvement with grace and gratitude. We use this principle across the organization to collaborate and build lines of open communication.

04: Resilience, Mettle, Perseverance

We will persevere even in difficult and challenging situations. Our ability to recover from missteps and failures in a positive way will help us to be successful in our mission.

05: Humility, Gratitude, Learning

We will be true learners by showing humility and gratitude in our work. We recognize that the smartest person in the room is the one who is always listening, learning, and willing to shift their thinking.

Norstella is an equal opportunities employer and does not discriminate on the grounds of gender, sexual orientation, marital or civil partner status, pregnancy or maternity, gender reassignment, race, color, nationality, ethnic or national origin, religion or belief, disability or age. Our ethos is to respect and value peoples differences, to help everyone achieve more at work as well as in their personal lives so that they feel proud of the part they play in our success. We believe that all decisions about people at work should be based on the individuals abilities, skills, performance and behavior and our business requirements. Norstella operates a zero-tolerance policy to any form of discrimination, abuse or harassment.

Sometimes the best opportunities are hidden by self-doubt. We disqualify ourselves before we have the opportunity to be considered. Regardless of where you came from, how you identify, or the path that led you here - you are welcome. If you read this job description and feel passion and excitement, we're just as excited about you.