Analytics Engineer & Snowflake dbt Developer

ANAGHA MADHUKAR GAIKAR

Dallas, TX 202-***-**** *************@*****.*** linkedin.com/in/anaghagaikar

PROFESSIONAL SUMMARY

Data Analyst with 6+ years of experience driving analytics strategy across manufacturing, financial services, and government sectors. Proven track record of building enterprise data infrastructure from the ground up, including data warehouse implementation, BI platform migrations, and modern ELT pipelines. Skilled at translating complex business requirements into scalable reporting solutions with deep expertise in SQL, Snowflake, dbt, Power BI, and ERP data systems.

TECHNICAL SKILLS

Data Warehousing & Modeling: Snowflake, BigQuery, SQL Server, MySQL, Oracle, dbt, Dimensional Modeling

BI & Visualization: Power BI (DAX, RLS, Power Query), Domo, Tableau, Looker Studio, Crystal Reports

Data Integration & ETL: Airbyte (CDC), Stitch, Pentaho, SSIS, Python (Pandas, Automation)

ERP Systems: NetSuite, DELMIAWorks, Stone Profit Systems (SPS), Insight 2020

Programming & Tools: SQL (T-SQL, SnowSQL, MySQL, Oracle SQL), Python, R, SAS, Shell Scripting, Git

WORK EXPERIENCE

Allied Interior Solutions, Farmers Branch, TX Aug 2023 – Present

Analytics Engineer Snowflake, dbt, Power BI, Domo, Airbyte, Fivetran, NetSuite, Python

•Spearheaded Snowflake implementation as the organization’s first data warehouse, defining schemas, roles, access controls, and ingestion pipelines that established a scalable analytics foundation.

•Led migration of 30+ reports from Domo to Power BI within 4 months, reducing licensing costs by 75%.

•Implemented enterprise data governance in Power BI, configured Entra ID security groups for dashboard distribution and enforced row-level security (RLS) for role-based access.

•Architected end-to-end data pipelines using Airbyte (CDC-based ingestion), dbt (intermediate, fact, and mart layers), and Snowflake, enabling near real-time reporting.

•Designed dbt models with incremental refresh strategies and layered transformations, reducing Snowflake computing costs by 25% across 4 M+ daily records.

•Migrated all legacy Domo Workbench queries to version-controlled dbt models, consolidating disparate extraction logic into a maintainable transformation framework.

•Serving as SME for NetSuite ERP implementation, mapping backend table structures, analyzing entity relationships, and building dbt/Power BI reporting layer to ensure continuity during transition from legacy SPS ERP.

•Built a Python-based automated compliance notification system, reducing data inconsistencies by 30% and manual quality-check effort by 40%.

•Partnered cross-functionally with operations, purchasing, accounting, HR, and sales to design KPIs (on-time delivery, callback rate, cost savings, retention) driving measurable operational improvements.

Diamond C Trailers, Mount Pleasant, TX Sep 2022 – Jul 2023

Data Analyst SQL, BigQuery, Stitch, Looker Studio

•Improved employee retention by 10% through targeted HR KPIs and data-driven retention strategies.

•Drove 20% increase in sales volume by conducting conquest analysis to identify high-value dealership prospects.

•Built and maintained 200+ queries, views, reports, and dashboards across BigQuery and Looker Studio for executive decision-making.

•Designed ETL pipelines using Stitch for automated data integration across ERP, and operational systems, reducing manual processing by 60%.

Dept. of Social Services, State of South Dakota, Pierre, SD May 2022 – Aug 2022

Data Analyst Intern SQL, Power BI, Power Query

•Analyzed Medicaid claims datasets across providers and recipients to support policy recommendations, identifying cost-savings opportunities for the state.

•Developed interactive Power BI dashboards with storytelling techniques, delivering actionable insights on claims trends and provider performance.

CRISIL (S&P Global Company), Mumbai, India Mar 2018 – Nov 2020

Senior Associate Analyst SQL, Data Warehousing, ETL, Reporting

•Delivered 50+ change requests and technical solutions for enterprise banking clients including Development Bank of Singapore and Kotak Mahindra Bank.

•Built ETL pipelines for data warehousing (sorting, deduplication, transformation), improving data quality by 80% and automating report distribution to 500+ employees.

EDUCATION

The University of Texas at Dallas Dec 2022

M.S. in Information Technology Management GPA: 3.81/4

CDAC, India — PG Diploma in Advanced Computing Feb 2018

Rajiv Gandhi Institute of Technology, Mumbai — B.E. in Electronics & Telecommunications May 2017

Contact this candidate