Sr. Data Integration Developer

Title: Sr. Data Integration Developer

Location: Fountain Valley, CA / Remote

Department: IS Healthcare Intelligence

Status: Full Time

Shift: Days

Pay Range*: $117, 852.80 - $170,851.20

At MemorialCare Health System, we believe in providing extraordinary healthcare to our communities and an exceptional working environment for our employees. Memorial Care stands for excellence in Healthcare. Across our family of medical centers, we support each one of our bright, talented employees in reaching the highest levels of professional development, contribution, collaboration and accountability. Whatever your role and whatever expertise you bring, we are dedicated to helping you achieve your full potential in an environment of respect, innovation and teamwork.

Position Summary

Members of the MemorialCare Data Integration job family work side by side with our end users to deliver analytics solutions to the enterprise through data analysis, data profiling, extraction and transformations, data modeling, and leveraging the appropriate Business Intelligence tools. Members from this job family are accountable for growing, as well as enhancing and maintaining the enterprise data warehouse (EDW), used for reporting and data analysis. The EDW is considered a core component of business intelligence acting as a central repository for source data. In support of the EDW, team members develop automated processes for integrating data from one or more disparate sources. They analyze and perform data profiling to ensure data quality and may perform data cleansing if required prior to delivering data into the EDW to be used for reporting. They build reusable data models and data marts to support data governance and consistency in reporting. They analyze and provide resolutions to all EDW related data issues and coordinate with developers or subject matter experts (SME) to validate all requirements. Data Integration members design and develop reliable, accurate, and robust processes to share and exchange data with internal customers or external vendor solutions on a near real time and/or batch basis. They demonstrate integrity, ethics and professional conduct at all times.

The Sr. Data Integration Developer is considered a subject matter expert involved with all phases of delivering analytics integration solutions from technical requirements gathering, design, development, Quality Assurance, implementation and post implementation problem solving. They independently provide an advanced level of development expertise with their focus geared more towards complex and overall large projects. They can effectively diagnose and resolve complex problems quickly and act as a mentor to the Data Integration Developers.

Essential Functions and Responsibilities of the Job

• Participates and manages multiple data integration projects. Develops project plans, project roadmaps, and strategizes the project execution from inception to completion. Develops, maintains, and demonstrates in-depth business knowledge in assigned areas, and expertise in contemporary use of automation to improve business performance.

• Conducts data sourcing by analyzing applications, analyzing, defining and validating data, identifying the relationship among data objects, and performing basic data modeling activities. Uses Structured Query Language (SQL) against diverse data sources.

• Develops a robust and extensible data acquisition and integration solution for complex systems to meet the requirements of the business.

• Provides technical and administrative support of complex, enterprise-wide analytics systems to ensure data integrity and proper system functioning. Ensures data presented to customers is connected to the enterprise data dictionary, standardized terminologies, and provides insight into data lineage and transformations after initial creation.

• Creates new data structures using data modeling software and design principles to support more robust analysis capabilities. Develops solutions that are high performance, rapid response time, and as close to real-time as possible.

• Provides guidance and reviews work of lower level staff on development projects. Provides coaching as necessary.

• Mentors lower level staff and customers on analytics integration principles and best practices.

• Develops a robust and extensible data acquisition and integration solution for systems to meet the functional and non-functional requirements of the business.

• Works to analyze and understand source and target data systems for mapping purposes. Defines and captures any additional metadata associated with data handling processes.

• Develops and maintains data extraction scripts using MemorialCare' s enterprise information management (EIM) toolset from data sources, populating data warehouse and metadata repository data models in supporting existing and new applications.

• Optimizes query and database performance by applying best practices in database, data model, and query tuning techniques.

• Works closely with customers and technical team members, initiating and maintaining positive and proactive relationships and working collaboratively to deliver data integration solutions that are high performance, rapid response time, meets deadlines, and as close to real-time as possible.

• Adheres to and promotes best practices and standard work for all recurring activities

• Placement in the pay range is based on multiple factors including, but not limited to, relevant years of experience and qualifications. In addition to base pay, there may be additional compensation available for this role, including but not limited to, shift differentials, extra shift incentives, and bonus opportunities. Health and wellness is our passion at MemorialCare-that includes taking good care of employees and their dependents. We offer high quality health insurance plan options, so you can select the best choice for your family. And there's more...Check out our MemorialCare Benefits for more information about our Benefits and Rewards.

Minimum Requirements

Qualifications/Work Experience:

• Minimum 5 years' experience with enterprise data integration software required.

• Minimum 5 years' experience using relational database technology, including writing, debugging, and performance tuning SQL queries.

• Demonstrated history of successful analytics integration projects in respective application

• Experienced in leading projects, providing expert consultative guidance and direction on change initiatives, effectively managing more than one project, and meeting established deadlines

• Proven ability in workflow and data analysis and design techniques, including needs assessment, specification development, validation, and publication.

• Past success leading meetings between business stakeholders, technical resources, and third parties for business requirements and technical solutions

• Experienced working with a diverse, multi-disciplinary team, and interacting with all levels of the organization

• Proven knowledge of downstream use of data for effective customer consumption.

• Experienced in healthcare environment preferred.

Education/Licensure/Certification:

• Bachelor's degree or an equivalent combination of education and relevant experience required

• Epic Certification in Clarity Data Model preferred