Job description

Role Summary Design, develop, and maintain reliable data pipelines, data models, and reporting datasets using PostgreSQL as the system of record and read-only Snowflake for analytics and query-time aggregation. Responsibilities • Build and maintain data pipelines between application services, PostgreSQL, and Snowflake reporting layers. • Design PostgreSQL data structures for configuration, actions, audit, and operational reporting needs. • Develop optimized read-only Snowflake queries and query-time aggregation logic for dashboards and analytics. • Support datasets required for Highcharts and Apache Superset reports. • Implement data quality checks, validation rules, lineage documentation, and reconciliation processes. • Collaborate with developers, QA, BA/PO, and architects to ensure accurate, secure, and performant data delivery. Required Skills • 3–6 years of experience in data engineering, data modeling, or analytics engineering. • Strong SQL skills with hands-on experience in PostgreSQL and Snowflake. • Experience building ETL/ELT pipelines, data validation checks, and optimized reporting queries. • Understanding of audit data, configuration data, access-controlled datasets, and analytics consumption patterns. • Exposure to Apache Superset, Highcharts, Redis caching, and RBAC-driven data access is preferred. • Good documentation, troubleshooting, and cross-functional collaboration skills.

Requirements

Must-haves

Design, develop, and maintain reliable data pipelines, data models, and reporting datasets using PostgreSQL as the system of record and read-only Snowflake for analytics and query-time aggregation.
Build and maintain data pipelines between application services, PostgreSQL, and Snowflake reporting layers.
Design PostgreSQL data structures for configuration, actions, audit, and operational reporting needs.
Develop optimized read-only Snowflake queries and query-time aggregation logic for dashboards and analytics.
Support datasets required for Highcharts and Apache Superset reports.
Implement data quality checks, validation rules, lineage documentation, and reconciliation processes.
Collaborate with developers, QA, BA/PO, and architects to ensure accurate, secure, and performant data delivery.
3–6 years of experience in data engineering, data modeling, or analytics engineering.
Strong SQL skills with hands-on experience in PostgreSQL and Snowflake.
Experience building ETL/ELT pipelines, data validation checks, and optimized reporting queries.
Understanding of audit data, configuration data, access-controlled datasets, and analytics consumption patterns.
Good documentation, troubleshooting, and cross-functional collaboration skills.

Nice-to-haves

Exposure to Apache Superset, Highcharts, Redis caching, and RBAC-driven data access is preferred.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: careers-browser
Effort: medium