ENGINEER, DATA
Denver, CO, United States
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:
The mission of the DPS Department of Technology Services (DoTS) is to be a proactive partner enabling the success of every child. We support the students, families, and staff of Denver Public Schools by providing the infrastructure, tools, data, and support to enable effective educators and efficient operations. Our leading-edge technology work includes delivering custom portals for our students, parents, teachers, and administrators, managing one of the largest networks in the state of Colorado, providing unparalleled levels of customer support, finding new ways to get technology in the hands of our students, and much more. We believe that technology is a positive, enabling force for parent engagement, student engagement, educator effectiveness, operational efficiency, student safety, and student achievement. By joining us, you too will be enabling the success of every child!
Additional Information:
Work Year Calendars (including accrued time off): http://thecommons.dpsk12.org/Page/1129
Benefits (including DPS contributions): http://thecommons.dpsk12.org/Page/1397
Compensation Structures: http://thecommons.dpsk12.org/Page/244
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.
Denver Public Schools is an Equal Opportunity Employer and does not discriminate on the basis of race, color, religion, national origin, sex, sexual orientation, age, disability, or any other status protected by law or regulation. It is our intention that all qualified applicants be given equal opportunity and that selection decisions be based on job-related factors.
#J-18808-Ljbffr