Senior Data & Automation Analyst

The University of Texas at Arlington; Arlington (TX); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Benefits package

Job summary

The University of Texas at Arlington seeks a Senior Data & Automation Analyst to lead data visualization, analytics, and workflow automation for the Office of Research and Innovation. You will translate business workflows into automated solutions, serve as a bridge between enterprise systems and ORI units, and drive high-impact initiatives across the research enterprise.

You will design dashboards and data models, promote AI-driven processes, and document data definitions and SOPs to ensure

Qualifications

• Experience gathering and documenting reporting requirements from executive and operational stakeholders.
• Two years in warehousing reporting tools to design reports/visualizations.

Responsibilities

• Designs, builds, and deploys dashboards, analytics, and automated workflows.
• Interacts with ORI Leaders to identify reporting needs.
• Works with analysts/architects to design data models for reporting needs.
• Champions AI tools and low-code tech to automate processes and document steps.
• Audits and catalogs transaction records for clean migration into enterprise data repositories.
• Evaluates data models for accuracy and performance.
• Documents definitions, business logic, and SOPs for governance.
• Maintains SOPs, policy summaries, FAQs, and AI tool guides.
• Ensures content is current and properly tagged per governance standards.

Skills

Oracle/SQL databases

Power BI

Tableau

AI tools / generative AI

Data modeling

Data warehousing concepts

Education

Bachelor’s degree in Business Administration, Mathematics, Data Science, Business Analytics, CS, IS

Tools

Databricks

Microsoft Power Automate

Job description

Purpose of Position

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.

Essential Functions

• 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.

Required Qualifications

• 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.

Preferred Qualifications

• 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.

Knowledge, Skills & Abilities

• 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.

Work Schedule

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

Benefits Information

• Position is benefit eligible: Yes
• We are proud to offer a comprehensive benefits package to our employees at the University.
• https://www.uta.edu/hr/employee-benefits