About Pivotal Solutions

Business Intelligence Technical Architect/ Manager

Posted on: October 28, 2010, Job Type: Full Time

Job Title: Business Intelligence Technical Architect/ Manager
Skills: BI, Higher Education, Oracle, ETL
Location: Ithaca, NY

Job Description:
The Business Intelligence Technical Architect/Manager will provide hands-on technical leadership and overall management of the Business Intelligence (BI) technical services team to provide services in support of strategic and operational reporting and analytic needs. This position is expected to spend 50% of the time coding or in a hands-on technical role in addition to leading the BI technical team.


• Provide leadership, technical and managerial expertise in the design, implementation, maintenance, security, and delivery of the college’s business intelligence systems and services.

• Lead design and development of data warehouses and operational data stores utilizing dimensional data modeling, OLAP, and ETL concepts.

• Develop and implement strategies and self-service tools which leverage the college’s Web portal environment to allow end users to access and analyze data to provide useful information for business decisions.

• Coordinate efforts with college offices to ensure that the BI technical infrastructure (including overall technical architecture, data structures and models, ETL processes, and reporting tools) meet their needs and objectives.

• Provide leadership for BI concepts, ETL code development, data models, source-to-target mappings, documentation, project and resource management, performance tuning, security, and reporting tool environments.

• Develop and implement mechanisms, processes and procedures (both technical and by establishing effective communication mechanisms) to ensure the accuracy and timeliness of the data in the BI environment so that the campus community has a high level of trust of the BI environment, its data and the accuracy of reports generated.

• Participate as a member of the college’s Core Data and Data Governance teams.

Required Qualifications

• Bachelor’s degree, Computer Science or related field (Master’s degree or additional certifications preferred)
• Minimum of 5 years of experience working in a business intelligence capacity or the equivalent combination of education and experience; previous supervisory experience, strong leadership ability, and demonstrated ability to establish priorities and meet objectives and schedules; in-depth knowledge of BI principles, products and technologies; and strong organizational, analytical, written and verbal communication skills.

• At least 3 years of experience in providing BI services within a higher education setting; strong experience in star schema denormalized data models with conformed dimensions; senior level ETL programming skills, including experience with large code bases, complex data structures, and a variety of development tools
• 5 years of experience as ETL developer in fast moving, full-life cycle Data Integration, Data Warehouse or Business Intelligence projects
• 2 years in Oracle 10g and 11g and the full suite of Oracle; experience with Oracle 10g and 11g, Oracle Warehouse Builder, OBIEE and other OLAP and reporting tools; and 5 years of data history in finance, enrollment, admissions and graduation data subject areas.

Send resumé in MS Word format to: s.edelman@pivotal-solutions.net