Jeffco Public Schools (Jeffco) is located in Jefferson County, Colorado. It is the second largest school district in Colorado serving 69,000 students across 155 schools. With 14,000 employees, the district is the largest employer in Jefferson County and has provided educational excellence for more than 70 years.

Jeffco embraces the spirit of the West and the natural beauty of the Rocky Mountain region with the county spanning more than 770 square miles running the length of the western edge of the Denver metropolitan area. The district is diverse in both population and geography, from urban to rural, including the mountain communities in the foothills west of Denver.

Overall, Jeffco has 31% of students that qualify for free and reduced lunch, an indicator of poverty, and 34% minority (25% Hispanic) student population. The district is implementing a new strategic plan, Jeffco Thrives 2025 that is focused on providing a world-class education that prepares all Jeffco students for bright and successful futures as local and global citizens. Come join us!

Jeffco Public Schools is a Single-State Employer. All candidates hired by Jeffco Public Schools must reside within the state of Colorado.

Sr Dev - Data Modeler
Annual Position
FLSA: Exempt
FTE: 1.00000 , Hours/Day: 8.000 , Days/Year: Year Round
Salary Plan, Grade, Step: Information Technology , N07, 1
Min-Mid Annual Salary Range: $89,415.00 - $107,136.00 Effective as of: 06-16-2022

**Annual salary noted above is based on an 8 hour day and full days worked calendar. Any position that is less than a full FTE/8 hours per day or late start will be prorated accordingly.

Certain Education Support Professional (ESP) jobs may include the value of holiday pay into the hourly rate. Review the Holiday in Rate column of the Education Support Professional Job Title, Wage Plan, Grade document.

The successful new hire or rehired candidate will be responsible to complete and incur the fingerprinting and processing fee of $54.50 through an appropriate fingerprinting vendor and the Colorado Bureau of Investigation, within 48 hours of offer acceptance.

SUMMARY: Oversee the data warehouse design, ingestion, modeling, and optimization. Ensure the warehouse and ingestion architecture are optimized for delivering highly performant reporting and analysis using objects and shared data sets. This includes highlighting opportunities to reduce cost and innovate by managing data sources and applying business rules to make data meaningful for Jeffco. Manage the technical governance of data structures and design standards for information delivery enterprise-wide.

ESSENTIAL DUTIES AND RESPONSIBILITIES include the following.

Design and implement data warehouse environments, schemas, and objects/measures.

Create, manage, and optimize the transformation of data within a warehouse.

Prepare and model data for marts, analytics, sharing, and visualizations.

Define and manage data methods and standards for ingestion, modeling, and sharing.

Design and implement data ingestion into lake/raw layer from API's, on premise application databases, and flat files.

Manage ongoing development to ensure the timely and accurate delivery.

Manage refresh and telemetry on data warehouse performance.

Effective collaboration with stakeholders directly and indirectly.

Demonstrate work ethic based on a strong desire to exceed expectations.

Perform other duties as assigned.

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

EXPERIENCE Five (5) years' of experience in warehouse and data modeling. Advanced knowledge of SQL. Experience working with cloud data tools and infrastructure (AWS, Azure, etc.). Experience with acquiring data from API's. Familiarity with Python, Airflow, Snowflake, Source Control (TFS, GitHub), and PowerBI. Ed-Fi data standard experience preferred.

EDUCATION AND TRAINING Bachelor's degree in a quantitative or technical field similar to Mathematics, Engineering, Sciences, or Operations Research. Master's degree preferred.

CERTIFICATES, LICENSES, REGISTRATIONS SnowPro certification preferred.

SKILLS, KNOWLEDGE, & EQUIPMENT Oral and written presentation and communication; interpersonal; system thinking; conflict resolution; and analytical and organizational skills. Ability to work and be collaborative and creative in new environments/markets. Effective and efficient working on and with technical teams both directly and indirectly. Ability to inform and guide senior leadership on key data management decisions. Ability to solve problems analytically. Knowledge of Agile devolvement process.

DECISION MAKING Requires detailed analysis and development of best-fit solutions. Ability to accurately develop queries and jobs to optimize performance. Ability to evaluate the impact and potential unintended consequences of queries and reports. Must ensure the protection of the Districts data following Board, State, and District guidelines. Errors could potentially result in substantial embarrassment and/or cost to the district.

COMMUNITY RELATIONS Daily contact with professional staff within the department to discuss routine internal matters. Work with internal stakeholders across all teams. Support and collaborate with external partners/vendors.

SPAN OF CONTROL This job has no supervisory responsibilities; however, this position assists in the interview process and screening of applicants.

EDUCATIONAL DELIVERY Provide reporting and dashboards that support both our academic and operational needs.

COMPLEXITY OF WORK The work is primarily directed by the Architect Central Data Systems to align with Jeffco Public Schools' strategic goals and operational needs. Requires independent judgment and thinking; interpretation of facts; technical and analytical skills; application of technical knowledge; and analysis of a situation/decision's impact on the District. Must be able to analyze, synthesize, gather information, calculate, and interpret information. Must have a strong ability to solve system problems.

The physical demands, mental functions, and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential duties of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

PHYSICAL DEMANDS While performing the duties of this job, the employee is regularly required to talk or hear. The employee is frequently required to stand; walk; sit; use hands to finger, handle, or feel; and reach with hands and arms. The employee is occasionally required to stoop, kneel, or crouch. The employee is frequently required to lift and/or move up to 10 pounds. The employee is occasionally required to lift and/or move up to 25 pounds. There are no specific vision requirements for this position.

MENTAL FUNCTIONS While performing the duties of this job, the employee is regularly required to compare, analyze, coordinate, compute, synthesize, evaluate, negotiate, instruct, copy and compile. The employee is frequently required to use interpersonal skills.

WORK ENVIRONMENT The noise level in the work environment is usually moderate.

Jeffco Salary Schedules

Jeffco Benefits

The Jefferson County School District does not discriminate on the basis of disability, race, color, creed, religion, national origin, age, sexual orientation, marital status, political affiliation, pregnancy, or gender.