Associate Data Engineer
Boolean Data Systems · Jun 2025 – May 2026
- Worked on 2 projects designing and maintaining Snowflake ELT pipelines across Raw, Staging, and Curated layers using CDC workflows and SCD Type 2 implementation, delivering analytics-ready datasets for 10+ business reports and dashboards.
- Optimized complex SQL queries, joins, and warehouse workloads, improving report and dashboard query performance and supporting faster business decision-making.
- Built 6 reusable Cortex AI accelerators in Snowflake to automate common data transformation and reporting tasks, reducing development time by 80% across analytics projects.
- Automated data ingestion, transformation, and orchestration workflows using Snowpark, Streams, Tasks, and Stored Procedures, cutting manual processing time by 10 hours per week.
- Performed data validation, reconciliation, and quality checks across 5+ datasets, improving accuracy and trust in datasets used for reporting and dashboarding.
- Partnered with analytics and business stakeholders to translate reporting needs into analytics-ready datasets, supporting Power BI dashboards and KPI tracking for business teams.
- Implemented Snowflake optimization techniques including clustering, warehouse tuning, and RBAC-based access controls, reducing compute costs by 30% while maintaining secure data access.
- Set up and maintained Jira boards for the entire project, breaking down work into epics and tasks, assigning tasks to resources, and tracking progress through sprint cycles.
- Coordinated with the Project Manager on resource allocation and task division across the team, aligning workload with project timelines and priorities.