Senior Business Intelligence (BI) and Data Warehouse Analyst

Job Description Summary

Responsible for the design, development, implementation, and the administration of the organization’s operational data store (ODS) and BI applications, including IBM Cognos and Microsoft Power BI. This role involves working closely with business stakeholders, IT teams, and others to ensure that the data warehouse and BI platforms meet business intelligence and reporting requirements. The incumbent will be responsible for the end-to-end management of BI applications and data integration processes, ensuring optimal performance, security, and data accuracy. Lead the design, implementation, and maintenance of a centralized data warehouse and BI infrastructure to support departmental and University reporting, analytics, and dashboards. This role addresses workflow inefficiencies, integrates disparate data sources (Banner, Slate, HR, finance, and external files), ensures data integrity, and enables trusted, timely, and actionable data for institutional decision-making.

Minimum Qualifications

• 8 years of Experience with the following Technical Knowledge:
  • Strong understanding of data warehousing concepts, including star schemas, snowflake schemas, and Operational Data Store (ODS) architecture.
  • Proficiency in data integration tools and ETL / ELT processes, including knowledge of data transformation and loading techniques.
  • Expertise in IBM Cognos, including Report Studio, Framework Manager, and Cognos Administration.
  • Proficiency in Microsoft Power BI, including Power BI Desktop, Power BI Service, and Power Query.
  • Strong SQL skills for querying databases and managing data transformations.
  • Familiarity with database management systems (e.g., SQL Server, Oracle) and scripting languages (e.g., Python, PowerShell).
• 8 years of Experience with the following Analytical and Problem-Solving Skills:
  • Ability to analyze complex business requirements and translate them into effective BI solutions.
  • Strong troubleshooting and problem-solving skills for resolving data and application-related issues.
  • Attention to detail and a focus on accuracy and data integrity.
• 8 years of Experience with the following Communication and Collaboration:
  • Excellent communication skills, with the ability to convey technical concepts to non-technical stakeholders.
  • Experience working in cross-functional teams and collaborating with business users to gather requirements and deliver solutions.
  • Ability to provide training and support to end-users, enhancing their ability to use BI tools effectively.
• 8 years of excellent demonstrable written and verbal skills.
• 4 years of experience Experience managing BI-related projects, including planning, execution, and delivery within agreed timelines.
• Ability to prioritize tasks, manage time effectively, and handle multiple projects simultaneously.
• Experience gathering requirements needed to create business and functional project or reporting specification
• Bachelor’s degree in Computer Science, Information Systems, Data Science, or a related field.
• 5+ years of experience in data warehouse administration, business intelligence, and application administration in IBM Cognos and Microsoft PowerBI.
• Strong Experience with programming and scripting language (e.g., Python, Java, SQL R, C++, CLI , HTML5, XMNL).
• Ability to deal with ambiguity in a fast-paced environment.
• Excellent verbal/written communication skills and data presentation skills.
• Strong understanding of data governance, security, and compliance best practices.
• Requires interpersonal skills in order to work with both technical and non-technical personnel at various levels in the organization and with outside vendors.
• Possess excellent documentations skill for reports and workflow processing.
• Must be self-motivated, able to learn quickly, meet deadlines and demonstrate problem solving skills.
• Excellent analytical skills to define and reengineer business process to maximize the capabilities of technology without sacrificing the functional experience, business process flow, efficiencies or effectiveness
• Working knowledge of data management software and database systems
• Demononnstarated software repository skills.
• Demostrated testing and test planning skills.
• Demonstrated advanced and strong PL/ SQL knowledge and tuning skills and oracle database design, along with an understanding of different data warehousing and dimensional modeling concept.
• Demonstrated ability to work with end users in determining proposed data warehouse and reporting solutions, including enabling standard functionality, as well as custom modification to fulfill departmental needs.
• Demonstrated ability to work both independently and closely with others according to project needs.
• Demostrated ability to maintain a customer focus in providing technoloty services.
• Demonstrated skills in requirements gathering, designing, prototyping, troubleshooting and supporting users.
• Statistical analysis and/or math skills
• Develop and implement test plans to ensure successfully delivery of a project.
• Demonstrated ability to effectively manage time, and communicate clearly.
• SQL server and Oracle database query experience

Preferred Qualifications

• Master’s degree in Business Administration, Economics, Computer Science, Information. Management, Data Analytics, or related field with equivalent experience.
• Ability to analyze large / complex datasets.
• Excellent interpersonal and communication skills (oral and written), and professional demeanor and presentation, including active listening and ability to convey information clearly.
• Analytical with strong problem-solving skills, takes initiative and uses good judgment, excellent follow-up and troubleshooting skills.
• High attention to detail, outstanding organizational skills, and the ability to manage time effectively.
• Certifications : A- CSD , Programmer, Scrum Developer, CSSLP /ISC2.