Ninad Shewale

Data Engineer and Data Analyst with 3+ years of experience designing data pipelines, developing ETL/ELT workflows, transforming large datasets, optimizing SQL queries, and delivering business intelligence solutions. Strong hands-on experience with Python, SQL, PySpark, Apache Spark, Apache Airflow, Azure (ADF, Databricks, Synapse, ADLS), Power BI, data warehousing, data modeling, and cloud platforms. Experienced in building scalable data pipelines, implementing data quality checks, developing analytical datasets, and creating interactive dashboards.

Proven ability to translate complex business requirements into reliable data solutions and actionable insights.

DATA ENGINEER at Smart Software Services Pvt Ltd. (2023-04 – Present)

• Designed, developed, and maintained scalable ETL/ELT data pipelines using Azure Data Factory, Databricks, and PySpark to ingest data from relational databases, APIs, CSV files, and cloud storage.
• Developed Python and SQL-based data extraction, transformation, validation, and loading processes for high-throughput analytical workloads.
• Built and maintained automated workflows using Apache Airflow, including DAG development, scheduling, monitoring, dependency management, and failure handling.
• Leveraged PySpark and Apache Spark to process and transform large-scale unstructured and structured datasets efficiently.
• Developed complex SQL queries using joins, CTEs, subqueries, window functions, stored procedures, and aggregations for optimized reporting.
• Optimized SQL queries and data-processing workflows in Snowflake and Azure Synapse, significantly improving query performance and reducing execution time.
• Designed and implemented dimensional models using fact and dimension tables, star schemas, and data vault modeling principles.
• Integrated multi-source system data into centralized cloud data warehouses (Snowflake, BigQuery).
• Implemented rigorous data quality checks, validation rules, duplicate detection, null handling, and reconciliation processes.
• Developed incremental data-loading strategies to process newly generated or modified records efficiently.
• Created reusable data transformation logic and modules to improve pipeline maintainability and scalability.
• Built interactive Power BI dashboards and reports for sales, operations, customer analytics, and financial KPIs.
• Developed complex DAX measures and calculated columns to support advanced business reporting requirements.
• Performed exploratory and descriptive data analysis using Python, Pandas, SQL, and Excel to uncover actionable business insights.
• Identified key operational trends, anomalies, performance gaps, and revenue opportunities through detailed data profiling.
• Collaborated with business analysts, data scientists, software engineers, and executive stakeholders to define data requirements.
• Translated complex business requirements into robust technical specifications, data models, pipelines, reports, and dashboards.
• Monitored production data pipelines, proactively investigating data failures, quality issues, and performance bottlenecks.
• Authored comprehensive technical documentation for data sources, transformation logic, data models, pipeline workflows, and reporting processes.

Bachelor of Business Administration in Computer Applications in Computer Applications – Savitribai Phule Pune University (2020-01 – 2023-01)