Jason Earl Lopez, Developer in New Berlin, WI, United States
Jason is available for hire
Hire Jason

Jason Earl Lopez

Verified Expert  in Engineering

Data Analytics and Visualization Developer

New Berlin, WI, United States

Toptal member since March 4, 2022

Bio

Jason is an experienced data and analytics architect specializing in projects involving the Microsoft BI Stack, Azure infrastructure, and a variety of data visualization tools. He has successfully implemented solutions in industries ranging from marketing and genetics to insurance and logistics. His curiosity and insight into business result in an intimate understanding of client needs and his technical expertise translates those needs into best-in-class products.

Portfolio

Neugen Health
SQL, Azure Logic Apps, Azure Data Factory, Azure Service Bus...
Neighborhood Analytics
Business Intelligence Development, SQL, Agile Development...
Skyline Technologies
SSAS Tabular, Business Intelligence Development, SSIS, Agile Development...

Experience

Availability

Part-time

Preferred Environment

DevOps, SQL, Microsoft Power BI, Azure Data Factory, Azure Cosmos DB, Azure Machine Learning, Tableau, CI/CD Pipelines, Visio, Microsoft PowerPoint

The most amazing...

...feedback I've received from clients is that I get them excited. I'm passionate about what I do and nothing's better than seeing that reflected by my clients.

Work Experience

Enterprise Data Architect

2020 - PRESENT
Neugen Health
  • Promoted from an SQL developer to a lead data architect within three months.
  • Developed a methodology to support a new analytics practice, including standard request flows, user training, accepted data science methodologies, dissemination, and situation report designs.
  • Took ownership of database development due to API performance issues. Proposed a new design pattern, led the development efforts, and successfully implemented the newly designed assets under budget and before the initial deadline.
  • Integrated a database development team seamlessly into SDLC.
  • Introduced the first organization analytics dashboard and Power BI data models.
  • Redesigned the entire database structure to support a member portal supporting up to 500,000 users.
  • Led data migration efforts and designed the infrastructure to capitalize on Azure services.
Technologies: SQL, Azure Logic Apps, Azure Data Factory, Azure Service Bus, Infrastructure as Code (IaC), Azure Resource Manager (ARM), Azure, Azure Machine Learning, SQL, SSIS, Business Intelligence Development, Visio, Embarcadero RAD Studio, SQL Server Profiler, Memory Optimization, OLAP, In-memory Databases, Database, CI/CD Pipelines, Build Pipelines, GitHub, UX Development, Microsoft PowerPoint, Data Modeling, APIs, DevOps, Dashboard, SQL Server, Linear Regression, Data Science, DAX, Data Science, Analytics Development, T-SQL (Transact-SQL), SQL, Scrum Master Consulting, Data Visualization, Architecture, Database Performance, Classification, Data Engineering, XML, ETL Tools, Healthcare Services, Healthcare & Insurance, Machine Learning, Azure, Database Design, Relational Databases, Database, API Connectors, Best Practices, ETL, Data Migration, Data-level Security, Excel Development, Data Architecture, Data Warehouse, Database, Logical Database Design, Database Schema Design, Business Intelligence Development, Reporting, Integration, Salesforce Design, Microsoft Power Apps, Office 365

Business Intelligence Architect

2020 - 2021
Neighborhood Analytics
  • Analyzed the existing database, ETL, and analytics infrastructure and processes.
  • Presented stakeholders with assessment conclusions and a framework for implementing recommended changes within one year.
  • Interfaced with the development team, business users, and stakeholders to conceptualize three enterprise-level Proof of Concept (POC) addressing organizational data and analytics needs.
  • Assisted organization in identifying and prioritizing project work related to infrastructure and development required for analytics product implementations affecting 10 departments.
  • Designed complex process flows, infrastructure diagrams, and data models for a final executive-level architecture proposal.
Technologies: Business Intelligence Development, SQL, Agile Development, Assessment Development, Risk Assessment, Findings & Recommendations Reports, Training, Proof of Concept (POC), Data Flows, Systems Analysis, Process Analysis, Project Estimation, Dashboard, SQL Server, DAX, Data Science, Analytics Development, T-SQL (Transact-SQL), Team Mentoring, Coaching, Budgeting Consulting, Data Visualization, Data Engineering, ETL Tools, Machine Learning, Azure, Database Design, Relational Databases, Database, ETL, Data-level Security, Excel Development, Data Architecture, Data Warehouse, Database, Logical Database Design, Database Schema Design, Business Intelligence Development, Reporting, CRM

Senior Analytics Engineer

2020 - 2020
Skyline Technologies
  • Developed short, medium, and long-term project goals that align with organizational strategic objectives.
  • Led the design and development of cloud-based solutions utilizing DevOps, Data Factory, Azure SQL, Azure Analysis Services, and Power BI.
  • Provided expertise and analytics to facilitate a well-informed decision-making process.
  • Developed presentations to explain and advocate for technical solution related to data and analytics.
  • Translated business requirements into technical specifications for project planning.
Technologies: SSAS Tabular, Business Intelligence Development, SSIS, Agile Development, DevOps, CI/CD Pipelines, BIML, Technical Requirements, UX Development, Presentations, Architecture, Azure Data Factory, Azure, Dashboard, SQL Server, DAX, Data Science, Analytics Development, T-SQL (Transact-SQL), Scrum Master Consulting, Budgeting Consulting, Data Visualization, Database Performance, Data Engineering, ETL Tools, Tableau Desktop Pro, Healthcare Services, Healthcare & Insurance, Azure, Database Design, Relational Databases, Database, API Connectors, ETL, Data Migration, Excel Development, Data Architecture, Data Warehouse, Database, Logical Database Design, Database Schema Design, Business Intelligence Development, Reporting, Integration, CRM, Office 365

