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' homes. The Science 37 Operating System (OS) enables universal access to patients and providers, leading to faster enrollment, greater retention and a more representative patient population. To help us achieve our goal, we are seeking a Data Architect eager to make an impact within a mission-driven organization.


The Data Architect is responsible for helping drive the database elements surrounding our proprietary systems. This 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 SDLC.

DUTIES AND RESPONSIBILITIES

Duties include but are not limited to:

  1. Being part of a team that builds amazing software and improves the systems we already have
  2. Installing, configuring, monitoring and maintaining databases in the production, development, testing environments
  3. Defining database physical and logical structure, functional capabilities, security, back-up, and recovery specifications
  4. Defining and implementing database schemas and configurations working with our development teams
  5. Optimizing database performance by identifying and resolving application bottlenecks, tuning of DB queries, implementation of stored procedures, conducting performance tests, troubleshooting and integrating new elements
  6. Working with development team design and implement reporting capabilities
  7. Implementing solutions for database performance monitoring and tuning
  8. Recommending operational efficiencies; eliminating duplicate work efforts and remove unnecessary complexities; creating and implementing new procedures and workflows
  9. Processing database change requests, including the creation and modification of databases, tables, views, stored procedures, triggers, jobs, etc. in accordance with change control policies
  10. Utilizing 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 

  1. Bachelor's degree in Computer Science or equivalent, with more than 6+ years of Database Administration experience
  2. Strong architectural & database design skills
  3. Experience using SQL, NoSQL and Graph Databases
  4. Thrive in fast-paced, agile environments, and able to learn new areas quickly
  5. Experience with AWS required (other cloud providers are a plus)
  6. Deep knowledge on data architecture for microservices from identifying data types to selecting a database model, designing, implementing and operating in production
  7. Experience across different database platforms and tools such as MySQL, PostgreSQL, SQL Server, DynamoDB, MongoDB, AWS Neptune, Cassandra, Neo4j
  8. Experience designing and building data lake and data warehouse solutions
  9. Linux Server basic hands-on admin experience
  10. Experience with Cloud Computing management on the AWS platform
  11. Scripting experience with Python or Bash required
  12. Experience with Monitoring/Alert planning for data services
  13. Broad knowledge of common infrastructure technologies such as web servers, load balancers, etc.
  14. Expertise with highly available database technologies like clustering, replication, mirroring, etc.
  15. Excellent troubleshooting skills and ability to understand complex relationships between components of multi-tiered and distributed applications
  16. Extensive knowledge of administration, replication, backup and restore of relational databases
  17. Experience with MuleSoft Anypoint Platform and Dataweave a plus
  18. Solid understanding of load balancing and high volume, high availability environments
  19. Knowledge of SDLC and project management methodologies (JIRA experience is a plus)
  20. Able to analyze and review current functionality to determine potential areas of improvement and cost savings
  21. Ability to work independently with minimal guidance in a fast-paced environment
  22. Demonstrate excellent communication skills including the ability to effectively communicate with internal and external customers
  23.   Strong work ethic with good time management with the ability to work with diverse teams and lead meetings
  24. Ability to work with all levels of the organization 
  25. Understanding of conduct of clinical trials preferred
  26. Experience in clinical trials and/or life science industry preferred
  27. Understanding of regulatory framework for software delivery preferred
  28. Experience with operational efficiency improvement initiatives preferred
  29. Experience with CSV (Computer Systems Validation) preferred
  30. Experience with SAFe methodology preferred
  31. Experience with JIRA, Confluence, SpiraTest preferred

Capabilities

  1. Experience using both SQL, NoSQL and Graph Databases
  2. Experienced in automation and automation tools such as Jenkins, Puppet, Chef, etc.
  3. Amazon RDS
  4. Amazon Aurora
  5. Amazon Athena
  6. Amazon DocumentDB
  7. Amazon DynamoDB
  8. Amazon Neptune 
  9. Apache Cassandra
  10. Neo4j
  11. 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 is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law. 

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!

Apply for this Job

* Required

  
  
When autocomplete results are available use up and down arrows to review
+ Add Another Education