Worked on improving data accuracy for active users reporting in the mozilla/bigquery-etl repository by addressing a key data integrity issue. Focused on refining SQL aggregations, the work involved removing an unnecessary date filter from usage_reporting_active_users_aggregates to ensure filtering relied solely on submission_date. Additionally, version filtering thresholds in composite_active_users_aggregates for firefox_desktop were adjusted to maintain consistency across aggregates, specifically aligning thresholds for different user aggregates. Tests were updated to reflect these logic corrections, ensuring reliable cross-source consistency. Utilized skills in Data Engineering, ETL, and SQL, with Jinja templates supporting the changes to maintain robust and accurate reporting pipelines.