Business Intelligence and Data Warehouse Administrator

Found in: beBee jobs US - 2 weeks ago


Colorado Springs, Colorado, United States Colorado College Full time

Posting Number: 1896
Job Title: Business Intelligence and Data Warehouse Administrator
Working Title:
Position Type: Full Time
Annual Hours 2080
Base Months 12
Hours per Week 40
Department: ITS: Operations
Summary Description
Leads the technical aspects of the College's continuing effort to integrate disparate data sources into a centralized, Snowflake- based analytical data lake, applying industry standards and best practices.
Works closely with the ITS development staff and database administrator to engineer and administer Snowflake and its associated architecture and ETL processes.
Interfaces with analysts and data consumers to develop logical views, data models and reports from the Data Lake.
Promote the uses, benefits and adoption of the data lake across the campus community.

Location of job:Colorado College, 14 E Cache La Poudre St, Colorado Springs, CO 80903.
Pay Band 8
Anticipated Salary Range
Pay Information
The anticipated pay for this position is $87,027.00/year.

The pay range reflects base pay for positions in a given pay band across the college. Individual rates are determined within the range by factors including one's qualifications, equity with others in the department, market rates for positions within the same band and department budget. Please refer to
Responsibilities:
Essential/Primary Responsibilities:
Manage and maintain the data warehouse and business intelligence solutions for the College.
Design, develop and maintain data integration processes from various sources into the Data Lake / Data Warehouse.
Develop and maintain reporting and analytics solutions for academic and administrative users.
Troubleshoot and resolve issues related to data warehousing and business intelligence.
Collaborate with academic departments and administrative offices to optimize data models and schemas.
Research and evaluate new technologies to improve our data warehousing and business intelligence solutions.
Maintain and expand data integrity and validation processes to proactively ensure accuracy of Snowflake data.
Participate in the planning and execution of data migration and conversion projects.
Collaborate with business and technology stakeholders to understand business requirements and ensure data lake architecture development meets the needs of the College.
Provide technical expertise regarding overall integrated reporting architecture within the Data Lake.
Maintain and expand the existing data lake data architecture, data logical views and data models, interpreting raw source data into standardized business meaningful forms to support reporting.
Create and maintain documentation on data processing, including functional and technical design documents, test cases, support documentation, migration and installation steps, release notes, mapping documents, data flow diagrams, process flow diagrams and ERDs.
Maintain awareness of related emerging technologies, developments and/or processes which could inform future growth.
Conduct capacity planning for growth to support current and future needs.

Secondary Responsibilities:
Assist in promoting a working environment and relationships that reflects inclusion and respect for diversity and equitable practices.
Actively support the College's plan to be an antiracist institution by understanding, engaging with, and promoting diversity, inclusion, and equity in the college community.
Promote a culture of safety and environmental protection by working in a safe manner; immediately reporting unsafe situations and accidents; following college procedures; and participating in appropriate safety training.
Demonstrate environmental sustainability by using college resources wisely and supporting the college's sustainability initiatives and innovation.
Perform other duties as assigned.
Does this position require driving CC vehicles/ being insurable under CC's insurance plan? No
Required Qualifications:
Bachelor's degree from an accredited college or university in computer science, information systems, or related field.

Three years of experience in the following*:
RDBMS databases.
Writing, debugging, and tuning/optimizing advanced SQL queries, including but not limited to: left, inner and outer joins of multiple tables; inline subqueries; case statements; creating views/materialized views; CRUD operations.
Building enterprise level reports, charts and dashboards using Power BI, Tableau, IBM Cognos, or Evision's Argos.
Extracting, cleaning and modeling raw data into ready to analyze format.
Creating and troubleshooting PL/SQL stored procedures, functions, materialized view and views.

Two years of experience in the following*:
Recommending, evaluating, testing, and implementing latest features in Business Intelligence and Extract Load and Transform (ELT) process.
Defining, capturing, and documenting business requirements.
Working with other infrastructure teams seamlessly as necessary (DBA, Server, Network, Security, etc.)
Training end-users and power users on Business Intelligence report usage and data best practices.
Creating warehouses, data marts, databases, all database objects (schemas, tables, views, file format etc.), and access management policies in Snowflake.

One year of experience in the following*:
Technical design and documentation for data pipelines, business intelligence and data warehousing.
All phases of SDLC from requirements analysis, design, coding, testing and delivery of products.
Working with large, complex, and incomplete data sets.
Using a Kanban, board style project management tool.
Performing business intelligence tools administration, including creation of users and groups, removing inactive users, and conducting license audits to ensure adherence to licensing requirements.
Designing and developing secure access to objects in Snowflake with Role-Based Access Control (RBAC).
Snowflake continuous data loading features such as streams, task, snow-pipe.
Snowflake security features including access control, authentication, network policies, masking, row level access, secured views etc.

