Senior Data Architect & Reporting Solutions D

Datavault AI Inc. • Philadelphia, PA

8d • Remote

About The Position

We are seeking a Senior Data Architect & Reporting Solutions Designer to define and build the next‑generation data foundation that powers enterprise analytics, operational reporting, and strategic decision‑making. This role blends deep expertise in data architecture, production‑grade ETL/ELT engineering, and reporting design, ensuring that data is modeled, transformed, and delivered with reliability, clarity, and scale. You will architect end‑to‑end data ecosystems—from ingestion pipelines to semantic layers—while shaping how data is presented through enterprise reporting platforms.

Requirements

• 5+ years in data architecture, data engineering, or enterprise reporting design.
• Strong expertise in:
• Data modeling (relational, dimensional, semantic)
• SQL and NoSQL systems
• ETL/ELT pipeline design
• Cloud data platforms (AWS, Azure, or GCP)
• Hands‑on experience with:
• Data warehouses (Snowflake, Redshift, BigQuery)
• Orchestration frameworks (Airflow, Dagster, dbt)
• Streaming systems (Kafka, Kinesis, Pub/Sub)
• Enterprise BI tools (Power BI, Tableau, Looker, etc.)
• Deep understanding of data governance, security, and compliance frameworks.
• Ability to translate business requirements into scalable data and reporting architectures.

Nice To Haves

• Experience designing semantic layers and enterprise reporting models.
• Background in high‑volume data environments or event‑driven architectures.
• Familiarity with metadata management, data catalogs, and lineage tools.
• Experience supporting finance, marketing, operations, or product analytics teams.

Responsibilities

• Data Architecture & Modeling
• Architect scalable, secure, and high‑performance data environments across cloud and on‑prem systems.
• Design logical and physical data models for operational reporting, analytics, and executive dashboards.
• Build semantic layers, dimensional models, and data marts optimized for BI consumption.
• Define data standards, modeling conventions, and architectural patterns that ensure long‑term maintainability.
• Production‑Grade ETL/ELT Engineering
• Design and implement automated, resilient, and low‑maintenance ETL/ELT pipelines for batch and streaming data.
• Build ingestion and transformation workflows using tools such as Airflow, dbt, Spark, Kafka, or similar frameworks.
• Implement robust data‑quality checks, schema evolution strategies, and lineage tracking.
• Optimize pipelines for performance, cost efficiency, and operational reliability.
• Reporting Architecture & Data Presentation
• Shape data structures specifically for reporting, dashboarding, and self‑service analytics.
• Partner with business stakeholders to translate reporting needs into scalable data models and curated datasets.
• Define KPI frameworks, metric definitions, and standardized reporting logic across the organization.
• Ensure data is presented in a way that is intuitive, consistent, and aligned with business objectives.
• Enterprise Reporting Integration
• Integrate and manage enterprise‑grade BI platforms (Power BI, Tableau, Looker, Qlik, MicroStrategy, etc.).
• Architect secure, performant data connections, refresh strategies, and semantic models.
• Collaborate with analysts and business teams to design dashboards, reports, and analytic workflows.
• Implement governance around report lifecycle management, versioning, and access control.
• Data Governance, Security & Compliance
• Define and enforce data governance frameworks including cataloging, lineage, retention, and stewardship.
• Implement privacy‑by‑design principles and ensure compliance with regulatory requirements.
• Architect secure data‑exchange mechanisms using encryption, tokenization, and role‑based access controls.
• Technical Leadership
• Provide architectural guidance to data engineering, analytics, and reporting teams.
• Evaluate emerging technologies in data modeling, ETL automation, BI tooling, and metadata management.
• Produce architecture diagrams, data flow documentation, and technical specifications.
• Champion best practices for data quality, modeling, and reporting across the organization.

Benefits

• Competitive compensation and benefits.
• Influence over the architectural direction of a modern enterprise data platform.
• Opportunities to work with advanced data modeling, ETL automation, and BI technologies.
• A culture that values technical rigor, ownership, and innovation.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed
• Number of Employees: 11-50 employees