Business Intelligence Architect (BI Architect)

Austin, Texas, United States | Full-time | COVID-19 remote


Business Intelligence Architect (BI Architect) 


About SubjectWell
SubjectWell is a venture-backed technology company on an unstoppable mission to disrupt the antiquated $100 billion-dollar clinical trial patient recruitment sector. Almost all clinical trials fall behind schedule, leaving patients unable to access the most promising treatments and pharmaceutical and biotech companies unable to quickly carry their innovations to market. SubjectWell was founded by two entrepreneurs on their third successful startup, to unlock the potential of a true marketplace for clinical trials. We leverage proven data science and performance marketing techniques to hit a hard reset to the massive patient recruitment challenge that sits at the critical nexus of speeding delivery of the best therapeutics to the world.

Here's your chance to really make a difference, both in your career and in the lives of millions.


About the position

This BI Architect position will work collaboratively with other stakeholders in the business to understand our data and reporting needs in order to design and implement a Data Warehouse architecture and model that will support the specific reporting requirements needed to analyze data trends.  The current systems are comprised of relational databases in a MySQL RDS instance in AWS that has a master/read-only replica pair which is used for reporting purposes.  Tableau is used to build reporting off the relational data in the read-only database for use by the business.  This role will need to evaluate the current setup and determine a plan to then build out the subsequent implementation of the Data Warehouse from the ground up using industry-leading technologies.  This will include looking at ways to improve how we store data in our relational schema, what data we to move to the Data Warehouse, how and where we ETL that data, how we store the data once ETL is done and how we design the Warehouse schema to fit our reporting requirements.  The BI Architect will also evaluate data storage trends and the best way to ETL the data from our production relational database to a data warehouse environment.



  • Define, design, and implement Business Intelligence (BI) and Data Warehouse (DW) strategies for operational, ad-hoc, and other BI related solutions.
  • Assist in the definition, documentation and development of mapping rules for movement of data from disparate data sources and into the various components and subject areas of the BI environment.
  • Create data models including robust data definitions, entity-relationship-attribute models, as well as relational and/or dimensional models.
  • Work closely with a DBA to transition logical models to physical implementation of data structures.
  • Design and architect enterprise BI systems from conceptual to physical implementation and operations
  • Work with the Development team to establish best patterns, practices, and standards as new technology arises.
  • Collaborate with other departments to define development and production infrastructure needs and best practices. 
  • Ability to move between high level architectural review/design and the “roll up the sleeves” level of providing architectural oversight for project delivery.
  • Develop comprehensive implementation plans along with delivering the output as defined in the project’s goals and objectives
  • Provide hands-on data modeling (relational and dimensional) for Data Warehouse and overall BI environment.
  • Provide best practices and guidance regarding use of ETL, data modeling (relational and dimensional), and reporting deliverables.
  • A good understanding of the design and development of complex business reports.
  • Design and build complex relational data structures.
  • Work with technical and business users to understand requirements then identify, and design multiple solution options as well as determine and recommend a right-sized approach.



  • Degree in Information Systems, Computer Science, or equivalent education and/or experience.
  • Minimum 5 years of experience in delivering Business Intelligence solutions.
  • Minimum 5 years of experience with Relational and Dimensional Modeling.
  • In-depth expertise of relational database design, logical data modeling, data warehousing, and relational database management systems preferably MySQL or similar
  • Familiarity with data security, storage solutions, database virtualization and replication.
  • Expert level SQL skills.
  • Strong understanding of reporting tools such as Tableau
  • Knowledge of Business Intelligence and Data Warehousing concepts and proven experience delivering both.
  • Expert knowledge of ETL concepts, development, and experience.
  • Ability to adapt to a fast-paced, ever-changing environment 
  • Ability to meet deadlines and attention to detail.
  • Austin, Texas based or willing to relocate.



  • Full Medical, Dental, and Vision Benefits
  • 401(k)
  • Company stock options
  • Paid time off
  • Paid holidays
  • Casual office