Denver Public Schools
ENGINEER, DATA
Denver Public Schools, Denver, Colorado, United States, 80285
OFFICE OF OPERATIONS
Traditional 235 work days per year
FTE: 1.0
Salary Range: $105,639 - $129,387
Applications will be received until November 8, 2024 . If the position is not filled by then, we may consider applications submitted after the deadline. Interested applicants must apply online by visiting the Denver Public Schools job board at careers.dpsk12.org
About this job:
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.
What DPS Offers You:
A Culture that values Equity, Accountability, Integrity, Collaboration and Fun with a shared vision that Every Student Will Succeed.Salary Range: $105,639 - $129,387. Click here for more information on compensation for these roles.In addition to competitive compensation, DPS has other Total Reward offerings such as; time off , health and wellness benefits , and PERA Retirement .What You'll Do:
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.What You'll Need:
High school diploma or equivalent required.Master's Degree in a quantitative discipline preferred.One (1) or more years of SQL experience and the ability to write basic Python tasks; experience in acquiring data from API's.Valid Colorado Driver's License, appropriate insurance coverage and acceptable driving record for the past three years.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.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.
Denver Public Schools is an Equal Opportunity Employer and does not discriminate on the basis of race, color, religion, sex (including pregnancy, gender expression, and sexual orientation), parental status, national origin, age, disability, genetic information (including family medical history), political affiliation, military service, or any other status protected by law or regulations. It is our intention that all qualified applicants be given equal opportunity and that selection decisions be based on job-related factors.
Traditional 235 work days per year
FTE: 1.0
Salary Range: $105,639 - $129,387
Applications will be received until November 8, 2024 . If the position is not filled by then, we may consider applications submitted after the deadline. Interested applicants must apply online by visiting the Denver Public Schools job board at careers.dpsk12.org
About this job:
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.
What DPS Offers You:
A Culture that values Equity, Accountability, Integrity, Collaboration and Fun with a shared vision that Every Student Will Succeed.Salary Range: $105,639 - $129,387. Click here for more information on compensation for these roles.In addition to competitive compensation, DPS has other Total Reward offerings such as; time off , health and wellness benefits , and PERA Retirement .What You'll Do:
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.What You'll Need:
High school diploma or equivalent required.Master's Degree in a quantitative discipline preferred.One (1) or more years of SQL experience and the ability to write basic Python tasks; experience in acquiring data from API's.Valid Colorado Driver's License, appropriate insurance coverage and acceptable driving record for the past three years.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.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.
Denver Public Schools is an Equal Opportunity Employer and does not discriminate on the basis of race, color, religion, sex (including pregnancy, gender expression, and sexual orientation), parental status, national origin, age, disability, genetic information (including family medical history), political affiliation, military service, or any other status protected by law or regulations. It is our intention that all qualified applicants be given equal opportunity and that selection decisions be based on job-related factors.