Data Warehouse Analyst
Data Warehouse Analyst
Posted on :
05-04-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Monthly Salary
Not Disclosed
Salary Not Disclosed
Vacancy
1 Vacancy
Posted on :
05-04-2025
Job Description
Job Summary
The Data Coordinating Center DCC housed within the Division of Pediatric Critical Care at the University of Utah School of Medicine has an immediate opening for a Business Intelligence (BI) Developer position. This position provides qualified candidates with an opportunity to be a part of a highfunctioning cuttingedge academic research operation ARO that is working to accelerate the translation of research to the bedside. The BI Developer will assist in the strategic design and maintenance of streamlined and performanceoptimized BI solutions for the entire DCC organization. In doing such this position will have the opportunity to work on a diverse range of projects and acquire new skills while working alongside some of the most innovative individuals within the industry. Positions are designed to provide growth and professional development opportunities including promotions within a defined career ladder. The University of Utah offers a comprehensive benefits package including: Excellent health care coverage at affordable rates 14.2 retirement contributions that vest immediately Generous paid leave time 11 paid Holidays per year 50 tuition reduction for employee spouse and dependent children Flex spending accounts Free transit on most UTA services Employee discounts on a variety of products and services including cell phones & plans entertainment health and fitness restaurants retail and travel Professional development opportunities Additional benefits information is available at www.hr.utah/benefits
Responsibilities
Essential Functions As a BI Developer your responsibilities will include: 1. Building and Maintaining Reports SSRS Tableau Power BI): The BI Developer will be responsible for creating and managing reports using tools such as SSRS Tableau and Power BI. This involves designing visually appealing and informative reports that meet the specific needs of the business ensuring data accuracy and consistency and updating reports as necessary to reflect changes in business requirements or data structures. 2. Writing AdHoc Queries (T SQL : The role requires proficiency in writing T SQL queries to retrieve and analyze data. This includes writing complex queries for adhoc data requests optimizing query performance and ensuring data integrity. 3. Collecting Requirements and Documenting Processes: A key part of the role is to liaise with business stakeholders to gather and understand their BI requirements. This includes documenting business processes data needs and report specifications as well as communicating these requirements to the technical team for implementation. 4. Developing and Maintaining Extract Transform Load ETL Processes SSIS : The BI Developer will design develop and maintain ETL processes using SSIS . This includes extracting data from various sources transforming it according to business logic and loading it into data warehouses or other storage solutions. 5. Building and Maintaining Online Analytical Processing OLAP Tools SSAS : The role involves creating and managing OLAP cubes using SSAS which includes designing data models setting up measures and dimensions and optimizing cube performance. The ability to build robust and scalable OLAP solutions that support complex data analysis is essential. 6. Following Industry Standards and Best Practices: The BI Developer is expected to stay abreast of the latest trends and best practices in business intelligence and data analytics. This includes adhering to industry standards for data security and privacy ensuring highquality and accurate reporting and continuously seeking ways to improve BI processes and solutions. Disclaimer This job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties responsibilities and qualifications required of employees assigned to the job. Comments Familiar with a variety of the fields concepts practices and procedures. Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of tasks. A wide degree of creativity and latitude is expected. Typically reports to a manager or head of a unit/department. Work Environment and Level of Frequency typically required Nearly Continuously: Office environment. Physical Requirements and Level of Frequency that may be required Nearly Continuously: Sitting hearing listening talking. Often: Repetitive hand motion (such as typing) walking. Seldom: Bending reaching overhead.
Minimum Qualifications
Requires a bachelors degree in area of specialty or equivalency (one year of education can be substituted for two years of related work experience) and 24 years of experience in the field or in a related area. Familiar with a variety of the fields concepts practices and procedures. Applicants must demonstrate the potential ability to perform the essential functions of the job as outlined in the position description.
The Data Coordinating Center DCC housed within the Division of Pediatric Critical Care at the University of Utah School of Medicine has an immediate opening for a Business Intelligence (BI) Developer position. This position provides qualified candidates with an opportunity to be a part of a highfunctioning cuttingedge academic research operation ARO that is working to accelerate the translation of research to the bedside. The BI Developer will assist in the strategic design and maintenance of streamlined and performanceoptimized BI solutions for the entire DCC organization. In doing such this position will have the opportunity to work on a diverse range of projects and acquire new skills while working alongside some of the most innovative individuals within the industry. Positions are designed to provide growth and professional development opportunities including promotions within a defined career ladder. The University of Utah offers a comprehensive benefits package including: Excellent health care coverage at affordable rates 14.2 retirement contributions that vest immediately Generous paid leave time 11 paid Holidays per year 50 tuition reduction for employee spouse and dependent children Flex spending accounts Free transit on most UTA services Employee discounts on a variety of products and services including cell phones & plans entertainment health and fitness restaurants retail and travel Professional development opportunities Additional benefits information is available at www.hr.utah/benefits
Responsibilities
Essential Functions As a BI Developer your responsibilities will include: 1. Building and Maintaining Reports SSRS Tableau Power BI): The BI Developer will be responsible for creating and managing reports using tools such as SSRS Tableau and Power BI. This involves designing visually appealing and informative reports that meet the specific needs of the business ensuring data accuracy and consistency and updating reports as necessary to reflect changes in business requirements or data structures. 2. Writing AdHoc Queries (T SQL : The role requires proficiency in writing T SQL queries to retrieve and analyze data. This includes writing complex queries for adhoc data requests optimizing query performance and ensuring data integrity. 3. Collecting Requirements and Documenting Processes: A key part of the role is to liaise with business stakeholders to gather and understand their BI requirements. This includes documenting business processes data needs and report specifications as well as communicating these requirements to the technical team for implementation. 4. Developing and Maintaining Extract Transform Load ETL Processes SSIS : The BI Developer will design develop and maintain ETL processes using SSIS . This includes extracting data from various sources transforming it according to business logic and loading it into data warehouses or other storage solutions. 5. Building and Maintaining Online Analytical Processing OLAP Tools SSAS : The role involves creating and managing OLAP cubes using SSAS which includes designing data models setting up measures and dimensions and optimizing cube performance. The ability to build robust and scalable OLAP solutions that support complex data analysis is essential. 6. Following Industry Standards and Best Practices: The BI Developer is expected to stay abreast of the latest trends and best practices in business intelligence and data analytics. This includes adhering to industry standards for data security and privacy ensuring highquality and accurate reporting and continuously seeking ways to improve BI processes and solutions. Disclaimer This job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties responsibilities and qualifications required of employees assigned to the job. Comments Familiar with a variety of the fields concepts practices and procedures. Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of tasks. A wide degree of creativity and latitude is expected. Typically reports to a manager or head of a unit/department. Work Environment and Level of Frequency typically required Nearly Continuously: Office environment. Physical Requirements and Level of Frequency that may be required Nearly Continuously: Sitting hearing listening talking. Often: Repetitive hand motion (such as typing) walking. Seldom: Bending reaching overhead.
Minimum Qualifications
Requires a bachelors degree in area of specialty or equivalency (one year of education can be substituted for two years of related work experience) and 24 years of experience in the field or in a related area. Familiar with a variety of the fields concepts practices and procedures. Applicants must demonstrate the potential ability to perform the essential functions of the job as outlined in the position description.
Required Experience:
IC
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
