Are you ready to make a difference in the world of healthcare data and insights delivery? Then you've come to the right place. Sermo is moving medicine forward, one conversation at a time. Our mission is to revolutionize real-world medicine by connecting doctors online to the support, wisdom and insights of their peers globally.
Our team is:
Passionate: whether a technologist, qual buff, savvy marketeer, biz dev guru, or quant geek, we are all motivated by our passion to improve access to global healthcare data and insights each and every day.
Diverse: with 350 employees in 9 countries, we bring together talent from across the globe to meet the needs of our network of 1.3M medical professionals and serve clients in 80+ countries.
Innovative: our tech and customer-first approach to the conventional worlds of physician engagement and market research enables us to actually make a difference - and have fun while we're at it.
Knowing your hard work is helping physicians across the world unite to improve patient outcomesand even save lives is an incredible feeling. Interested?
We are looking for a very qualified and skilled database administrator to join our team in NYC or you can work remotely anywhere in the US or Denmark. You will be responsible for extending and maintaining our enterprise data warehouse and own the core data pipeline and the systems it integrated with. We expect you to be a very SQL tech-savvy professional, who is curious about new digital technologies and aspires to combine huge amounts of data with automated systems to maintain and keep things efficient. The role comes with a lot of flexibility in terms of technologies that you will be using daily, and you will have a lot of say in terms of how those technologies should be used.
You will be working with a team of very skilled professionals that has a high drive and strives for better and faster, and we will expect the same from you. You will be focusing on helping getting data into our warehouse for ease of extracting and querying from mainly our Marketing department. Data transformation and aggregation is key to keep our systems fast and responsive.
Senior Database Administrator Tasks:
Be the owner of the core data pipeline and be excited about ETL
Design, develop, deploy, test, and maintain data processing solutions to support analysts
Maintain and develop the data model based on business- and engineering needs
Integrate external data sources into the data warehouse
Optimize existing processes and integrations to allow faster throughout
Support requested ad-hoc data queries, analysis, and reports
Building automated error checking to monitor and facilitate data synchronization
Help and be part of analyzing feedback to allow us to continuously improve our offerings
Assist in creating functional requirements documentation and guides
Participate in meetings (internal as well as external) and standups
Be part of the decision process in terms of technologies and processes
Work with our highly skilled and dedicated backend developers to further integrate our internal systems with our data warehouse
Participate in pager duty and call rotation to ensure system stability
7+ years of experience with data warehousing and the integration of multiple data sources
Experience in developing tools for monitoring, reporting, analysis, and data transformations
You must be able to provide examples of a software and scripts that you have been part of building in the past
Extensive hands-on experience with relational databases and SQL
Must have experience with both PostgreSQL and MS SQL
Experience with NoSQL databases
Must have experience with Redshift
Experience using Git for maintaining code and scripts
Bonus Skills and Experience:
Experience using Solr
Experience with Etlworks a great plus
Advanced experience (performance tuning, etc.) with PostgreSQL a great plus
Experience with Asp.Net (Core)
Understanding and experience with the medical industry
Understanding and experience with GDPR compliance
An ability to perform well in a fast-paced environment
Experience working with high volume data platforms
What you'll get:
A competitive base salary
Competitive benefits; 401k match, health, dental, and vision insurance + health and wellness
The opportunity to revolutionize real world medicine and amplify the voice of physicians globally
Any questions, please email: email@example.com
Sermo is a global social platform for physicians that fosters impactful peer-to-peer collaboration & discussions through meaningful insights, data, and trends. It is the most trusted global platform for physicians with over 800,000 fully verified and licensed physicians across 150 countries. The platform enables doctors to anonymously talk real-world medicine, review treatment options via our proprietary Drug Ratings platform, collectively solve patient cases, and earn honorarium from surveys. Through Sermo's unique community, pharmaceutical and healthcare partners can drive physician awareness and gain deep understanding of brand perceptions to benefit the medical community at large. To learn more, visit www.sermo.com