City and County of Denver
Associate IT Data Architect - Denver International Airport
City and County of Denver, Denver, Colorado, United States, 80285
About Our Job
With competitive pay, great benefits, and endless opportunities, working for the City and County of Denver means seeing yourself working with purpose - for you, and those who benefit from your passion, skills and expertise. Join our diverse, inclusive and talented workforce of more than 11,000 team members who are at the heart of what makes Denver, Denver.
What We Offer
The City and County of Denver offers competitive pay commensurate with education and experience. New hires are typically brought into the organization between $95,000 - $125,000/year. We also offer generous benefits for full-time employees which include but are not limited to: A guaranteed life-long monthly pension, once vested after 5 years of service 457B Retirement Plan 140 hours of PTO earned within first year + 12 paid holidays, 1 personal holiday, 1 wellness day, and 1 volunteer day per year Competitive medical, dental and vision plans effective within 1 month of start date The City and County of Denver has announced furlough days, or unpaid days off, for most employees to meet a budget shortfall in 2025. There are two fixed furlough days for all limited (temporary positions with an end date) and unlimited (permanent) employees on August 29th, the Friday before Labor Day, and November 28th, the day after Thanksgiving. If you receive an offer for this position, your annual pay will determine whether you are required to take additional furlough days. Details will be discussed during the offer process for selected candidate(s).
Location
The City and County of Denver supports a hybrid workplace model. Employees work where needed, at a job site several days a week and off-site as needed. Employees must work within the state of Colorado on their off-site days.
In this position you can expect to work on site at least two days per week at the Denver International Airport (Concourse A).
Who We Are & What You'll Do
Denver International Airport (DEN) is the third-busiest airport in the United States and one of the top ten busiest airports in the world, connecting our community globally through flight and business. DEN is the primary economic engine for the state of Colorado, generating more than $47.2 billion for the region annually and employing nearly 37,000 people. At DEN, we are committed to fostering a diverse, inclusive and equitable workplace. We celebrate individuality and uplift all races, ethnicities, gender identities, national origins, ages, abilities, religion, and LGBTQIA+ communities. We know that our diversity makes us stronger, and we strive to keep diversity, equity and inclusion at the center of all that we do.
Denver International Airport is looking for an Associate IT Data Architect to join our Business Technologies team. This position will support the Business Intelligence team with both on-premises and cloud data warehouse management and implementation.
Specifically, as the Associate IT Data Architect, you will be responsible for:
Gathering and analyzing requirements from customers on their data needs. Developing enhancements to existing on-prem SQL solutions and PowerBI dashboards, Learning Microsoft Fabric to implement cloud data solutions where appropriate. Supporting data governance processes and data sensitivity labeling through Microsoft Purview. Identifying opportunities to improve, stabilize, or expedite technical or team processes. Build and maintain relationships with vendors and both internal and external stakeholders. Performing other duties as assigned. What You'll Bring
Our top candidate will have a professional attitude with strong interpersonal communications and positive energy. This is a customer facing position and requires that the resource approach all work tasks and business relationships with the internal project team, external vendors, and other support resources in a professional manner.
Our ideal candidate has some or all the following experience, skills, and characteristics:
Knowledge of information technology and data processing sufficient to be able to complete ETL processes for data solutions Ability to clearly communicate with the team, scrum master, and manager on status, issues, and roadblocks Ability to define requirements and user stories and develop associated documentation Skill in clearly communicating complex technical information to non-technical audiences Provide support and training to stakeholders in developing PowerBI dashboards Engage and interact with stakeholders to understand the technical needs of a complex organization Knowledge of integration design and support Knowledge and/or experience with working in an Agile environment Additionally, our ideal candidate will have systems experience with one or more of the following:
Experience with SQL services including SSIS, SSAS, and SSRS, including creating and scheduling SQL agent jobs Experience with writing ETL and DDL using T-SQL Experience with Microsoft PowerBI reports and dashboards Familiarity with Microsoft Fabric and Azure Data Factory a plus Familiarity with Microsoft Azure DevOps a plus Familiarity with writing ETL and DDL using PySpark or Spark SQL a plus Required Minimum Qualifications
Education requirements: Bachelor's Degree in Computer Science, Computer Information Systems, Business Administration, Mathematics, or a related field. Experience Requirement: Two (2) years of professional information technology developing and maintaining business or enterprise data systems, to include one year of experience participating in the development of data architecture standards. Education/Experience Equivalency: One (1) year of the appropriate type and level of experience may be substituted for each required year of post-high school education. Additional appropriate education may be substituted for the minimum experience requirements.
Additional Information
FBI Background Check: FBI criminal background check is required for all positions at Denver International Airport (DEN). Employees are also required to report any felony convictions and/or moving violations to maintain this clearance and be eligible for continued employment. By position, a pre-employment physical/drug test may be required.
Snow/Emergency Duties:Denver International Airport is a 24/7/365 team operation. If weather conditions warrant or an emergency crisis occurs, all DEN employees can be required to work extended hours and/or shifts.
Application Deadline
This position is expected to stay open until Wednesday, September 17, 2025. Please submit your application as soon as possible and no later than 9/17/25 at 11:59 p.m. to ensure consideration.
About Everything Else
Job Profile CI2866 IT Data Architect Associate To view the full job profile including position specifications, physical demands, and probationary period, click here.
Position Type Unlimited
Position Salary Range $84,604.00 - $139,597.00
Target Pay $95,000 - $125,000/year
Agency Denver International Airport
Redeployment during Citywide Emergencies
City and County of Denver employees may be re-deployed to work in other capacities in their own agencies or in other city agencies to support core functions of the city during a citywide emergency declared by the Mayor.
The City and County of Denver provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, national origin, sex, sexual orientation, gender identity, national origin, disability, genetic information, age, or any other status protected under federal, state, and/or local law.
It is your right to access oral or written language assistance, sign language interpretation, real-time captioning via CART, or disability-related accommodations. To request any of these services at no cost to you, please contact Jobs@Denvergov.org with three business days' notice.
Applicants for employment with the City and County of Denver must have valid work authorization that does not require sponsorship of a visa for employment authorization in the U.S.
For information about right to work, click here for English or here for Spanish.
With competitive pay, great benefits, and endless opportunities, working for the City and County of Denver means seeing yourself working with purpose - for you, and those who benefit from your passion, skills and expertise. Join our diverse, inclusive and talented workforce of more than 11,000 team members who are at the heart of what makes Denver, Denver.
What We Offer
The City and County of Denver offers competitive pay commensurate with education and experience. New hires are typically brought into the organization between $95,000 - $125,000/year. We also offer generous benefits for full-time employees which include but are not limited to: A guaranteed life-long monthly pension, once vested after 5 years of service 457B Retirement Plan 140 hours of PTO earned within first year + 12 paid holidays, 1 personal holiday, 1 wellness day, and 1 volunteer day per year Competitive medical, dental and vision plans effective within 1 month of start date The City and County of Denver has announced furlough days, or unpaid days off, for most employees to meet a budget shortfall in 2025. There are two fixed furlough days for all limited (temporary positions with an end date) and unlimited (permanent) employees on August 29th, the Friday before Labor Day, and November 28th, the day after Thanksgiving. If you receive an offer for this position, your annual pay will determine whether you are required to take additional furlough days. Details will be discussed during the offer process for selected candidate(s).
Location
The City and County of Denver supports a hybrid workplace model. Employees work where needed, at a job site several days a week and off-site as needed. Employees must work within the state of Colorado on their off-site days.
In this position you can expect to work on site at least two days per week at the Denver International Airport (Concourse A).
Who We Are & What You'll Do
Denver International Airport (DEN) is the third-busiest airport in the United States and one of the top ten busiest airports in the world, connecting our community globally through flight and business. DEN is the primary economic engine for the state of Colorado, generating more than $47.2 billion for the region annually and employing nearly 37,000 people. At DEN, we are committed to fostering a diverse, inclusive and equitable workplace. We celebrate individuality and uplift all races, ethnicities, gender identities, national origins, ages, abilities, religion, and LGBTQIA+ communities. We know that our diversity makes us stronger, and we strive to keep diversity, equity and inclusion at the center of all that we do.
Denver International Airport is looking for an Associate IT Data Architect to join our Business Technologies team. This position will support the Business Intelligence team with both on-premises and cloud data warehouse management and implementation.
Specifically, as the Associate IT Data Architect, you will be responsible for:
Gathering and analyzing requirements from customers on their data needs. Developing enhancements to existing on-prem SQL solutions and PowerBI dashboards, Learning Microsoft Fabric to implement cloud data solutions where appropriate. Supporting data governance processes and data sensitivity labeling through Microsoft Purview. Identifying opportunities to improve, stabilize, or expedite technical or team processes. Build and maintain relationships with vendors and both internal and external stakeholders. Performing other duties as assigned. What You'll Bring
Our top candidate will have a professional attitude with strong interpersonal communications and positive energy. This is a customer facing position and requires that the resource approach all work tasks and business relationships with the internal project team, external vendors, and other support resources in a professional manner.
Our ideal candidate has some or all the following experience, skills, and characteristics:
Knowledge of information technology and data processing sufficient to be able to complete ETL processes for data solutions Ability to clearly communicate with the team, scrum master, and manager on status, issues, and roadblocks Ability to define requirements and user stories and develop associated documentation Skill in clearly communicating complex technical information to non-technical audiences Provide support and training to stakeholders in developing PowerBI dashboards Engage and interact with stakeholders to understand the technical needs of a complex organization Knowledge of integration design and support Knowledge and/or experience with working in an Agile environment Additionally, our ideal candidate will have systems experience with one or more of the following:
Experience with SQL services including SSIS, SSAS, and SSRS, including creating and scheduling SQL agent jobs Experience with writing ETL and DDL using T-SQL Experience with Microsoft PowerBI reports and dashboards Familiarity with Microsoft Fabric and Azure Data Factory a plus Familiarity with Microsoft Azure DevOps a plus Familiarity with writing ETL and DDL using PySpark or Spark SQL a plus Required Minimum Qualifications
Education requirements: Bachelor's Degree in Computer Science, Computer Information Systems, Business Administration, Mathematics, or a related field. Experience Requirement: Two (2) years of professional information technology developing and maintaining business or enterprise data systems, to include one year of experience participating in the development of data architecture standards. Education/Experience Equivalency: One (1) year of the appropriate type and level of experience may be substituted for each required year of post-high school education. Additional appropriate education may be substituted for the minimum experience requirements.
Additional Information
FBI Background Check: FBI criminal background check is required for all positions at Denver International Airport (DEN). Employees are also required to report any felony convictions and/or moving violations to maintain this clearance and be eligible for continued employment. By position, a pre-employment physical/drug test may be required.
Snow/Emergency Duties:Denver International Airport is a 24/7/365 team operation. If weather conditions warrant or an emergency crisis occurs, all DEN employees can be required to work extended hours and/or shifts.
Application Deadline
This position is expected to stay open until Wednesday, September 17, 2025. Please submit your application as soon as possible and no later than 9/17/25 at 11:59 p.m. to ensure consideration.
About Everything Else
Job Profile CI2866 IT Data Architect Associate To view the full job profile including position specifications, physical demands, and probationary period, click here.
Position Type Unlimited
Position Salary Range $84,604.00 - $139,597.00
Target Pay $95,000 - $125,000/year
Agency Denver International Airport
Redeployment during Citywide Emergencies
City and County of Denver employees may be re-deployed to work in other capacities in their own agencies or in other city agencies to support core functions of the city during a citywide emergency declared by the Mayor.
The City and County of Denver provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, national origin, sex, sexual orientation, gender identity, national origin, disability, genetic information, age, or any other status protected under federal, state, and/or local law.
It is your right to access oral or written language assistance, sign language interpretation, real-time captioning via CART, or disability-related accommodations. To request any of these services at no cost to you, please contact Jobs@Denvergov.org with three business days' notice.
Applicants for employment with the City and County of Denver must have valid work authorization that does not require sponsorship of a visa for employment authorization in the U.S.
For information about right to work, click here for English or here for Spanish.