Job details
Job type full-time
Full job description
This is a fully remote and work from home (wfh) opportunity within the us
Science 37 is accelerating the research and development of breakthrough biomedical treatments by bringing clinical trials to patients` homesBy leveraging the latest innovations in mobile technology, cloud services, telemedicine, and mass-engagement channels like facebook and google, we are breaking down traditional geographic barriers to patient trial participation while shortening the time needed to bring new treatments to the marketBacked by venture investors such as glynn capital, google ventures, redmile group, drx capital and lux capital, we are revolutionizing the clinical trial industry, one patient, at a timeTo help us achieve our goal, we are seeking a data architect eager to make an impact within a mission-driven organization.
Science 37 is accelerating the research and development of breakthrough biomedical treatments by bringing clinical trials to patients` homesBy leveraging the latest innovations in mobile technology, cloud services, telemedicine, and mass-engagement channels like facebook and google, we are breaking down traditional geographic barriers to patient trial participation while shortening the time needed to bring new treatments to the market.
As part of the science 37 tech team, you will collaborate with motivated, energetic, and entrepreneurial individuals working together to achieve science 37`s mission of changing the world of clinical research through patient-centered designYou will have a hands-on role with the architecture and development of nora® (network oriented research assistant), the technology that enables science 37`s groundbreaking metasite™ clinical research model and collaborates with product, data, clinical operations, and other relevant stakeholders to define study-specific nora requirements.
Duties and responsibilities
We are looking for a high energy data architect who will help drive the database elements surrounding our proprietary systemsThis position will report to the director, enterprise architecture and will work with our architects, software engineers, product managers, and devops to help design database solutions and architecture, assist the team with database problems and optimization and help drive the execution of our increasingly iterative sdlcDatabase architect is responsible for the following:
Being part of a team that builds amazing software and improves the systems we already have
Install, configure, monitor and maintain databases in the production, development, testing environments
Define database physical and logical structure, functional capabilities, security, back-up, and recovery specifications
Define and implement database schemas and configurations working with our development teams
Optimize database performance by identifying and resolving application bottlenecks, tuning of db queries, implementation of stored procedures, conducting performance tests, troubleshooting and integrating new elements
Working with development team design and implement reporting capabilities
Implement solutions for database performance monitoring and tuning
Recommend operational efficiencies, eliminate duplicate work efforts and remove unnecessary complexities; create and implement new procedures and workflows
Process database change requests, including the creation and modification of databases, tables, views, stored procedures, triggers, jobs, etcIn accordance with change control policies
Utilize an understanding of agile management to help the team with all release and configuration related tasks around software builds into preproduction and production environments.
Qualifications & skills
Qualifications
Bachelor`s degree in computer science or equivalent, with more than 6+ years of database administration experience
Strong architectural & database design skills
Experience using sql, nosql and graph databases
Thrive in fast-paced, agile environments, and able to learn new areas quickly
Must have experience with aws (other cloud providers are a plus)
Deep knowledge on data architecture for microservices from identifying data types to selecting a database model, designing, implementing and operating in production.
Experience across different database platforms and tools such as mysql, postgresql, sql server, dynamodb, mongodb, aws neptune, cassandra, neo4j
Experience designing and building data lake and data warehouse solutions
Linux server basic hands-on admin experience.
Experience with cloud computing management on the aws platform
Scripting experience with python or bash required.
Experience with monitoring/alert planning for data services.
Broad knowledge of common infrastructure technologies such as web servers, load balancers, etc.
Expertise with highly available database technologies like clustering, replication, mirroring, etc.
Excellent troubleshooting skills and ability to understand complex relationships between components of multi-tiered and distributed applications.
Extensive knowledge of administration, replication, backup and restore of relational databases
Experience with mulesoft anypoint platform and dataweave a plus.
Solid understanding of load balancing and high volume, high availability environments
Knowledge of sdlc and project management methodologies (jira experience is a plus)
Able to analyze and review current functionality to determine potential areas of improvement and cost savings
Ability to work independently with minimal guidance in a fast-paced environment
Demonstrate excellent communication skills including the ability to effectively communicate with internal and external customers
Strong work ethic with good time management with the ability to work with diverse teams and lead meetings
Ability to work with all levels of the organization
Preferred qualifications
Understanding of conduct of clinical trials
Experience in clinical trials and/or life science industry
Understanding of regulatory framework for software delivery
Experience with operational efficiency improvement initiatives
Experience with csv (computer systems validation)
Experience with safe methodology
Experience with jira, confluence, spiratest is a plus
Competencies
Experience using both sql, nosql and graph databases
Experienced in automation and automation tools such as jenkins, puppet, chef, etc.
Amazon rds
Amazon aurora
Amazon athena
Amazon documentdb
Amazon dynamodb
Amazon neptune
Apache cassandra
Neo4j
Snowflake
Reporting
The incumbent is required to work under the guidance and direction of the director, enterprise architecture with little to minimal supervision.
Science 37 values the well-being of its employees and aims to provide team members with everything they need to succeed.
Submit your resume to apply!
Job type: full-time
Work location: multiple locations