Information Systems Analyst IV - Remote - 138495

UC San Diego Health is seeking an applicant for a Senior Integration Developer who will be responsible for analyzing, designing, developing, and maintaining ETL and integrations code into and out of various database and systems including ERP systems (Oracle Financials Cloud, PeopleSoft, Salesforce), EMR( Epic), SQL Server, and more. The incumbent will need to be well versed in SQL Server Integration Services (SSIS) and SQL but familiarity with other technologies such as MuleSoft, Okta IAM, and data exchange platforms is desired. The applicant will support the ongoing efforts to implement a robust ETL/EAI/SOA to meet the strategic goals of the organization. This position will be part of the overall systems and integration teams at UC San Diego Health and will be part of the team responsible for the overall framework and architecture for Enterprise Integration.

Senior Integrations Engineer:

The Senior Integrations Developer will function as part of a team supporting the integration needs for our clinical enterprise, including our Medical Center, Physician Group, and Population Health Services Organization. Extensive SQL Server Integration Services (SSIS), and database solution development/maintenance experience are required. Specific duties include: supporting the development of a sustainable program around ETL and integration projects. Defining the framework and architecture most appropriate when implementing with various solutions.

Project Management:

Senior Integrations Developer will function as the technical project manager responsible for their own project plans in conjunction with the operational project managers to ensure accurate, consistent, and timely data delivery. Specific duties include but are not limited to developing and maintaining project plans, coordinating and collaborating with team members, creating status reports, facilitating decisions, identifying and mitigating risks, collecting and interpreting data from various sources, presenting measure and project results to clinical and operations executives, and managing evolving technical requirements.

Product Management:

The Senior Integrations Developer will function as the technical product manager responsible for developing and maintaining integrations into and out of the various systems including but not limited to: ERP systems, UCSD Health and campus data warehouse environments, and other data environments as required, using techniques and tools including MuleSoft, SSIS, MoveIT, and more. Roadmaps should be developed in conjunction with senior leadership, operational stakeholders, and vendor advisors to ensure these products can meet business and clinical requirements including scaling across multiple dimensions. Specific duties include but are not limited to facilitating operational and requirements planning sessions, conducting product related research, developing product requirements and specifications, producing development approaches and timelines, coordinating the integration of products into the larger enterprise product portfolio, assessing third party products/vendor solutions, communication plans, training plans, writing recommendations to senior leadership, and creating maintenance/upgrade plans.

Level 4:

Technical leader with a high degree of knowledge in the overall field and recognized expertise in specific areas; problem-solving frequently requires analysis of unique issues/problems without precedent and/or structure. May manage programs that include formulating strategies and administering policies, processes, and resources; functions with a high degree of autonomy.

Key Responsibilities:

• Create and support ETL processes across functional domains(HR, Finance, IT, Operations). Implement associated monitoring, user communications, and redundancies to ensure maximum uptime and customer satisfaction.
• Designs and runs complex SQL queries (on MSSQL and other RDBMS) for enhanced data access.
• Using Mule Management APIs, build onboarding and access management automations to the API Hosting platform
• Setup SFTP jobs to various internal and external customers using MoveIT, working with internal security team to deploy appropriately secure transfers.
• Understand and follow company policies surrounding data governance, security, and API development
• Design, develop, test, and implement technical solutions based on business requirements and strategic direction.
• Assess opportunities for application and process improvements and prepare documentation outlining platform road maps.
• Maintain, troubleshoot, optimize, and upgrade existing systems such as Password State and Org Chart Now.
• Collaborates with clinical, financial, business, and technical leaders to plan, develop, implement, and analyze and design an integrated architectural approach to ensure an optimal and efficient user experience and functionality, integrity, and reliability of integrations .
• Design, configure, and maintain Single Sign-On (SSO) connections and provisioning workflows within the Okta Identity Cloud; proactively address and resolve service incidents related to authentication and access management; and perform system administration of the Okta platform, in alignment with enterprise security and governance standards.
• Experience with system administration tasks, including installation, configuration, patching, and the overall lifecycle management of integration applications, servers, SAAS applications, and AWS offerings.
• Able to author scripting languages (e.g., Python, PowerShell) and UIPath RPA for task automation and system administration.
• Utilize Atlassian products (Jira, Confluence) and ServiceNow for workflows and IT Service Management responsibilities.
• Performs quality assurance testing, establishes robust systems integrations monitoring, and implements regression testing tools.
• Executes Dev Ops methodologies using GitHub, Azure repositories, CICD pipeline, and associated development lifecycle management tools.
• As a technical leader and information resource, may provide support, troubleshooting, and problem solving at an advanced level, and may produce and deliver user training curricula.
• Work collaboratively with team members to ensure continuity and support of the ETL jobs, databases, File transfers, and API operations of the organization.
• Other duties as assigned.

