Senior Data Engineer
CurrentMy goal is for our team to be the most effective in the industry. I focus on building teams where top talent at all levels of experience feels a true sense of belonging, is recognized for their unique strengths, and is challenged in ways that support both personal and professional growth.I work on the Enterprise Commercial Data Platform (ECDP) initiative, which is critical to the enterprise realizing material returns from our investments in market-share growth. Responsibilities include:• Communicating cross-functionally with DBAs, data stewards, and business stakeholders to define data architecture requirements (dimension, fact, and grain) for transforming third, fourth, and fifth normal form data tables into dimensional star schema data models that answer relevant business questions and power internal analytics for product, financial and risk business teams.• Deploy, Operated, Maintained, and Enhanced scalable Python based ELT and ETL pipelines for Google Cloud using Cloud Composer to ingest data from Google Cloud storage, transform the 3NF-5NF models into a dimensional model, and load it into BigQuery , including error reporting and operations support.• Keep existing data sources and data models fresh against data quality issues and source system updates, refactors, and upgrades.• Develop relationships with production engineering teams and business analysts to manage our data structures as the consumer and business needs evolve.• Maintaining a tight, transparent feedback loop with leadership on ways to improve project performance.• Identify, design, and implement internal process improvements for automating manual processes (e.g. data governance, data profiling, etc.)