*Unless specifically noted, experience must include at least one year in a production environment, within the last three years.


  • Supervisory Intelligence Operations Specialist

    Found in: beBee jobs US - 1 week ago


    Colorado Springs, Colorado, United States Department Of Homeland Security Full time

    Summary Securing Travel, Protecting People - At the Transportation Security Administration, you will serve in a high-stakes environment to safeguard the American way of life. In cities across the country, you would secure airports, seaports, railroads, highways, and/or public transit systems, thus protecting America's transportation infrastructure and...

  • Intelligence Operations Specialist

    Found in: beBee jobs US - 2 weeks ago


    Colorado Springs, Colorado, United States Department Of Homeland Security Full time

    Summary Securing Travel, Protecting People - At the Transportation Security Administration, you will serve in a high-stakes environment to safeguard the American way of life. In cities across the country, you would secure airports, seaports, railroads, highways, and/or public transit systems, thus protecting America's transportation infrastructure and...

  • Lead Data Integrator

    Found in: beBee jobs US - 1 week ago


    Colorado Springs, Colorado, United States Logistics Management Institute Full time

    OverviewLMI is seeking a Lead Data Integrator to assist a United States Army client in architecting, designing, and developing a next generation command and control. LMI is a consultancy dedicated to powering a future-ready, high-performing government, drawing from expertise in digital and analytic solutions, logistics, and management advisory services. We...

  • Business Development Officer, SBA

    Found in: beBee jobs US - 2 weeks ago


    Colorado Springs, Colorado, United States Alerus Financial Full time

    Position Summary:The Small Business Administration (SBA) Business Development Officer is responsible for developing, soliciting, and promoting new SBA loans independently by working and maintaining relationships primarily with outside referral partners. The role will be responsible for developing and maintaining strong relationships with SBA oriented centers...

  • Service Validation and Testing SVAT Administrator

    Found in: beBee jobs US - 18 hours ago


    Colorado Springs, Colorado, United States Leidos Full time

    Description The Leidos Digital Modernizations Sector has an opportunity for a Service Validation and Testing (SVAT) Administrator. This position supports our NORAD and USNORTHCOM N2NOMS program in Colorado Springs, CO.Our customer maintains a highly demanding mission and requires our support to provide expert technical and professional management support to...

  • Program/Site Manager II

    Found in: beBee jobs US - 2 weeks ago


    Colorado Springs, Colorado, United States BAE Systems Full time

    Job Description BAE Systems is seeking a Program Managers/Site Lead (Program Manager II) to join our team supporting the Department of Defense (DoD) High Performance Computing Modernization Program (DoD HPCMP). The successful candidate will serve as the overall contractor site lead responsible for the performance of the work and provide management at the Air...

  • Valet (Overnight)

    Found in: beBee jobs US - 2 weeks ago


    Colorado Springs, Colorado, United States The Mining Exchange Full time

    Mining Exchange Hotel & SpaValet/BellAbout The OpportunityPractice Hospitality is seeking an experienced and hands-on Overnight Valet to join the team at the Mining Exchange Hotel & Spa.About The CompanyPractice Hospitality manages hotels differently. A growing company with opportunities for advancement, we infuse hotels with style, spirit, and soul. We...

  • Clinical Sales Specialist

    Found in: beBee jobs US - 1 week ago


    Colorado Springs, Colorado, United States Proclinical Full time

    Clinical Sales Specialist - Permanent - OnsiteProclinical Staffing is seeking a Clinical Sales Specialist (Rare Disease, Liver) to join a cutting-edge pharmaceutical company. This is a permanent role located in Colorado Spring, CO.Primary ResponsibilitiesIn this field-based role as a Rare Disease Clinical Science Specialist, you will be accountable for...

  • transportation assistant

    Found in: beBee jobs US - 1 week ago


    Colorado Springs, Colorado, United States Department Of The Air Force Full time

    Summary The primary purpose of this position is: To serve as a quality control inspector providing information on matters associated with personal property operations. This position observes, documents, and evaluates carrier and contractor performance in moving personal property of DoD personnel.Click on "Learn more about this agency" button below to view...

  • Springs Orleans Supervisor

    Found in: beBee jobs US - 1 week ago


    Colorado Springs, Colorado, United States The Mining Exchange Full time

    Mining Exchange Hotel & SpaFood and Beverage SupervisorAbout The OpportunityPractice Hospitality is seeking an experienced and hands-on Food and Beverage Supervisor to join the team at the Mining Exchange Hotel & Spa in Springs Orleans restaurant.About The CompanyPractice Hospitality manages hotels differently. A growing company with opportunities for...

  • Quality Specialist

    Found in: beBee jobs US - 2 weeks ago


    Colorado Springs, Colorado, United States CSL Behring Full time

    The OpportunityThis position provides immediate support to the Assistant Manager of Quality in monitoring plasma center processes to ensure overall compliance with CSL Operating Procedures, as well as all applicable local, state, federal requirements. This role will ensure compliance to training needs, SOPs, processes and other regulatory or company...

  • Junior Financial Analyst

    Found in: beBee jobs US - 2 days ago


    Colorado Springs, Colorado, United States ASRC Federal Holding Company Full time

    ASRC Federal in Colorado Springs, CO is seeking a full-time Early Career Financial Analyst .This is a remote position.Key Role : Provide detailed weekly and monthly cost analysis, review contract expenditures for accuracy against allotted funding, review and record contractual modifications, create and monitor charge codes utilizing Deltek Costpoint, support...

  • Program Analyst

    Found in: beBee jobs US - 1 week ago


    Colorado Springs, Colorado, United States Department Of Homeland Security Full time

    Summary Securing Travel, Protecting People - At the Transportation Security Administration, you will serve in a high-stakes environment to safeguard the American way of life. In cities across the country, you would secure airports, seaports, railroads, highways, and/or public transit systems, thus protecting America's transportation infrastructure and...

  • Recruiting Coordinator

    Found in: beBee jobs US - 1 week ago


    Colorado Springs, Colorado, United States Skyline Products Full time

    **We are only looking for local candidates at this time.**Skyline Products is seeking a highly organized and detail-oriented Recruiting Coordinator to join our team. The ideal candidate will have experience in HR administrative tasks and possess strong communication and interpersonal skills. As a Recruiting Coordinator, you will play a key role in supporting...

  • Senior MySQL Database Administrator

    Found in: beBee jobs US - 2 weeks ago


    Steamboat Springs, Colorado, United States Cynet Systems Full time

    Responsibilities And Skills:Analyze and optimize database and server performance.Develop and maintain automated processes for routine database tasks.Streamline operational procedures through automation to improve productivity.Collaborate closely with application development teams to provide database support.Troubleshoot and resolve database-related issues...

  • ASC Sales Manager

    Found in: beBee jobs US - 1 week ago


    Colorado Springs, Colorado, United States Johnson & Johnson Full time

    DePuy Synthes , part of the Johnson & Johnson Medical Devices Companies, provides one of the most comprehensive orthopedics portfolios in the world. DePuy Synthes solutions, in specialties including joint reconstruction, trauma, craniomaxillofacial, spinal surgery and sports medicine, are designed to advance patient care while delivering clinical and...

  • Senior Engineer I

    Found in: beBee jobs US - 2 weeks ago


    Colorado Springs, Colorado, United States Novo Nordisk Full time

    About the Department Our Boston Research & Development hub, anchored in the greater Boston area, brings together the best minds in life science innovation. The teams located in facilities in Lexington, Watertown and Cambridge reflect the full R&D continuum, from early research through late-stage clinical development. Here, we are building for the future,...

  • Catering Sales Manager

    Found in: beBee jobs US - 1 week ago


    Colorado Springs, Colorado, United States The Mining Exchange Full time

    About The OpportunityPractice Hospitality is seeking an experienced Catering Sales Manager to join the team at the Mining Exchange Hotel & Spa.About The HotelMining Exchange Hotel & Sap was built in 1902 as a stock exchange for local mining companies, The Mining Exchange Hotel & Spa offers a one-of-a-kind experience in the heart of downtown Colorado Springs....

  • Relationship Banker

    Found in: beBee jobs US - 2 weeks ago


    Colorado Springs, Colorado, United States Bank of America Full time

    Job Description:At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. Responsible Growth is how we run our company and how we deliver for our clients, teammates, communities and shareholders every day. One of the keys to driving Responsible Growth is being a great place to work for...

  • Project Manager

    Found in: beBee jobs US - 2 weeks ago


    Colorado Springs, Colorado, United States AVOMIND Full time

    Our client specializes in market research, digital marketing and direct marketing for consultants, corporations, agencies, and other companies. They are a leading provider of market research and technology services in the United States, experiencing rapid growth. They take pride in their foundation of superior sample quality and customer service that goes...