Analytics Engineer (26-27)

IDEA Public Schools • El Paso, TX

56d • $89,600 - $105,300

About The Position

Analytics Engineer
This is a vacancy for the 26-27 school year with a target start date of July 1, 2026
Mission:
The Analytics Engineer transforms raw data into trusted, business-ready datasets that drive decision-making and student outcomes across IDEA’s multi-state network. This role uses dbt and Snowflake to build clean, well-tested Silver and Gold data models that power dashboards, reporting, and analytics used by educators and leaders.

Reporting to the Manager of Analytics Engineering, this role combines strong technical execution (SQL, dbt, data modeling, testing) with business partnership—translating real stakeholder needs into reliable, well-documented data products.
Supervisory Responsibilities:
Individual contributor role with no direct reports.
Location:
This is a full-time position based in Texas, with preference given to candidates who live in Austin, El Paso, Houston, Permian Basin (Midland/Odessa), Rio Grande Valley, San Antonio, and Tarrant County (Fort Worth), or who are willing to relocate.
Travel Expectations:
Minimal travel (5–10% annually) for collaboration, stakeholder engagement, or campus context.

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 Haves

• 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.

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.

Benefits

• medical, dental, and vision plans, disability, life insurance, parenting benefits, flexible spending account options, generous vacation time, referral bonuses, professional development, and a 403(b) plan
• relocation stipend to defray the cost of moving for this role, if applicable

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 501-1,000 employees