Matera Systems
December 2022 - present
Query and analyze large-scale KPI datasets from AWS and Oracle using advanced SQL with multiple CTEs, then design star schema dimension tables to prep and transform data for dashboarding; version control in Git. Build executive KPI dashboards and reporting for Technology Governance in Power BI and Qlik Sense, translating stakeholder requirements into standardized metrics. Partner with business stakeholders to define, standardize, and monitor KPIs, presenting analytical findings to cross-functional teams across the BI function. Automate data validation processes in Python and N8N, plus validation dashboards, to monitor data load and quality. Track agile delivery metrics for Scrum teams across Technology Governance in dedicated dashboards, supporting KPI standardization. Reduce manual effort in recurring reporting workflows by building and maintaining RPA automation in Python.