Avishua Stein
Data Engineer
Work Experience
Preql
Brooklyn, New York, United States
January 2024 – Present
Lead Data Engineer
Preql is a data Saas company and I am the primary 'data person'! I wear many hats including data engineer, solutions architect, data analyst, product manager, and more!
Highlights
- Serve as subject matter expert for all things data, explaining data and analytics concepts to internal and client stakeholders including C-Suite execs, engineers, product managers, and designers of varying technical proficiency.
- Leverage my analytics experience to prioritize and implement new features for our no-code UI such as joins, unions, UDFs, and more based on feedback from existing and prospective clients.
- Develop Preql's internal analytics stack on Snowflake, AWS, Github & Github Actions, dbt, and dlt (data load tool) with Python, SQL, and Bash to provide reporting on app usage and dogfood new features.
- Work with clients to ensure Preql is providing maximum value and identify opportunities to add more value by developing new or changing existing features.
Brooklyn Data Co.
Brooklyn, New York, United States
January 2023 – December 2023
Consultant - Senior Data Engineer I
As a consultant at Brooklyn Data Co I advise on and implement solutions for our clients' most challenging data & analytics problems. I also provide technical mentorship and support for Brooklyn Data engineers across a variety of data and programming related domains.
Highlights
- Develop analytics stacks with AWS, GCP, Snowflake, Databricks, dbt, etc., for clients from scratch with an eye towards scalability, cost-effectiveness, and ease of use
- Use open source tools like Meltano and Github Actions set up free or extremely cheap ELT pipelines for clients, saving tens of thousands of dollars per month.
- Refactor a client's event data ingestion flow by optimizing ingestion, cloud storage, data warehouse, and query configurations, saving > $100,000 per year and reducing ingestion time from 12+ hours to 1 hour.
- Translate business problems into technical solutions, working cross-functionally with stakeholders and engineers to define and prioritize their analytics roadmaps, ensuring that requirements are met.
- Founded and lead Brooklyn Data's internal Data Engineering user group. Each week I would help engineers of all skill levels debug their code, give lessons on technology internals, and facilitate conversations around Data and Analytics Engineering.
Brooklyn Data Co.
Brooklyn, New York, United States
February 2022 – December 2022
Consultant - Data Engineer III
3Q Digital
New York, New York, United States
October 2020 – November 2021
Sr Analytics Engineer
At 3Q I develop and implement data solutions for our employees and clients, including Meta and LinkedIn.
Highlights
- Lead projects involving the automated ingestion, modeling, distribution, and visualization of client and third-party data.
- Develop API calls and optimize ETL processes using Matillion, Python, Amazon S3, Snowflake DB, and more.
- Create tools to automate internal processes such as QA, Project Management, and report distribution.
- Visualize data by creating interactive dashboards in Tableau and Python.
- Communicate with clients to manage project timelines, prioritize development work, and provide ongoing support.
3Q Digital
New York, New York, United States
March 2019 – October 2020
Analytics Engineer
AIM Specialty Health
Greater Chicago Area
February 2018 – November 2018
Business Information Analyst/ Developer
Reporting to the Director of Business Information, was responsible for developing ETL processes, analyzing data to solve business problems, and maintaining the DataMart.
Highlights
- Integrated data from clients, third-party providers, and other AIM departments into the DataMart, ensuring that all data was accurate and up to date.
- Employed ETL tools including SSIS, IBM DataStage, PowerShell and C# to pipeline data into team’s SQL Server DB for analysis.
- Conducted analyses of company data, utilizing SSMS, Sybase, Excel, SSIS, and Tableau.
- Performed SQL Server DBA responsibilities, including: Increasing database performance, setting up staging environments, troubleshooting dataflow and integrity issues, developing custom log files, and creating physical and logical data flow diagrams and documentation.
Binghamton Philosophy Club
August 2015 – December 2015
Founder and President
Awards
-
December 2017
Binghamton University Philosophy Department
Departmental Honors
I graduated with departmental honors in philosophy for writing and presenting my senior thesis, "Democracy and Epistemic Authority".
-
Binghamton University
Dean's List
Volunteer
December 2018 – October 2019
Data Analyst/ Developer
Education
-
2014 2017
Binghamton University
Bachelors
Philosophy and Economics Double Major
Skills
Databases/ Data Warehouses
Snowflake
BigQuery
Databricks
Redshift
SQL Server
MySQL
Postgres
ETL/ ELT
Data Modeling
Airflow
dbt
Github Actions
dlt
Meltano
Airbyte
Matillion
DataStage
SSIS
Cloud
Amazon Web Services (AWS)
Google Cloud Platform (GCP)
Heroku
Business Intelligence/ Data Visualization
Tableau
Looker
Mode
Plotly
Google Data Studio
Sisense
Qlik
Programming Languages
Python
SQL
JavaScript
Bash
Powershell
R
C#
Visual Basic (VBA)
Interests
🎸 Music/ Jamming/ Concerts
🤔 Philosophy, especially ethics & epistemology
📈 Economics, especially game theory & macroeconomics
🎮 Video/ Tabletop games
📖 Reading, especially sci-fi/ science & intellectual bios
🐱 My kitties Alfredo & Ziti