What are the responsibilities and job description for the Lead Data Analyst position at Texas A&M Health?
Job Description
What we want
The Lead Data Analyst serves as technical lead and lead programmer for a variety of data processes. Provides technical oversight for the application of and compliance with technical standards. May coordinate the technical activities of a systems analysis and development team. Completes reports and summaries for management and users including data requests, data sets for State and Federal agencies, data sets and analyses for University administration and committees, project status reports, problem reports, and progress summaries. Documents all developed processes and reporting methodologies.
What you need to know
Salary : Compensation will be commensurate to selected hire’s experience.
Special Instructions : A cover letter and resume are strongly recommended. You may upload these in the CV / Resume section.
Required Education :
Bachelor’s degree, or equivalent combination of education and experience, in Information Technology, Business Analytics, Programming orsimilar field.
Required Experience :
5 years (60 months) of experience in SQL scripting or similar programming background.
Must include five (5) years of experience with : writing scripts inStructured Query Language (SQL) and using SQL tools for handling data; interpreting data request and determining tools for writing reports; preparing user reports based on user specifications.
Preferred Education and Experience :
Masters degree in Information Technology, Business Analytics, Data Science, Programming, or similar field.
Eight years experience in information technology. Experience with Informatica, Tableau, and Cognos a plus.
Required Knowledge, Skills, and Abilities :
Ability to write complex scripts in SQL to load recurring data extracts into databases, and to manipulate and merge data from various sources.
Requires heavy use of SQL tools for handling data.
Ability to interpret data requests, determine most appropriate tool for writing the report and prepare end product for customer.
Ability to create reports based on user specifications.
Ability to multi-task and work cooperatively with others.
Job Responsibilities :
40% : Technical Lead on Data Project (Student Reports / Faculty Reports / Texas Higher Education Coordinating Board Reports) - Act independently as a technical lead on various data projects. Analyze, review, document and develop complex IT processes and data structures to meet reporting needs for the University administration as well as for State and Federal agencies. Acquire, load, and merge data from various campus sources to produce required State and Federal reports. Be available to run processes during key data acquisition dates, make modifications to scripts and document scripts as data profile and requirements change. Work with University administration and committees to provide data needed for strategic initiatives.
30% : Coordination with Others to Implement Systems - Work with end users or agencies to make sure that the systems developed meet the requirements of the processes. Meet with data owners to make sure reports generated by processes accurately reflect source data. Also work with data owners to find solutions to data quality issues and to monitor progress of changes. Maintains current knowledge of State and Federal requirements for reporting to ensure reports generated by the department are correct.
25% : Ad Hoc Reporting - Assist in the response to requests for special data from both within the University and outside the university. Determine appropriate tool and data source for the request.
5% : Other Duties - Performs other duties as assigned.
