Senior Data & Automation Analyst

The Senior Data & Automation Analyst leads the development of data visualization, analytics, and workflow automation for the Office of Research and Innovation (ORI). This role is a hands-on builder who translates business workflows and data into trusted, automated solutions that improve decision-making and operational efficiency. Serving as a vital bridge between enterprise systems and ORI units, centers, and institutes, the analyst aligns front-line processes with modern analytics and automation tools.

Operating as an individual contributor, the role prioritizes high-impact initiatives that advance the research enterprise as a whole.

• Designs, builds, and deploys interactive dashboards, analytics solutions, and automated workflows that streamline operations and drive evidence-based decision-making.
• Interacts with ORI Leaders and other business owners to identify reporting needs and requirements.
• Works with other ORI and/or OIT analysts/architects to design and implement reporting data models to support ORI reporting needs.
• Champions the adoption of generative AI tools, prompt-assisted data manipulation, and modern low-code technologies to eliminate manual repetitive steps, transform data tables, and draft automated documentation.
• Audits, catalogs, and labels operational transaction records to facilitate clean migration into enterprise data repositories and Databricks schemas.
• Evaluates/revises data models for accuracy and performance efficiency.
• Acts as an operational data steward by documenting field definitions, business logic, and standard operating procedures, ensuring consistency across Sponsored Programs and Research Data Governance.
• Maintains accurate, well-organized SOPs, policy summaries, FAQs, and how-to guides for AI-assisted tools.
• Ensures content is current, consistently formatted, properly tagged, and aligned with OIT AI team requirements and governance standards.
• Performs other duties as assigned.

• Bachelor’s degree in Business Administration, Mathematics, Data Science, Business Analytics, Computer Science, Information Systems, or a related field and three (3) years of experience working with business intelligence tools and/or data warehouse applications, OR seven (7) years of any equivalent combination of education and experience.
• Experience to include intermediate to advanced level of experience gathering and documenting reporting requirements from stakeholder meetings at executive and operational levels and two (2) years of advanced level in warehousing reporting tools to design reports/visualization tools like Oracle, Microsoft, Tableau, Power BI or SAS.

• Three (3) years advanced experience in data analysis, data warehousing, business requirements and work with data warehousing applications or equivalent experience.
• Experience with Microsoft Power Automate for designing and deploying automated workflow solutions.
• Direct professional experience in building data visualizations and dashboards for grants management or research operations.
• Prior experience or personal experimentation using AI agents or automated workflow builders to optimize day-to-day tasks.

• Demonstrate knowledge working with Oracle/SQL databases.
• Knowledge of 4th generation reporting tools such as Oracle, Microsoft, Data Warehousing Models to produce reports and data driven reporting/visualization requests.
• Excellent communication skills, attention to detail, and documentation skills.
• Ability to work with information systems for students, researchers, and staff.
• Microsoft Office Suite, Visio, Microsoft Teams, and SharePoint.
• Knowledge of Agile Scrum Methods for projects.
• Experience working with Fact/Dimension Tables, Data Cubes for Data Analytics, and AI models for forecasting.

• Monday through Friday; 8:00am through 5:00pm
• Hybrid work environment (remote & office).

• Position is benefit eligible:
  Yes
• We are proud to offer a comprehensive benefits package to our employees at the University.
• https://(Use the "Apply for this Job" box below).-benefits