Juli Beirio

Aurora, CO

ad256a@r.postjobfree.com

720-***-****

Profile

●Driven Data Engineer focused on automating data pipelines for analytics teams

●Learning and applying new technologies quickly

●Experienced in working with stakeholders and leadership teams to set expectations and maintain visibility into progress

Experience

Zayo Group – Data Engineer – October 2020-Present

●Write and automate complex SQL queries to ETL data from Salesforce and other sources in Azure data lake into Snowflake

●Build ETL pipelines in Azure Data Factory, and create linked services to different data sources for the team to connect to for their jobs

●Star schema modeling of Sales and Finance data marts in Snowflake to drive dashboards and reports in PowerBI and Tableau

●Write SQL queries and Stored Procedures in Snowflake to transform and aggregate data in Snowflake for reporting in PowerBI and Tableau

●Create pyspark jobs on Azure Databricks to ingest data from cloud storage and train models for Data Science.

●Create SQL framework for the team to use in building Azure Data Factory pipelines

●Perform data quality checks for the migration from on premises SQL Server to Azure-Data Lake and Snowflake(write SQL scripts to compare reports from both sources and report/fix the discrepancies)

●Use Python to manipulate and load data

●Write SQL queries for ETL jobs to load data from source systems(Workday, Netsuite, Salesforce, internal applications) into Snowflake

●Migrate SSIS packages to Azure Data Factory

●Migrate SSRS reports to PowerBI

●Troubleshoot problems in the data(missing records, adding new filters, rerunning failed data loading jobs)

●Gather requirements for new reports and data integrations

●Create documentation for solutions I have deployed

●Exploration and validation of new data sources

EPIQ Global - Business Intelligence Analyst, Sales Operations - January 2019 - October 2020

●Write and automate complex SQL queries to ETL data from Salesforce and other sources in AWS S3 and Azure data lake into Snowflake(some clients used BigQuery or Redshift)

●Build ETL pipelines in Azure Data Factory to load Snowflake

●Build star schema data marts in Snowflake for reporting in PowerBI and Tableau

●Create reports and dashboards in PowerBI and Tableau for Sales and Finance partners

●Use Excel for Mapping

●Gather requirements for new reports and data integrations

●Create documentation for solutions I have deployed

●Exploration and validation of new data sources

Luxury Flow – Business Intelligence Analyst – July 2015-January 2019

●Write SQL queries and Stored Procedures using Snowflake and SQL Server Management Studio to transform and aggregate data in Azure SQL DB and Snowflake for reporting in PowerBI, Excel and Tableau

●Write SQL queries for ETL jobs to load data from source systems(Workday, Netsuite, Salesforce, Marketo, internal applications) into Snowflake

●Advanced Excel analysis(pivot tables, VLOOKUP, charts)

●Build and automate SSRS/PowerBI/Tableau reports for Sales, Finance, and Executive teams( Month-over-month Revenue/Sales reports, budget vs. actual variance reporting,

●Troubleshoot problems in the data(missing records, adding new filters, rerunning failed data loading jobs)

●Perform data quality checks for the migration from on premises SQL Server to Azure-SQL(compare reports from both sources and report the discrepancies)

●Automate queries and Stored Procedures using the Alteryx, SSIS, Azure SQL Agent

●Work with report consumers on Sales and Finance teams to define requirements for reporting(data sources, output format, update frequency, etc)

●Use git for version control and code reviews of SQL queries

●Use JIRA to track project status

●Working in Agile environment

●

Education

University of Cartagena, Bachelor’s of Finance - July 2016

University of Cartagena, Bachelor’s of International Business - July 2016

Contact this candidate