Data Warehouse Architect

Austin Permanent USD175,000 - USD195,000 Hybrid working
  • Multinational Health Care Company
  • Sponsorship Available

About Our Client

The company provides risk-free patient recruitment for clinical trials. They engage the 96% of Americans who have never participated in clinical trials and they only charge for those who randomize.

Job Description

The main responsibilities are:

  • 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.

MPI does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, veteran status, marital status, or based on an individual's status in any group or class protected by applicable federal, state or local law. MPI encourages applications from minorities, women, the disabled, protected veterans and all other qualified applicants.

The Successful Applicant

The main qualifications are:

  • 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

What's on Offer

  • Base Salary from $175k to $195k
  • Sponsorship Available
  • Health, Dental, Vision
  • 401k
  • PTO
  • 100% Remote Available
  • Stock Options
Alexis Moses
Quote job ref

Job summary

Information Technology
Sub Sector
IT Data Analysis
Healthcare / Pharmaceutical
Contract Type
Consultant name
Alexis Moses
Job Reference
Job Nature
Hybrid working