Dave Patterson

Led, scaled, and mentored high-performing hybrid team consisting of 4 data engineers, 2 data analysts, 1 cloud engineer, and an offshore support team.

• Led legacy modernization and ETL migration, transferring IBM InfoSphere DataStage ETL workflows to cloud-based Apache Airflow-based orchestration.
• Directed cloud infrastructure and architecture by architecting scalable data pipelines in AWS, improving data modeling efficiency and coordinating storage and processing across Snowflake and Amazon Redshift.
• Strengthened engineering culture via career development and mentorship; advanced developer capabilities from legacy tools to cloud-native technologies, improving delivery timelines.
• Managed global operations by leading the offshore support team to implement 24/7 data pipeline monitoring, standardize workflows, and enhance platform uptime and incident resolution times.

Directed a data warehousing team consisting of 5 full-time developers and 5 offshore contractors, driving data strategy, infrastructure modernization, and system stability.

• Infrastructure & Server Modernization: Successfully led the team through multiple server migrations while enhancing system performance and reliability.
• Technical Design Leadership: Led collaborative team design sessions, defining data warehousing best practices, data structure, and scalable SSIS ETL architectures.
• Stakeholder Alignment & Collaboration: Collaborated with business stakeholders and external application teams to translate business requirements into clear technical solutions and data delivery pipelines.
• Talent Development & Mentorship: Actively promoted the career development and technical upskilling of internal team members, guiding developers through multiple projects and creating a continuous learning culture.
• Data Operations Management: Structured and prioritized daily operational run work, overseeing the monitoring and tuning of SSIS packages and scheduled jobs to optimize platform availability and minimize incident occurrences.

Served as the lead developer on multiple high-impact projects, designing and implementing solutions to meet complex business needs. Partnered directly with stakeholders to gather requirements, build efficient pipelines, and ensure the operational integrity of production environments.

• ETL Engineering & Architecture: Designed, built, and deployed ETL packages using SSIS, establishing data pipelines that feed the data warehouse from multiple sources.
• Technical Project Leadership: Acted as the lead developer across multiple data projects; translated business requirements into technical specifications and led the end-to-end development lifecycle.
• On-Call Production Support: Provided on-call production support for the data warehouse during off hours to ensure data availability and accuracy at the start of the business day.
• Requirements Gathering & Ad-Hoc Analytics: Collaborated closely with business stakeholders to gather data requirements and engineered complex queries to fulfill critical, time-sensitive ad-hoc data requests.
• Mentorship & Onboarding: Mentored junior team members and offshore contractors on best practices, including SQL optimization and SSIS development standards, fostering a collaborative team environment.

• Legacy Modernization: Converted text-based, non-GUI legacy applications into modern graphical user interfaces (GUI) utilizing proprietary, in-house software frameworks.
• Application Engineering: Programmed, edited, and debugged database transaction logic within a legacy database environment.
• Technical User Support: Provided cross-platform troubleshooting for remote users and conducted technical training sessions to ensure smooth end-user adoption of newly deployed software programs.