IU School of Medicine has an exciting, new opportunity as a data analyst to support the growing data needs of the organization. As part of the Office of Business Intelligence, the data analyst will develop queries to make data available to all levels of stakeholders. The data analyst will work closely with business intelligence analysts to understand the data needs for reporting and high-profile initiatives like the school's strategic plan. Using industry best practices, they will create efficient and reliable data assets to be used throughout the Office of Business Intelligence's data environment.
This role offers the opportunity to develop your technical skills (specifically SQL) while still learning about and impacting the business as a whole. It will allow you to apply and further develop your understanding of data, and identify ways to bring systems and databases together. Confidence in SQL and a talent for turning raw data into useful information is key.
If you have a curious nature, positive approach to problem solving and finding solutions for complex needs, and thrive on the idea of becoming an expert of the IU School of Medicine’s data environment, this could be an ideal opportunity for you!
The data analyst partners and consults with business intelligence analysts and school stakeholders to identify, discern, assess, and evaluate underlying business needs and requirements. The data analyst scopes the query, asset or model that will serve as a consistent and reliable solution. Based on the request, conduct significant discovery across multiple databases/warehouses and source systems to assess/scope query to determine extent to which business need/request can be accomplished. The data analyst then develops requested queries (primarily SQL), assets, extracts, data models, and other solutions to meet the data needs of business partners and the Office of Business Intelligence.
The data analyst will lead and provide analysis for transitioning existing data assets into a comprehensive business intelligence environment by developing methods for database design, validation reports, etc. Engage and consult with university and CAITS technical staff to effectively communicate technical requirements for the data assets and accompanying ETL as well as monitoring progress and ensuring data integrity.
Additionally, the data analyst provides technical and operational support, information and analysis to school leadership and external business partners to deliver consistent and reliable data-sharing and transfers, and assist in strategic and long-term planning and decision making. This includes developing queries, data assets, and SSRS reports to enable high-availability and self-serve methods. The data analyst will also oversee regular and high priority data-sharing and migration activities to ensure processes are completed in a timely, and satisfactory manner.
REQUIRED: Four-year degree BS/BA, plus 1-3 years' data analysis experience.
Combination of experience/education at a 2:1 ratio.
Demonstrated experience with query development and data analysis. Working knowledge of SQL, including ability to write queries of intermediate complexity. Understanding of relational data models and data warehousing. Understanding of basic HTML and web development. Ability to communicate effectively both verbally and in writing.
An educational focus in computer science, information systems, technology, statistics, or related field.
Salary Plan: PAE
Salary Grade: 2IT
Campus: IUPUI - Indianapolis
Department: BUSINESS INTELLIGENCE & OPER (IN-DBIO-IUINA)
Internal Number: 66223
About Indiana University
Founded in 1820, Indiana University is the state’s public university system, comprised of two core campuses—IU-Bloomington and IUPUI—and six regional campuses located throughout the state. Combined, the total student population is more than 114,000 undergraduate, graduate and professional school students. IU is one of the largest employers in the state, with over 20,000 faculty and staff. Indiana University is an equal employment and affirmative action employer and a provider of ADA services. Diversity and inclusion remains a core commitment to IU’s mission to cultivate an educational environment that supports equal access, participation and representation on all of its campuses and that provides educational and career opportunities for all.