2 of 7

Hello 👋🏼

K12 analytics engineer
20 years working in K12 + tech + data
Instructor for the Ed-Fi Academy
Misc other things

Marcos Alcozer

marcos@alcozer.dev

K12 Analytics Engineering

3 of 7

Alcozer Consulting

Alcozer Consulting is a boutique data shop specializing in deep impact work with a small number of clients.

Marcos and Zander are senior data engineers who can augment your team providing you with additional data engineering capacity.

We also offer a managed data platform, K12 Analytics Engineering, where we ingest data from all of your source systems (HR, SIS, assessment, etc) into a BigQuery instance.

4 of 7

K12 Analytics Engineering

School districts that leverage our managed data platform are given access to a BigQuery instance with their organization's data ready to be connected to a BI platform.

Our responsibilities:

Extract and load data from key source systems into a data lake
Transforming data from the data lake into a set of data marts in Google BigQuery
Work with your team to build out metrics
Training of FTE staff where desired
Maintain all infrastructure: Dagster, data lake, BigQuery, and dbt codebase
Optionally assist with data product creation in Looker Studio or Lightdash

Costs:

$3,500 annual infrastructure fee
$200 / hour

*District analytics engineer has full access to their BigQuery instance to load any additional data they need to as well as to connect Google Sheets

5 of 7

Managed data platform

SIS

Assessment

Misc

Data lake

Data warehouse

dbt

BI Platform

6 of 7

https://www.k12analyticsengineering.dev

7 of 7

Don't have an Ed-Fi certified SIS, use our Clever app!

Assessment

Misc

Ed-Fi API

Data lake

Data warehouse

dbt Cloud

Looker Studio

Ed-Fi Data Standard

dbt

BigQuery

SQL