University of Colorado
IT Senior Business Intelligence Developer
University of Colorado, Aurora, Colorado, United States, 80012
IT Senior Business Intelligence Developer
Description
University of Colorado Anschutz Medical Campus
Department: School of Medicine, IT Shared Services
Job Title: Information Sciences Senior Professional, Senior Business Intelligence Developer
Position #: '00830092 - Requisition #:35836
Job Summary:
Key Responsibilities:
Business Intelligence (BI) Tools and Reporting - 40%
Create business intelligence tools and reports, such as physical data models and dimensional analyses.
Author, deploy, and support end-user reports, dashboards, and tools built in PowerBI, SQL Server Reporting Services, Excel, and others.
Complete full lifecycle development for business intelligence (BI) reports and applications.
Analyze user needs and requirements to modify or enhance existing reports, data models, and tools.
Validate and test outputs for accuracy; perform code review, conduct data product user-acceptance testing, and other related testing.
SQL Server Analysis Services (SSAS) - 20%
Assist in the development, deployment, and maintenance of SQL Server Analysis Services tabular models.
Configure data sources, load and modify tables/partitions, create measures, relationships, and model roles to apply row-level-security.
Assist in authoring novel measures using DAX query language.
Data Warehousing Concepts and Technologies- 20%
Provide hands-on participation with common analytics and data warehousing concepts & technologies such as data marts, star schemas, facts and dimensions.
Assist with development and maintenance of ETL integration processes by monitoring daily imports, ODBC connections and event/error management.
Troubleshoot and optimize ETL pipelines, SQL queries, and ETL jobs for optimal system performance.
Data Architecture and Warehousing- 10%
Participate in the design, development, and analysis of data architecture, warehousing, and reporting methodologies.
Design, develop, deploy, and maintain MS SQL databases within School of Medicine Data Warehouse.
Process Improvement & Documentation- 5%
Proactively identify opportunities for process improvement to add value or create efficiencies (performance tuning, code reusability, etc.).
Create, update and maintain technical documentation for all data sources, business rules, and data processes.
End User Support - 5%
Provide direct support to end users of analytics products, including handling support tickets, bug reports, access requests, and general education.
Work Location:
Remote
Why Join Us:
Why work for the University?
Medical: Multiple plan options
Dental: Multiple plan options
Additional Insurance: Disability, Life, Vision
Retirement 401(a) Plan: Employer contributes 10% of your gross pay
Paid Time Off: Accruals over the year
Vacation Days: 22/year (maximum accrual 352 hours)
Sick Days: 15/year (unlimited maximum accrual)
Holiday Days: 10/year
Tuition Benefit: Employees have access to this benefit on all CU campuses
ECO Pass: Reduced rate RTD Bus and light rail service
Diversity and Equity:
Qualifications:
Minimum Qualifications:
A bachelor's degree in Computer Science, Information Technology, or related field.
At least 2 years professional level experience as a business intelligence developer, software developer, programmer or related occupation which includes experience working with SQL queries to extract data from relational databases (SQL Server and Oracle) in addition to creating stored procedures, views, and user-defined functions.
A combination of education and related technical/paraprofessional experience may be substituted for the bachelor's degree on a year for year basis.
Preferred Qualifications:
2 years' experience with PowerBI, Tableau or other similar data visualization tools.
Bachelor's degree in finance or scientific field and/or experience working with finance or higher education administration.
4+ years' experience developing BI solutions built on the Microsoft SQL Server Business Intelligence stack: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS).
4+ years' experience implementing analytical data models within a data warehouse environment (star, snowflake, etc.).
2+ years' experience with PowerBI, Tableau or other similar data visualization tools.
Experience with Microsoft SQL Server Analysis Services Tabular Model development (as opposed to Multi-Dimensional Model development)
Experience implementing Kimball Group dimensional modeling techniques
Experience implementing data-driven role-based row-level security within PowerBI and SQL Server Analysis Services Tabular models.
Experience with Microsoft Power Query Language (M) and DAX (Data Analysis Expressions)
Experience with Microsoft Azure ETL tools such as Azure Data Factory, Azure Functions, Azure Blob Storage
Experience with version control systems such as Git
Experience with code repositories and collaboration platforms such as GitHub
Knowledge, Skills and Abilities:
Ability to convey technical information to technical and non-technical users.
Understanding best practices for data reporting and data visualization.
Professional, service-oriented, meticulous, and detail oriented. Readily takes ownership and responsibility for work.
Inquisitive, self-starter with the ability to work independently while also contributing to team efforts.
Ability to prioritize multiple projects and requirements while meeting deadlines.
Ability to thrive in ambiguous environments.
Ability to create and maintain business requirements and other technical documentation.
How to Apply:
Screening of Applications Begins:
February 6, 2024.
Anticipated Pay Range:
HIRING RANGE:
ADA Statement:
Background Check Statement:
Vaccination Statement:
Job Category
Primary Location
Schedule
Posting Date
Unposting Date
To apply, visit https://cu.taleo.net/careersection/2/jobdetail.ftl?job=35836&lang=en (https://apptrkr.com/5908959)
Copyright 2024 Jobelephant.com Inc. All rights reserved.
Posted by the FREE value-added recruitment advertising agency (https://www.jobelephant.com/)
IT Senior Business Intelligence Developer - 35836 University Staff
The School of Medicine Information Services team has an opening for a full-time Information Technology Senior Professional Business Intelligence Developer. This position will assist in the design, development, testing and maintenance of performance-optimized Business Intelligence (BI) solutions for the School of Medicine. This position requires an excellent communicator, a curious and inquisitive temperament, and a strong background in developing enterprise level data solutions. The BI Developer will be responsible for implementing and maintaining numerous BI solutions for a diverse set of stakeholders within the School of Medicine. This role will work closely with School of Medicine data owners to translate business processes and requirements into BI tools that support business operations and strategy.
this role is eligible to work remotely, but the employee must be in the United States.
Are you passionate about leveraging technology to advance health science education and research? At the School of Medicine Information Services, we are dedicated to making a significant impact through innovative technology solutions. Our team provides a wide range of services, including custom development, data collection, analytics, consulting, technology support, security and compliance, web design, and much more.As a member of our team, you'll collaborate with top-tier professionals to support clinical, research, and educational initiatives. You'll have the opportunity to work on cutting-edge projects, enhance your skills, and contribute to a mission-driven organization that values customer-centric service and technological excellence. If you're ready to be part of a forward-thinking team that is transforming the future of healthcare through technology, we invite you to apply and join us in making a difference!We have AMAZING benefits and offerexceptional amounts of holiday, vacation and sick leave! The University of Colorado offers an excellent benefits package including: There are many additional perks & programs with the CU Advantage (https://apptrkr.com/get_redirect.php?id=5908959&targetURL=https://advantage.cu.edu/) .
The University of Colorado Anschutz Medical Campus is committed to recruiting and supporting a diverse student body, faculty and administrative staff. The university strives to promote a culture of inclusiveness, respect, communication and understanding. We encourage applications from women, ethnically minoritized individuals, persons with disabilities, persons within the LGBTQ+ community and all veterans. In addition, the Anschutz Campus has also been recognized as an Age-Friendly University. The University of Colorado is committed to diversity and equality in education and employment.
Applicants must meet minimum qualifications at the time of hire.
For full consideration, please submit the following document(s):1. Curriculum vitae / Resume2. Three to five professional references, including name, address, phone number (mobile number if appropriate), and email addressQuestions should be directed to: Michelle Dedin at michelle.dedin@cuanschutz.edu (https://apptrkr.com/get_redirect.php?id=5908959&targetURL=michelle.dedin@cuanschutz.edu)
Immediately and continues until If this option is used, the posting will come down on the date indicated. The hiring department will need to notify their Talent Acquisition Consultant if the role needs to be reposted.
The starting salary range (or hiring range) for this position has been established as $80,000 - $100,000The above salary range (or hiring range) represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting. This position may be eligible for overtime compensation, depending on the level.Your total compensation goes beyond the number on your paycheck. The University of Colorado provides generous leave, health plans and retirement contributions that add to your bottom line.Total Compensation Calculator: http://www.cu.edu/node/153125 (https://apptrkr.com/get_redirect.php?id=5908959&targetURL=http://www.cu.edu/node/153125)
The University will provide reasonable accommodations to applicants with disabilities throughout the employment application process. To request an accommodation pursuant to the Americans with Disabilities Act, please contact the Human Resources ADA Coordinator at hr.adacoordinator@cuanschutz.edu (https://apptrkr.com/get_redirect.php?id=5908959&targetURL=hr.adacoordinator@cuanschutz.edu) .
The University of Colorado Anschutz Medical Campus is dedicated to ensuring a safe and secure environment for our faculty, staff, students and visitors. To assist in achieving that goal, we conduct background investigations for all prospective employees.
CU Anschutz strongly encourages vaccination against the COVID-19 virus and other vaccine preventable diseases (https://apptrkr.com/get_redirect.php?id=5908959&targetURL=https://www.cdc.gov/vaccines/schedules/downloads/adult/adult-combined-schedule.pdf) . If you work, visit, or volunteer in healthcare facilities or clinics operated by our affiliated hospital or clinical partners or by CU Anschutz, you will be required to comply with the vaccination and medical surveillance policies of the facilities or clinics where you work, visit, or volunteer, respectively. In addition, if you work in certain research areas or perform certain safety sensitive job duties, you must enroll in the occupational health medical surveillance program (https://apptrkr.com/get_redirect.php?id=5908959&targetURL=https://research.cuanschutz.edu/ehs/home/divisions/occupational-health/oh-enrollment) . Application Materials Required: Cover Letter, Resume/CV, List of References : Information Technology : Remote Department: U0001 -- Anschutz Med Campus or Denver - 21751 - SOM-DEAN DO Shared Srvc-InfoTc : Full-time : Jan 6, 2025 : Ongoing Posting Contact Name: Michelle Dedin Posting Contact Email: michelle.dedin@cuanschutz.edu (https://apptrkr.com/get_redirect.php?id=5908959&targetURL=michelle.dedin@cuanschutz.edu) Position Number: 00830092jeid-3aca7418781d9d4391d3e5b75804b3f0
The University of Colorado does not discriminate on the basis of race, color, national origin, sex, age, pregnancy, disability, creed, religion, sexual orientation, gender identity, gender expression, veteran status, political affiliation, or political philosophy. All qualified individuals are encouraged to apply.
Description
University of Colorado Anschutz Medical Campus
Department: School of Medicine, IT Shared Services
Job Title: Information Sciences Senior Professional, Senior Business Intelligence Developer
Position #: '00830092 - Requisition #:35836
Job Summary:
Key Responsibilities:
Business Intelligence (BI) Tools and Reporting - 40%
Create business intelligence tools and reports, such as physical data models and dimensional analyses.
Author, deploy, and support end-user reports, dashboards, and tools built in PowerBI, SQL Server Reporting Services, Excel, and others.
Complete full lifecycle development for business intelligence (BI) reports and applications.
Analyze user needs and requirements to modify or enhance existing reports, data models, and tools.
Validate and test outputs for accuracy; perform code review, conduct data product user-acceptance testing, and other related testing.
SQL Server Analysis Services (SSAS) - 20%
Assist in the development, deployment, and maintenance of SQL Server Analysis Services tabular models.
Configure data sources, load and modify tables/partitions, create measures, relationships, and model roles to apply row-level-security.
Assist in authoring novel measures using DAX query language.
Data Warehousing Concepts and Technologies- 20%
Provide hands-on participation with common analytics and data warehousing concepts & technologies such as data marts, star schemas, facts and dimensions.
Assist with development and maintenance of ETL integration processes by monitoring daily imports, ODBC connections and event/error management.
Troubleshoot and optimize ETL pipelines, SQL queries, and ETL jobs for optimal system performance.
Data Architecture and Warehousing- 10%
Participate in the design, development, and analysis of data architecture, warehousing, and reporting methodologies.
Design, develop, deploy, and maintain MS SQL databases within School of Medicine Data Warehouse.
Process Improvement & Documentation- 5%
Proactively identify opportunities for process improvement to add value or create efficiencies (performance tuning, code reusability, etc.).
Create, update and maintain technical documentation for all data sources, business rules, and data processes.
End User Support - 5%
Provide direct support to end users of analytics products, including handling support tickets, bug reports, access requests, and general education.
Work Location:
Remote
Why Join Us:
Why work for the University?
Medical: Multiple plan options
Dental: Multiple plan options
Additional Insurance: Disability, Life, Vision
Retirement 401(a) Plan: Employer contributes 10% of your gross pay
Paid Time Off: Accruals over the year
Vacation Days: 22/year (maximum accrual 352 hours)
Sick Days: 15/year (unlimited maximum accrual)
Holiday Days: 10/year
Tuition Benefit: Employees have access to this benefit on all CU campuses
ECO Pass: Reduced rate RTD Bus and light rail service
Diversity and Equity:
Qualifications:
Minimum Qualifications:
A bachelor's degree in Computer Science, Information Technology, or related field.
At least 2 years professional level experience as a business intelligence developer, software developer, programmer or related occupation which includes experience working with SQL queries to extract data from relational databases (SQL Server and Oracle) in addition to creating stored procedures, views, and user-defined functions.
A combination of education and related technical/paraprofessional experience may be substituted for the bachelor's degree on a year for year basis.
Preferred Qualifications:
2 years' experience with PowerBI, Tableau or other similar data visualization tools.
Bachelor's degree in finance or scientific field and/or experience working with finance or higher education administration.
4+ years' experience developing BI solutions built on the Microsoft SQL Server Business Intelligence stack: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS).
4+ years' experience implementing analytical data models within a data warehouse environment (star, snowflake, etc.).
2+ years' experience with PowerBI, Tableau or other similar data visualization tools.
Experience with Microsoft SQL Server Analysis Services Tabular Model development (as opposed to Multi-Dimensional Model development)
Experience implementing Kimball Group dimensional modeling techniques
Experience implementing data-driven role-based row-level security within PowerBI and SQL Server Analysis Services Tabular models.
Experience with Microsoft Power Query Language (M) and DAX (Data Analysis Expressions)
Experience with Microsoft Azure ETL tools such as Azure Data Factory, Azure Functions, Azure Blob Storage
Experience with version control systems such as Git
Experience with code repositories and collaboration platforms such as GitHub
Knowledge, Skills and Abilities:
Ability to convey technical information to technical and non-technical users.
Understanding best practices for data reporting and data visualization.
Professional, service-oriented, meticulous, and detail oriented. Readily takes ownership and responsibility for work.
Inquisitive, self-starter with the ability to work independently while also contributing to team efforts.
Ability to prioritize multiple projects and requirements while meeting deadlines.
Ability to thrive in ambiguous environments.
Ability to create and maintain business requirements and other technical documentation.
How to Apply:
Screening of Applications Begins:
February 6, 2024.
Anticipated Pay Range:
HIRING RANGE:
ADA Statement:
Background Check Statement:
Vaccination Statement:
Job Category
Primary Location
Schedule
Posting Date
Unposting Date
To apply, visit https://cu.taleo.net/careersection/2/jobdetail.ftl?job=35836&lang=en (https://apptrkr.com/5908959)
Copyright 2024 Jobelephant.com Inc. All rights reserved.
Posted by the FREE value-added recruitment advertising agency (https://www.jobelephant.com/)
IT Senior Business Intelligence Developer - 35836 University Staff
The School of Medicine Information Services team has an opening for a full-time Information Technology Senior Professional Business Intelligence Developer. This position will assist in the design, development, testing and maintenance of performance-optimized Business Intelligence (BI) solutions for the School of Medicine. This position requires an excellent communicator, a curious and inquisitive temperament, and a strong background in developing enterprise level data solutions. The BI Developer will be responsible for implementing and maintaining numerous BI solutions for a diverse set of stakeholders within the School of Medicine. This role will work closely with School of Medicine data owners to translate business processes and requirements into BI tools that support business operations and strategy.
this role is eligible to work remotely, but the employee must be in the United States.
Are you passionate about leveraging technology to advance health science education and research? At the School of Medicine Information Services, we are dedicated to making a significant impact through innovative technology solutions. Our team provides a wide range of services, including custom development, data collection, analytics, consulting, technology support, security and compliance, web design, and much more.As a member of our team, you'll collaborate with top-tier professionals to support clinical, research, and educational initiatives. You'll have the opportunity to work on cutting-edge projects, enhance your skills, and contribute to a mission-driven organization that values customer-centric service and technological excellence. If you're ready to be part of a forward-thinking team that is transforming the future of healthcare through technology, we invite you to apply and join us in making a difference!We have AMAZING benefits and offerexceptional amounts of holiday, vacation and sick leave! The University of Colorado offers an excellent benefits package including: There are many additional perks & programs with the CU Advantage (https://apptrkr.com/get_redirect.php?id=5908959&targetURL=https://advantage.cu.edu/) .
The University of Colorado Anschutz Medical Campus is committed to recruiting and supporting a diverse student body, faculty and administrative staff. The university strives to promote a culture of inclusiveness, respect, communication and understanding. We encourage applications from women, ethnically minoritized individuals, persons with disabilities, persons within the LGBTQ+ community and all veterans. In addition, the Anschutz Campus has also been recognized as an Age-Friendly University. The University of Colorado is committed to diversity and equality in education and employment.
Applicants must meet minimum qualifications at the time of hire.
For full consideration, please submit the following document(s):1. Curriculum vitae / Resume2. Three to five professional references, including name, address, phone number (mobile number if appropriate), and email addressQuestions should be directed to: Michelle Dedin at michelle.dedin@cuanschutz.edu (https://apptrkr.com/get_redirect.php?id=5908959&targetURL=michelle.dedin@cuanschutz.edu)
Immediately and continues until If this option is used, the posting will come down on the date indicated. The hiring department will need to notify their Talent Acquisition Consultant if the role needs to be reposted.
The starting salary range (or hiring range) for this position has been established as $80,000 - $100,000The above salary range (or hiring range) represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting. This position may be eligible for overtime compensation, depending on the level.Your total compensation goes beyond the number on your paycheck. The University of Colorado provides generous leave, health plans and retirement contributions that add to your bottom line.Total Compensation Calculator: http://www.cu.edu/node/153125 (https://apptrkr.com/get_redirect.php?id=5908959&targetURL=http://www.cu.edu/node/153125)
The University will provide reasonable accommodations to applicants with disabilities throughout the employment application process. To request an accommodation pursuant to the Americans with Disabilities Act, please contact the Human Resources ADA Coordinator at hr.adacoordinator@cuanschutz.edu (https://apptrkr.com/get_redirect.php?id=5908959&targetURL=hr.adacoordinator@cuanschutz.edu) .
The University of Colorado Anschutz Medical Campus is dedicated to ensuring a safe and secure environment for our faculty, staff, students and visitors. To assist in achieving that goal, we conduct background investigations for all prospective employees.
CU Anschutz strongly encourages vaccination against the COVID-19 virus and other vaccine preventable diseases (https://apptrkr.com/get_redirect.php?id=5908959&targetURL=https://www.cdc.gov/vaccines/schedules/downloads/adult/adult-combined-schedule.pdf) . If you work, visit, or volunteer in healthcare facilities or clinics operated by our affiliated hospital or clinical partners or by CU Anschutz, you will be required to comply with the vaccination and medical surveillance policies of the facilities or clinics where you work, visit, or volunteer, respectively. In addition, if you work in certain research areas or perform certain safety sensitive job duties, you must enroll in the occupational health medical surveillance program (https://apptrkr.com/get_redirect.php?id=5908959&targetURL=https://research.cuanschutz.edu/ehs/home/divisions/occupational-health/oh-enrollment) . Application Materials Required: Cover Letter, Resume/CV, List of References : Information Technology : Remote Department: U0001 -- Anschutz Med Campus or Denver - 21751 - SOM-DEAN DO Shared Srvc-InfoTc : Full-time : Jan 6, 2025 : Ongoing Posting Contact Name: Michelle Dedin Posting Contact Email: michelle.dedin@cuanschutz.edu (https://apptrkr.com/get_redirect.php?id=5908959&targetURL=michelle.dedin@cuanschutz.edu) Position Number: 00830092jeid-3aca7418781d9d4391d3e5b75804b3f0
The University of Colorado does not discriminate on the basis of race, color, national origin, sex, age, pregnancy, disability, creed, religion, sexual orientation, gender identity, gender expression, veteran status, political affiliation, or political philosophy. All qualified individuals are encouraged to apply.