As Lead Architect, I oversee the development and delivery of scalable data solutions, driving innovation and ensuring successful implementation for our diverse range of clients.Key Responsibilities:- Lead the design and architecture of the Databricks Lakehouse & AI Platform, a metadata-driven, high-performance data processing platform.- Manage end-to-end data migration strategies to Databricks, accelerating client digital transformation across various industries.- Collaborate closely with clients to align solutions with business needs, ensuring seamless integration and high ROI for their data operations.- Oversee a remote, cross-functional team, fostering a collaborative and innovative work environment.

As a Lead Data Engineer and Delta Lake Architect at The Wrench Group, I am driven by a profound passion for leveraging the power of Databricks to revolutionize data engineering and analytics.My primary focus is on architecting and implementing cutting-edge data solutions that harness the capabilities of Databricks. I specialize in designing and building robust data lake analytical platforms that drive efficiency and empower data-driven decision-making.At the heart of my work lies the commitment to defining, implementing, and enforcing data architectural standards, ensuring enterprise-level excellence in database development. My expertise in Databricks allows me to design data structures for extensive and diverse datasets, develop intricate ELT processes.As a fervent advocate for the transformative potential of Databricks, I am dedicated to pushing the boundaries of data engineering and analytics. I thrive on collaborating with forward-thinking professionals and organizations looking to unlock the true power of Databricks to achieve data-driven innovation and success.

Define, implement, and enforce data architectural guidelines establishing enterprise-level standards for database development including designing data structures for large, nonhomogeneous, medical claims datasets; develop complex ETL and ELT processes. Develop multi-dimensional Tabular Model in analysis services to expose complex datasets and identify improvements. Build APIs in PowerShell and Python to automate data extraction from end points, such as CMS and Cerner.

Established PowerShell scripts to load Active Directory security groups to safely expose data by enabling row level security. Created indexes (rowstore and columstore) along with proper partitioning of large tables to ensure optimal performance. Conceptualized/designed multi-dimensional databases to manage large datasets and to enhance population health reporting by strategically using business user feedback.

Led and developed a User Interface (UI) for Advocate’s Physician Reporting; met regulations and generated $5M annual savings. Automated the monthly processing of key utilization measures using custom R packages, slashing staffing by 2.0 FTEs per month. Trained team of analysts to use BI tools/macro-enabled pivot tables; developed Advocate’s 1st Microsoft Azure Cloud Database.

Created Microsoft Power BI reporting structure and STAR SCHEMA data model allowing reports to dynamically display measures. Collaborated with C# developer to build data collection forms; eliminated manual errors and reduced time by 30 hours monthly. Automated the monthly KRA processing using stored procedures and business logic; reduced staffing time by 24 hours monthly. Built SAS program for leadership to analyze market performance against peers using CMS’ Hospital Compare data.

Created excel tool to expose clinical datasets to business users leveraging pivot tables and macros to enhance user experience. Supported the administration of clinical decision support systems, analyzed data for trends, and built online reports in SSRS. Provided consultation on the use of control charts and statistical software to system-wide users.