Sr. Data Integration Developer - FT/Remote - (Job Number: MEM007016)

MemorialCare; Fountain Valley (CA); Remote; USD 113,000 - 165,000; Full time

Job summary

MemorialCare is seeking a Sr. Data Integration Developer in Fountain Valley, CA. This critical role involves delivering analytics integration solutions across multiple projects, leveraging extensive technical expertise. You will develop and optimize integration solutions using SQL and guide a team, contributing significantly to enterprise data integrity. The position offers competitive compensation and generous benefits.

Benefits

High quality health insurance plan options

Additional compensation including bonuses

Qualifications

• Minimum 5 years’ experience with enterprise data integration software required.
• Minimum 5 years’ experience with relational database technology.
• Proven history of analytics integration project success.

Responsibilities

• Develop project plans and roadmaps for data integration projects.
• Conduct data sourcing and analysis for data integrity.
• Mentor lower level staff on analytics integration.

Skills

SQL

Data modeling

Analytical skills

Problem-solving

Project management

Education

Bachelor’s degree or equivalent experience

Epic Certification in Clarity Data Model

Job description

Pay Competitive

Location Fountain Valley/California

Employment type Other

Job Description

Req#: MEM007016 !*!

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

• Develop project plans, project roadmaps, and strategizes the project execution from inception to completion
• Conduct data sourcing by analyzing applications, analyzing, defining and validating data, identifying the relationship among data objects, and performing basic data modeling activities
• Develop data acquisition and integration solution for complex systems to meet business requirements
• Provide technical and administrative support of complex, enterprise-wide analytics systems to ensure data integrity and proper system functioning
• Create new data structures using data modeling software and design principles to support more robust analysis capabilities
• Develop a robust and extensible data acquisition and integration solution
• Analyze and understand source and target data systems for mapping purposes
• Develop and maintain data extraction scripts using MemorialCare’ s enterprise information management (EIM) toolset from data sources
• Optimize query and database performance by applying best practices in database, data model, and query tuning techniques
• Deliver data integration solutions that are high performance, rapid response time, meets deadlines, and as close to real-time as possible

Specific job related responsibilities and duties

• 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

Pay Range: $113,318.40 - $164,278.40

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.

!*!

Experience

• Minimum 5 years’ experience with enterprise data integration software required.
• Minimum 5years’ 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

• Bachelor’s degree or an equivalent combination of education and relevant experience required
• Epic Certification in Clarity Data Model preferred

About the company

MemorialCare is Orange & LA counties' leading integrated health system with the best doctors, urgent care, & pediatricians. Join our family & see the difference today!

Notice

Talentify 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, disability, or protected veteran status.

Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at [e-mail] or 407-000-0000.

Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.

An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report . NYC applicants may request an alternative process or accommodation at [e-mail] or 407-000-0000.