1 month ago
Base Salary
$175k - $215k/yr
Responsibilities
- Own analytics data products across internal business functions.
- Design and maintain reusable intermediate models, gold models, metrics, access controls, tests, documentation, and Lightdash agent guidance.
- Turn stakeholder ideas into production data products by defining requirements, validating results, and publishing them.
- Reconcile conflicting concepts across source systems and document mappings, unmatched records, assumptions, and quality checks.
- Deliver production changes using SQL, dbt tests, Lightdash metadata, access rules, content validation, and AI-agent instructions.
- Diagnose incorrect or stale results across data layers and partner with data engineering on underlying issues.
- Review modeling changes, pair with teammates, and help maintain shared standards.
Requirements
- 5+ years of analytics engineering or equivalent experience, including contribution to a production dbt project with tests, CI, incremental models, and documentation.
- Strong dimensional modeling judgment, including designing conformed entities and facts at the correct grain and resolving conflicting source-system definitions.
- Experience delivering a metrics or semantic layer used by people and tools with safe access controls for sensitive data.
- Regular hands-on use of AI coding agents, including verifying their output and recognizing when they are inappropriate.
- Strong SQL skills and enough Python experience to understand existing pipelines and build transformation tasks.
- Clear technical writing and commitment to treating model documentation and metric definitions as part of the data product.
- Lightdash or another code-managed semantic layer experience is preferred.
- AWS knowledge and familiarity with Athena, Iceberg, and Spark are preferred.
- Experience with legal, private equity, or financial-services data, including restricted or client-sensitive information, is preferred.
- Experience setting standards or mentoring on a small team is preferred.
Benefits
- Base salary of $175,000 to $215,000 per year, plus equity.
- 401(k) with employer match and health, dental, and vision coverage.
- Unlimited paid time off, free lunch in the office daily, and an employee referral bonus program.
- Financial relocation support for moving to New York City.
- Hybrid work model in New York City with an expectation of 3–4 days per week in the office.
Tech Stack
Categories
Data Engineering
About Norm AI
Norm AI builds regulatory and legal AI products that let compliance teams and lawyers design and supervise domain-specific agents for high-stakes, regulated work. It sells software and services to major financial institutions and other large enterprises; its client base represents over $30 trillion in combined assets under management. Founded in 2023 and headquartered in New York, the privately held company also powers Norm Law, an affiliated AI-native law firm for institutional clients.