Position Title: Business Intelligence Analyst
Department: Office of Institutional Research
Location: Hybrid/Remote (Negotiable)
Position Summary:
A Business Intelligence Analyst within the Office of Institutional Research Department is crucial to fulfilling data requests and optimizing processes by designing, developing, and maintaining data dashboards. As part of this role, you will need to have technical skills in data analysis and database management, along with a thorough understanding of the needs and objectives of institutional research. The incumbent will collaborate closely with stakeholders to gather requirements, design and develop solutions, and deliver actionable insights through user-friendly dashboards and reports.
Key Responsibilities:
• Optimize SQL queries to ensure efficient data retrieval and processing for ad-hoc requests.
• Develop interactive dashboards, reports, and visualizations using BI tools such as Power BI platforms.
• Assist in the establishment, development, and maintenance of data warehouses to ensure that data repositories are centralized and accessible.
• Ensure data quality and consistency through data cleansing and validation techniques.
• Customize and enhance reports based on stakeholder requirements.
• Ensure compliance with all reporting requirements by assisting the Director of Institutional Research with IPEDS, HLC, RUSO, and OSRHE reports.
• Identify and resolve performance bottlenecks in data pipelines and reports.
• Provide clear, understandable communication of complex technical concepts to non-technical stakeholders.
• Document the requirements and specifications of reports to facilitate knowledge sharing and maintainability.
• Staying abreast of industry best practices and emerging trends in business intelligence and data analytics.
• Collaborate with the Director of Institutional Research on data requests and projects.
• Fulfill other duties as assigned by the Director of Institutional Research.
Qualifications:
• Extensive experience of writing SQL against the Colleague and other SQL databases, and of using the resulting data for reporting using Excel, Argos, and other reporting software.
• Strong analytical and problem-solving skills along with the ability to turn data into actionable insights.
• Knowledge of student management systems (such as Colleague or similar), database management and querying software (e.g., SQL Server), and production-level data visualization and analysis software (such as MS Power BI or similar).
• Experience with Argos or similar systems for writing reports.
• Excellent communication and interpersonal skills, enabling effective collaboration with cross functional teams.
Education:
• Bachelor’s degree in computer science, information systems, statistics, etc., with a minimum of two years of experience in Visualization.
• A background in institutional research is advantageous.
TO APPLY: Applications should consist of (1) a detailed cover letter addressing the expectations of the position; (2) a current resume/curriculum vitae; (3) a list of three professional references with complete contact information and a notation describing the work relationship with each; (4) unofficial transcripts from all degrees; and (5) a completed *Disclosure Statement. (Official transcripts are required upon hiring.)
Applications should be sent electronically to Employment Services at es@ecok.edu. Application review will begin immediately and continue until the position is filled. For more information about ECU, visit our website at http://www.ecok.edu.
***Please do not include a full Social Security Number on documents. Please provide only the last four (4) digits. We may never receive your information if a full Social Security Number is listed on any document. Our email system will reject emails if it detects a full Social Security Number, therefore Employment Services will not receive your information. ***
East Central University, in compliance with all applicable Federal and State laws and regulations, does not discriminate on the basis of race, color, national origin, sex, age, religion, disability, sexual orientation, genetic information, or status as a veteran in any of its policies, practices, or procedures. This includes but is not limited to admission, employment, financial aid, and educational services. The following person has been designated to handle inquiries regarding the non-discrimination policies: Employment Services Director, 1100 E. 14th St., Admin. 160, Ada, OK 74820, (580) 559-5260.