Data Engineer Power Bi

Amulya Srinivasamurthy

Dallas, TX ******.*@*********.*** 689-***-**** LinkedIn

SUMMARY

Data Engineer with 5+ years of experience in financial systems, insurance analytics, and software product telemetry. At BlackRock, scaled AWS Glue, Redshift, and Kafka pipelines handling 400M+ transactions daily to support real-time risk reporting. Delivered BI solutions at MetLife using Azure Synapse, ADF, and Power BI, cutting reporting cycles by hours. Earlier at Vivma, built Snowflake-based data marts and streaming architectures for microservice analytics, enabling product teams to track adoption across millions of user sessions. EXPERIENCE

BlackRock Data Engineer Feb 2025 - Current

Built large-scale ETL pipelines on AWS Glue + S3 and Spark to process 400M+ financial transaction records daily; reduced data load time from 3 hours to under 50 minutes with partition tuning and parallelism.

Designed and deployed Kafka streaming jobs to capture portfolio trades in real time, cutting reporting latency from T+1 to near-instant (less than 2 minutes) for risk teams.

Modeled fact and dimension tables in Redshift and implemented schema evolution with stored procedures, enabling analysts to query data 35% faster during quarterly reporting.

Automated pipeline orchestration with Airflow DAGs integrated into CI/CD (Jenkins and Terraform); improved SLA adherence from 72% to 97% across 120+ jobs.

Partnered with quant and research teams to deliver a data mart on AWS for market risk analytics; optimized data flows brought down compute cost by 28% while supporting daily VaR and stress testing runs. MetLife BI Engineer Intern Sep 2024 - Jan 2025

Queried and cleaned policy and claims datasets using Azure Data Lake + SQL, reconciling mismatches that enhanced accuracy of month-end reporting by 15%.

Created Power BI dashboards for premium trends, reserve balances, and lapse ratios; automated refresh through Azure pipelines, reducing manual reporting cycles by 10 hours each month.

Developed reusable ETL workflows in Azure Data Factory to integrate data from several internal systems; shortened data availability window from 2 days to a few hours for finance teams.

Assisted actuarial teams in building Power BI analytical layers on top of Azure Synapse, applying star-schema designs that cut premium and reserve query times from minutes to seconds. Vivma Software Inc. Data Engineer May 2019 - Jul 2023

Engineered event-driven pipelines with Apache Kafka and Spark Structured Streaming to capture microservice logs across 25+ backend services; eliminated incident triage time by 40% through near real-time visibility.

Optimized transactional schemas in Snowflake, applying clustering keys and partitioning strategies that cut query runtimes for API usage data by 60%.

Containerized ETL pipelines with dbt + Airflow to transform raw service telemetry into curated Snowflake tables; elevated developer access to clean datasets and shortened analysis cycles by 12 hours per sprint.

Implemented data quality validation using Great Expectations and dbt tests, surfacing anomalies in 2% of ingested records before propagated to monitoring dashboards.

Coordinated with backend teams to build a feature adoption dashboard in Snowflake, enabling product managers to track usage metrics across 5M+ user sessions and retire low-value features

Deployed containerized data services on Kubernetes, scaling ingestion jobs dynamically during peak traffic windows and cutting infrastructure costs by 20%.

SKILLS

Data Engineering & ETL: SQL (T-SQL, PL/SQL), dbt, Apache Spark, PySpark, Kafka, Airflow, Talend, Informatica, Azure Data Factory, ETL/ELT pipeline design, Data Quality frameworks (Great Expectations, dbt tests). Databases & Cloud Platforms: Snowflake, Amazon Redshift, Azure Synapse, Google BigQuery, PostgreSQL, SQL Server, Oracle, Data Lakes/Marts, Dimensional Modeling (Star/Snowflake schemas), AWS (Glue, EMR, Lambda, S3, Redshift), Azure (Data Lake, ADF, Synapse, Databricks), GCP (BigQuery, Dataflow), Kubernetes, Docker, Terraform. Business Intelligence & Analytics: Power BI, Tableau, Qlik, SSRS, Looker, Excel (macros, VBA, pivots), DAX, KPI Dashboards, Forecasting, Scenario & Sensitivity Analysis, Cohort Analysis, A/B Testing, Statistical Analysis. Programming & Scripting: Python, Scala, Java, Shell scripting, R, API integration, CI/CD (Jenkins, GitHub Actions). Governance & Data Management: Data Security (encryption, masking, RBAC), GDPR/HIPAA compliance, Metadata

& Master Data Management, Data Lineage, Version Control (Git), Logging & Monitoring (CloudWatch, Grafana). Certifications: IBM Data Engineering Microsoft Power BI Data Analyst Google Data Analytics EDUCATION

University of Central Florida Orlando, FL

MS in Statistics & Data Science May 2025

Contact this candidate