Lance Gonzalez
Kirkland,WA
Summary
Advanced Data Engineer with deep knowledge of Snowflake, DBT, Corporate Data Models, Tableau, and MicroStrategy. Experienced in translating business needs into technical requirements as well as communicating effectively with both technical and business leads. Routinely tapped to work on some of Sunrun's hardest, most ambiguous data platform challenges. Frequently consulted by analysis leadership regarding people and process matters.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Staff Data Enginner/BI Architect
Sunrun
06.2016 - Current
- Routinely flex into Sunrun's most critical SNF/DBT/Tableau/Modelling data platform issues
- Design and implement automated administration framework for 11,000+ user Tableau Cloud instance
- Train and consult on Tableau & MicroStrategy dashboards and best practices
- Manage key corporate reporting tables and lead rollout to a community of ~100 analysts
- Design and implement administration framework for 500+ user MicroStrategy instance as well as architect a semantic layer in MicroStrategy used for reporting
- Transform and create numerous tables and views in Snowflake to support end-user reporting in BI tools
- Help design an effective Agile flow (JIRA) for a team of ~20 analytics engineers.
- Manage data platform intake (JIRA Tickets/Grooming) for senior analytics leaders across Sunrun.
- Manage rollout for a widely praised analyst center of excellence (office hrs, best practices, etc).
- Lead vetting process for new BI tools, gather business feedback, and coordinate with vendors.
- Streamline complex workflows by breaking them down into manageable components for easier implementation and maintenance.
Senior Data Analyst
Vivint Solar (Acquired By Sunrun)
01.2015 - 06.2016
- Used SQL and VBA to create automated reports sent out to 200+ users.
- Created presentations for VPs and C-Level execs
- Collaborated with stakeholders to identify business needs and data sources.
- Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
Solar Interconnection Supervisor
Vivint Solar (acquired By Sunrun)
07.2013 - 01.2015
- Led a team of 10 employees and 2 team leads.
- Monitored workflow to improve employee time management and increase
productivity. - Maintained relationships with Utility Companies to ensure quick processing of documents.
- Evaluated employee performance and coached to improve weak areas during monthly one-on-ones.
- Coordinated with Customer Service and Design Engineering teams to resolve complicated customer issues.
Education
Bachelor of Science - Information Systems, Business Intelligence Systems
Utah Valley University
Orem, UT05-2025
Associate of Science - Information Systems/Technology
Utah Valley University
Orem, UT05.2023
Skills
- SQL
- Snowflake
- BI Tool Visualization (Tableau/MicroStrategy)
- BI Tool Administration (Tableau/MicroStrategy
- dbt
- Python Automation
- Data/Visualization Consulting
Certification
- Certificate of Proficiency - Information Systems and Technology - Utah Valley University - Sept 2021
- Certificate of Proficiency - Foundations of App Development - Utah Valley University - June 2022
Accomplishments
- Gave presentation at MicroStrategy's worldwide conference in 2020 on how to build an effective admin dashboard
Timeline
Staff Data Enginner/BI Architect
Sunrun
06.2016 - Current
Senior Data Analyst
Vivint Solar (Acquired By Sunrun)
01.2015 - 06.2016
Solar Interconnection Supervisor
Vivint Solar (acquired By Sunrun)
07.2013 - 01.2015
Bachelor of Science - Information Systems, Business Intelligence Systems
Utah Valley University
Associate of Science - Information Systems/Technology
Utah Valley University
Similar Profiles
Earnest GreenEarnest Green
Field Service Technician at SunrunField Service Technician at Sunrun
Mark PlentyMark Plenty
Appointment Setter at SunrunAppointment Setter at Sunrun
Lucy MillerLucy Miller
Customer Service Representative at SunrunCustomer Service Representative at Sunrun