• Nine (9) years of related experience, education/training, OR a Bachelor's degree in related area plus five (5) years of related experience/training. Related professional experience: developing, implementing, and maintaining Extract, Transform, Load (ETL) processes using SQL Server Integration Services (SSIS) including: Error handling and logging frameworks in SSIS, package deployment, configuration management, performance optimization and/or scalability. Enterprise Solution development, healthcare analytics, and/or healthcare development.

• Advanced skills associated with programming design, modification and implementation. Advanced knowledge of secure software development. Demonstrated ability to create software specifications.

• Demonstrated advanced knowledge, skills and abilities associated with system problem identification and resolution. Knowledge necessary to design, set up, operate and correct malfunctions involving technology systems. Experience in incident response and digital forensics, including data collection, examination and analysis.

• Advanced knowledge of business and process analysis functions. Knowledge of the design, development and application of technology and systems to meet business needs.

• Demonstrated experience with database administration. Advanced knowledge of database management systems and standards. Knowledge relating to highly complex database system design.

• Advanced database querying and modeling skills working with moderately complex databases.

• Knowledge of conceptual database design. Skills necessary to develop procedures and standards relating to database management systems. Skills associated with implementing database enhancements that improve performance and reliability of the system at the software, hardware and operating system level.

• Ability to write technical documentation in a clear and concise manner.

• Advanced knowledge of computer security tools, best practices and policies including demonstrated experience securing server-based software. Advanced knowledge of computer security tools, best practices and policies including demonstrated experience securing server-based software. Demonstrated skill at analyzing and preventing security incidents of high complexity. Strong security skills for protecting the operating system, software, data and hardware.

• Works independently and as part of a team. Demonstrated problem-solving skills. Ability to learn effectively and meet deadlines. Demonstrated skill leading technical teams, including organizing workflow and scheduling assignments. Ability to work independently on complex technical projects as well as on a team of technical professionals and departmental decision-makers.

• Knowledge of test application code in client server environment.

• Demonstrated comprehensive understanding of how system management actions affect other systems, system users and dependent / related functions. Experience in data integration and the specification of data services. Ability to understand and model complex knowledge-intensive processes such as scholarly and research processes.

• Interpersonal skills sufficient to work with both technical and non-technical personnel at various levels in the organization. Ability to elicit and communicate technical and non-technical information in a clear and concise manner.

• Familiarity with data quality and governance issues and requirements.

• Familiarity with logical data design and data mapping or data conversion.

• Demonstrated project management skills.

• Technical skill to develop, implement and test disaster recovery functions using backup technologies.

• Proficiency in MS SQL and relational database management systems (RDBMS), including deep SQL expertise, stored procedures, and performance tuning.

• Strong knowledge of EAI/SOA best practices, development methodologies & standards

• Working knowledge of Finance, HR, and Health Care terminology and operations.

• Experience with all phases of software development life cycle from Business Requirement Analysis to Production implementation.

• Experienced integrating EMR and ERP systems, specifically Epic, Oracle Financials Cloud, Salesforce Health Cloud, and PeopleSoft.

• Three (3+) or more years of experience with MuleSoft, Boomi or similar API platform, certification.

• Prior mentoring experience, supporting peers and junior staff members through requirements, design and development activities.

• Advanced level of project management, Dev Ops, and/or program management experience. Familiarity with Agile development, Software Development Life Cycles (SDLC), Product Development Life Cycles (PDLC), and waterfall implementation methodologies.

• Familiarity with or professional experience working in a major cloud platform, such as Amazon Web Services (AWS).

• Experience configuring, managing, and utilizing Secure File Transfer Protocol (SFTP) for automated and secure data file transfers. Moveit experience preferred.

• Proficiency in scripting languages (e.g., Python, PowerShell) for task automation and system administration. UIPath RPA toolsets and concepts.

• Experience using modern version control systems (e.g., Git, Azure) for collaborative development.

• Must be able to work various hours and locations based on business needs.

• Employment is subject to a criminal background check and pre-employment physical.