Overview

Job Location:
Foothills Lab Anthes Building

UCAR is excited to announce the job opening for the Database Development & Administration Lead. This position is responsible for leading the EIT Software and Application data and reporting development group that performs database development and ETL activities across an array of MySQL, MS SQL, Informix, and cloud databases in a dynamic enterprise wide applications development platform.

Where You Will Work:

At UCAR|NCAR|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.

Job Location: Boulder, Colorado

Job Location Type: Fully Remote (must reside in United States) w/ hybrid or on-site options available
 

Position Type & Term: Full-Time, Regular
 

Hiring Range: $103,336 – $129,169

*Final salary and rates are based on education, experience, skills relevant to the role, and internal equity.*

Application Notes:

  • Application Deadline: The position will be posted until filled with priority given to applications submitted prior to June 9, 2023.

  • Required application materials (preferably in PDF Format):

    • Resume

    • Cover Letter (Please address the Knowledge/Skills/Abilities indicated in the position description below; also, directly reference any experience with ETL tools and database programming skills in TSQL)

  • An Inclusion statement may be required for applicants advancing to an in-person or video interview. When applicable, candidates will be notified with instructions. Learn more.

  • Work Authorization: US Residency is a Requirement. You must reside in the U.S. for this position. UCAR/NCAR will not sponsor a work visa (e.g., J-1, H-1B, etc.) for this position. U.S. Citizenship, Permanent Residency, or another protected status under 8 U.S.C. 1324b(a)(3) is required for this position.

  • International remote work is only available for 20 days per calendar year

  • Relocation Assistance: Relocation assistance is not available for this position.

  • Pre-employment screenings are conducted for selected candidates; background checks are also conducted for risk-based positions. Learn more.

Benefits Overview (not including internship or casual roles) 

UCAR affirms its commitment to employees through competitive 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 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

  • 14 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 Diversity, Equity & Inclusion

Our organization is committed to creating a diverse, equitable, and inclusive work environment and fostering a culture where everyone feels welcome and supported. To learn more about these efforts, visit the Office of Diversity, Equity & Inclusion Strategic Plan and our Diversity & Inclusion: A Welcoming Workplace site. 

Research shows that women and people of color are less likely to apply for a position if they do not meet almost 100% of the desired skills and experience. Please note this is not necessary! If you meet the minimum requirements and have a passion for the work, you are encouraged to apply. We can provide on-the-job training for the rest!

HOW YOU WILL MAKE AN IMPACT AT UCAR

Here is a brief outline of what one would expect to be responsible for in this role. 

Key Responsibilities

  • 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
  • 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

WHO WE’D LOVE TO JOIN OUR TEAM

Successful candidates will ensure their application materials speak to the following criteria:

Education & Experience

  • 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

  • Demonstrated skill and experience with ETL tools such as Microsoft SQL Server Integration Services
  • Demonstrated supervisory skills including providing coaching, mentoring, and performance feedback to direct reports
  • 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
  • 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 experience in prioritizing tasks at the team level to meet objectives
  • Ability to manage personnel

SOME FINAL CONSIDERATIONS

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, fully-remote and/or flexible work schedules.

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.

The University Corporation for Atmospheric Research (UCAR) is an equal opportunity/equal access/affirmative action employer that strives to develop and maintain a diverse workforce. 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 the University Corporation for Atmospheric Research (UCAR). We are committed to inclusivity and promoting an equitable environment that values and respects the uniqueness of all members of our organization.