Analytics Engineer
Trevor Johnson
Professional Summary
Detail-oriented Analytics Engineer with hands-on experience building scalable ETL pipelines, designing business dashboards, and transforming complex data into actionable insights. Skilled in SQL, Python, Databricks, Power BI, and cloud platforms. Proven ability to drive data efficiency, lead teams, and deliver measurable business impact in fast-paced environments.
Work Experience
Software Engineering Instructor at TechBridge Education
-
Taught 80+ students Python, SQL, and Java with a focus on ML techniques such as Neural Networks and Regression. Designed adaptive curriculum for students with learning disabilities, improving comprehension by 75%. Gained strong experience in communicating complex data topics to non-technical audiences.
Software Engineer Intern at Innovexa Labs
-
Designed and optimized ETL pipelines using Azure Data Factory and Databricks, reducing processing time from 8 hrs to 4 mins (99.17% improvement). Created a centralized data warehouse for large-scale SQL/Scala data ingestion, enhancing data reliability and speed. Developed Power BI dashboards using custom DAX measures, improving report performance and interactivity by 20%. Led a team of 5 interns and collaborated with stakeholders to define data requirements and deliver a usable analytics product.
Data Analyst Intern at Brightlytics Inc
-
Cleaned and processed 20+ datasets using Python and Pandas, improving reporting turnaround and data accuracy. Applied Linear Regression and Random Forest models, achieving over 90% accuracy across various prediction tasks. Created compelling Power BI reports with executive-level summaries to support strategic decisions.
Education
Bachelor of Arts in Computer Science 6 Economics
California State University, Fullerton
-
Skills
Technical Skills
- Python
- SQL
- Java
- C++
- Scala
- Azure Data Factory
- Databricks
- Power BI
- Pandas
- DAX
- Microsoft Excel
- PostgreSQL
- MySQL
- MongoDB
- Firebase
- React
- Node.js
- RESTful APIs
- GitHub
- Jenkins
- Azure
- AWS
- GCP
- Agile (Scrum/Kanban)
- CI/CD
- Unit Testing
- Integration Testing
Soft Skills
- Detail-oriented
- Team Leadership
- Communication
- Collaboration
- Adaptability