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 and Analytics Engineer is responsible for designing, developing and evolving the environment (physical and logical) for the Enterprise Data Warehouse, Data Governance, Big Data and other systems. The Business Intelligence and Analytics Engineer is also responsible for enterprise data management implementation and for developing Metadata solutions.
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 five (5) years of experience providing production support for several Oracle relational database management systems and applications, 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, RMAN, Enterprise Manager Grid Control, exp, imp, Data Pump, and TOAD is required; AWS is a plus.
Minimum two (2) years of enterprise data warehouse experience and Business intelligence tools (like Business Objects, Tableau) in progressively responsible positions.
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), creating logical and physical Data Warehouse models (including implementation into Physical schemas and utilizing complex SQL and PL-SQL). Relational database experience necessary (Oracle preferred).
Must be well-versed in overall Oracle database performance monitoring, troubleshooting, and tuning. Experience with SQL diagnostics and tuning techniques a plus.
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.