The BI (Business Intelligence) Modeler will work with other team members of the University Advancement BI group to meet the reporting requirements of University Advancement (UA). This will include understanding of the data architecture of the UA data warehouse, the business rules for reporting, and creating framework models for reporting. Primary responsibilities includes working with Business and IT stakeholders to understand reporting business goals and requirements in order to quickly deploy BI solutions that enable better decision making. BI Modeler will provide data management expertise to our clients in evaluating BI requirements and developing FM models and solution design.
Unit Specific Education/Experience/Skills
Knowledge equivalent to that which normally would be acquired by completing a four-year degree program in Computer Science, Information Technology, with coursework in an information technology specialization related to the area of employment; three to five years of related and progressively more responsible or expansive work experience in an information technology area related to the duties to be performed; experience with IBM Cognos C10, IBM Cognos Analytics C11, Tableau, Oracle DB, ETL (Informatica, datastage); or an equivalent combination of education and experience.
•Degree in Computer Science, Information Technology or the knowledge equivalent to that which normally would be acquired by completing a four year college degree program with similar relevant coursework; •Ideal candidate will have 5+ years of hands-on professional experience. •Excellent organizational, verbal and written communication skills •Very strong technical knowledge of Cognos BI and Cognos Analytics suites (IBM Cognos versions 10 and 11). •Good knowledge of ETL tools (Informatica or Data Stage), Databases (Oracle), PL/SQL, ability to work alone or in conjunction with a DBA. •Must be proficient with Cognos BI and Analytics suite 10, 11 (3-5 years at a minimum) with clear concepts on Cognos Framework Modeling tool and its application. •Must be proficient with Cognos BI and Analytics suite 10, 11 (3-5 years at a minimum) with solid understanding of Query Studio, Analysis Studio, Report Studio, Active Report and Cognos Workspace Advanced tools. •Experience creating multi-prompt reports with drill-thru capabilities. •Has participated in projects utilizing project management process and SDLC documentation. Strong data analysis.
Required Application Materials
Provide 3 references knowledgeable of your work.
Bidding eligibility ends on 3/24/20 at 11:55 PM
Internal Number: 641472
About Michigan State University
Spartans work every day to advance the common good in uncommon ways.Together, we tackle some of the world?s toughest problems to find solutions that make life better?from alternative energy to better food safety to breakthrough medical and environmental applications achieved through rare isotope research.We teach. We explore and we discover. We collaborate and lead. We innovate, inspire, and empower. We achieve our potential and create circumstances that help our students and others achieve theirs.We're good at it, and we've been at it for more than 150 years.The nation?s pioneer land-grant university, MSU began as a bold experiment that democratized higher education and helped bring science and innovation into everyday life. The revolutionary concept became a model for the nation.Today, MSU is one of the top research universities in the world?on one of the biggest, greenest campuses in the nation. Home to nationally ranked and recognized academic, residential college, and service-learning programs, we?re a diverse community of dedicated students and scholars, athletes and artists, scientists and leaders.In ways both practical and profound, we work to create a stronger, more sustainable, and more hopeful future for all.