Data Analyst

Job Title

Data Analyst

Agency

Texas A&M University

Department

Graduate And Professional School

Proposed Minimum Salary

$4,666.67 monthly

Job Location

College Station, Texas

Job Type

Staff

Job Description

What We Want

We are seeking a detail-oriented and collaborative Data Analyst with strong analytical skills who can transform complex data into actionable insights. The ideal candidate has at least two years of professional experience developing and maintaining interactive Power BI dashboards and reports, supported by a solid understanding of DAX fundamentals. They are proficient in Python (preferably using Jupyter Notebook) for data analysis, ETL processes, and workflow documentation, and possess advanced Microsoft Excel skills, including pivot tables, Power Query, and advanced formulas. Working knowledge of SQL, Banner, Microsoft Access, Git, and ETL/data pipeline development is highly desirable.

The successful candidate is comfortable working independently while collaborating closely with colleagues to translate analytical requirements into effective technical solutions. They prepare and deliver high-quality ad hoc reports, interactive dashboards, infographics, and technical documentation while ensuring data accuracy. Strong written and verbal communication skills are essential, as this role requires presenting analytical findings clearly to both technical and non-technical stakeholders."

What You Need To Know

Salary: $56,000.00 (based on selected hire’s qualifications)

Cover Letter & Resume: A cover letter and resume are strongly recommended.

Responsibilities

Power BI Dashboard Design, Development and Maintenance Support

  • Collaborate with team members across the Graduate and Professional School to gather reporting needs and translate data requirements into the design and development of interactive, user-friendly Power BI dashboards and data visualizations.

  • Support maintain and enhance existing Power BI solutions by optimizing performance, improving data load efficiency, and refining visual layouts and data structures to enhance user experience.

  • Troubleshoot issues related to data accuracy, refresh processes, and report functionality to ensure reliable, high-quality reporting outputs.

Perform Data Querying and Data Preparation

  • Perform end-to-end Power BI data pipeline processes, including data extraction, transformation, and loading (ETL), to ensure datasets are accurately structured for reporting and visualization.

  • Assist with extracting data from Compass reports and other institutional data sources.

  • Perform data querying, data cleaning, and validation activities such as handling missing values, removing duplicates, and validating data consistency across multiple data sources.

Analyze Data and Develop the Technical Reports

  • Support senior analysts and independently complete planned and ad hoc data reporting requests from university department directors, academic units, and other stakeholders.

  • Conduct detailed analyses of both quantitative and qualitative data, and develop clear and well-structured reports, summaries, and presentation materials for diverse stakeholders.

Event & Operational Support

  • Assist with event and operational support activities, including required and mandatory all-hands-on-deck events.

  • Support coordination of logistics, space, materials, and staffing needs to ensure successful execution of events.

  • Provide additional operational support as needed to assist with departmental priorities and high-volume activities.

Qualifications

Required Education and Experience

  • Bachelor’s degree in related field or equivalent combination of education and experience.

  • Minimum of two years of progressively responsible experience designing, developing, and maintaining Power BI dashboards and reports.

Knowledge, Skills, and Abilities:

  • Ability to work both independently and collaboratively in a dynamic, team-oriented environment.

  • Strong organizational skills with the ability to manage multiple priorities, meet deadlines, and maintain a high level of accuracy and professionalism.

  • Demonstrated ability to design, develop, and maintain interactive dashboards and data visualizations using Power BI.

  • Ability to interpret data and present findings clearly to non-technical audiences.

Preferred Qualifications

  • Master’s Degree (in related field)

  • Familiarity with DAX fundamentals, including measures and calculated columns

  • Proficiency in Python and Microsoft Excel

  • More than two years of experience using Python in Jupyter Notebook for data analysis, automation, and workflow documentation

  • More than two years of advanced professional experience with Power BI, including dashboard development, data modeling, DAX, and report optimization

    Preferred Special Knowledge, Skills, and Abilities:

    • Demonstrated proficiency in developing, maintaining, and documenting data analysis workflows using Python in Jupyter Notebook, including data extraction, transformation, visualization, and reporting.

    • Demonstrated proficiency in designing and delivering interactive, high-quality, and insightful data visualizations using Power BI, supported by a strong understanding of DAX fundamentals, including measures and calculated columns.

    • Advanced proficiency in Microsoft Excel (e.g., pivot tables, advanced formulas, Power Query).

    • Working knowledge of SQL, Banner, Microsoft Access, and version control tools such as Git.

    • Experience creating infographics and technical reports, with strong written and verbal communication skills to effectively present analytical findings to diverse audiences.

    Who We Are

    Texas A&M University's Graduate and Professional School strives to enhance graduate experiences and development of all students, personally and professionally, foster and facilitate interdisciplinary intercollegiate graduate programs and research activities, as well as provide the highest quality support for services to advance creative scholarship and scientific inquiry. Our vision to achieve recognition as a leader in support of graduate education through innovation, exceptional service and commitment to excellence. For more information, please visit our website: grad.tamu.edu.

    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.

    Our Commitment

    Texas A&M University is committed to enriching the learning and working environment by promoting a culture that respects all perspectives, talents & lived experience. Embracing varying opinions and perspectives strengthens our core values which are: Respect, Excellence, Leadership, Loyalty, Integrity, and Selfless Service.

    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/Veterans/Disability Employer.