Open to opportunities

Joel Losch

@joellosch

Senior Data Engineer at Esquire Deposition Solutions who replaced a broken integration system, cutting loads from days to hours.

United States

Message

At Esquire Deposition Solutions, I audited data flows across 60+ interdependent databases and consolidated them into a unified, metadata-driven solution. I also replaced a broken, proprietary integration system with a new SSIS framework, improving reliability to 97% and reducing load times from days to hours.

At Wells Fargo, I reengineered the Impairments process, reducing processing time from weeks to minutes. I also served as technical lead for four developers delivering analytical tools and regulatory reporting for financial operations.

Earlier, I built and maintained data warehouse and BI solutions at Aetna, including claims processing that handled 100M+ records in batches. Across my work, I’ve modernized data flows, models, and reporting systems to make them more reliable and useful.

Experience

Work history, roles, and key accomplishments

Current

Sr. Business Intelligence Developer

Current

Esquire Deposition Solutions

Feb 2023 - Present (3 years 9 months)

Audited data flows across 60+ interdependent databases and consolidated them into a unified, metadata-driven solution. Built a new SSIS data integration framework, improving reliability to 97% and reducing load times from days to hours.

SQL Server T SQL SSIS Data Integration Data Modeling Git TDE SOC2 AI QA validation

Data Architect

Riskonnect

Aug 2021 - Feb 2023 (1 year 6 months)

Led discovery on existing Salesforce data flows to evaluate a Snowflake-based pipeline architecture. The recommendation was tabled after cost analysis outweighed projected benefit.

Salesforce Snowflake Data Architecture Discovery Cost Analysis

AVP / Senior Analytical Consultant

Wells Fargo

Jun 2018 - Aug 2021 (3 years 2 months)

Reengineered the Impairments process, increasing automation and reducing processing time from weeks to minutes. Developed and stabilized BI reporting and analytical tools for financial operations.

BI Reporting Data Analysis Agile Waterfall Team Leadership Financial Analysis SQL

Database Developer

Billing Tree

Oct 2016 - Jun 2018 (1 year 8 months)

Reduced duplicated and missed fees during billing by rewriting key portions. Decreased development time from three months to three days by rewriting configuration tables.

SQL Server T SQL SSIS Query Optimization Indexing Data Modeling

Business Intelligence Developer

Aetna

Apr 2014 - Oct 2016 (2 years 6 months)

Resolved a critical data warehouse reload failure by rewriting claims processing logic to handle 100M+ records in batches. Developed and maintained SSIS packages to consolidate healthcare claims data from 60+ sources.

SQL Server T SQL SSIS Data Warehouse HIPAA Query Optimization Batch Processing

Business Intelligence Developer | Database Administrator

Preferred Homecare

Feb 2012 - Apr 2014 (2 years 2 months)

Managed production database environments and maintained SSAS cubes. Implemented transactional replication, reducing nightly load processes from 8 to 2 and improving completion rate from 73% to 83%.

SQL Server SSAS Replication Database Administration Data Warehouse Excel