Senior Business Intelligence Developer

Under minimal supervision design reports data models table structures and data pipelines to facilitate enterprise reporting and analytics and to aid in decision-making for the University community.

Duties include: architect and deliver dashboards reports analyses data models pipelines and data warehousing solutions; work with clients to plan design develop implement and enhance applications scripts procedures and metadata; design data warehouse schema and define extract/transform/load (ETL) processes for the data warehouse in collaboration with ETL developers and database administrators; design document configure and optimize database architectures and applications; monitor the data warehouse and business intelligence system performance and integrity; enhance and debug dashboards and reports; support enterprise data warehousing data models dashboards infographics and future data information systems; promote best practices in data management and software development within the Institutional Research and Effectiveness team; support and guide junior Business Intelligence Analysts.

Requires a Bachelors degree in Computer Science Computer Engineering Information Systems or a related field and 4 years of experience or alternatively a Masters degree and 2 years of experience. Experience must include working with business intelligence tools (e.g. Tableau MicroStrategy); SQL; ETL tools (e.g. Informatica); transaction and data warehouse databases (e.g. Oracle); data modeling; data governance security and compliance; and Agile collaboration. Must work in the office at least one day per week. Aptitude test required.