Microsoft Power BI
ERNESTO GOMEZ
Sr. Business Intelligence And Analytics Engineer
Tucson,AZ
Summary
Knowledgeable Business Intelligence and Analytics Engineer with background in research and history of contributing to high-impact projects. Proven record in gathering, analyzing, and interpreting data to support decision-making processes. Demonstrated ability to utilize critical thinking and attention to detail in conducting comprehensive research.
Overview
13
13
years of professional experience
2
2
Certifications
2
2
Languages
Work History
Senior Business Intelligence Engineer
Phidiax
10.2023 - Current
- Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
- Enabled implementation of Microsoft Power BI, recommending appropriate solutions and aiding in corresponding onboarding processes.
- Created trainings and drafted technical documentation for business intelligence and analytics processes, incorporating factors such as technical design, data manipulation, ETL and storage management.
- Streamlined processes for increased efficiency through automation of data collection and analysis using SQL, Python, Microsoft Fabric Pipelines, and SQL Server Integration Services
Business Intelligence Engineer
Microsoft (Contract)
04.2022 - 10.2023
- Increased automation in reporting processes by designing dynamic dashboards using visualization tools like Tableau or Power BI.
- Evaluated emerging BI technologies and methodologies, recommending appropriate additions or improvements to existing systems.
- Corrected, modified and upgraded existing Power BI assets to improve performance leveraging best practices in data visualization, analytics data modeling, and DAX programming
- Estimated work hours and tracked progress using Scrum methodology.
Senior Data Analyst
Quicken
03.2021 - 03.2022
- Coordinated efforts to migrate and consolidate customer data into a unified repository in AWS
- Developed a classification model to identify customers at risk of cancellation
- Forecasted demand for support, agent attrition, work hours, and other critical metrics
- Managed Power BI and Tableau infrastructure and provided guidance to end users on Power BI Services
- Designed and conducted weekly training workshops for junior analysts
- Automated data extraction using Python, SQL, and AWS Athena
- Reduced manual data entry errors by designing and deploying automated ETL processes to transform raw data into usable formats.
- Contributed to overall organizational growth through continuous improvement of data analytics capabilities and processes.
- Served as a subject matter expert on various projects, sharing valuable insights derived from extensive industry experience as a Senior Data Analyst.
Business Intelligence Developer
Croptrak
12.2018 - 03.2021
- Evaluated emerging BI technologies and methodologies, recommending appropriate additions or improvements to existing systems.
- Improved data gathering, analysis, and visualization procedures with strategic optimizations.
Systems Analyst
Mister Car Wash
05.2018 - 12.2018
- Automated KPI tracking using advanced Excel macros and PowerQuery, reducing manual reporting efforts
Data Analyst
Cyracom
05.2016 - 05.2018
- Produced daily reports using advanced Excel spreadsheet functions
- Reduced report development time by 90% by creating Excel templates leveraging Power Pivot data models and DAX formulas
- Designed, deployed, and maintained SSAS tabular models in Azure
Administration and Marketing Coordinator/Board Secretary (Volunteer)
Grounded Wellness
03.2013 - 05.2013
- Spearheaded business process improvements and modernization projects, enhancing efficiency organization-wide
- Collaborated with marketing team to drive successful campaigns, resulting in a 60% increase in social media engagement
- Led efforts to secure Grounded Wellness' non-profit status, preparing and compiling a successful 5013c application
Research Specialist (Volunteer)
University of Arizona
07.2012
- Assisted a University of Arizona Psychology professor in preparing a statistics seminar for the University of Costa Rica
- Designed and structured seminar materials and slides for effective data visualization and engagement
- Strengthened data analysis and statistical communication skills, applicable to analytics and reporting
Industry Analyst
Arizona Dispensary Solutions
03.2012 - 07.2012
- Conducted stakeholder interviews to capture project requirements and business needs
Behavioral Health Technician
Providence of Arizona
10.2013 - 04.2016
- Collected, analyzed, and tracked patient data within an EHR system, ensuring accuracy and compliance with HIPAA regulations
- Designed and implemented data collection frameworks for behavioral health assessments, improving treatment effectiveness through structured analysis
- Developed data-driven reports to monitor patient progress, identify trends, and support evidence-based decision-making
- Evaluated program effectiveness using key metrics, optimizing four youth programs based on data insights
Education
Master of Science - Analytics
Capella University
03-2009
Bachelor of Arts - Psychology
University of Arizona
Tucson, AZ05-2009
Skills
Expertise in Power BI
Data Visualization Expertise
Database Querying
Proficient in Python
ETL Development Proficiency
Microsoft Fabric Expertise
Efficient Database Architecture
Performance Dashboard Refinement
Stakeholder Requirements Gathering
Development of Stakeholder Skills
Power BI tools
Python programming
Predictive analytics
Data Integration Proficiency
SQL and databases
Process Optimizatio
Certification
Microsoft Certified: Power BI Data Analyst Associate, Microsoft, 05/01/22
Publications
A Life History Approach to the Dynamics of Social Selection, Evolutionary Perspectives on Social Psychology
Software
Microsoft Fabric Pipelines
Tableau
Excell
Languages
English
Native or Bilingual
Spanish
Native or Bilingual
Timeline
Senior Business Intelligence Engineer
Phidiax
10.2023 - Current
Business Intelligence Engineer
Microsoft (Contract)
04.2022 - 10.2023
Senior Data Analyst
Quicken
03.2021 - 03.2022
Business Intelligence Developer
Croptrak
12.2018 - 03.2021
Systems Analyst
Mister Car Wash
05.2018 - 12.2018
Data Analyst
Cyracom
05.2016 - 05.2018
Behavioral Health Technician
Providence of Arizona
10.2013 - 04.2016
Administration and Marketing Coordinator/Board Secretary (Volunteer)
Grounded Wellness
03.2013 - 05.2013
Research Specialist (Volunteer)
University of Arizona
07.2012
Industry Analyst
Arizona Dispensary Solutions
03.2012 - 07.2012
Master of Science - Analytics
Capella University
Bachelor of Arts - Psychology
University of Arizona