Job Information
Texas A&M University SQL Data Analyst in United States
Job Title
SQL Data Analyst
Agency
Texas A&M University
Department
Academic & Business Performance Analytics
Proposed Minimum Salary
Commensurate
Job Location
College Station, Texas
Job Type
Staff
Job Description
Who we are
Aca d emi c and Business Per f ormance Analytics (ABPA) collects and submits data to the Texas Higher Education Coordinating Board (THECB), the Integrated Postsecondary Education Data System (IPEDS), and many ranking surveys such as U.S. News, Kiplinger’s, Peterson’s, and Barron’s. ABPA also provides student, course and f aculty data through various reports and online data dashboards f or the university administration and other stakeholders .
What we want
The Data Analyst, under general supervision, gathers, compiles, analyzes, interprets, reports data and identifies patterns.
What you need to know
Salary: $69,190.00
Special Note: A cover letter and resume are strongly encouraged. You may upload them on the application under the CV/Resume section.
Position Details: Must work a minimum of 40 hours a week. We expect employees to work 8-5 M-F, with some flexibility with start/stop times as long as the 40-hour minimum is maintained
Required Education and Experience:
Bachelor’s degree in applicable field or equivalent combination of education and experience.
Three years of related experience in data collection and analysis.
Required Knowledge, Skills, and Abilities
Basic SQL skills, word processing, Excel spreadsheet, and SQL Server database applications.
Ability to multitask and work cooperatively with others.
Excellent verbal and written communication skills.
Preferred Qualifications
Experience working in higher education.
General experience in data management, data dashboard creation, SQL and statistical and analytical skills.
Experience working with SQL to load and update data to existing databases.
Familiarity with relational database design and modern data warehousing techniques.
Essential Duties/Tasks
Processing Data
Runs scripts to load and transform data needed by department for reporting.
This will include each semester class days data processing and produce CBM reports submitting to Texas Higher Education Coordinating Board (THECB).
Uses SQL tools to manipulate, analyze, clean and transform data.
Runs processes during key data acquisition dates.
Ad-hoc Reporting
Responds to data requests by querying various databases. Collects, analyzes and interprets data, both quantitative and qualitative analyses, using accepted statistical methods and qualitative research methods.
Determines best tool for the request including Tableau, Excel, SQL queries, COGNOS, ARGOS, SAS, SPSS, etc.
In some cases, reporting requires acquisition, cleaning and transforming of new data to merge with other data sets.
Compiles data into usable reports.
Routine Reporting
Collects data and produces routine reports needed by other colleges and/or department every semester/year.
Uses SQL tools to pull data and statistical tools to present the output.
Skills Development
- Participates in training and professional development to stay current on tools, skills and methodologies related to job duties.
Other Duties
Performs other duties as assigned and which may include but are not limited to the following:
Collaboration with the data warehouse team to migrate data into new Enterprise Data Warehouse, assignment and participation in university committees, attending University community meetings as required Restrictions and Other
Why Texas A&M University?
We are a prestigious university with strong traditions, Core Values, and a community of caring and collaboration. Amenities associated with a major university, such as sporting and cultural events, state-of-the-art recreation facilities, the Bush Library and Museum, and much more await you. Experience all that a big city has to offer but with a reasonable cost-of-living and no long commutes.
Health (https://www.tamus.edu/business/benefits-administration/medical/) , dental (https://www.tamus.edu/business/benefits-administration/dental/) , vision (https://www.tamus.edu/business/benefits-administration/vision-insurance/) , life and long-term disability insurance (https://www.tamus.edu/business/benefits-administration/life-add/) with Texas A&M contributing to employee health and basic life premiums
12-15 days (https://employees.tamu.edu/employee-relations/leave/index.html) of annual paid holidays
Up to eight hours of paid sick leave (https://employees.tamu.edu/employee-relations/leave/paid/sick.html) and at least eight hours of paid vacation each (https://employees.tamu.edu/employee-relations/leave/paid/vacation.html) month
Automatically enrollment in the Teacher Retirement System of Texas
Health and Wellness: Free exercise programs and release time (https://flourish.tamu.edu/wellness-release-time/)
Professional Development: All employees have access to free LinkedIn Learning (https://linkedinlearning.tamu.edu/) training, webinars, and limited financial support to attend conferences, workshops, and more
Employee Tuition Assistance (https://livingwell.tamu.edu/employee-tuition-assistance/) and Educational Release time (https://employees.tamu.edu/employee-relations/leave/paid/educational.html) for completing a degree while a Texas A&M employee
For additional information on benefits Click here (http://employees.tamu.edu/benefits/_media/documents/200benefitsWellness101.pdf)
All positions are security-sensitive. Applicants are subject to a criminal history investigation, and employment is contingent upon the institution’s verification of credentials and/or other information required by the institution’s procedures, including the completion of the criminal history check.
Equal Opportunity/Affirmative Action/Veterans/Disability Employer.