Responsibilities
- Build and maintain dbt models transforming Bronze (raw) data into Silver (cleaned, validated) and Gold (business-ready) datasets.
- Write complex SQL transformations implementing business logic, aggregations, and education metrics.
- Implement performant transformation patterns including incremental models, snapshots, and SCDs.
- Apply dbt best practices for modularity, naming conventions, reuse, and performance optimization.
- Create reusable macros and patterns that accelerate future development.
- Partner with Data Platform Engineering to understand source structures and provide feedback on ingestion quality.
- Design and implement comprehensive dbt tests validating schema integrity, business logic, and data quality.
- Build data tests to detect anomalies, broken relationships, and unexpected changes.
- Partner with DataOps on automated testing execution and CI/CD integration.
- Monitor test results, investigate failures, and perform root-cause analysis.
- Proactively surface and address data quality risks before stakeholder impact.
- Gather and clarify requirements from academic, operations, finance, and state stakeholders
- Translate business questions into clear data model designs and technical specifications.
- Validate outputs with stakeholders to ensure accuracy, usability, and trust.
- Communicate how data is calculated, what it represents, and where limitations exist.
- Partner with Business Intelligence to ensure models support dashboards and reporting needs.
- Maintain clear documentation for dbt models, including business logic, sources, and usage guidance.
- Contribute to data dictionaries, lineage documentation, and the data catalog.
- Capture institutional knowledge to reduce dependency on individuals and support onboarding.
- Continuously improve SQL, dbt, and data modeling skills through practice and feedback.
- Build domain knowledge in K-12 education metrics and operational rhythms.
- Participate actively in code reviews, retrospectives, and team knowledge sharing.
- Identify technical debt and propose pragmatic improvements.
Requirements
- Strong SQL skills for analytical transformations and performance-aware querying.
- Hands-on experience with dbt (models, tests, macros, documentation).
- Solid understanding of analytical data modeling (facts, dimensions, temporal data).
- Experience working in Snowflake or similar cloud data warehouses
- Experience implementing and troubleshooting data quality checks.
- Bachelor’s degree in a quantitative or technical field, or equivalent practical experience
- 3+ years of experience in analytics engineering, data analytics, BI, or data engineering roles.
- Demonstrated experience building analytical data models and writing complex SQL.
- Experience translating business requirements into technical data solutions.
Nice to Have
- Experience with dbt Cloud, CI/CD concepts, or automated testing workflows.
- Familiarity with education data domains (enrollment, attendance, assessments).
- Exposure to BI tools and how data models support dashboards.
- Basic Python or scripting experience.
- Experience working across multiple regions or business units.
- Prior role explicitly focused on analytics engineering or data transformation.
- dbt Analytics Engineering certification or progress toward certification.
- Experience working in education, public sector, or regulated data environments.
Benefits
- medical, dental, and vision plans
- disability
- life insurance
- parenting benefits
- flexible spending account options
- generous vacation time
- referral bonuses
- professional development
- 403(b) plan
Work Arrangement
On-site
Team
Structure: Individual contributor role with no direct reports.
Additional Information
- Prolonged periods working on a computer
- Ability to participate in virtual meetings and stakeholder discussions
- Flexibility for occasional evening meetings with stakeholders across time zones
- Minimal travel (5–10% annually) for collaboration, stakeholder engagement, or campus context.
- Relocation stipend to defray the cost of moving for this role, if applicable.
