Position Overview
Description
Responsibilities
Design databases and pipelines that balance functionality, performance, cost, and development time; evaluate technical options with the product manager.Design, build, test, and maintain ETL/ELT processes using T-SQL stored procedures, SSIS, and SQL Agent; apply metadata-driven design for extensibility.Serve as a team leader; contribute to project planning, work breakdown, dependency sequencing, and release management.Develop and promote standards, conventions, design patterns, DevOps/SDLC best practices, and operational procedures for pipelines and warehouse maintenance.Mentor junior engineers in data warehousing, data engineering skills, and operational support.Design, build, and maintain data management processes, including loading flat files (csv, tsv, pipe-delimited, JSON).Lead design sessions, code walkthroughs, peer reviews, and produce technical documentation.