Business Intelligence Developer II

Do you enjoy writing good SQL code? Do you like figuring out what data can tellyou about a business? Ohio University seeks a solutions-oriented BI Developer tojoin its central IT organization.Ohio University has embarked upon strategic initiatives that require efficient andeffective uses of data. You can have a key role in the fulfilling of these initiativesby applying your SQL and data reporting skills to University data. You will enhance existing and develop new operational and analytical reporting solutions. You willwork on a variety tight-deadline, quick turnaround tasks as well as longer termprojects to elevate existing solutions utilizing industry best practices.Apply for this position if you consider yourself a self-starter, excellent communicatorand solid team player. Other skills that will make you successful in this position include being:• well organized• detail-oriented• keen on following data security best practices• quick to learn both technology and processes• and able to juggle multiple projectsThe BI Developer II is a member of the Ohio University Information Delivery team. This is a junior position responsible for assisting in the design, development and delivery ofreporting solutions for Ohio University. This includes developing moderately complex data models, queries and custom reports for operational and analytical reporting.Key Accountabilities:• Participates in the development, maintenance and support of an enterprise data warehouse system and corresponding data marts. Perform data warehouse design anddevelopment requiring an advanced knowledge of business processes, source data,and SQL language features, including creating scripts, stored procedures, indexes and views. Troubleshoot existing data warehouse applications. Responsible for metadata and repository creation. Provide secondary analytical support for multiple functional areas.• Responsible for creating moderately complex database reports based on the needs ofend users. Incorporate end user requests and requirements to develop an enterprisereporting solution. Requires advanced knowledge of SQL programming. Review queries forperformance issues, making changes as needed. Provide secondary operational supportfor multiple functional areas.• Leverage an advanced understanding of reporting application features to support the usercommunity in the use of business intelligence tools to query files and databases for reportoutputs. Assist customers in use of OLAP tools, extract and collect data for performingqueries and writing reports.• Other duties as assigned.