Job Description
Job Description Data Warehouse Project Manager is responsible for leading the end-to-end planning, implementation, and maintenance of data pipelines, ensuring that data is accurately extracted, transformed, and loaded (ETL) from diverse sources into a central data warehouse or data lake . This role bridging technical teams and business stakeholders focuses heavily on data quality, validation, and automation, specifically in the ingestion of flat files, APIs, and databases Key Responsibilities Project Planning & Execution: Define project scope, create project plans, manage milestones, and ensure delivery within budget and timelines Data Ingestion & Pipelines: Oversee the construction and maintenance of robust ingestion pipelines to move data from databases (RDBMS/Cloud Data Warehouses) and flat files (CSV, JSON, XML) into data lakes/warehouses. Data Quality & Validation: Establish data profiling and verification procedures to catch schema drift, data errors, and duplicates during ingestion, ensuring data integrity ETL/ELT Processes: Collaborate with data engineers to design and optimize data extraction, transformation, and loading routines using tools like Informatica IDMC, IBM Data Stage, Talend, or Apache Airflow. Stakeholder Management: Liaise with business users and technical teams to gather requirements, report status, and address risks. Vendor/Resource Management: Manage third-party vendors and internal teams, including staff allocation and work direction. Required Skills & Qualifications Experience : 5–8+ years of experience in data warehousing or data engineering project management. Data Technologies : Proficiency in cloud data warehouses (Databricks, Snowflake, Azure Synapse) and ETL/ingestion tools (INFORMATC/ DataStage). Technical Skills: Strong understanding of SQL, data modeling (Kimball/Inmon), data profiling, and orchestration platforms. Project Methodologies: Experience with Agile/Scrum or Waterfall project management methodologies. Education : Bachel
