Team Lead - Business Intelligence, Dayton, OH - Full time

[vladamsoh]

Position Summary:
This is a hands-on technical lead position responsible for providing leadership and management of the SunGard Banner Electronic Data Warehouse (EDW) and Operational Data Store (ODS), as well as, incorporating other data sources within the Cognos reporting environment.

This individual will use their significant demonstrable experience working with Cognos, data architecting, database technologies, and data modeling to provide business intelligence reporting support from multiple data sources to support a variety of uses and analysis. They will establish practices to ensure data quality and perform quality reviews of Cognos Framework Manager and data modeling.

The team lead will be responsible for the complete range of Cognos capabilities, including developing, testing, deploying, and maintaining cubes, dashboards, reports, metrics, and events in support of client reporting needs. This individual will also be responsible for supporting the Cognos environment including performance tuning, licensing, security, and package creation and should possess a strong knowledge of Cognos Framework Manager. 

Minimum Qualifications:
•   Metadata management.
•   Strong conceptual, analytical, problem-solving, communications, and technical skills.
•   Ability to translate business needs into technical solutions.
•   Strong relational and dimensional data modeling, database design, and performance tuning skills.
•   Understanding of source and target data structures, ETL processes, and products.
•   Strong knowledge of Oracle, Oracle Warehouse Builder (WB), PL/SQL related ETL technologies, and Cognos 8.
•   Bachelor's degree in Management Information Systems, Computer Science, or related experience.
•   Minimum five years experience in systems analysis and design involving Business Intelligence tools within a data warehousing environment.
•   Two years experience with relational databases and/or data warehouse technologies such as ETL, reporting, & OLAP tools.
•   Ability to apply business requirements when working with meta-data models, reports, OLAP cubes, metrics, and events.
•   Skill in deriving flexible & extensible data models and/or requirement specifications, with potential to support large enterprise, from customer-specific input as well as system documentation.
•   Due to the security requirements of this position, US citizenship or green card holder status is required. 


Preferred Qualifications:
1. Extensive knowledge of data warehousing design principles.
2. Experience using the Cognos 8 Software Development Kit (SDK).
3. Ability to work and communicate effectively with UNIX system administrators and DBAs.
4. Basic project planning and project management experience.
5. Staff supervision experience.   


Full job posting and application information can be found at jobs.udayton.edu or by clicking on the link:
https://jobs.udayton.edu/applicants/jsp/shared/frameset/Frameset.jsp?time=1271873184947