What are the responsibilities and job description for the Data Analyst and AI Specialist position at Association for Institutional Research (AIR)?
Application Procedure
Please apply through the CMU careers website at: https://cmu.wd5.myworkdayjobs.com/CMU/job/Pittsburgh-PA/Data-Analyst-and-AI-Specialist---Institutional-Effectiveness-and-Planning---Office-of-the-Provost_2023933-1
Job Duties
Core responsibilities include:
Dashboard Development and Reporting
Job Qualifications
You should demonstrate:
The Data Analyst and AI Specialist will help advance Carnegie Mellon’s efforts to leverage data for strategic decision-making across academic and administrative functions. This role requires expertise in database systems, statistical analysis, and data visualization tools to transform complex datasets into actionable insights that drive student success, operational efficiency, and institutional effectiveness. This position will combine data cleaning and preparation skills with data visualization and communication skills.
This position collaborates with business leaders across divisions including but not limited to the provost division, academic colleges, enrollment management, student success, finance and budget, student affairs, human resources, and computing services. They will collaborate through the Data Analytics Community of Practice and help implement the CMU Data Strategy by ensuring data integrity, privacy compliance, and ethical use of university information. A successful candidate in this role will combine technical proficiency with strong communication skills to translate analytical findings into compelling narratives that inform institutional planning and demonstrate the impact of university initiatives to a wide range of stakeholders.
Benefits
Joining the CMU team opens the door to an array of exceptional benefits.
Benefits eligible this link will open a new tab. employees enjoy a wide array of benefits including comprehensive medical, prescription, dental, and vision insurance this link will open a new tab. as well as a generous retirement savings program this link will open a new tab. with employer contributions. Unlock your potential with tuition benefits this link will open a new tab., take well-deserved breaks with ample paid time off this link will open a new tab. and observed holidays this link will open a new tab., and rest easy with life and accidental death and disability insurance.
Additional perks include a free Pittsburgh Regional Transit bus pass, access to our Family Concierge Team this link will open a new tab. to help navigate childcare needs, fitness center access this link will open a new tab., and much more!
For a comprehensive overview of the benefits available, explore our Benefits page this link will open a new tab..
At Carnegie Mellon, we value the whole package when extending offers of employment. Beyond credentials, we evaluate the role and responsibilities, your valuable work experience, and the knowledge gained through education and training. We appreciate your unique skills and the perspective you bring. Your journey with us is about more than just a job; it’s about finding the perfect fit for your professional growth and personal aspirations.
Are you interested in an exciting opportunity with an exceptional organization?! Apply today!
Please apply through the CMU careers website at: https://cmu.wd5.myworkdayjobs.com/CMU/job/Pittsburgh-PA/Data-Analyst-and-AI-Specialist---Institutional-Effectiveness-and-Planning---Office-of-the-Provost_2023933-1
Job Duties
Core responsibilities include:
Dashboard Development and Reporting
- Design and implement data visualization dashboards that translate complex institutional data into actionable insights for university stakeholders at various levels.
- Assist in implementing the university’s data strategy and development of data franchises across the university business units.
- Develop new dashboards and reports to support university planning and operations using PowerBI
- Assist in managing permissions and data access to published PowerBI and Tableau reports.
- Convert existing Tableau dashboards and reports to PowerBI.
- Partner with key stakeholders and data franchises within the university to facilitate development of data insights to support decision making.
- Contributes to developing existing and new AI solutions in data preparation and automation pipelines.
- Configures and orchestrates RAG implementations to create AI Chatbots and other tools for non-technical users.
- Utilizes AI models to extract structured data from unstructured text sources
- Contributes to chatbot development and agentic AI workflows to enable AI to answer questions from internal and external data sources.
- Performs complex statistical analyses of financial, organizational, developmental and/or planning data. Verifies the correctness of the data reported. Makes recommendations based on these analyses.
- Complete complex data analysis to measure effectiveness of key areas and reports results to university leadership.
- Assists with writing SQL queries that translate raw and unfiltered data by creating semantic layer and reporting views in the database to be used for reporting.
- Collaborates to combine data from multiple sources and documents processes and data definitions.
- Creates consistent and reproducible workflows that automate reporting requirements.
- Collaborates with data partners in developing data analytics and AI solutions to support the University’s academic mission and operational objectives.
- Communicates complex and sometimes conflicting information clearly to both technical and non-technical audiences.
- Identifies data challenges and/or roadblocks to project success and recommend solutions to overcome barriers to project completion.
- Collaborates with other divisions and departments to create verified and reusable data products and data sources.
Job Qualifications
You should demonstrate:
- An ability to work with sensitive information, maintain confidentiality and use discretion.
- Strong oral and written communication skills.
- Ability to collaborate and work well as part of a team.
- Bachelor’s degree required, Master’s degree preferred.
- 0-2 years of related work experience.
- Experience with data analysis and generating reports using business intelligence tools required.
- Experience using inferential statistics techniques (such as regression, chi-square, and ANOVA) required.
- Experience using any statistical programming language (such as Python, R, SAS, STATA, MATLAB, etc.) required.
- Experience using SQL programing language required.
- A combination of education and relevant experience from which comparable knowledge is demonstrated may be considered.
- Successful pre-employment background check
- Sponsorship: Applicants for this position must be currently legally authorized to work for CMU in the United States. CMU will not sponsor or take over the sponsorship of an employment visa for this opportunity. Carnegie Mellon is not a qualifying employer for the STEM OPT benefit: only the 12-month OPT may be used to work at Carnegie Mellon.
The Data Analyst and AI Specialist will help advance Carnegie Mellon’s efforts to leverage data for strategic decision-making across academic and administrative functions. This role requires expertise in database systems, statistical analysis, and data visualization tools to transform complex datasets into actionable insights that drive student success, operational efficiency, and institutional effectiveness. This position will combine data cleaning and preparation skills with data visualization and communication skills.
This position collaborates with business leaders across divisions including but not limited to the provost division, academic colleges, enrollment management, student success, finance and budget, student affairs, human resources, and computing services. They will collaborate through the Data Analytics Community of Practice and help implement the CMU Data Strategy by ensuring data integrity, privacy compliance, and ethical use of university information. A successful candidate in this role will combine technical proficiency with strong communication skills to translate analytical findings into compelling narratives that inform institutional planning and demonstrate the impact of university initiatives to a wide range of stakeholders.
Benefits
Joining the CMU team opens the door to an array of exceptional benefits.
Benefits eligible this link will open a new tab. employees enjoy a wide array of benefits including comprehensive medical, prescription, dental, and vision insurance this link will open a new tab. as well as a generous retirement savings program this link will open a new tab. with employer contributions. Unlock your potential with tuition benefits this link will open a new tab., take well-deserved breaks with ample paid time off this link will open a new tab. and observed holidays this link will open a new tab., and rest easy with life and accidental death and disability insurance.
Additional perks include a free Pittsburgh Regional Transit bus pass, access to our Family Concierge Team this link will open a new tab. to help navigate childcare needs, fitness center access this link will open a new tab., and much more!
For a comprehensive overview of the benefits available, explore our Benefits page this link will open a new tab..
At Carnegie Mellon, we value the whole package when extending offers of employment. Beyond credentials, we evaluate the role and responsibilities, your valuable work experience, and the knowledge gained through education and training. We appreciate your unique skills and the perspective you bring. Your journey with us is about more than just a job; it’s about finding the perfect fit for your professional growth and personal aspirations.
Are you interested in an exciting opportunity with an exceptional organization?! Apply today!