Vacancy expired!
Business Intelligence Developer (IT Principal Professional) 6-month W2 contract to hire Location: Aurora, CO Hybrid schedule Dean’s Office has an opening for a full-time University Staff (unclassified) Business Intelligence Developer (IT Principal Professional) position. Examples of Work Performed:
- Create business intelligence tools and reports, such as physical data models and dimensional analyses.
- Participate in the design, development, and analysis of data architecture, warehousing, and reporting methodologies.
- Provide hands-on participation with common analytics and data warehousing concepts & technologies such as data marts, star schemas, facts and dimensions.
- Author, deploy, and support end-user reports and dashboards built in SQL Server Reporting Services, PowerBI, and Tableau.
- Develop, deploy, and maintain 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.
- Author novel measures using DAX query language.
- Assist with the design of the dimensional models core to BI reporting platforms and systems.
- Develop and oversee ETL integration processes by monitoring daily imports, ODBC connections and event / error management.
- Design, develop, deploy, and maintain MS SQL databases within School of Medicine Data Warehouse.
- Troubleshoot and optimize ETL pipelines, SQL queries, and ETL jobs for optimal system performance.
- Complete full lifecycle development for business intelligence (BI) reports and applications. Analyze user needs and requirements to modify existing reports and systems.
Vacancy expired!