Data Engineer Senior

Brenna Paine, MS

Senior Data Engineer / Architect

******@********.*** 949-***-****

Professional Summary

Senior Data Engineer/Architect with 15+ years of experience designing scalable data architectures, building efficient ETL/ELT pipelines, managing large datasets, and implementing modern data solutions across cloud platforms like AWS and Snowflake. Proven expertise in data modeling, pipeline orchestration, PII obfuscation, analytics tooling, and cross-functional collaboration.

Experience Summary

Presidio – Sr. Cloud Data Engineer

Sep 2023 – Jan 2025

●Designed efficient data pipelines and APIs integrating Oracle SQL with Snowflake.

●Built and optimized Power BI dashboards for state health program metrics.

●Modeled and curated large datasets for executive-level visibility.

●Collaborated with analysts and stakeholders to align technical delivery with business KPIs.

●Tuned slow-performing queries, significantly reducing report refresh times.

●Implemented RBAC and encryption policies to meet state-level compliance.

Aktana – Sr. Data Operations Engineer

Nov 2022 – Jul 2023

●Migrated sensitive client datasets to AWS S3; led MySQL upgrade from 5.7 to 8.

●Developed Python scripts for data obfuscation using Faker; integrated with Informatica TDM.

●Automated workflows using Rundeck; scheduled nightly and on-demand obfuscation jobs.

●Implemented monitoring via Grafana and alerting with Slack/Email integrations.

●Collaborated with QA and Compliance to validate obfuscated data before deployment.

●Tuned Snowflake clustering and partitioning to improve dbt model performance.

Wipro / Verizon Wireless (Consultant) – Data Architect / Engineer

Mar 2022 – Nov 2022

●Built automated data pipelines (Jenkins > S3 > Snowflake > NetSpring) for user analytics.

●Led initiative to standardize data schema across mobile app telemetry sources.

●Integrated usage metrics into business reporting for customer behavior insights.

●Ensured data privacy through masking and access controls within Snowflake.

●Delivered dashboards and KPIs consumed by Marketing, UX, and Engineering teams.

●Reduced end-to-end data latency through asynchronous ingestion strategies.

SimplePractice – Data Engineer

Jul 2020 – Mar 2022

●Developed and maintained ELT pipelines using dbt and Snowflake for healthcare analytics.

●Created dashboards in Power BI to track provider engagement and patient access trends.

●Integrated disparate data sources across MySQL, NoSQL, and CSV for unified reporting.

●Used Power Automate to trigger alerts and reports for compliance workflows.

●Worked closely with Data Analysts and Product Managers to deliver self-service data models.

●Implemented audit logging and HIPAA-compliant data retention strategies.

Panasonic Avionics – Senior Data Engineer

Nov 2008 – May 2020

●Built and maintained large-scale ETL pipelines using Python, SQL, and Bash on Linux.

●Created data APIs and tools for airline operational analytics and system health.

●Administered MySQL and PostgreSQL databases; handled replication and backup strategies.

●Designed data warehouse models to support both internal engineering and customer reporting.

●Supported real-time telemetry ingestion from aircraft systems; built dashboards for diagnostics.

●Designed and ran high-availability Linux servers in on-prem and AWS environments.

Spectrum College Funding – Senior Development Manager

May 2002 – Dec 2008

●Led development of .NET applications using VB, ASP, and C# for financial planning tools.

●Administered and maintained MySQL and Access databases for CRM and reporting.

●Oversaw internal network infrastructure, security patches, and VPN setup.

●Migrated legacy systems to web-based platforms with improved usability and security.

●Developed tools to generate customized financial aid projections and reports.

●Trained staff on use of internal software and handled ongoing support and maintenance.

Earlier Roles (summary only)

●Linux and Web Development Instructor Computer Education Institute — Jun 2001 – Feb 2002

●Lead Software Engineer Epicor — Feb 2000 – Dec 2001

●Functional Integrity Test Engineer Western Digital — Jan 1998 – Dec 2000

●Computer Engineer Qualcomm — Nov 1996 – Sep 1997

●Computer Engineer U.S. Navy — Jan 1994 – Jan 1996

Technical Skills

●Cloud & Platforms:

AWS (EC2, S3, RDS, Lambda, CloudWatch, IAM), Snowflake (Query Profiler, Metadata Views, Snowpipe), Azure (basic), Databricks, Jenkins, Rundeck, Docker, Kubernetes

●Languages & Scripting:

Python, SQL / T-SQL, MySQL, JavaScript (dashboard enhancements, UI logic), Shell Script, XML, HTML, PERL, C#, Visual Basic, C++, Java, PHP, VBA, JSON

●Data Engineering & Pipelines:

ETL/ELT Design, Asynchronous Ingestion Strategies, dbt, Airflow, Snowpipe, Informatica TDM, Airbyte, API Integration (REST, internal APIs), Kafka, Kinesis, Jenkins Automation, Rundeck, Lambda Functions

●Databases & Storage:

Snowflake, Oracle, MySQL, SQL Server, NoSQL, MongoDB, Microsoft Access, Data Warehouses

●Modeling & Transformation Tools:

SQL, dbt, Power BI Data Modeling Layer, Snowflake Views & Schemas, SQLAlchemy, Pandas, NumPy, PySpark, Spark

●Security & Compliance:

PII Obfuscation (Informatica TDM, Faker), HIPAA, GDPR, Role-Based Access Control (RBAC)

●Monitoring, Logging & CI/CD:

Grafana, Jenkins, Git, GitHub Actions, GitLab, CloudWatch, Logging & Alerting Systems

●BI, Analytics & Visualization:

Power BI, Microsoft Power Apps, Power Automate, JavaScript (UI interactivity), Excel (VBA), Prescriptive & Predictive Modeling, Data Analysis & Reporting

●Operating Systems & Development Environments:

Linux (Debian, Red Hat, Ubuntu – incl. server setup), Windows, macOS, PyCharm, Visual Studio, Git

Education

●California Polytechnic State University – San Luis Obispo

B.S. in Computer Engineering / Computer Science / Electrical Engineering

●University of Phoenix

M.S. in Computer Information Systems

Certifications

●Certified Linux Engineer (LFCE)

●ITIL Practitioner

Contact this candidate