Lead Business Intelligence Engineer

2017 - 2020
GMR Marketing
  • Designed enterprise cloud (Azure) infrastructure including database, ETL, semantic layer and data visualizations (SQL, Microsoft Data Transformation Services (now SSIS), Azure Data Factory, Azure Analysis Services, Tableau, and Power BI).
  • Gathered business requirements as baseline for the design of an analytics infrastructure for a new line of business.
  • Designed and implemented an automated and fully managed cloud ETL infrastructure using BIML framework, T4 templates, Microsoft Data Transformation Services (now SSIS), Azure Data Factory, and Azure Integration Runtime.
  • Designed an enterprise data warehouse, Data Marts, and data models to facilitate analysis across multiple functional areas.
  • Established standards defining the Cloud-based semantic data layer attributes, data governance, and presentation methodologies.
  • Devised, documented and drove implementation of short, medium, and long-term strategic goals.
  • Managed team workflow and projects within an Agile framework.
  • Built infrastructure diagrams, process flows, relationship models, and other documentation for stakeholder presentations to ensure business continuity.
Technologies: SQL, Azure Data Factory, SSAS Tabular, BIML, Planning, Budgeting Consulting, Coaching, SSIS, Presentations, Dashboard, SQL Server, Linear Regression, Data Science, DAX, Data Science, Analytics Development, T-SQL (Transact-SQL), SQL, Data Visualization, Database Performance, Classification, Data Engineering, XML, ETL Tools, Tableau Desktop Pro, Tableau Server, Funnel Analysis, Machine Learning, Azure, Database Design, Relational Databases, Database, API Connectors, Best Practices, ETL, Data Migration, Excel Development, Data Architecture, Data Warehouse, Database, Logical Database Design, Database Schema Design, Business Intelligence Development, Reporting

Neugen Analytics Practice Implementation

https://drive.google.com/drive/folders/1FbheUTkSD_G8D6ph-dQuv-FEJwFHjJ3v?usp=sharing
During this implementation, I was tasked with creating an analytics practice from the ground up. This included the design of the Software Development Life Cycle (SDLC), the creation of visualization standards, data modeling, CI/CD pipelines, and the implementation of Azure infrastructure.

Waukesha County COVID-19 Reporting Assessment

https://drive.google.com/drive/folders/1FproZMAtxVMh5dLLlRhFJaEUu-9ddfNs?usp=sharing
An assessment of a local municipality's COVID-19 reporting infrastructure, including data warehouse architecture, ETL processes, Power BI reporting, and workflow processes. The results of this assessment were presented as a detailed set of recommendations supplemented with information about the criticality of each and the ROI expected from implementing the prescribed changes.

Consumer Engagement Application & Analytics Initiative

https://docs.google.com/presentation/d/1iJ-3ieLQSmGK_ek9XZN4R6Sz0-NoMkIL/edit?usp=sharing&ouid=101185391971638225920&rtpof=true&sd=true
Designed an end-to-end solution to support a mobile application used to engage consumers to support the marketing funnel. The system included metadata-driven ETL via BIML, Azure SQL databases, Azure Data Factory pipelines, DevOps CI/CD, and an Azure Analysis Services tabular model. The result was a series of Tableau dashboards used to measure the results of A/B testing, provide insights into demographic-based marketing techniques, and manage the workflow of field marketing experts.
2002 - 2004

AASD in Software Applications and Programming

ITT Technical Institute - Greenfield, WI, USA

Tools

Visio, Microsoft PowerPoint, GitHub, Excel Development, Business Intelligence Development, Tableau Development, Azure Logic Apps, SQL Server Profiler, Tableau Desktop Pro, Microsoft Power Apps, Azure Machine Learning

Languages

SQL, T-SQL (Transact-SQL), BIML, XML, C#, R

Paradigms

Database Design, ETL, Business Intelligence Development, DevOps, OLAP, Agile Development, Scrum Master Consulting, Best Practices

Platforms

Azure, Salesforce Design, Azure Synapse

Storage

SQL, SSIS, Azure, SQL, Database Performance, SQL Server, Relational Databases, Database, Database, Database, SQL Server, In-memory Databases, Database, SSAS Tabular, Azure

Other

Azure Data Factory, UX Development, Data Modeling, Presentation Design, IT Projects, Architecture, Data Visualization, Assessment Development, Findings & Recommendations Reports, Technical Requirements, UX Development, Presentations, Analytics Development, Data Science, Dashboard, Data Engineering, ETL Tools, Healthcare Services, Healthcare & Insurance, Data Migration, Data Warehouse, Data Analysis, Database Schema Design, Reporting, Integration, Data Architecture, Data Warehouse, Logical Database Design, Data Analysis Consulting, Data Management, SSRS Reports, CI/CD Pipelines, Memory Optimization, Build Pipelines, Proof of Concept (POC), Process Analysis, Project Estimation, Planning, DAX, Data Science, Linear Regression, Classification, Tableau Server, Funnel Analysis, Machine Learning, API Connectors, CRM, Office 365, Data-level Security, Mobile Apps, Mobile Analytics, Azure Service Bus, Infrastructure as Code (IaC), Azure Resource Manager (ARM), Embarcadero RAD Studio, APIs, Software Development, Power Shell Commands, Risk Assessment, Training, Data Flows, Systems Analysis, Budgeting Consulting, Coaching, Team Mentoring, Goal-directed Design, Agile DevOps, Research & Investigation, Value Analysis, ROI, Google BigQuery

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring