Role :PostgreSQL data warehouse Consulant
Duration: 6+ Months
Location : Hybrid (Jersey City, NJ)
We need a hands-on Technical Lead to own our PostgreSQL data warehouse end to end. You will lead onshore and offshore development and PROD support teams, make architectural decisions, resolve upstream and downstream data issues, and work directly with business stakeholders to deliver reliable analytical reporting.
• Lead: Guide offshore development and PROD teams through sprint planning, code reviews, release readiness, and incident management.
• Architect: Recommend and decide on data models (star/snowflake, Data Vault, ODS), partitioning, and performance strategy. Set standards for PL/pgSQL, ETL, logging, and reconciliation.
• Build: Develop complex PL/pgSQL procedures and functions, and optimize high-volume batch and incremental ETL/ELT pipelines. Build the analytical reporting layer (aggregates, materialized views, reporting datasets).
• Own data quality: Triage upstream issues (late or bad feeds, schema changes), manage downstream impact on reports and extracts, and deliver root-cause fixes with proactive checks and alerts.
• Partner with the business: Translate requirements into solutions and communicate risks and status clearly to senior stakeholders.
