Enterprise Data Warehouse Architect

Sorry, this particular job is closed. But feel free to fill out a General Application

Search Jobs

General Apply

  • As an Equal Employment Opportunity Employer, DAVIS has reporting requirements which require us to invite employees to voluntarily self-identify their race/ethnicity. Submission of this information is voluntary and refusal to provided it will not subject you to any adverse treatment. The information obtained will be kept confidential.
  • Accepted file types: pdf, doc, docx, txt, rtf.
  • By applying to this position and providing my contact information, I give The DAVIS Companies permission to provide me with email communications and information.

Enterprise Data Warehouse Architect

  • Specialty:

  • Title:

    Enterprise Data Warehouse Architect
    • City:

    • State:

    • Zip Code:

  • Start date:

  • Status:

  • Assignment Type:

  • Job Id:



Our clients Enterprise Data Warehouse will be implemented on Azure Data Services, sourcing data from on-premise as well as Cloud business applications. Informatica Cloud will be used as the Integrations platform.

This individual with his / her strong understanding of iPaaS, ETL / ELT and Azure DW / Lake concepts, should be able to contribute effectively towards evaluation, proof of concept, design and development of the Azure EDW solution. 

This position requires individual to be a self-starter with excellent communication skills and ability to multi-task on various initiatives.


  • Contribute to EDW solution architecture by participating in design review sessions and providing suggestions/ideas
  • Work with technical team members for Proof of Concept (PoC) of the EDW Use Cases 
  • Work with project stakeholders to understand the requirements and deliver design that best meets the business and technical need
  • Design and develop ETL/ELT solutions using data warehouse design best practices, specifically using Informatica Cloud and Azure Data Warehouse / Data Lake or Azure Synapse
  • Collaborate with business analysts and data architects during data modeling, data mapping and system specification activities
  • Create Data Integrations technical specifications  
  • Follow as well suggest architectural / design best practices, coding standards
  • Contribute to project plan through details on integrations tasks and effort estimations
  • Consistently deliver on time and high-quality deliverables
  • Effectively communicate status, challenges, issues, risks to management

Required Experience:

  • Minimum of 1 full Azure implementation (POC through go-live)
  • Broad experience with: Azure SQL Data warehouse, Data Lake, Data Factory and Databricks, Familiarity with Azure Synapse
  • Informatica experience

Other Qualifications: 

  • Bachelor’s Degree in a technology area of study, preferably in Computer Science, MIS or Analytics.
  • 10+ years of experience in designing and implementing data warehouses, at least 4 years with Cloud data warehouses
  • 4+ years of hands-on experience with Azure ecosystem, specifically Azure SQL Data warehouse, Data Lake, Data Factory and Databricks, Familiarity with Azure Synapse
  • 10+ years of experience using ETL / ELT & iPaaS integration technologies with solid understanding of hybrid integration architecture to identify, analyze and develop interfaces and integration flows both on-premise and on cloud.
  • 8+ years of hands-on ETL development experience using Informatica integration tools, PowerCenter and Informatica Cloud
  • 5+ years of experience in relational and data warehouse database design, optimization and performance, specifically with MS SQL Server and Oracle
  • Microsoft Certification in Azure Data Solutions is preferred
  • Experience with Informatica Cloud application integration (ICRT) tool is desired
  • Experience working with offshore resources is desired







More Info


Similar Positions