Data Engineer (Remote from anywhere in CO).
State of Colorado
Full time
Other
United States
Hiring from: United States
Department Information
Together, we innovate for a stronger Colorado
The work of employees at the Governor's Office of Information Technology (OIT) is challenging and diverse because the needs of agencies, customers and Coloradans constantly evolve. But our focus never changes: improve the lives of all Coloradans through innovation and collaboration. We're building one of the nation's leading government IT organizations by reimagining how we support agencies, building first-of-their-kind applications, and creating an inclusive, collaborative culture, together. Join us in the important work of providing equitable access to services.
Watch this video to learn about how OIT is thinking differently!
Description Of Job
IMPORTANT NOTE: Please review your application to ensure completion. For the most equitable applicant experience, OIT’s hiring team considers only the contents of your application to review your qualifications. Please do not include any attachments (such as resume or cover letter) with your application as these items are not used by OIT’s hiring team.
Term Limited Position: This position is term limited with an anticipated end date of approximately two years from the date of hire. This position is eligible for State employee benefits and may be extended as the situation warrants. This video explains the many benefits of working at the State of Colorado on a term limited basis.
Are you looking for an opportunity to combine your love of data, and work for the great State of Colorado? If so, as our new data engineer you will be responsible for designing, creating, maintaining, and optimizing data infrastructure for data collection, management, transformation, and access. You will be in charge of creating pipelines that convert raw data into usable formats for data consumers to utilize as well as maintaining the infrastructure and pipelines that allow our organization to collect, process, and analyze data.
Specific Duties Include
Designing systems : Creating systems for collecting, storing, and analyzing data.
Building data pipelines : Connecting information from different systems into a single pipeline.
Cleansing data : Integrating, consolidating, and cleansing data to make it usable.
Securing data : Managing and storing data to protect it from loss or theft.
Scaling data : Considering how to scale the system if the amount of data grows.
Connecting to cloud : Connecting OIT’s business systems to cloud-based systems.
C reating models: Creating models to analyze data faster and more accurately.
Monitoring data management costs: Tracking day to day warehouse use for costs and tuning processes for cost optimization.
Supporting Analytics: Uses intermediate to advanced SQL, creating analytics ready data objects to support standard and advanced analytics.
Creating Batch Processes: Uses intermediate to advanced SQL, creating data batch processes which support division units to work more efficiently.
Minimum Qualifications, Substitutions, Conditions Of Employment & Appeal Rights
A wide salary range is posted for this position and any job offer is based upon a salary analysis to comply with the Colorado Equal Pay for Equal Work Act. The salary analysis considers relevant experience, education, certifications, and state seniority as compared to others doing substantially similar work. While all offers are compliant with the Colorado Equal Pay for Equal Work Act, there is no guarantee an offer will be at the top of the posted range based on the salary analysis.
Minimum Qualifications
This is a skills-based job announcement. The required minimum qualifications and/or education (if substituting for the proven experience, knowledge, and skills), are as follows:
A minimum of three years (3) of experience in software development, data science, data engineering, ETL, and analytics reporting development
A minimum of one year (1) of experience designing, building, implementing, and maintaining data and system integrations using dimensional data modeling and development and optimization of ETL pipelines.
A minimum of one year (1) of experience designing, building, implementing, and maintaining data and system integrations and data transformations utilizing Snowflake.
Demonstrated proficiency in Structured Query Language (SQL)
Substitutions
Additional appropriate education will substitute for the required experience on a year-for-year basis, but cannot completely substitute for these qualifications.
Training or Certification related to the work assigned to the position will be assigned credit towards substitution for experience and/or education, but cannot completely substitute for these qualifications.
If the minimum qualifications include a degree requirement, additional appropriate paid or unpaid experience will substitute for the required education on a year-for-year basis.
Preferred Qualifications
Previous experience working for a government agency.
Experience with Python, R or other programming languages used in data engineering.
Experience with Snowflake, Informatica, MuleSoft, AWS Glue is a plus.
Experience with CI / CD and source control platforms like Azure DevOps.
Experience with the public sector, especially with the business domain of labor and employment.
Familiarity with data governance frameworks and tools.
Experience with data visualization tools like Tableau, or Power BI is a plus.
Knowledge of other cloud platforms like AWS, GCP or Azure.
Conditions Of Employment
OIT employees must comply with any screening procedures in place at state entity locations where they might be required to perform work.
A pre-employment background check will be conducted as part of the selection process.
Positions supporting some agencies such as the Department of Corrections and the Department of Public Safety will also require a pre-employment drug test.
This position may require travel within the specified geographic area, and to locations across the state as needed.
Supplemental Information
If this posting indicates “remote from anywhere in CO” in the title, periodic reporting to the primary state work location designated for the position is required. All remote work must be performed in Colorado.
While candidates from out of state will be considered for this role, the candidate selected for the position must relocate and reside in Colorado on the first day of their new position. A reasonable timeframe for relocation will be established on an individual basis, while considering business needs, and determining a start date.
We know it's important to support each other, and that means having a healthy balance of work and personal time. Visit our benefits to learn more about some of our great offerings that allow us all to have fulfilling lives.
Visit our How to Apply webpage to learn more about our application process and what to expect after you apply.
The State of Colorado strives to create a Colorado for All by building and maintaining workplaces that value and respect all Coloradans through a commitment to equal opportunity and hiring based on merit and fitness. The State is resolute in non-discriminatory practices in everything we do, including hiring, employment, and advancement opportunities.
The Governor's Office of Information Technology is committed to the full inclusion of all qualified individuals. As part of this commitment, our agency will assist individuals who have a disability with any reasonable accommodation requests related to employment, including completing the application process, interviewing, completing any pre-employment testing, participating in the employee selection process, and/or to perform essential job functions where the requested accommodation does not impose an undue hardship. If you have a disability and require reasonable accommodation to ensure you have a positive experience applying or interviewing for this position, please direct your inquiries to our ADA Coordinator at [email protected] or call (303) 764-7900.
This posting may be used to fill multiple vacancies based upon business need.
The Governor's Office of Information Technology does NOT offer sponsored Visas for employment purposes.
Together, we innovate for a stronger Colorado
The work of employees at the Governor's Office of Information Technology (OIT) is challenging and diverse because the needs of agencies, customers and Coloradans constantly evolve. But our focus never changes: improve the lives of all Coloradans through innovation and collaboration. We're building one of the nation's leading government IT organizations by reimagining how we support agencies, building first-of-their-kind applications, and creating an inclusive, collaborative culture, together. Join us in the important work of providing equitable access to services.
Watch this video to learn about how OIT is thinking differently!
Description Of Job
IMPORTANT NOTE: Please review your application to ensure completion. For the most equitable applicant experience, OIT’s hiring team considers only the contents of your application to review your qualifications. Please do not include any attachments (such as resume or cover letter) with your application as these items are not used by OIT’s hiring team.
Term Limited Position: This position is term limited with an anticipated end date of approximately two years from the date of hire. This position is eligible for State employee benefits and may be extended as the situation warrants. This video explains the many benefits of working at the State of Colorado on a term limited basis.
Are you looking for an opportunity to combine your love of data, and work for the great State of Colorado? If so, as our new data engineer you will be responsible for designing, creating, maintaining, and optimizing data infrastructure for data collection, management, transformation, and access. You will be in charge of creating pipelines that convert raw data into usable formats for data consumers to utilize as well as maintaining the infrastructure and pipelines that allow our organization to collect, process, and analyze data.
Specific Duties Include
Designing systems : Creating systems for collecting, storing, and analyzing data.
Building data pipelines : Connecting information from different systems into a single pipeline.
Cleansing data : Integrating, consolidating, and cleansing data to make it usable.
Securing data : Managing and storing data to protect it from loss or theft.
Scaling data : Considering how to scale the system if the amount of data grows.
Connecting to cloud : Connecting OIT’s business systems to cloud-based systems.
C reating models: Creating models to analyze data faster and more accurately.
Monitoring data management costs: Tracking day to day warehouse use for costs and tuning processes for cost optimization.
Supporting Analytics: Uses intermediate to advanced SQL, creating analytics ready data objects to support standard and advanced analytics.
Creating Batch Processes: Uses intermediate to advanced SQL, creating data batch processes which support division units to work more efficiently.
Minimum Qualifications, Substitutions, Conditions Of Employment & Appeal Rights
A wide salary range is posted for this position and any job offer is based upon a salary analysis to comply with the Colorado Equal Pay for Equal Work Act. The salary analysis considers relevant experience, education, certifications, and state seniority as compared to others doing substantially similar work. While all offers are compliant with the Colorado Equal Pay for Equal Work Act, there is no guarantee an offer will be at the top of the posted range based on the salary analysis.
Minimum Qualifications
This is a skills-based job announcement. The required minimum qualifications and/or education (if substituting for the proven experience, knowledge, and skills), are as follows:
A minimum of three years (3) of experience in software development, data science, data engineering, ETL, and analytics reporting development
A minimum of one year (1) of experience designing, building, implementing, and maintaining data and system integrations using dimensional data modeling and development and optimization of ETL pipelines.
A minimum of one year (1) of experience designing, building, implementing, and maintaining data and system integrations and data transformations utilizing Snowflake.
Demonstrated proficiency in Structured Query Language (SQL)
Substitutions
Additional appropriate education will substitute for the required experience on a year-for-year basis, but cannot completely substitute for these qualifications.
Training or Certification related to the work assigned to the position will be assigned credit towards substitution for experience and/or education, but cannot completely substitute for these qualifications.
If the minimum qualifications include a degree requirement, additional appropriate paid or unpaid experience will substitute for the required education on a year-for-year basis.
Preferred Qualifications
Previous experience working for a government agency.
Experience with Python, R or other programming languages used in data engineering.
Experience with Snowflake, Informatica, MuleSoft, AWS Glue is a plus.
Experience with CI / CD and source control platforms like Azure DevOps.
Experience with the public sector, especially with the business domain of labor and employment.
Familiarity with data governance frameworks and tools.
Experience with data visualization tools like Tableau, or Power BI is a plus.
Knowledge of other cloud platforms like AWS, GCP or Azure.
Conditions Of Employment
OIT employees must comply with any screening procedures in place at state entity locations where they might be required to perform work.
A pre-employment background check will be conducted as part of the selection process.
Positions supporting some agencies such as the Department of Corrections and the Department of Public Safety will also require a pre-employment drug test.
This position may require travel within the specified geographic area, and to locations across the state as needed.
Supplemental Information
If this posting indicates “remote from anywhere in CO” in the title, periodic reporting to the primary state work location designated for the position is required. All remote work must be performed in Colorado.
While candidates from out of state will be considered for this role, the candidate selected for the position must relocate and reside in Colorado on the first day of their new position. A reasonable timeframe for relocation will be established on an individual basis, while considering business needs, and determining a start date.
We know it's important to support each other, and that means having a healthy balance of work and personal time. Visit our benefits to learn more about some of our great offerings that allow us all to have fulfilling lives.
Visit our How to Apply webpage to learn more about our application process and what to expect after you apply.
The State of Colorado strives to create a Colorado for All by building and maintaining workplaces that value and respect all Coloradans through a commitment to equal opportunity and hiring based on merit and fitness. The State is resolute in non-discriminatory practices in everything we do, including hiring, employment, and advancement opportunities.
The Governor's Office of Information Technology is committed to the full inclusion of all qualified individuals. As part of this commitment, our agency will assist individuals who have a disability with any reasonable accommodation requests related to employment, including completing the application process, interviewing, completing any pre-employment testing, participating in the employee selection process, and/or to perform essential job functions where the requested accommodation does not impose an undue hardship. If you have a disability and require reasonable accommodation to ensure you have a positive experience applying or interviewing for this position, please direct your inquiries to our ADA Coordinator at [email protected] or call (303) 764-7900.
This posting may be used to fill multiple vacancies based upon business need.
The Governor's Office of Information Technology does NOT offer sponsored Visas for employment purposes.
How to apply
To apply for this job you need to authorize on our website. If you don't have an account yet, please register.
Post a resumeSimilar jobs
À propos de SJC Nous créons, publions et imprimons du contenu de premier ordre. En tant que plus grande entreprise privée de communication au Canada, nous travaillons en partenariat avec nos clients pour fournir des solutions marketing qui informent et...
Other
Canada
Hiring from: Canada
Evolve Psychiatry is looking for a few dedicated remote professionals to join our dedicated team. Evolve Psychiatry is a mid-large sized psychiatry practice based out of New York with over 20,000 patients. We specialize in Medication Management, Talk Therapy, TMS,...
Other
United States
Hiring from: United States
Remote Work-at-Home | Canada JOB TYPE Full-Time PAY TYPES Hourly Position Overview MCI is a leading Business Process Outsourcing (BPO) company that specializes in delivering tailored solutions to meet the diverse needs of our clients. With a commitment to excellence...
Other
Canada
Hiring from: Canada