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.
Must have a minimum of 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.
Minimum two (2) years of Business Intelligence experience and Reporting tools (Business Objects is preferred) in progressively responsible positions.
Enterprise working-level knowledge of working with Data Modeling (Dimensional Schemas) using ER modeling tools, creating logical and physical Data Warehouse models (including implementation into Physical schemas and utilizing complex SQL, PL-SQL and transact SQL).
Must have a minimum of two (2) years of experience working with ETL tools. TALEND is preferred.
Enterprise working-level knowledge of one programming language such as Pl/SQL, 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.
The incumbent will be expected to continue upgrading the knowledge, skills, and abilities needed to keep abreast of regulation/policy changes.
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.