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

Location
New Berlin, WI, United States
Toptal Member Since
March 4, 2022

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
Azure SQL, Azure Logic Apps, Azure Data Factory, Azure Service Bus...
Neighborhood Analytics
Microsoft Power BI, SQL, Agile, Assessment Development, Risk Assessment...
Skyline Technologies
SSAS Tabular, Microsoft Power BI, SQL Server Integration Services (SSIS), Agile...

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: Azure SQL, Azure Logic Apps, Azure Data Factory, Azure Service Bus, Infrastructure as Code (IaC), Azure Resource Manager (ARM), Azure Cosmos DB, Azure Machine Learning, SQL, SQL Server Integration Services (SSIS), Microsoft Power BI, Visio, Embarcadero RAD Studio, SQL Server Profiler, Memory Optimization, OLAP, In-memory Databases, OLTP, CI/CD Pipelines, Build Pipelines, GitHub, Process Flows, Microsoft PowerPoint, Data Modeling, APIs, DevOps, Dashboards, Microsoft SQL Server, Linear Regression, Data Science, DAX, Data Analytics, Analytics, T-SQL (Transact-SQL), SQL Stored Procedures, Scrum, Data Visualization, Architecture, Database Performance, Classification, Data Engineering, XML, ETL Tools, Healthcare Services, Healthcare & Insurance, Machine Learning, Azure, Database Design, Relational Databases, Databases, API Connectors, Best Practices, ETL, Data Migration, Data-level Security, Microsoft Excel, Data Architecture, Data Warehouse Design, Database Architecture, Logical Database Design, Database Schema Design, Business Intelligence (BI), Reporting, Integration, Salesforce, 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: Microsoft Power BI, SQL, Agile, Assessment Development, Risk Assessment, Findings & Recommendations Reports, Training, Proof of Concept (POC), Data Flows, Systems Analysis, Process Analysis, Project Estimation, Dashboards, Microsoft SQL Server, DAX, Data Analytics, Analytics, T-SQL (Transact-SQL), Team Mentoring, Coaching, Budgeting, Data Visualization, Data Engineering, ETL Tools, Machine Learning, Azure, Database Design, Relational Databases, Databases, ETL, Data-level Security, Microsoft Excel, Data Architecture, Data Warehouse Design, Database Architecture, Logical Database Design, Database Schema Design, Business Intelligence (BI), Reporting, Customer Relationship Management (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, Microsoft Power BI, SQL Server Integration Services (SSIS), Agile, DevOps, CI/CD Pipelines, BIML, Technical Requirements, User Requirements, Presentations, Architecture, Azure Data Factory, Azure SQL Databases, Dashboards, Microsoft SQL Server, DAX, Data Analytics, Analytics, T-SQL (Transact-SQL), Scrum, Budgeting, Data Visualization, Database Performance, Data Engineering, ETL Tools, Tableau Desktop Pro, Healthcare Services, Healthcare & Insurance, Azure, Database Design, Relational Databases, Databases, API Connectors, ETL, Data Migration, Microsoft Excel, Data Architecture, Data Warehouse Design, Database Architecture, Logical Database Design, Database Schema Design, Business Intelligence (BI), Reporting, Integration, Customer Relationship Management (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: Azure SQL, Azure Data Factory, SSAS Tabular, BIML, Planning, Budgeting, Coaching, SQL Server Integration Services (SSIS), Presentations, Dashboards, Microsoft SQL Server, Linear Regression, Data Science, DAX, Data Analytics, Analytics, T-SQL (Transact-SQL), SQL Stored Procedures, Data Visualization, Database Performance, Classification, Data Engineering, XML, ETL Tools, Tableau Desktop Pro, Tableau Server, Funnel Analysis, Machine Learning, Azure, Database Design, Relational Databases, Databases, API Connectors, Best Practices, ETL, Data Migration, Microsoft Excel, Data Architecture, Data Warehouse Design, Database Architecture, Logical Database Design, Database Schema Design, Business Intelligence (BI), 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, Microsoft Excel, Microsoft Power BI, Tableau, 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 (BI), DevOps, OLAP, Agile, Scrum, Data Science, Best Practices

Platforms

Azure, Salesforce, Azure Synapse

Storage

Azure SQL, SQL Server Integration Services (SSIS), Azure SQL Databases, SQL Stored Procedures, Database Performance, Microsoft SQL Server, Relational Databases, Databases, Database Architecture, Data Pipelines, SQL Server Reporting Services (SSRS), In-memory Databases, OLTP, SSAS Tabular, Azure Cosmos DB

Other

Azure Data Factory, Process Flows, Data Modeling, Presentation Design, IT Projects, Architecture, Data Visualization, Assessment Development, Findings & Recommendations Reports, Technical Requirements, User Requirements, Presentations, Analytics, Data Analytics, Dashboards, Data Engineering, ETL Tools, Healthcare Services, Healthcare & Insurance, Data Migration, Data Warehousing, Data Analysis, Database Schema Design, Reporting, Integration, Data Architecture, Data Warehouse Design, Logical Database Design, Data Analysis Consultant, Data Management, SSRS Reports, CI/CD Pipelines, Memory Optimization, Build Pipelines, Proof of Concept (POC), Process Analysis, Project Estimation, Planning, DAX, Linear Regression, Classification, Tableau Server, Funnel Analysis, Machine Learning, API Connectors, Customer Relationship Management (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, 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