Under the general leadership of the Strategy, Architecture and Analytics director (SAA) and in conjunction with other University areas and external organizations when necessary, the Business Intelligence Programmer/Analyst is responsible for providing technical knowledge in Business Intelligence that enables the University to make decisions using current and accurate data by creating the conceptual and logical data models and the translation of the logical model into a physical model. The Business Intelligence Programmer/Analyst creates, reviews, and modifies ETL scripts and jobs to ensure accurate data capture and translations for a successful implementation of an enterprise BI solution.
Typically a Bachelor's Degree in Computer Science, or related field or equivalent experience. Incumbent will be expected to continue upgrading knowledge, skills, and abilities needed to keep abreast of regulation/policy changes.
Must have minimum three (3) years of experience providing production support for several Oracle relational database management systems, and systems troubleshooting in progressively responsible positions. Some experience with Oracle and third-party software, including, but not limited to, Oracle 11g/12c Enterprise Edition, Oracle Client, SQL*Plus, and TOAD. Must have minimum two (2) years of experience working with ETL tools. TALEND is preferred.
Enterprise working level knowledge of working with Data Modeling (Dimensional Schemas) using ER modeling tools, creating logical and physical Data Warehouse
Enterprise working level knowledge of one programming language such as Java, C#, C++
Exemplary communication skills (both written and oral) evidenced by background in preparing comprehensive requirements, specifications, deployment procedures, testing plans, maintenance processes and incorporating complex, highly technical information.
Ability to multi-task and work as an effective member of a team.
Founded in 1911, LMU is a premier Catholic university rooted in the Jesuit and Marymount traditions. Our enrollment includes 5,962 undergraduate, 2,129 graduate and 1,278 law school students. Our 142-acre bluff-top campus is located in West Los Angeles and is among the nation's most beautiful and green campuses.