Joe Bloom Email & Phone Number

Winchester, Va, Us

New York, Ny, Us

San Francisco, Us

Responsible for technical collaboration, architecture consultation, and end-user enablement toward the goal of optimal adoption of Census within the customer's data and analytics stack.DATA ENGINEERING: Data pipeline and architecture consultation and collaboration on ETL, real-time data pipelines, data engineering practices, monitoring, and orchestration with tools like Snowflake, Databricks, AWS, GCP, Airflow/Astronomer, Dagster, and Kafka.ANALYTICS ENGINEERING: dbt Cloud data transformation and modeling, semantic modeling in Looker/LookML. Version control via GitHub, GitLab, and Bitbucket.CUSTOMER SUCCESS: Co-create implementation and enablement plans for successful deployment of Census within the customer organization. Be the voice of the customer to the Product and Engineering teams as well as a strategic partner in considering how to continue to deliver tools our customers love and use to drive value.

Chicago, Il, Us

Responsible for data strategy, business intelligence, data architecture and engineering, and analytics engineering for 30k+ member nonprofit professional association. I was the founding data hire and I hired and managed two direct reports (who said I was the best manager they'd ever had 😊).DATA STRATEGY: Established AMA’s data practice from the ground up, including defining data strategy in partnership with executive leadership and the Board, data governance committees and processes, business analytics roadmap, Cloud architecture, change management and end-user training and support.BUSINESS INTELLIGENCE: Developed dashboards, reports, and data integrations for internal customers in Finance, Growth, Customer Success, Sales, Operations, Human Resources, Product, Partnerships, and Learning and Development. Procured and implemented Sigma Computing for internal and external (embedded) analytics and business intelligence, delivering near real-time dashboards and data exports for 50+ internal users and 300+ external users via secure dashboards embedded in WordPress.DATA ARCHITECTURE & ENGINEERING: Built a cloud data warehouse on AWS, utilizing an Extract-Load-Transform (ELT) strategy incorporating Fivetran for data ingestion, dbt Cloud to transform raw data into Kimball dimensional models. Maintained efficiency and governability via IaC (AWS CloudFormation + CircleCI), GitHub, dbt Slim CI, and dbt tests. Set up data ingestion pipelines to unify data from Salesforce, MailChimp, Sage Intacct, WordPress, WooCommerce, Google Analytics, and Qualtrics.ANALYTICS ENGINEERING: Developed data transformations via SQL and Jinja using dbt Cloud to clean, deduplicate, integrate, and aggregate data using techniques such as CTEs, analytic (window) functions, JSON parsing, pivots/unpivots, ranking, casting, lead/lag, and other advanced SQL.

Washington, D.C., Us

Responsible as a member of a five-person Scrum team for the enterprise data warehouse and business intelligence data, systems, and administration for a private nonprofit University with 13k faculty and staff and 500+ EDW users.DATA ARCHITECTURE & ENGINEERING: Worked with various lines of business to develop conceptual models for business processes and designed dimensional data models with ERwin Data Modeler according to Kimball methodology (The Data Warehouse Toolkit). Built ETL pipelines from operational data stores (stages) to Oracle data warehouse using Informatica PowerCenter, Informatica Developer, IDMC Cloud Services, and Talend. Managed orchestration of ETL jobs and Tableau data extracts.BUSINESS INTELLIGENCE: Integrated and modeled data within BI tools and created meaningful and intuitive data visualizations. Developed Tableau PDSs and dashboards via Tableau Desktop and published via Tableau Server. Administered user access and privileges. Implemented ThoughtSpot for AI-powered self-service BI, serving as the principal project manager, developer, and system architect and administrator.DATA GOVERNANCE: Contributed to data dictionaries and business glossaries across numerous domains (E.G. Finance, HR, Financial Aid, Enrollment Management, IT).DATA QUALITY: Ran data profiles using Informatica Analyst to ensure completeness, validity, and freshness of data from numerous operational sources.

Washington, D.C., Us

BUSINESS INTELLIGENCE: Created data models (Tableau PDSs, ThoughtSpot Worksheets, Cognos OLAP Packages) and data visualizations, reports, and dashboards in Tableau, ThoughtSpot, and IBM Cognos.DATA MODELING: Designed conceptual, dimensional, and physical models for the Enterprise Data Warehouse (EDW).DATA ENGINEERING: Developed ETL mappings to clean, standardize, aggregate, and join data from dozens of disparate sources to load fact and dimension tables within Kimball star schemas for analysts within the central BI team and throughout the University.

Herndon, Virginia, Us

DATA ANALYSIS: Consulted with stakeholders and higher ed data partners such as Achieving the Dream, Aspen Institute, and the Lumina Foundation to define business logic for educational progress and outcome metrics. Developed analysis programs using SAS Enterprise Guide to compute project-specific metrics and data features. Applied numerous techniques utilizing DATA step programming, PROC GLM, PROC FREQ, and PROC SQL to perform data standardization, normalization, weighting, cleansing, and imputation as needed to ensure the integrity of model output.

Winchester, Va, Us

WEB DEVELOPMENT: Built 75+ WordPress websites for SMB clients in retail, insurance, events, entertainment, restaurant, IT, construction, and healthcare industries.PROJECT MANAGEMENT: Conducted discovery, design, development, and delivery project phases utilizing an Agile approach utilizing Basecamp.

Middletown, Va, Us

DATA ANALYSIS: Extracted data from PeopleSoft SIS for analysis in SAS via DATA step programming and report scripting. Conducted a study of facilities utilization and course offerings by location in support of reaccreditation.EDUCATIONAL ASSESSMENT: Conducted student and alumni surveys, analyzed data with Excel, and presented results in annual reports. Administered student course assessments and aggregated and reported results. Consulted with departmental leaders on assessment frameworks via student learning outcomes (SLOs) and evaluation methods such as assessment testing, rubrics, and portfolios.

Harrisonburg, Virginia, Us

DATA ANALYSIS: Supported program assessment and first-year student assessment processes by assisting to administer, ingest, and analyze data from educational assessments/psychometrics tests.

Graduate Certificate, Data Science

Bachelor Of Science

Associate Of Arts & Sciences