EDW Architect II IS Clinical Research Full Time 8 Hour Days (Exempt) (Non-Union)

The EDW Architect II will create implement and maintain Keck Medicine of USCs Enterprise Data Platform & Information Architecture Framework. The key responsibility of this role is to create architecture processes procedures & protocols to support the full life cycle of the data of Kecks Analytics platform leveraging appropriate technologies. Design the Implementation of Kecks Data governance processes and protocols to secure and provision data at rest and in motion. Collaborate with Clinical Research Administrative system owners external vendors community partners contractors and other Health Science Campus leadership to understand their data needs and design develop implement Kecks data analytics platform.

Essential Duties:

• EDW Framework: Provides Technology thought leadership in Modern Data Warehouse Framework for the KECKs Enterprise Data Analytics platform.
• End To End Technology Architecture: Collaborate with Information Management & Information delivery team to provide end to end Technology architecture to support the complete data life cycle phases including core functions like Information management & Information delivery.
• Architecture Design: Understand KECKs Strategic plan Data Strategy & Data Governance and conceptualize architect Enterprise Data/Information Architecture framework that supports the execution of the Strategic plan successfully.
• Training: Trains new/current staff members on applicable systems/applications. Responsible for working with customer and/or vendors with training on new systems being implemented and rolled out for use in the departments.
• Priority Management: Must work several assignments at one time follow/meet priorities deadlines and time. The work is highly technical requires collaboration across multiple disciplines and groups. The ability to work independently is also required.
• Customer Service: Addresses customer questions concerns enhancement requests communicates with customers handles services problems and tickets politely and efficiently always available for customers follows procedures utilizes problem solving skills maintains pleasant and professional image. Customers may include both internal department users vendors and peers within IS.
• Team Work and Project Management: Helps team leader/manager/director to establish project goals milestones and procedures. Leads projects including team members and facilitate team and cross-functional meetings; uses planning skills to manage and complete work efforts on time and on budget for projects.
• Documentation: Create publish maintain all the documents about the Architecture Design Road map & framework assets in the appropriate collaboration tools.
• Other Duties and On-Call: Ability to fulfill On-Call requirements and other duties as assigned.

Required Qualifications:

• Req Bachelors degree Degree in Computer Science Information Systems Computer Engineering or related field

• Combined work experience and education as equivalent

• Req 16 years Relevant experience including programming in data modeling OLAP Hadoop Cloudera Talend RDBMS NoSQL Hadoop enterprise data warehouse projects. IF NO BACHELOR DEGREE: * 20 years of relevant business support and/or information technology support experience.
• Req 5 years Experience with detailed knowledge of Enterprise Information architectures & Data Governance implementation.
• Req 5 years Design of data infrastructure components for the complete data life cycle.
• Req 3 years Experience with Structured Query Language (MS SQL Server Oracle).
• Req Demonstrated experience with RDBMS NoSQL Hadoop.
• Req Hands-on expertise in programming with database services.

• Req Good organization skills with ability to prioritize multiple activities in a rapidly changing environment.
• Req Strong customer service focus.
• Req Proficient in Microsoft Office (Outlook Word Excel Power Point).
• Req Requires a maturing level of analytical ability to find solutions to increasingly difficult technical or to determine economic feasibility or options available and to nothing related to supervisory or leads assess time involved in system changes.
• Req Thorough documentation skills.
• Req Must be able to communicate the impact and solutions of application/system problems in business language.
• Req Requires a professional approach in all situations.
• Req Ability to work any hours to support 24/7 operations.
• Req Must resolve problems entirely by either completing the work or gathering all of the resources needed for ultimate resolution and continuity of problem management.
• Req Availability to travel between Keck Medicine of USC USC and other facilities.

Preferred Qualifications:

Required Licenses/Certifications:

• Req Fire Life Safety Training (LA City) If no card upon hire one must be obtained within 30 days of hire and maintained by renewal before expiration date. (Required within LA City only)

USC is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race color religion sex sexual orientation gender identity national origin protected veteran status disability or any other characteristic protected by law or USC policy. USC observes affirmative action obligations consistent with state and federal law. USC will consider for employment all qualified applicants with criminal records in a manner consistent with applicable laws and regulations including the Los Angeles County Fair Chance Ordinance for employers and the Fair Chance Initiative for Hiring Ordinance and with due consideration for patient and student safety. Please refer to theBackground Screening Policy Appendix Dfor specific employment screen implications for the position for which you are applying.

We provide reasonable accommodations to applicants and employees with disabilities. Applicants with questions about access or requiring a reasonable accommodation for any part of the application or hiring process should contact USC Human Resources by phone at or by email at. Inquiries will be treated as confidential to the extent permitted by law.

• Notice of Non-discrimination
• Employment Equity
• Read USCs Clery Act Annual Security Report
• USC is a smoke-free environment
• Digital Accessibility

If you are a current USC employee please apply to thisUSC job posting in Workday by copying and pasting this link into your browser: