Anthony Lopez
Austin,TX
Summary
Bilingual (English/Spanish) data analyst with 4+ years of experience delivering actionable insights and automating workflows across education, healthcare, and research sectors. Skilled in SQL, Power BI, Excel, and Python with a strong foundation in data visualization, performance tracking, and stakeholder reporting. Proven success in optimizing operations and translating complex data into business decisions. Actively seeking Sales Analyst or Operations Analyst roles where analytical rigor and business acumen drive impact.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Research Analyst I
North East Independent School District
04.2023 - Current
- Automated several manual reporting and data retrieval processes, improving efficiency and accuracy across departments.
- Developed interactive dashboards using Power BI and Excel for executive-level decision support and ad hoc analyses.
- Regularly queried internal databases using SQL to extract and prepare datasets for performance tracking.
- Created a district-wide Teacher Walkthrough survey in Qualtrics in collaboration with campus leadership.
- Produced dynamic boundary maps in ArcGIS Pro to model rezoning and school closure scenarios.
- Implemented Scribe as the team's documentation tool; authored most SOPs and step-by-step guides.
- Supported federal and state reporting by preparing detailed reports and collaborating with cross-functional stakeholders.
Project Manager
Zebra Strategies
05.2022 - 03.2023
- Led research project operations across timelines, milestones, and deliverables; ensured client satisfaction and timely execution.
- Created comprehensive project documentation, including schedules, progress reports, and stakeholder updates.
- Identified and mitigated operational risks with contingency planning and issue tracking.
- Designed and implemented quality control processes to uphold research integrity and client standards.
- Collaborated with cross-functional teams and clients to align expectations and deliver actionable insights.
Junior Scientist
Media Science
07.2020 - 04.2023
- Partnered with clients and PMs to develop research instruments aligned with media testing goals.
- Built and maintained a Google BigQuery database to centralize research data.
- Designed heatmaps and interactive dashboards using Python to deliver actionable viewer engagement insights.
- Conducted statistical tests on survey data and collaborated with senior scientists to present findings to clients.
- Managed end-to-end data cleaning, coding, and quality assurance for all survey data collected.
Research Area Specialist
UT Health San Antonio
07.2019 - 07.2020
- Ensured compliance with NIH research protocols by auditing and validating all incoming data.
- Led training for interns and staff on data entry and research best practices.
- Oversaw assessment scoring and implemented quality checks before database submission.
- Organized and executed community outreach for participant recruitment.
Education
Master of Arts - Psychological Research
Texas State University
Bachelor of Arts - Psychology
The University of Texas at San Antonio
Skills
- Data Tools: SQL, Power BI, Excel (PivotTables, VLOOKUP), Python (Pandas, NumPy), R, SPSS, Google BigQuery
- Visualization & Reporting: Power BI, Excel, ArcGIS Pro, Qualtrics, Google Sheets, Tableau
- Other: Scribe (SOP creation), Process Automation, KPI Tracking, Cross-functional Collaboration
Languages
Spanish
Native or Bilingual
Timeline
Research Analyst I
North East Independent School District
04.2023 - Current
Project Manager
Zebra Strategies
05.2022 - 03.2023
Junior Scientist
Media Science
07.2020 - 04.2023
Research Area Specialist
UT Health San Antonio
07.2019 - 07.2020
Bachelor of Arts - Psychology
The University of Texas at San Antonio
Master of Arts - Psychological Research
Texas State University
Similar Profiles
Gisela RochinGisela Rochin
District Translator at North East Independent School DistrictDistrict Translator at North East Independent School District
Shawna SchmidtShawna Schmidt
Art Instructor and Instructional Assistant at North East Independent School DistrictArt Instructor and Instructional Assistant at North East Independent School District
Kelly MorganKelly Morgan
Teacher at North East Independent School DistrictTeacher at North East Independent School District
JOSE MACEDOJOSE MACEDO
Trust and Safety at Accenture/WhatsappTrust and Safety at Accenture/Whatsapp
ALMASI TAYLORALMASI TAYLOR
Part-Time Barista and Bartender at BlackBird Books and SpiritsPart-Time Barista and Bartender at BlackBird Books and Spirits