UCAR is looking for a Database Development and Administration Lead to manage database components, data transformations, and data design for reporting and application interfaces, ensuring efficient data processes and supporting analytics and reporting requirements.
Requirements
- 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
- 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
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
- 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
Other
- This 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?
- Hybrid, 3 days/week minimum requirement in Boulder office
- Strong communication and team building skills with all levels of project teams, technical and non-technical
- Demonstrated supervisory skills including providing coaching, mentoring, and performance feedback to direct reports
