This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
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.
Job Responsibility:
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
Supporting the ongoing efforts to implement a robust ETL/EAI/SOA to meet the strategic goals of the organization
Part of the team responsible for the overall framework and architecture for Enterprise Integration
Supporting the integration needs for our clinical enterprise, including our Medical Center, Physician Group, and Population Health Services Organization
Supporting the development of a sustainable program around ETL and integration projects
Defining the framework and architecture most appropriate when implementing with various solutions
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
Function as the technical product manager responsible for developing and maintaining integrations into and out of the various systems
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
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
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
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
Requirements:
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
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
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
Nice to have:
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