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 Bachelor’s degree in Computer Science, Computer Engineering, Information Systems, or a related field and 4 years of experience, or alternatively, a Master’s 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.
