Analytics & Data Specialist (Hybrid) - IIE
Chicago IL, IL
About the Job
Houston TX - Houston, TX 77027 US
New York NY - New York, NY 10007 US (Primary)
Washington DC - Washington, DC 20005 US
The Institute of International Education (IIE) is hiring an Analytics and Data Specialist for our Business Systems team. We invite you to join a team united by a single goal: to transform our interconnected world into a network of more peaceful and equitable societies. IIE’s team members share a belief that when education transcends borders, it opens minds, enabling people to go beyond building connections to solving problems together.
Learn more about IIE, our culture and commitment to DEIA here.
If you are a job seeker in need of an accommodation to navigate our careers site or apply for one of our jobs, please click here to learn more.
Job Summary
This position will work with the Business Systems Department. The Business Systems team provides end-to-end management of IIE's numerous industry-leading technology solutions supporting the organization's core business functions and program operations. The Business System department provides full technology support for these solutions and leads or assists in the acquisition of new technology, developing custom or extensions of existing solutions, user training, operations, and management of all business systems.
Reporting to the Director, Analytics & Data Science the Analytics & Data Specialist will provide subject matter expertise in delivering complex business intelligence (BI) solutions and support to internal and external stakeholders of the Institute of International Education (IIE), serve as a BI SME for the Business Systems Department and entire Technology organization, contribute to IIE analytics road map implementation, support development of advanced analytics and solutions, and promote use of analytics across the organization.
Essential Functions:
• Elicits business requirements for new reports or requests for change to existing reports by communicating directly with IIE business users at all levels of the organization.
• Implements and delivers complex business intelligence, including dashboards and analytics to internal and external stakeholders of IIE
• Performs validations and identifies data anomalies across business systems. Assists with ongoing data management process and governance efforts
• Supports IIE analytics roadmap implementation and identification of uses cases for advanced analytics solutions at IIE
• Coordinates data preparation efforts for analytics projects with IIE’s data engineering team and assists with Extract, Transform, and Load (ETL) activities
• Performs complex quantitative and qualitative analysis on IIE datasets and exploratory data analysis and visualizations
• Supports development of advanced analytics solutions at IIE
• Supports BI and analytics solution life cycle from development to deployment & maintenance
• Manages analytics activities and projects including tracking work progress via project/product management tools ensuring timely delivery of high-quality work products
• Delivers BI and analytics trainings to internal users as needed
Education and Work Experience:
• Requires a Bachelor's degree and at least five years of related work experience, or an equivalent combination of education and experience.
Required Knowledge, Skills and Abilities:
• Expert knowledge of the modern cloud-based Business Intelligence tools Power BI and Microsoft Azure data stack.
• Power BI experience must include performing significant data transformations using Power Query/M-language, writing complex calculated measures and columns using DAX, and implementing dynamic Row Level Security in the data model.
• Proven experience in Business Intelligence requirements gathering, solution design and application operations and maintenance activities as well as drawing BI insights through analysis of data.
• Knowledge and prior experience using SQL to perform complex data analyses.
• Prior work experience planning, organizing, and managing work activities or projects including formal or informal management of deliverables of others.
• Excellent written and verbal communication skills. Ability to communicate complex technical information in non-technical terms to business users and management.
• Excellent organization and document creation skills with attention to detail.
• Ability to work occasional non-standard hours including weekends and evenings.
Preferred Knowledge, Skills and Abilities:
• Prior work experience with DevOps processes and tools such as Azure DevOps preferred.
• Prior experience utilizing Power Automate to build automated workflows preferred.
• Prior work experience with CRM systems and data preferred.
Salary Range: $87,549 - $116,431. A candidate’s salary is determined by various factors including, but not limited to, relevant work experience, job-related knowledge, skills, abilities, internal organizational equity, and geographic region.
IIE offers a robust suite of benefits to team members including medical, dental, and vision plans, paid time off and holidays, student loan and tuition reimbursement programs, professional development reimbursement program, retirement plans and a family medical leave benefits. Please visit our careers page for further details.
The Institute of International Education (“IIE”) has a hybrid work environment that allows team members a combination of in-office work and telework at any of the locations listed above.
Work Conditions & Physical Demands:
Essential functions are performed in a general office setting with low noise. Job demands may require long periods of sitting; telephone work and/or computer work, as well as interactions with other team members and external stakeholders. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
IIE is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.