Accountability Data Specialist

Angelo State University; Town of Texas (WI); On-site; USD 75,000 - 110,000; Full time

Job summary

Angelo State University is seeking a data and reporting professional to design and develop dataset preparation, reporting, and decision support solutions. You will produce dashboards, scorecards, and complex reports using SAS, Power BI, and Cognos for accountability and compliance needs.

Collaboration with IT ensures secure data access and governance. The role emphasizes data quality, best-practice reporting, and timely delivery to campus leadership and governing bodies.

Qualifications

• Bachelor’s degree in a quantitative field, computer science, MIS, business, or related field.
• Three years of experience using reporting software such as SAS and other reporting tools (e.g., Microsoft Power BI, IBM Cognos).
• Willingness to work additional hours during peak times or with a flexible schedule to accommodate business needs.

Responsibilities

• Prepare data visualizations of university data (dashboards, scorecards, and complex reports) using SAS, Power BI, Cognos, and other tools.
• Plan and organize work to meet deadlines and deliver timely reports for accountability bodies.
• Ensure data access controls and protocols protect sensitive information and comply with regulations.

Skills

SAS experience

Power BI

IBM Cognos

SQL

BI report design

data analysis

time management

prioritization

Education

Bachelor’s degree in quantitative field

Tools

SAS

Power BI

IBM Cognos

SQL

Job description

Designs and develops dataset preparation, reporting, and decision support solutions. Captures requirements and designs, creates, manages, and fulfills requests for Accountability/institutional compliance needs, Accountability federal reporting requirements, campus reports, dashboards, and scorecards through report writing tools, including SAS , Microsoft Power BI, IBM Cognos, and other software tools. Works in the Office of Accountability and collaborates with Information Technology on data access and architecture needs to ensure information is accessed and managed in a common way. Supports reporting requirements for IPEDS , THECB , LBB , and other accountability initiatives.

• Plans and organizes work to ensure completion of tasks and functions in a timely manner, prior to all deadlines.
• Prepare data visualizations of university data (strategic dashboards, scorecards, and complex reports) based on goals, priorities and key performance indicators. This includes using SAS and other reporting/data visualization tools (example: Microsoft Power BI, IBM Cognos and other software) for reporting needs.
• Propose/initiate procedures and evaluate existing procedures to effect improved or additional methods for handling or reporting information.
• Focus on compliance and information reports for the campus and governing bodies like SACSCOC , the Texas Tech University System, Texas Higher Education Coordinating Board, IPEDS , etc.
• Strong general programming skills to provide data needed to support institutional decision-making. Provide strategic information analysis and decision support by identifying gaps and outliers in data as projects are being created, updated, or analyzed.
• Proactively identify data issues, propose solutions, and respond to requests to address data quality and analysis concerns.
• Work with Accountability leadership to develop and implement protocols, processes, and timelines for data collection, data review and correction, and dataset preparation. Manage access/protocols to the Accountability reporting environment to ensure that key stakeholders have appropriate/need-to-know access to data.
• Ensure access to sensitive information is adequately protected and only given to individuals with appropriate approvals, including an institutional justification with a ‘need to know’ approach. Coordinate with Information Technology to ensure access methods align with campus requirements.
• Leverage multiple database resources appropriately to ensure consistent data management methods are followed. Work closely with Information Technology to collaborate and align data management procedures ensuring data is used in a manner consistent with its meaning and following agreed-upon campus reporting naming conventions and processes when creating and managing reports/dashboards. Address reporting issues as they arise and help to maintain Accountability infrastructure.
• Maintains consistent and accurate communication with the Assistant Vice President of Accountability and Analytics as well as constituencies.
• Assists the Assistant Vice President of Accountability and Analytics in monitoring changes, in a timely manner, and adhering to institutional, state, and/or federal rules and regulations.
• Prepares correspondence and other written documentation ensuring timelines and milestones are met.
• Participates in training activities and meetings as required or needed.
• Performs other duties as assigned.

Knowledge

• Experience of SAS software and reporting tools such as (Microsoft Power BI, IBM Cognos, and other associated components).
• Knowledge of design, development, and maintenance of Business Intelligence reports, dashboards, metrics, and other reporting constructs.
• Knowledge of the Analytics/Report Design processes, strategic thinking, critical thinking, analytical ability.
• Knowledge of relational database, SAS , SQL and query tools.

Skills

• Skill in priority and time management.
• Skill in SQL and structured programming techniques.
• Skill in maintaining accurate records and logs

Abilities

• Ability to communicate effectively, both orally and written, with skill in interpersonal relations.
• Ability to interpret and understand the needs and concerns of collaborators to generate appropriate follow-up analyses, reports, and identification of potential planning priorities.
• Ability to effectively analyze situations and develop suitable solutions.
• Ability to work as a cooperative team member across all levels of the organization, while also having strong independent skills.
• Ability to share knowledge while also keeping confidentiality and secure PII and other protected data and information.
• Ability to work with large and complex computer databases.
• Ability and willingness to pay attention to detail, organize, be proactive, think logically, work both independently and in groups, work with numbers, maintain confidentiality and follow policies and regulations.
• Ability to perform mathematical calculations
• Ability to organize workflow and complete detailed tasks accurately and in a timely manner
• Ability to maintain confidentiality and follow policies and regulations

Minimum Qualifications

• Bachelor’s degree in a quantitative field, computer science, MIS , business, or another related field.
• Three years of experience using reporting software such as SAS and other reporting tools (example: Microsoft Power BI, IBM Cognos, etc) or area dealing with numbers—and accompanying issues regarding accuracy, organization, and detail—and record of supporting multiple but very different projects simultaneously using programming. Preferred experience and qualifications can stand in lieu of education. Must be willing to work additional hours during peak times and/or flexible schedule to accommodate business needs.

Preferred Qualifications

The following is not required; however is preferred. Knowledge and/or experience with data extraction tools SAS Enterprise guide, SQL , interactive analytic or dashboard of SAS , Microsoft tools, Tableau, data extraction tools.

Physical Requirements

Requires prolonged period of sitting, occasional walking, and intermittent bendingand standing; medium level of manual dexterity; occasional lifting up to 25-50 lbs.

EEO Statement

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, disability, genetic information, or status as a protected veteran.

In compliance with the Americans with Disabilities Act ( ADA ), Angelo State University is committed to providing reasonable accommodations to ensure equal access to employment opportunities for qualified individuals with disabilities. We are committed to ensuring that a qualified individual with a disability has the same rights and privileges in employment as non-disabled employees. If an accommodation is requested for the job application process, please contact our office at [phone] or email us at [e-mail] .