Senior Data Warehouse Engineeer

Senior Data Warehouse Engineeer

Tempe, Arizona
Posted 2 months ago

Make 2022 your best year yet and join a growing company that was named a 2021 Top Workplace by AZCentral! BioCare is a distributor of Specialty Pharmaceuticals that treat rare diseases, such as hemophilia, immune system deficiency and ALS. We are looking for a Senior Data Warehouse Engineer to join our growing IT team to design, build, and manage the BioCare Data Warehouse.   If you want to make a difference in people’s lives and support our ability to get the right medication into the right hands, at the right time, apply today to be part of the BioCare family!


Why you should apply:

  • Low cost and flexible medical, dental & vision plans
  • 17 days (136 hours) Paid Time Off accrued during your first year
  • Up to 40 hours Paid Sick Time accrued annually
  • 401k with 5% employer match
  • Company paid life and disability insurance
  • Competitive pay


Typical duties:

Data Transformation and Integration:

  • Extract data from identified databases, both on premises and cloud
  • Create data pipelines and transform data to a structure that is relevant to the problem by selecting appropriate techniques


Data Source Identification:

  • Support the understanding of the priority order of requirements and service level agreements
  • Help identify the most suitable source of data that is fit for the purpose
  • Perform initial data quality checks on extracted data


Data Modeling:

  • Analyze complex data elements, systems, data flows, dependencies, and relationships to contribute to conceptual, physical, and logical data models
  • Develop the Logical Data Models and Physical Data Models including data warehouse and data mart designs
  • Define relational tables, primary, foreign keys, and stored procedures to create a data model structure
  • Evaluate existing data models and physical databases for variances and discrepancies
  • Develop efficient data flows
  • Analyze data-related system integration challenges and propose appropriate solutions


Code Development and Testing:

  • Write code to develop the required solution and application features by determining the appropriate programming language and leveraging business, technical and data requirements
  • Create test cases to review and validate the proposed solution design
  • Create proofs of concept
  • Test the code using the appropriate testing approach
  • Contribute code documentation, maintain playbooks, and provide timely progress updates


What we are looking for:

  • 7+ years’ experience as a data warehouse engineer/architect designing and deploying data systems in a startup environment
  • Mastery of database and data warehouse methodologies and techniques from transactional databases to dimensional data modeling, to wide denormalized data marts
  • Deep understanding of SQL-based Big Data systems and experience with modern ETL tools
  • Experience with Microsoft Dynamics
  • Expertise in developing complex mappings using SSIS and Azure data factory to load the data from various sources into the Data Warehouse
  • Expertise in designing data warehouses using SQL Server/Azure Data Factory
  • Experience in Azure data warehouse and Synapse analytics
  • Fluency in different SQL techniques for data transformation and data analysis
  • Quality and improvement focus to ensure reliable, timely, and complete data
  • Experience developing data pipelines in Python
  • Familiarity with software engineering best practices as they apply to the data engineering domain


We are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, gender, marital status, national origin, ancestry, disability, genetic information, medical condition, military/veteran status, sexual orientation, gender identity, gender expression, or any other characteristic protected by law.

Job Features

Job Category


Apply Online

A valid email address is required.
A valid phone number is required.