ENGINEER, DATA

ENGINEER, DATA (JOB ID: 65013)

OFFICE OF OPERATIONS

Traditional 235 work days per year

FTE: 1.0

Salary Range: $103,567 - $126,851

Essential Functions and Objectives:

Responsible for ingesting critical District data from applications and other sources into a warehouse environment and preparing the data for consumption using an Extract Load Transform (ELT) methodology. Data preparation includes transformation based on District specific practices and the generation of structures that are highly available and highly performant. Ensure consistent use of best practices and support accuracy and optimized performance across the data platform.

• Prototype data solutions to enable warehousing, event-driven data capture, and data modeling.
• Implement solutions using Extract Load Transform (ELT/ETL) and/or combinations of automation tools.
• Collaborate with data teams to develop reusable data solution patterns to enable quick to market data assets.
• Analyze & profile business data in structured and unstructured formats.
• Design and implement conceptual and logical data models, create metadata definitions, and create a source-to-target mapping.
• Evaluate tools and emerging technologies within the data ecosystem to push innovation.
• Collaborate with data owners, functional teams, and data consumers to understand the end-to-end intention of data use.
• Optimize data performance throughout the ELT process.
• Demonstrate Students First, Integrity, Equity, Collaboration, Accountability, and Fun in all interactions with team members, other DPS employees and external partners.

Knowledge, Experience & Other Qualifications:

• One (1) or more years of SQL experience and the ability to write basic Python tasks; experience in acquiring data from APIs.
• Valid Colorado Driver’s License, appropriate insurance coverage and acceptable driving record for the past three years, if the position requires travel.
• Effective time management and organizational skills.
• The ability to take responsibility for one’s own performance.
• Works collaboratively with others on a team.
• High degree of integrity in handling confidential information.
• Aptitude for variety and changing expectations in a fast-paced environment.
• Ability to work in a multi-ethnic and multicultural environment with district and school leaders, faculty, staff and students.
• Experience working within a cloud based data infrastructure.
• Advanced proficiency in developing SQL queries preferred.
• Effective communication skills.
• Analytical problem solver with strong attention to detail.
• Experience with or ability to quickly learn new tools and technologies including dbt, Snowflake, Airflow, AWS S3.

Education Requirements:

• Bachelor’s Degree in related Quantitative Field (e.g. Mathematics, Engineering, Sciences, Operations Research) required.

Other Information:

• Employee must live and work with a permanent home address in Colorado while working for Denver Public Schools.

About Denver Public Schools:

Denver Public Schools is committed to meeting the educational needs of every student with great schools in every neighborhood. Our goal is to provide every child in Denver with rigorous, enriching educational opportunities from preschool through high school graduation. DPS is comprised of nearly 200 schools including traditional, magnet, charter and alternative pathways schools, with an enrollment of more than 90,000 students.

DPS has become the fastest-growing school district in the country in terms of enrollment and the fastest-growing large school district in the state in terms of student academic growth. Learn more at dpsk12.org.