Role Data Engineer
Location India, Remote (Work from Anywhere in India)
Minimum Qualification B. Tech. (or equivalent) from an accredited institution
Indicative Experience 3+ Years
Domain Preferably Life-Sciences/Pharma.
Other benefits Health Insurance, Provident Fund, Reimbursement of Certification Expenses, Gratuity, 24x7 Health Desk
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 (Citeline, Evaluate, MMIT, Panalgo, The Dedham Group) delivers must-have answers for critical strategic and commercial decision-making. Together, via our market-leading brands, we help our clients:
· Citeline – accelerate the drug development cycle
· Evaluate – bring the right drugs to market
· MMIT – identify barrier to patient access
· Panalgo – turn data into insight faster
· The Dedham Group – think strategically for specialty therapeutics
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.
As one of the largest global pharma intelligence solution providers, Norstella has a footprint across the globe with teams of experts delivering world class solutions in the USA, UK, The Netherlands, Japan, China and India.
Have you wondered how life saving drugs and therapies are created, tested, marketed and made available to patients in need? Have you wondered how clinical trials are conducted at a global scale? How governments and health authorities regulate various organizations participating in this marketplace? Have you wondered how those companies and insurance providers price a certain drug, and how a care provider determines the right treatment for a given patient? If yes, Norstella could the next step in your career.
Reporting into Technology Manager, Senior Software Engg will work with internal and external developers responsible for the development and subsequent support of the various platform services components underpinning all the customer facing applications across Norstella. As part of a large technology group, the Senior Software Engg will work with product management, architecture and other software engineering teams in support of the product development roadmap.
We are looking for an experienced senior software engineer with great communication skills, deep experience in software engineering, and most importantly, the ability and willingness to keep learning in this ever-changing technology landscape.
Position Description
This full-time position will play a critical role supporting MMIT’s applications. Primary responsibilities will be to analyze, design, develop, implement and maintain technical solutions SSIS and T-SQL.
As a Data Engineer, you will:
▪ Design, code and test programs using the Microsoft SQL Server platform.
▪ Create business logic, reports, exports and other data related output.
▪ Learn continuously, manage your work independently and seek guidance from senior developers when needed.
▪ Use best practice coding standards in a fast-paced and agile environment.
▪ Works in a team environment that includes collaborating with Product Owners, Stakeholders,
and Software Developers.
Qualifications
▪ Bachelor’s degree or higher in technology field or related field preferred.
▪ 3-5 years of practical experience with SSIS, SQL, T-SWL
▪ Practical experience with Microsoft SQL Server platform, and Transact SQL stored procedures and triggers
▪ Experience with SSIS development and SSRS reports (preferred)
▪ Interest in working with complex data sets and analytic technologies such as Power BI
▪ Ability to create Functions/Views/Stored Procs.
▪ Experience with complex queries including use of CTEs, table variables, merge and dynamic SQL.
Experience with complex business logic including applying logic to transforms that falls outside of basic schema formatting conversion.
▪ Experience executing SSIS packages via SQL Server Job Agent
▪ Experience using all components available in SSIS including sorts, derived values, data conversion, multicast, merge, union, variables, parameters, package DB connections, project DB connections, flat file connections, excel connections and SMTP connections, expressions and file system tasks.
- Data processing on Azure services (Azure Data Lake, Azure Storage, Azure SQL, Azure DW)
- Working knowledge of Azure Synapse and/or Snowflake
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 doesn’t. 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, Perserverance
We will persevere – even in difficult and challenging situations. Our ability to recover from mis-steps 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.
