I am a Senior Data Engineer and Azure/SQL specialist with deep experience in building multi- terabyte data warehouses, designing scalable ETL pipelines, and delivering business intelligence solutions in regulated industries such as healthcare and finance. I excel at cross-functional collaboration, stakeholder engagement, and turning raw data into strategic dashboards and self-service analytics, while maintaining data quality and regulatory compliance across HIPAA, HEDIS, FHIR, HL7, and SOX.

Carolyn Deen

I am a Senior Data Engineer and Azure/SQL specialist with deep experience in building multi- terabyte data warehouses, designing scalable ETL pipelines, and delivering business intelligence solutions in regulated industries such as healthcare and finance. I excel at cross-functional collaboration, stakeholder engagement, and turning raw data into strategic dashboards and self-service analytics, while maintaining data quality and regulatory compliance across HIPAA, HEDIS, FHIR, HL7, and SOX.

Available to hire

I am a Senior Data Engineer and Azure/SQL specialist with deep experience in building multi- terabyte data warehouses, designing scalable ETL pipelines, and delivering business intelligence solutions in regulated industries such as healthcare and finance.

I excel at cross-functional collaboration, stakeholder engagement, and turning raw data into strategic dashboards and self-service analytics, while maintaining data quality and regulatory compliance across HIPAA, HEDIS, FHIR, HL7, and SOX.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
See more

Work Experience

Senior Data Engineer at Wisconsin Physician Services
September 1, 2025 - September 1, 2025
Analyzed and optimized the Financial Data Mart and Veterans Affairs Reporting Data Warehouses to improve runtimes, process management and meet internal SLAs. Designed and orchestrated Azure Data Factory pipelines to integrate HR data sourced from UKG. Maintained and enhanced HR Data Mart with reliable HR reporting via ETL pipelines. Worked in a DevOps/Agile environment, engineered high-availability ETL pipelines with error handling, logging and auditing (SSIS/SQL/T-SQL). Created and altered database tables to align with evolving ETL processes and BI requirements; managed security updates for ADF pipelines using Key Vault. Participated in 24/7 on-call coverage.
Senior SQL/ADF Data Architect/Engineer at DataLink Software
June 1, 2023 - June 1, 2023
Responsible for Process, System and Data Standards for validating ingestion, processing, aggregation and management of client provider data to meet HEDIS certification standards. Assessed Output Data Integrity Standards by evaluating CCD/PSV outputs and ensuring compliance. Worked in a DevOps/Agile environment using SQL, T-SQL, SSIS, Databricks, Python, VB to analyze, process and resolve PBI’s and update HRIS (UKG) databases for healthcare clients in on-prem and Azure/Snowflake environments. Set up data sources for HIPAA private health information (PHI) using SSIS for Master Data Management implementations.
Senior SQL/ADF Data Architect/Engineer at Ensemble Health Partners
December 1, 2021 - December 1, 2021
Led the Lift and Shift of legacy SQL ETL systems and EHR databases (EPIC, NextGen, Cerner, Allscripts) to Azure Data Factory and client APIs. Designed, developed, and maintained ETL processes using SSIS 2019 for Revenue Cycle Management data, applying client-specific rules. Automated ETL processes with SSIS, Databricks, PowerShell, Python, C#, VB to integrate diverse data sources and ingest healthcare data into proprietary systems. Established HIPAA PHI data sources for MDM implementations.
Senior Database Analyst V at Wells Fargo/USI
November 1, 2018 - November 1, 2018
Designed and developed SQL Server 2016 enterprise data warehouse for corporate portfolio reporting and KPI-driven visualizations via Tableau, Power BI, and SSRS. Led governance for BI solutions, delivered enterprise data warehousing for Sales analysis, and migrated SharePoint/ICO G processes to modern BI platforms.
Senior SQL SSIS Consultant at Various Clients – IBM, Bank of America, Apollo Group, DoD (Contract)
May 1, 2014 - May 1, 2014
Performed data analysis and healthcare data integration (claims, pharmacy charges, HL7, EDI 835/837) using SSIS; architected star-schema data warehouse for call center statistics; developed OLAP cubes (SSAS) and Tabular cubes; built end-to-end BI solutions replacing legacy platforms. Led cloud/on-prem ETL migrations, collaborating with CIO and QA teams.

Education

Bachelor of Science in Computer Science/Mathematics at University of South Carolina
January 11, 2030 - November 7, 2025

Qualifications

Active Security Clearance
October 11, 2023 - November 7, 2025

Industry Experience

Healthcare, Financial Services, Government, Education, Manufacturing, Professional Services, Software & Internet, Transportation & Logistics