BI Architect (Digital Healthcare)

Company: Hirestarter Inc.
Location: Austin
Posted on: November 22, 2021

Job Description:

This is an Austin based role with a flexible work environment. It is not a remote role.HireStarter's client is a venture-backed technology startup with a mission to disrupt patient recruitment for clinical trials, a $100 billion dollar sector. They are looking to bring on board a BI Architect with experience building a data warehouse from scratch. 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.ATableau is used to build reporting off the relational data in the read-only database for use by the business.AThis 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.AAResponsibilitiesDefine, 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 operationsWork 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.AAbility to move between high level architectural review/design and the 'roll up the sleeves'A 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 objectivesProvide 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.ARequirementsDegree 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 similarFamiliarity with data security, storage solutions, database virtualization and replication.Expert level SQL skills.Strong understanding of reporting tools such as TableauExpert knowledge of ETL concepts, development, and experience.by Jobble

Keywords: Hirestarter Inc., Austin , BI Architect (Digital Healthcare), Healthcare , Austin, Texas