BitSightAnalytics Engineer
Jun. 2021 - May. 2023• Partnered with and serviced internal business stakeholders to gather requirements and translate them into reporting dashboards [Looker, Agile] • Automated and standardized the process of manual uploads of excel/google sheets using Fivetran connector saving 4 hours per month within team [Fivetran] • Developed, tested and deployed 30+ models in dbt implementing concepts like snapshots, incremental models, macros, data tests to serve 4 Tier 1 KPIs in Looker dashboard for executive and stakeholder data insight visibility [Snowflake, Dbt Cloud, SQL, Git] • Developed SQL queries using aggregate functions, window functions, joins [Snowflake] • Implemented CI/CD process to reduce the mean change lead time to within 1 day [Dbt,Git] • Implemented test coverage, alerts to detect data quality issues in source system [Dbt,SQL] Identified opportunities to reduce cost in Snowflake by $200/month [Snowflake] • Maintained documentation regarding best practices and philosophy [Confluence] • Developed pipeline to fetch data from API to database [Airflow, Snowflake]