University Corporation for Atmospheric Research
Database Development & Administration Lead
University Corporation for Atmospheric Research, Boulder, Colorado, United States, 80301
Job Description Summary: UCAR is excited to announce a position for a Database Development and Administration Lead within our Enterprise Software and Applications (ESA) team! This position will include responsibilities for design and implementation of database components, data set transformation and loading, and data design for reporting, application interfaces. In addition, you will be responsible for support and maintenance on developed models and components, in addition to other responsibilities.
Position Details:
Visa Sponsored Job:
No
Relocation Assistance Eligible:
No
Job Location:
Boulder, Colorado
Position Type & Term:
Full time, Regular
Compensation Range:
Salary Range $109,097 - $136,370
Final salary and rates are based on education, experience, skills relevant to the role.
Application Notes
Job Location: Boulder, Colorado
Job Type: Hybrid, 3 days in Boulder office
Position Type & Term: Full-Time, Regular
Application Deadline: This position will be posted until 11:59 PM on Friday, August 22nd.
Required application materials: (preferably in PDF Format)
Resume/CV
Cover Letter - Please address how your skills and experience meet the needs of this position (for more information, please refer to the Key Responsibilities and Knowledge, Skills, and Abilities sections of this job posting). Additionally, please respond to the following questions within your cover letter. Applications that do not address these questions will not be eligible for further consideration:
T his position includes supervisory responsibilities. Please describe your approach to managing and mentoring technical staff. How have you supported the professional development of your team, particularly in areas such as systems integration, data management, and application support?
Briefly describe a successful technical project you led recently. How did you communicate complex data concepts to non-technical stakeholders, collaborate across functional teams, and ensure alignment with broader enterprise IT objectives?
Background Checks: Conducted for candidates selected for hire. Learn more (https://www.ucar.edu/opportunities/careers/faqs) .
Work Location: Regardless of flexible work arrangements, UCAR requires ALL positions to be performed within the U.S., excluding U.S. Territories.
What You Will Do
Here is a brief summary of what one would expect to be generally responsible for in this role.
Technical lead on project teams to support functional design, document and understand database requirements for data and integration related projects.
Lead the creation of processes, procedures, and scripts to migrate data and/or perform ETLs using integration software
Maintain coding standards, a consistent code base in conjunction with best practices and with the use of source control for all data objects
Lead the development of data integrations between cloud applications and internal data hub for use with internal applications
Lead data architecture initiatives to support analytics and reporting requirements
Design and develop efficient, functional data structures and data processes for data migrations to cloud platforms
Team with application developers for scheduling/design of API data integrations via Mule
Production monitoring and support of data-related jobs
Provide ongoing supervision, development, coaching, mentoring, and learning experiences for the database integration team.
Lead database integration team meetings and 1:1 meetings with staff
Provides daily direction and prioritization of support related tasks including data system tasks
Sets goals, delegates tasks, monitors productivity, and provides feedback and coaching.
Ensures application support goals and objectives are met.
Train users on developed models, answer and respond to user support questions.
Backup DBA support and maintenance tasks on SQL Server / SSIS ETL platforms.
Who We'd Love To Join Our Team
Successful candidates will ensure their application materials speak to the following criteria:Education and Experience (Required/Desired):
Bachelor’s degree in computer-related field and extensive and progressive relevant experience, which is typically gained by eight to twelve years of experience in database administration including experience in developing integrations and related applications and writing scripts, or an equivalent combination of education and experience.
Desired, but not required:
Knowledge of financial accounting systems and their relational database structures and concepts.
Knowledge of financial and business environments, including fund accounting and contract/budget monitoring environments.
Knowledge, Skills, and Abilities (Required/Desired)
Advanced skills and experience in relational and multidimensional DBMS on SQL Server
Demonstrated skill and experience with ETL tools such as Microsoft SQL Server Integration Services
Advanced skill and experience with data warehouse methodologies, design and analysis
Advanced data migration, data conversion and cloud application migrations
Experience with source control technologies such as Github
Ability to convey complex concepts to others of various technical backgrounds.
Strong communication and team building skills with all levels of project teams, technical and non-technical
Solid database programming skills in TSQL including design and implementation of complex stored procedures, views for use in meta data driven processes
Strong skills and experience in preparing data for use in reporting writing tools such as Cognos, Power BI, or Workday Report Writer
Understanding of data interface characteristics and complex database management
Strong ability to prioritize tasks at the team level to meet objectives
Demonstrated supervisory skills including providing coaching, mentoring, and performance feedback to direct reports
Benefits Overview
UCAR affirms its commitment to employees through competitive benefits (https://www.ucar.edu/opportunities/careers/benefits) . In addition to medical, dental, vision, retirement, and life insurance, UCAR offers a variety of programs focused on work-life balance and professional, and personal development. These include:
Tuition Assistance, time off allowance to attend classes, and other professional development opportunities
UCAR contributes 10% of your eligible pay into your retirement account; 100% fully vested on day one
Starting minimum accrual of 20 days of personal time off each year (prorated for less than full-time positions)
10 paid holidays
10 days of sick leave each year
12 weeks of paid parental leave
Short-term medical leave paid at 100% of your regular salary
EcoPass for local Colorado residents to use the Denver and Boulder-area transit system at no cost
Commitment to Job Application Fairness
Applicants are not required to provide age or age-related information and may redact information related to age, date of birth, or dates of attendance at or graduation from an educational institution from any submissions during the initial application process.
Some Final Considerations
At NSF NCAR| UCAR | UCP , you will work alongside a dedicated team of professionals conducting critical research and community outreach to solve complex Earth system science problems including climate change, air pollution, extreme weather, floods, drought, wildfires, and space weather, all with the goal of improving human life and reducing economic loss. Each of us, from scientists to the professionals who support their work, serves the public and a collaborative community of scientists in our mission to understand the complex processes that make up the Earth system, from the ocean floor to the Sun’s core.
Flexible Work
At UCAR, we are committed to supporting our mission by giving staff the flexibility to find the schedule and location that works best to maintain their own work-life circumstances and reach their full potential as professionals. Many positions within our organization are eligible for fully on-site, hybrid (three days per week) and/or flexible work hours.
Equal Opportunity Employer
UCAR is committed to providing equal opportunity for all employees and applicants for employment and does not discriminate on the basis of race, age, creed, color, religion, national origin or ancestry, sex, gender, disability, veteran status, genetic information, sexual orientation, gender identity or expression, or pregnancy. Whatever your intersection of identities, you are welcome at UCAR.
Export Control
All positions are required to comply with U.S. export compliance regulations work location requirements regarding access to facilities and research systems.
Visa Wait Times
Please consider the length of visa procurement when applying for this posting, understanding that you will not be able to begin employment until you are able to get a visa and enter the U.S.
Work Location
UCAR requires ALL positions to be performed within the U.S., excluding U.S. Territories.
AI Software
ChatGPT and similar AI software are powerful tools that are changing the way society receives, processes, and leverages information promptly. While we acknowledge its benefits and do not restrict leveraging it with job applications, we highly encourage a majority of the applicant material to be original work.
Position Details:
Visa Sponsored Job:
No
Relocation Assistance Eligible:
No
Job Location:
Boulder, Colorado
Position Type & Term:
Full time, Regular
Compensation Range:
Salary Range $109,097 - $136,370
Final salary and rates are based on education, experience, skills relevant to the role.
Application Notes
Job Location: Boulder, Colorado
Job Type: Hybrid, 3 days in Boulder office
Position Type & Term: Full-Time, Regular
Application Deadline: This position will be posted until 11:59 PM on Friday, August 22nd.
Required application materials: (preferably in PDF Format)
Resume/CV
Cover Letter - Please address how your skills and experience meet the needs of this position (for more information, please refer to the Key Responsibilities and Knowledge, Skills, and Abilities sections of this job posting). Additionally, please respond to the following questions within your cover letter. Applications that do not address these questions will not be eligible for further consideration:
T his position includes supervisory responsibilities. Please describe your approach to managing and mentoring technical staff. How have you supported the professional development of your team, particularly in areas such as systems integration, data management, and application support?
Briefly describe a successful technical project you led recently. How did you communicate complex data concepts to non-technical stakeholders, collaborate across functional teams, and ensure alignment with broader enterprise IT objectives?
Background Checks: Conducted for candidates selected for hire. Learn more (https://www.ucar.edu/opportunities/careers/faqs) .
Work Location: Regardless of flexible work arrangements, UCAR requires ALL positions to be performed within the U.S., excluding U.S. Territories.
What You Will Do
Here is a brief summary of what one would expect to be generally responsible for in this role.
Technical lead on project teams to support functional design, document and understand database requirements for data and integration related projects.
Lead the creation of processes, procedures, and scripts to migrate data and/or perform ETLs using integration software
Maintain coding standards, a consistent code base in conjunction with best practices and with the use of source control for all data objects
Lead the development of data integrations between cloud applications and internal data hub for use with internal applications
Lead data architecture initiatives to support analytics and reporting requirements
Design and develop efficient, functional data structures and data processes for data migrations to cloud platforms
Team with application developers for scheduling/design of API data integrations via Mule
Production monitoring and support of data-related jobs
Provide ongoing supervision, development, coaching, mentoring, and learning experiences for the database integration team.
Lead database integration team meetings and 1:1 meetings with staff
Provides daily direction and prioritization of support related tasks including data system tasks
Sets goals, delegates tasks, monitors productivity, and provides feedback and coaching.
Ensures application support goals and objectives are met.
Train users on developed models, answer and respond to user support questions.
Backup DBA support and maintenance tasks on SQL Server / SSIS ETL platforms.
Who We'd Love To Join Our Team
Successful candidates will ensure their application materials speak to the following criteria:Education and Experience (Required/Desired):
Bachelor’s degree in computer-related field and extensive and progressive relevant experience, which is typically gained by eight to twelve years of experience in database administration including experience in developing integrations and related applications and writing scripts, or an equivalent combination of education and experience.
Desired, but not required:
Knowledge of financial accounting systems and their relational database structures and concepts.
Knowledge of financial and business environments, including fund accounting and contract/budget monitoring environments.
Knowledge, Skills, and Abilities (Required/Desired)
Advanced skills and experience in relational and multidimensional DBMS on SQL Server
Demonstrated skill and experience with ETL tools such as Microsoft SQL Server Integration Services
Advanced skill and experience with data warehouse methodologies, design and analysis
Advanced data migration, data conversion and cloud application migrations
Experience with source control technologies such as Github
Ability to convey complex concepts to others of various technical backgrounds.
Strong communication and team building skills with all levels of project teams, technical and non-technical
Solid database programming skills in TSQL including design and implementation of complex stored procedures, views for use in meta data driven processes
Strong skills and experience in preparing data for use in reporting writing tools such as Cognos, Power BI, or Workday Report Writer
Understanding of data interface characteristics and complex database management
Strong ability to prioritize tasks at the team level to meet objectives
Demonstrated supervisory skills including providing coaching, mentoring, and performance feedback to direct reports
Benefits Overview
UCAR affirms its commitment to employees through competitive benefits (https://www.ucar.edu/opportunities/careers/benefits) . In addition to medical, dental, vision, retirement, and life insurance, UCAR offers a variety of programs focused on work-life balance and professional, and personal development. These include:
Tuition Assistance, time off allowance to attend classes, and other professional development opportunities
UCAR contributes 10% of your eligible pay into your retirement account; 100% fully vested on day one
Starting minimum accrual of 20 days of personal time off each year (prorated for less than full-time positions)
10 paid holidays
10 days of sick leave each year
12 weeks of paid parental leave
Short-term medical leave paid at 100% of your regular salary
EcoPass for local Colorado residents to use the Denver and Boulder-area transit system at no cost
Commitment to Job Application Fairness
Applicants are not required to provide age or age-related information and may redact information related to age, date of birth, or dates of attendance at or graduation from an educational institution from any submissions during the initial application process.
Some Final Considerations
At NSF NCAR| UCAR | UCP , you will work alongside a dedicated team of professionals conducting critical research and community outreach to solve complex Earth system science problems including climate change, air pollution, extreme weather, floods, drought, wildfires, and space weather, all with the goal of improving human life and reducing economic loss. Each of us, from scientists to the professionals who support their work, serves the public and a collaborative community of scientists in our mission to understand the complex processes that make up the Earth system, from the ocean floor to the Sun’s core.
Flexible Work
At UCAR, we are committed to supporting our mission by giving staff the flexibility to find the schedule and location that works best to maintain their own work-life circumstances and reach their full potential as professionals. Many positions within our organization are eligible for fully on-site, hybrid (three days per week) and/or flexible work hours.
Equal Opportunity Employer
UCAR is committed to providing equal opportunity for all employees and applicants for employment and does not discriminate on the basis of race, age, creed, color, religion, national origin or ancestry, sex, gender, disability, veteran status, genetic information, sexual orientation, gender identity or expression, or pregnancy. Whatever your intersection of identities, you are welcome at UCAR.
Export Control
All positions are required to comply with U.S. export compliance regulations work location requirements regarding access to facilities and research systems.
Visa Wait Times
Please consider the length of visa procurement when applying for this posting, understanding that you will not be able to begin employment until you are able to get a visa and enter the U.S.
Work Location
UCAR requires ALL positions to be performed within the U.S., excluding U.S. Territories.
AI Software
ChatGPT and similar AI software are powerful tools that are changing the way society receives, processes, and leverages information promptly. While we acknowledge its benefits and do not restrict leveraging it with job applications, we highly encourage a majority of the applicant material to be original work.