Data Engineer Power Bi

Komal Albhar

+ Dallas, TX 857-***-**** # ******.*****@*****.*** portfolio/k

summary

Motivated and detail-oriented Data Engineer with hands-on experience in Python, SQL, and AWS-based ETL pipelines. Skilled at contributing to the design, testing, and documentation of data workflows that improve automation and business efficiency. Collaborative team player with strong problem-solving skills and a proven ability to quickly learn new tools, ensuring data integrity and reliable reporting across systems. technical skills

Programming Languages: Python, SQL, PySpark, R

Data Engineering & ETL/ELT: AWS Glue, Apache Airflow, dbt(Data Build Tool), Alteryx, SSIS, SSMS Databases & Warehousing: MySQL, PostgreSQL, Spark SQL, Snowflake, Redshift, Azure Synapse Cloud Platforms: AWS (S3, Lambda, Glue, Athena, EC2, RDS), Azure (ADF, Databricks) Visualization Tools: Power BI (DAX, Power Query), Tableau, AWS QuickSight Other Tools: Git, Jira, Jupyter Notebooks, Visual Studio Code, Excel (Advanced) experience

Data Engineer Jan. 2025 – Present

Humanitarians AI Remote

• Designed and implemented scalable data pipelines on AWS using Glue, Lambda, and S3 to automate the ingestion and processing of large-scale, unstructured clinical and patient data, improving data availability for reporting by 40%.

• Developed and optimized Python scripts for complex ETL processes, transforming raw EHR (Electronic Health Record) and claims data into structured, analysis-ready formats for analytics and operational reporting.

• Built automated data validation and quality checks within pipelines to ensure data integrity, accuracy, and compliance across all systems, directly supporting internal controls and audit requirements.

• Collaborated with clinical analysts and business stakeholders to understand data requirements and deliver clean, reliable, and timely datasets for population health analytics and regulatory reporting. Data Engineer Intern Aug. 2024 – Dec. 2024

Abecedarian Boston, MA

• Engineered and maintained robust data pipelines using Python and SQL, automating the flow of educational data from multiple source systems into a centralized Snowflake data warehouse.

• Utilized Airflow to orchestrate and schedule ETL jobs, ensuring reliable and timely data delivery for stakeholder reporting.

• Documented all data processes, pipeline designs, and automation workflows, creating a comprehensive knowledge base for the team.

Data and Business Intelligence Analyst Jul. 2021 – Jun. 2022 UST Global Inc Pune, IN

• Supported the design of data solutions by collaborating with subject matter experts to interpret business requirements and translate them into technical specifications for ETL development.

• Extracted and analyzed data from various source systems to provide insights that informed business decisions and identified opportunities for process automation and maintenance of existing data pipelines

• Developed interactive dashboards and reports in Power BI utilizing advanced DAX for calculated measures and KPIs, enabling stakeholders to visualize critical performance metrics and track business efficiency. projects

Healthcare Claims Data Processing Automation AWS Glue, Lambda, S3, PySpark, SQL

• Architected an end-to-end automated data pipeline on AWS to process synthetic healthcare claims data.

• Leveraged S3 for storage, AWS Glue for serverless ETL, and Lambda functions to trigger processes.

• Engineered data transformations using PySpark and SQL to cleanse and standardize data, ensuring high quality.

• Utilized Athena to perform ad-hoc analysis directly on the processed data in S3. Hospital Operational Analytics Dashboard Python, SSMS, Power BI

• Spearheaded the development of a full-stack analytics solution, from database design to dashboard creation.

• Designed a star-schema data model in PostgreSQL to efficiently store and retrieve hospital operational data.

• Constructed a Python-based ETL pipeline to extract, transform, and load data from disparate sources.

• Developed an interactive Power BI dashboard to visualize critical metrics, driving insights into operational efficiency. education

Northeastern University Boston, MA

Master of Science in Information Systems Sep. 2022 – May. 2024 Pune University Pune, IN

Bachelor in Computer Science Aug. 2018 – Jun. 2021

Contact this candidate