- Design, write, review and ship SQL models to transform raw data into usable data products.
- Own and maintain the data transformation layer and data warehouse.
- Proactively monitor data warehouse operations to identify opportunities for improvements in accuracy, coverage, and usability.
- Translate ambiguous business requests into modeled data and establish clear business rules.
- Implement processes for data quality, lineage, access, and retention across source databases.
- Manage the data dictionary by documenting table and column origins for human and AI consumption.
- Diagnose and resolve data incidents using a methodical approach.
- Review peer code to maintain the hygiene of the production data environment.
- Collaborate with Business Analysts, Data Engineers, and Data Scientists to support data-driven decision-making.
PythonSQLGit+5 more