Eric Abramowitz

Data Integration Analyst 2 at Stellar Health

Newberry, Florida, United States

About

Experience

  • Stellar Health (New York, New York, United States)
    • Data Integration Analyst 2
      Jan 2023 - Present · 3 yrs 6 mos

      - Architected and managed end-to-end ETL processes using AWS-based data pipelines (Databrew, Glue), processing terabytes of data serving 1 million+ attributed patients and 15+ customers along with 25 million claims monthly - Developed and implemented robust ACO patient attribution model and claims processing rules that supported 150% year-over-year program growth (12k to 30k managed lives), directly enabling program expansion through reliable data operations - Designed scalable data quality frameworks for processing multiple healthcare data types, reducing processing time by 40% through new orchestration infrastructure, QA playbooks, and automated validation processes - Partnered with senior leadership to design and execute AWS infrastructure migration strategy for 90% of ETL’s, establishing scalable data pipelines and increasing processing capabilities for complex data feeds Implemented automated orchestration workflows in AWS, eliminating 72+ manual touch points across 18+ ETL processes and significantly reducing pipeline maintenance overhead - Engineered data quality monitoring solutions using Snowflake and custom Python utilities, creating multi-environment dashboards for ETL testing and accelerating investigation timelines for reported discrepancies

    • Data Integration Analyst
      Aug 2021 - Jan 2023 · 1 yr 6 mos

      - Orchestrated successful ingestion and transformation of 40+ healthcare data feeds including ANSI-837 claims, PCOR, ADT, and scheduling data across multiple payer types - Created automated validation processes for patient eligibility and provider network data, reducing manual review time by 50% - Led requirement gathering and specification development for 20+ ETL processes, translating complex business rules into comprehensive claims analysis and provider network mapping solutions - Spearheaded team training and documentation initiatives for new QA processes, resulting in standardized quality tracking across all data feeds and enabling quantifiable measurement of data reliability

  • Data Analyst at Ralph Lauren
    Jun 2019 - Apr 2020 · 11 mos

    - Researched and formulated strategies to assist with identifying store sales trends, employee performance metrics, and store loan tracking using extensive Excel knowledge - Conceptualized and constructed detailed analytical reports used by the Senior Leadership Team to make educated and efficient management decisions across 50+ Ralph Lauren Stores, including: -Created new metrics to help track employee sales performance across stores and management groups -Analyzed 50+ targeted benchmarks and developed worksheets for store leaders across North American Ralph Lauren Stores to assist in weekly merchandise purchasing decisions -Coordinated with Operation Staff at the NY Flagship store to gather, evaluate, and disseminate store performance data, feedback templates, sales and budgeting worksheets, and organizational charts

  • Property Manager at Megar Properties
    Dec 2018 - Mar 2019 · 4 mos

    Megar Properties, LLC 2018 - 2019 Property Manager • Organized, digitized, and streamlined a management system for rental properties worth over $5 Million for the efficient administration of lease agreements, banking, and communication. • Applied Microsoft Excel skills to create interactive worksheets/datasets to allow the property owner and subsequent property managers to enhance the fluid operation of all properties. • Worked directly with property owners and partners to deliver customized management practices to ensure contractual agreements were maintained.

  • Grocery Coordinator at Publix Super Markets
    May 2016 - Jul 2018 · 2 yrs 3 mos

    Publix Supermarkets 2016 - 2018 Grocery Coordinator • Delegated tasks to 6-8 employees every day to promote sales and support store operations. • Assisted customer service staff in meeting shoppers' needs and resolving customer complaints. • Managed and tracked inventory to account for merchandise loss and reduce waste of product.