Sr. Data Warehouse Architect


  • Location: Birmingham, AL
  • Type: Perm Placement
  • Job #33655

iMethods is seeking a Senior Enterprise Data Warehouse Architect for a full time opportunity with a health system in Birmingham, AL.  This position will require candidates either live in or relocate the Birmingham market.

The Senior Enterprise Data Warehouse Architect will lead the design of a high performing Enterprise Data Warehouse, utilizing a multi-platform, modern architecture approach. The architect will collaborate with the stakeholders and build solutions that support their reporting, analytics, and data exploration needs. This person will be responsible for contributing development efforts in building the EDW. This role will participate in process improvement initiatives and in setting the best practice standards around Data Architecture and Governance.

Roles and Responsibilities:

  • Provide expertise and guidance in the creation and refinement of agile technical stories for data architecture and development.
  • Work across the organization to architect data driven solutions that focus on fulfilling stakeholders needs
  • Lead the translation of business needs into feasible and acceptable data centric semantic layer designs
  • Document and present relationships between business entities
  • Lead discussions to prioritize and balance technical and business needs of the conceptual and logical data warehouse
  • Architect physical data models
  • Architect and document integration layer of the data warehouse
  • Architect and document dimensional presentation layer (de-normalized) of the data warehouse
  • Evaluate reusability of current solutions for additional analysis, while maintaining integrity and confidentiality of information in accordance with a minimum viable product
  • Lead discussions to document database standards and procedures for the definition of reference architecture
  • Mentor other data engineers on best practices in data warehouse design and implementation, including metadata management, data quality and master data management
  • Create data governance and monitoring models
  • Drive the execution of data architecture using industry best practices. Specifically – Provide technical and architectural guidance to teams across all platforms and infrastructures, including promoting adherence to design standards and methodologies.
  • Work with BI tools such as Tableau to offer self-serve solutions to the business

Experience and Skills:

  • College degree, specialized training or equivalent work experience is required
  • 7+ years of recent lead Data Warehouse Architecture experience to build and articulate conceptual, logical and physical dimensional data models and third normal form artifacts
  • 12+ years of experience in data, analytics, data migration, systems architecture Expert in using standard modeling tools
  • Must have an understanding of Extract Load and Transform (ETL) processes
  • Development skills with SQL Server databases/ TSQL in a high transaction volume environment.
  • Experience in delivering solutions using Agile (traditional and SAFe) and supporting tools like TFS, VSTS, or Jira is a plus
  • Proven expertise in designing well performing solutions with an ability to tune data warehouse objects for efficiency and accuracy
  • Experience with architecting solutions across platforms and using multiple data layers presented in a federated schematic layer
  • An understanding of Big Data technologies and modern data architectures preferred

Back to Featured Jobs