Data Engineer, IT
- Location
- Aliso Viejo, CA, US
- Pay
- $116,706 – $153,176 a year
- Education
- Bachelor's degree
- Job function
- Software/Internet/AI › Data & Analytics › Data Engineer
Posted Nov 18, 2026Last confirmed open Nov 19, 2026
About this role
Responsible for the end-to-end design, development, testing, deployment, maintenance, and support of enterprise data integration and ETL solutions. Deliver reliable, scalable, and efficient data pipelines that integrate data from multiple source systems into enterprise reporting and analytics platforms.
Play a key role in ensuring data quality, governance, performance, and operational stability while adhering to established development standards and best practices. Contribute to the ongoing evolution of the organization's data warehouse environment in alignment with the Terumo Global IT enterprise data architecture strategy. Job duties:
- Design, develop, test, deploy, and support enterprise ETL/ELT solutions that integrate data from multiple business applications, databases, cloud platforms, APIs, and external data sources.
- Collaborate with business stakeholders, data analysts, BI developers, and application teams to understand data requirements and translate business needs into scalable and reliable data integration solutions.
- Develop, maintain, and optimize data integration workflows, mappings, transformations, and data pipelines to ensure timely, accurate, and efficient delivery of data to reporting, analytics, and operational systems.
- Design and implement end-to-end ETL/ELT processes for extracting, transforming, validating, and loading data from diverse enterprise systems such as SAP, Hyperion, CRM, PLM, QMS, flat files, APIs, etc.
- Perform unit, integration, and performance testing while implementing data validation, reconciliation, error handling, and monitoring controls to ensure data accuracy, completeness, and integrity.
- Monitor, troubleshoot, and resolve data integration issues, providing ongoing production support and root cause analysis to minimize system disruptions and maintain data availability.
- Establish and maintain ETL development standards, coding practices, documentation, and operational procedures to promote consistent, maintainable, and high-quality integration solutions.
- Optimize ETL and database performance through query tuning, workflow optimization, resource management, and efficient data processing techniques to support growing business demands.
- Support data governance, security, compliance, and audit requirements by ensuring adherence to organizational policies, regulatory requirements, and data management best practices.
- Create and maintain technical documentation including source-to-target mappings, process flows, data lineage, support procedures, and system design specifications.
- Contribute to the ongoing evolution of the organization's data warehouse environment, integration strategy, and enterprise data architecture roadmap.
- Evaluate and recommend enhancements to data integration technologies, tools, and processes to improve scalability, reliability, maintainability, and operational efficiency.
- Comply with applicable Laws and Regulations, adhere to Quality Management System processes and requirements as well as demonstrate Ethics and Integrity in all matters and at all levels throughout the organization.
- Perform additional duties as assigned.
Job Details
Job ID 15047BR
Aliso Viejo, California, USA
Salary Range:
$116,706 - $153,176 (Financial compensation packages may be higher/lower than listed, & will ultimately depend on factors including relevant experience, internal equity, skillset, knowledge, geography, education, business needs and market demand)
- Qualifications
+ Bachelor’s degree in computer science, information systems, data engineering, or a related field, or an equivalent combination of education and experience.
+ Minimum of six (6) years of hands-on experience designing, developing, testing, implementing, and supporting enterprise ETL and data integration solutions.
+ Strong experience with Microsoft SQL Server, including database design, complex SQL development, stored procedures, views, query optimization & performance tuning.
+ Proven expertise with ETL technologies and data integration tools, such as SSIS, Azure Data Factory, SAP Data Services, or similar platforms.
+ Experience developing and supporting data warehouse solutions, including dimensional modeling, star schemas, snowflake schemas, and data marts.
+ Strong understanding of ETL development best practices, including data mapping, transformation logic, error handling, data validation, and automated data processing.
+ Experience troubleshooting production data integration or ETL issues, performing root cause analysis, maintaining reliable, high-performing data pipelines, and providing ongoing production support for data integration processes.
+ Experience working with source control, change management, SDLC methodologies, and production deployment processes.
+ Ability to collaborate effectively with business stakeholders, application teams, BI developers, and data consumers to deliver scalable data integration solutions.
+ Experience developing, maintaining, and supporting ETL solutions using Microsoft SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
+ Strong proficiency in Microsoft SQL Server, including complex SQL queries, stored procedures, views, functions, triggers, and performance tuning.
+ Strong understanding of data quality, validation, reconciliation, data governance, and metadata management practices.
+ Strong analytical, problem-solving, critical-thinking, verbal communication, and technical documentation skills.
+ Proficiency with Microsoft Office applications, including Word, Excel, Outlook, Teams, and related collaboration tools.
Desired Qualifications
+ Experience integrating data from enterprise applications such as SAP, Oracle, Salesforce, CRM, PLM, QMS, HRIS, and other business systems.
+ Experience supporting enterprise data warehouse and business intelligence environments, including dimensional modeling, star/snowflake schemas, data marts, and SQL Server-based analytics solutions.
+ Experience developing and supporting reports, datasets, and dashboards using Power BI or similar BI tools.
+ Familiarity with SQL Server performance optimization techniques, including query tuning, indexing strategies, and ETL workload optimization.
+ Knowledge of regulatory and compliance requirements such as GxP, SOX, and audit controls within a regulated environment.
+ Experience with source control, change management, release management, and SDLC best practices.
+ Experience serving as an individual technical contributor/resource within a data integration, ETL, or data warehouse team.
Prefer to apply directly?
Apply on Terumo Neuro