Business Intelligence Developer (School of Dentistry)

Job DescriptionResponsible for providing strategic, analytical and technical support in all business intelligence solutions for the Institution.Responsibilities• Responsible for aggregating data from multiple sources in an efficient data warehouse and designing enterprise-level solutions for tabular models.• Develops dashboards, pivot functions, and reports for key performance indicators, business metrics and operational data.• Optimizes and updates, complex cubes, tabular models, queries and reporting applications.• Maintains and tests data integrity.• Works with business analysts and contacts to understand needs requirements, and develops and maintains data models to support those needs.• Performs all other duties as assigned.Qualifications• Related experience including: Business Intelligence, requirements analysis, design, data modeling and data warehouse design.• Experience with SQL and relational database, systems analysis and design, Microsoft SQL Server development experience, including database design, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services SSIS; web based reporting tools, Microsoft Office, Visio, SharePoint, ETL and BI tools are strongly desired.• Proven experience sourcing data from a variety of applications, creating OLAP models, and generating multi-dimensional or tabular cubes using SSAS.• Ability to Identify and resolves problems in a timely manner; gathers and analyzes information skillfully; and develops alternative solutions.• Proven abilities to take initiative and be innovative.Education• Bachelor's degree in Computer Science, Management Information Systems, or related field is required. Will accept experience in lieu of degree.License And Certification• None.Required SkillsThree (3) years of related experience is required.About UsBenefits OverviewUT Health San Antonio offers an excellent benefits package for its employees. Employees who work at least 20 hours a week, with an appointment of at least 4.5 months, are eligible for benefits.Medical - UT SELECT Medical insurance is offered free for employees and administered by Blue Cross and Blue Shield of Texas. Family members can be added to the plan through payroll deduction. Employees and their dependents can also receive discounted copays and coinsurance when using UT Health Physicians, a network of 800 premier physicians including more than 100 specialists.Dental - Three dental insurance plan options are available for employees and their families through Delta Dental Insurance Company, two PPOs and one dental HMO plan. Both PPO plans allow employees to choose any licensed dentist.Vision - Fully insured Vision Care benefits are offered by Superior Vision Services. Two vision plan options that offer either standard or enhanced vision benefits. Life Employees receive $40,000 of group term life insurance and $40,000 of basic accidental death and dismemberment insurance for free, with options to purchase additional employee and dependent coverage for both at group rates.Retirement - Employees are eligible for either the Teacher Retirement System (TRS) or the Optional Retirement Plan (ORP). TRS is a defined benefit retirement plan which UT Health matches employee contributions. ORP is for eligible faculty staff employees. Voluntary retirement programs are also available to invest before- or after-tax dollars with the choice of five quality retirement plan providers.Time Off - A generous leave program offers multiple paid leave options:• Front-loaded Paid Time Off: 128 to 208 hours (16 to 26 days) of Paid Time Off based on years of service, given at the start of each fiscal year. PTO may be prorated in year one based on date of hire.• Extended Illness Bank: 8 hours (1 day) accrued per month which can be used for illness or injury after one day of Paid Time Off is taken.• Paid Family Leave: Up to 240 hours (6 weeks) to care for a spouse, child, or parent after 6 months of consecutive employment.• Holidays: 12 set paid holidays each year.FSAs - Employees can enroll in flexible spending accounts (FSAs) to set aside money from earnings before taxes for qualifying dependent day care expenses or out-of-pocket health care expenses.Discounts - Employees enjoy a range of discounts on services, tickets, and gym membership.EEO StatementUT Health San Antonio is an equal employment opportunity and affirmative action employer. It is our policy to promote and ensure equal employment opportunity for all individuals without regard to race, color, religion, sex, gender identity, national origin, age, sexual orientation, disability, or veteran status.