Data Warehouse Architect | Online Jobs | Optimhire

Data Warehouse Architect

Job Description:Lead the Data Warehouse system architecture design and implementations/ enhancementsAbility to create and maintain conceptual/business, logical and physical data modelsAbility to synchronize models to ensure that database structures match modelBuild and maintain high performing ETL (Extract, Transform and Load) processesSupport and enable Data Sciences and Business Intelligence teams with necessary data repository, pipes and regular feeds.Monitor data platform to ensure reliability, consistency and accuracy of information loaded into the enterprise warehouse on a regular basisAnalyse and document source systems data domains and inter-relationships to enable rapid ingestion into warehouse/ data lake environment and provision high quality and consumable dataAssist in the development of internal policies / procedures/ standards/ controls and metricsSeek continuous improvement in performance of the data platform load and consumption processesWork cross functionally to implement data driven projectsWork with external vendors, cross functional teams and data sources as required for planning, designing, implementing, testing, rolling out and management of Data platform projects.Effectively communicate and document the data platform architecture utilizing industry standardsManage and ensure data security, quality and process controls, managing escalations and developing and recommending improvementsImplement / follow Agile and DevOps methodology and tool setsRoles and ResponsibilitiesUnder general direction, primarily responsible for activities related to the architecture, design, development, implementation, and support of the data warehouse.Participates in the design of the technical and information architecture for the data warehouse, including all information structures (staging area, data warehouse, data marts, and operational data stores).Focuses on enterprise-wide data modelling and database design. Creates logical and physical data models, mapping logical to physical for Dimensional & Data VaultDesigns, develops, tests, monitors, manages, and validates data warehouse activity, including data extraction, transformation, movement, loading, cleansing and updating processes. Coordinates with other Data Warehouse IT stakeholders to ensure overall health and performance of the data warehouse environment. Works with end users to translate business questions and requirements into applications that employ the appropriate reporting tools. Performs other duties as required.Desired Candidate ProfileBachelor's Degree in Computer Science or a related technical fieldMinimum of 8 year experience in a similar roleExtensive experience in designing, developing, testing, and implementing ETL solutions using any enterprise ETL toolsData Modelling experience - Dimensional & Data VaultSuperior communication and business-technical interaction skillsProven experience proposing blueprint solutions and collaboratively defining enabling architectures for enterprise data platformsComfortable making decisions over uncertaintyExpert-level SQL skillsStrong team player and outstanding problem solverSelf-starter, self-managed, quick learner, problem-solver with a positive, collaborative, and team-based attitudeAbility to work remotely, at a home-office, with limited travel to client locations (as it's safe to travel again)Comfortable to provide 2 hours of overlap time for meetings/daily stand-ups with business during early USA hoursStrong understanding of various design and architecture patternsKnowledge of BI architectures, concepts and frameworksExtensive experience in any of the RDBMS platforms i.e. SQL Server, Oracle, TeradataCapable of facilitating data discovery sessions involving business subject matter expertsExperience in translating/mapping relational data models into Data Base SchemasShould have knowledge of different estimation modelsWork Location & Culture: Full-time positionRemote Working - Anywhere from IndiaFlexible working hours

Job Type



Software Architects

Must have Skills

  • SQL
  • Informatica
  • Agile Methodology
  • Relational Database Management System - RDBMS
  • Data Warehousing


  • ETL(Extract, Transform, Load)
  • Data Warehouse

25 - 31 K/Year USD (Annual salary)

Longterm (Duration)

Fully Remote

Shweta M