Senior Software Engineer at Ideamaker

Built SQL and Python pipelines to ingest data from product databases, CSV feeds, and partner APIs into BigQuery, then shaped outputs for Power BI reporting. Owned dbt models for the warehouse layer, transforming raw tables into clean dimensional models for analyst-friendly querying. Wrote complex SQL transformations for ETL jobs in BigQuery and AWS, including incremental loads, backfills, and late-arriving data fixes. Developed Tableau dashboards for leadership with trend and monthly reporting. Troubleshot upstream data breaks using Python-based checks and fixed warehouse logic before it reached dashboards. Partnered with PMs and stakeholders to translate requirements into SQL metrics and deliver reports, handling client questions about refresh delays and number mismatches. Added automated validation around dbt runs and ETL steps to reduce recurring defects, and reviewed changes via Git to catch schema drift and join issues early.

Senior Software Engineer at Infynex

Designed and maintained SQL-based ETL pipelines loading data from operational systems into Snowflake and BigQuery for analytics and reporting. Built dbt models and dimensional data marts to provide a stable semantic layer for Power BI and Tableau. Wrote Python scripts for scheduled ingestion jobs, including file parsing, API pulls, and cleanup before warehouse loading. Developed Tableau dashboards for descriptive analysis and monthly trends to surface gaps quickly. Gathered client requirements, mapped source systems to reporting needs, and explained tradeoffs when model changes were required. Troubleshot failed SQL jobs by fixing broken joins and duplicate loads while keeping ETL runs moving during tight reporting cycles. Used GCP services and AWS storage to move raw files/stage data and apply role-based access controls. Implemented data quality checks (row counts, null checks, reconciliation) to ensure trustworthy reporting numbers.

Full Stack Engineer at BellPepper

Worked on SQL reporting databases and Python-backed data extracts feeding internal dashboards and business analysis. Built ETL scripts to move transactional data into cleaner reporting tables and modeled outputs for analysts in Tableau. Created Power BI reports for operational teams, calculating sales, fulfillment, and customer activity metrics using SQL. Tuned MySQL queries and optimized joins so reporting jobs ran faster and dashboards stopped timing out. Collected stakeholder requirements, clarified report logic, and translated requests into concrete data fields and filters. Added data validation steps for missing records, duplicate loads, and bad date values prior to downstream reporting. Used Git for version control and code review on SQL/Python changes. Managed cloud-hosted datasets in AWS using S3 and scheduled recurring jobs; supported descriptive analysis via ad hoc SQL and Python notebooks; helped maintain secure access to sensitive reporting data.