Senior Data Engineer
hirist
Job Description
- Own data architecture and system design decisions for data pipelines and data models.
- Design and build scalable, production-grade data pipelines end-to-end.
- Design transaction-level fact tables and standard fact/dimension models.
- Implement Bronze/Silver/Gold (Medallion) architecture.
- Build pipelines for finance, risk, or compliance use cases where accuracy and auditability are critical.
- Implement data quality controls, reconciliation, anomaly detection, and audit trails.
- Write complex SQL using CTEs, window functions, CASE logic, COALESCE, NULLIF, and date/timestamp handling.
- Build idempotent data reload patterns and handle late-arriving or corrected records without double-counting.
- Develop and maintain Airflow-style DAGs and cross-pipeline dependencies.
- Build Python-based ETL tooling using Pandas, SQLAlchemy, and database drivers.
- Work with YAML-driven configurations and integrate with APIs where required.
- Own CI/CD processes using Git workflows.
- Document data models, pipeline logic, data lineage, and operational processes.