BI Architect

Austin, Texas, United States Full-time

About SubjectWell

SubjectWell is a venture-backed startup 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 position is for a business intelligence architect who will design and build our real-time analytics platform.  Applicants must have extensive experience in architecting, implementing and operating OLAP cubes, ETL systems, and decision analysis frameworks.

Responsibilities and Duties
  • Work with business stakeholders and data analysts to understand their data needs
  • Collaborate with software engineer to design production data structures
  • Select and implement the appropriate BI technology stack
  • Design and build company data warehouse
  • Design and build ETL/ELT processes
  • Assist the Data Analyst with complex data visualizations and advanced data analysis
  • Ensure data quality, consistency and security

Qualifications and Skills
  • 10+ years of experience working in the BI field.
  • In-depth understanding and hands-on experience at every stage of the SDLC for building data analytics platforms.
  • Experience working with any of the major data warehousing platforms, such as Amazon Redshift, Google BigQuery, SQL Data Warehouse, Teradata, etc.
  • Experience with ETL tools such as SSIS, Talend, Pentaho, Amazon Glue or Google Dataflow.
  • Experience with data visualization tools such as Tableau, SAS or PowerBI.
  • Experience maintaining and administering all of the above.
  • Strong analytical background.
  • Advanced SQL skills.
  • Experience in building ETL/ELT processes.
  • Knowledge of industry best practices and standards.

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