City of Colorado Springs
Senior Data Engineer (Senior IT Technology Architect)
City of Colorado Springs, Colorado Springs, Colorado, United States, 80509
Salary:
$120,725.90 - $144,929.05 Annually
Location :
Information Technology - City of Colorado Springs, CO
Job Type:
Classified - Full Time
Job Number:
16433
Division:
Innovation & Technology
Department:
Innovation & Technology
Opening Date:
11/13/2024
Closing Date:
11/27/2024 4:00 PM Mountain
FLSA:
Exempt
Description / Position Overview
Senior Data Engineer (Senior IT Architect)As a Senior Data Engineer, you will be responsible for designing and implementing data architecture solutions, and collaborating with IT teams and stakeholders to transform data into actionable insights to support business process improvements.
Come explore the possibilities a career with the City of Colorado Springs can offer!As a Senior Data Engineer, you will:Design and implement architecture roadmaps for enterprise-wide data solutions.Lead the development of ETL (Extract, Transform, Load) processes, solving data challenges and providing recommendations.Collaborate with IT teams and departments to develop and enhance business processes and technology solutions.Estimate costs and develop business cases for IT projects, working with project management to ensure completion.Communicate complex technical information clearly to technical and non-technical stakeholders.Document technical processes and collaborate with peers, vendors, and stakeholders to ensure seamless project delivery.Gather and document requirements for data ingestion into data lakehouseConsult with the organization's departments on data analytics needsPerform other duties as assignedLearn more about this job by reviewing the class specification on theRelevant Knowledge, Skills and Abilities:
Knowledge of cloud platforms, specifically Azure Data Analytics, for data management, storage, and analytics.Ability to develop and execute data models (star and snowflake schemas) and perform data analysis to support business needs.Proficient in SQL, Python, and working with databases including Oracle and Microsoft SQL Server.Ability to translate technical concepts to both technical and non-technical stakeholders and collaborate effectively across departments and with external vendors.Minimum Qualifications
Education: bachelor's degree from an accredited college or university with major coursework in information technology, data science, computer science, or a related field.Experience: five years of professional experience in IT architecture, data management, data lakehouse design, or related fields.Substitutions:
We value a diverse range of qualifications and experiences.
Each year of further education can be substituted for each year of relevant work experience, and each year of additional relevant work experience can be substituted for each year of required education.
We encourage all to apply!Preferred Qualifications
The following qualifications are not required, but they are considered desirable. If you possess any of the preferred qualifications, please include specific details in your application. This information may be used to identify a top group of applicants.
Experience with Microsoft Azure Synapse or other cloud-based platformsExperience with ETL processes and tools, including SQL and PythonExperience with star and snowflake schema designs for database structuresExperience with big data tools and storage formats including Parquet Files and Delta Lake
Additional Information
Equal Opportunity Employer
The City of Colorado Springs is committed to a culture that values our employees' unique individual qualities and fosters an inclusive environment where people want to be.
The City of Colorado Springs offers additional compensation depending on the position, area of assignment, and specific job assignments, including shift differential, pay differential, acting or lead, special assignment, hazard pay, longevity, cell phone allowance, uniform allowance, relocation, awards, standby, call out, compensatory time off, tuition, overtime, extra duty, incentive, holiday premium, proficiency, and vacation sell back.
NOTE: This job announcement is not intended to include a complete listing of all responsibilities, knowledge, skills, and abilities associated with the position.
The City does not sponsor applicants for work visas of any kind (including but not limited to F-1, H-1B or TN visas). Applicants must be currently authorized to work in the United States on a full-time basis.
Apply to Join Our Team
Please visit the and review our opportunities. Click on Apply button to complete an online application for any position of interest. All job applicants will need to create a new login and online application (unless you already have a Government Jobs user ID and password).Completing your application in full, including the entire work experience section, will assist Human Resources in the applicant screening process. Your application may not be considered if all of the information requested for each employer you list is not provided.Applicants may redact information from their resumes, certifications, transcripts, or any other additional application materials that identify the applicant's age, date of birth, or dates of attendance at or graduation from an educational institution. You will not be penalized for redacting or removing this information.We encourage candidates with out-of-state credentials to inquire about expedited processing of Colorado licensing with the Colorado Occupational Credential Portability Program. More information can be found at theOur Government Jobs application system does not allow you to edit your application after it has been submitted for a position. If you want to make changes, you may submit another application prior to the position's closing date and time listed in the job posting. HR will review the last application you submit for a position.
The City's job classifications, including physical demands and descriptions, can be found on the
You can view the status of your application on the
To be notified of future career opportunities sign up for job alerts on the page.
Working for the City of Colorado Springs is Rewarding!
Please visit the City of Colorado Springs' for additional benefits information.
The City of Colorado Springs is a place where people want to come to work each day. We have a culture of excellence, and we strive to provide our employees with the very best overall career experience and Total Rewards. We are proud to offer a comprehensive and competitive benefits program to meet the needs of our employees and their families.
01
What is the highest level of education you have completed?
Less than high schoolHigh School diploma or GEDAssociate's DegreeBachelor's DegreeMaster's Degree or above
02
How many years of relevant experience do you possess?
Less than one yearOne or more yearsTwo or more yearsThree or more yearsFour or more yearsFive or more yearsSix or more yearsSeven or more yearsEight or more yearsNine or more yearsTen or more years
03
Please explain your experience in detail, including your role and where you gained the experience.
04
Do you have experience with Microsoft Azure Synapse or other cloud-based platforms?
YesNo
05
If yes, please explain your experience in detail, including your role and where you gained the experience. If no, please enter N/A.
06
Do you have experience with ETL (Extract, Transform, Load) processes and tools, including SQL and Python?
YesNo
07
If yes, please explain your experience in detail, including your role and where you gained the experience. If no, please enter N/A.
08
Do you have experience with star and snowflake schema designs for database structures?
YesNo
09
If yes, please explain your experience in detail, including your role and where you gained the experience. If no, please enter N/A.
10
Do you have experience with big data rolls and storgame formats including Parquet Files and Delta Lake?
YesNo
Required Question
$120,725.90 - $144,929.05 Annually
Location :
Information Technology - City of Colorado Springs, CO
Job Type:
Classified - Full Time
Job Number:
16433
Division:
Innovation & Technology
Department:
Innovation & Technology
Opening Date:
11/13/2024
Closing Date:
11/27/2024 4:00 PM Mountain
FLSA:
Exempt
Description / Position Overview
Senior Data Engineer (Senior IT Architect)As a Senior Data Engineer, you will be responsible for designing and implementing data architecture solutions, and collaborating with IT teams and stakeholders to transform data into actionable insights to support business process improvements.
Come explore the possibilities a career with the City of Colorado Springs can offer!As a Senior Data Engineer, you will:Design and implement architecture roadmaps for enterprise-wide data solutions.Lead the development of ETL (Extract, Transform, Load) processes, solving data challenges and providing recommendations.Collaborate with IT teams and departments to develop and enhance business processes and technology solutions.Estimate costs and develop business cases for IT projects, working with project management to ensure completion.Communicate complex technical information clearly to technical and non-technical stakeholders.Document technical processes and collaborate with peers, vendors, and stakeholders to ensure seamless project delivery.Gather and document requirements for data ingestion into data lakehouseConsult with the organization's departments on data analytics needsPerform other duties as assignedLearn more about this job by reviewing the class specification on theRelevant Knowledge, Skills and Abilities:
Knowledge of cloud platforms, specifically Azure Data Analytics, for data management, storage, and analytics.Ability to develop and execute data models (star and snowflake schemas) and perform data analysis to support business needs.Proficient in SQL, Python, and working with databases including Oracle and Microsoft SQL Server.Ability to translate technical concepts to both technical and non-technical stakeholders and collaborate effectively across departments and with external vendors.Minimum Qualifications
Education: bachelor's degree from an accredited college or university with major coursework in information technology, data science, computer science, or a related field.Experience: five years of professional experience in IT architecture, data management, data lakehouse design, or related fields.Substitutions:
We value a diverse range of qualifications and experiences.
Each year of further education can be substituted for each year of relevant work experience, and each year of additional relevant work experience can be substituted for each year of required education.
We encourage all to apply!Preferred Qualifications
The following qualifications are not required, but they are considered desirable. If you possess any of the preferred qualifications, please include specific details in your application. This information may be used to identify a top group of applicants.
Experience with Microsoft Azure Synapse or other cloud-based platformsExperience with ETL processes and tools, including SQL and PythonExperience with star and snowflake schema designs for database structuresExperience with big data tools and storage formats including Parquet Files and Delta Lake
Additional Information
Equal Opportunity Employer
The City of Colorado Springs is committed to a culture that values our employees' unique individual qualities and fosters an inclusive environment where people want to be.
The City of Colorado Springs offers additional compensation depending on the position, area of assignment, and specific job assignments, including shift differential, pay differential, acting or lead, special assignment, hazard pay, longevity, cell phone allowance, uniform allowance, relocation, awards, standby, call out, compensatory time off, tuition, overtime, extra duty, incentive, holiday premium, proficiency, and vacation sell back.
NOTE: This job announcement is not intended to include a complete listing of all responsibilities, knowledge, skills, and abilities associated with the position.
The City does not sponsor applicants for work visas of any kind (including but not limited to F-1, H-1B or TN visas). Applicants must be currently authorized to work in the United States on a full-time basis.
Apply to Join Our Team
Please visit the and review our opportunities. Click on Apply button to complete an online application for any position of interest. All job applicants will need to create a new login and online application (unless you already have a Government Jobs user ID and password).Completing your application in full, including the entire work experience section, will assist Human Resources in the applicant screening process. Your application may not be considered if all of the information requested for each employer you list is not provided.Applicants may redact information from their resumes, certifications, transcripts, or any other additional application materials that identify the applicant's age, date of birth, or dates of attendance at or graduation from an educational institution. You will not be penalized for redacting or removing this information.We encourage candidates with out-of-state credentials to inquire about expedited processing of Colorado licensing with the Colorado Occupational Credential Portability Program. More information can be found at theOur Government Jobs application system does not allow you to edit your application after it has been submitted for a position. If you want to make changes, you may submit another application prior to the position's closing date and time listed in the job posting. HR will review the last application you submit for a position.
The City's job classifications, including physical demands and descriptions, can be found on the
You can view the status of your application on the
To be notified of future career opportunities sign up for job alerts on the page.
Working for the City of Colorado Springs is Rewarding!
Please visit the City of Colorado Springs' for additional benefits information.
The City of Colorado Springs is a place where people want to come to work each day. We have a culture of excellence, and we strive to provide our employees with the very best overall career experience and Total Rewards. We are proud to offer a comprehensive and competitive benefits program to meet the needs of our employees and their families.
01
What is the highest level of education you have completed?
Less than high schoolHigh School diploma or GEDAssociate's DegreeBachelor's DegreeMaster's Degree or above
02
How many years of relevant experience do you possess?
Less than one yearOne or more yearsTwo or more yearsThree or more yearsFour or more yearsFive or more yearsSix or more yearsSeven or more yearsEight or more yearsNine or more yearsTen or more years
03
Please explain your experience in detail, including your role and where you gained the experience.
04
Do you have experience with Microsoft Azure Synapse or other cloud-based platforms?
YesNo
05
If yes, please explain your experience in detail, including your role and where you gained the experience. If no, please enter N/A.
06
Do you have experience with ETL (Extract, Transform, Load) processes and tools, including SQL and Python?
YesNo
07
If yes, please explain your experience in detail, including your role and where you gained the experience. If no, please enter N/A.
08
Do you have experience with star and snowflake schema designs for database structures?
YesNo
09
If yes, please explain your experience in detail, including your role and where you gained the experience. If no, please enter N/A.
10
Do you have experience with big data rolls and storgame formats including Parquet Files and Delta Lake?
YesNo
Required Question