Senior Data Engineer – Onsite in Irvine, CA

Calance; Irvine (CA); On-site; USD 120,000 - 180,000; Full time

Job summary

Calance is seeking a Data Engineer III for its Irvine, CA IT department. This 100% onsite role involves designing and maintaining data architectures, pipelines and curated data layers to support analytics and reporting across multiple teams.

You will collaborate with analytics, product and engineering teams, optimize data flows, and ensure data quality and security. Transition to a San Dimas, CA office is planned for 2027; willingness to relocate is required.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Analytics or related fields is required.
• Minimum 5+ years experience in a Data Engineering role.
• Strong experience with enterprise relational database platforms; Oracle highly preferred.
• Advanced proficiency in SQL, PL/SQL, and Python; exposure to Spark.
• Experience with relational databases and large-scale data sets.
• Experience designing, developing, and maintaining data pipelines, integrations, and data models.
• Experience integrating data from multiple source systems, including applications, APIs, databases and flat files.
• Understanding of data warehousing concepts, dimensional modeling, data marts, and analytical reporting structures.
• Ability to analyze complex data issues and troubleshoot data discrepancies across systems.
• Strong understanding of ETL/ELT processes and data integration best practices.
• Ability to work with both technical and non-technical stakeholders.
• Ability to manage multiple projects and priorities.
• Strong communication, documentation, and problem-solving skills.
• Highly motivated and proactive with attention to detail.

Responsibilities

• Design, build and maintain data architectures, integrations and pipelines that align with business and technical requirements.
• Develop reliable data sets, data models and curated data layers to support analytics, reporting, dashboard and business intelligence solutions.
• Partner with analytics teams and stakeholders to design and deliver curated datasets for self-service analytics and data-driven decisions.
• Identify opportunities to improve data reliability, efficiency, scalability and data quality.
• Build and support API integrations to handle increasing data volume and complexity.
• Engineer scalable data pipelines and curated data layers to integrate and transform data from multiple source systems.
• Implement data quality monitoring, validation, and control processes to ensure production data accuracy.
• Troubleshoot data issues and assist with root-cause analysis and resolution.
• Collaborate with frontend/backend engineers, product managers and analysts to support data platform strategy.
• Monitor performance of data pipelines, integrations and SQL-based systems.
• Optimize SQL and PL/SQL workloads and data transformations for analytics.
• Document data pipelines, mappings, business rules and operational processes.
• Maintain confidentiality and security of sensitive data.

Skills

SQL

PL/SQL

Python

Spark

Data modeling

ETL/ELT

Oracle

Data pipelines

Education

Bachelor's degree in Computer Science, Information Systems, Analytics or related fields

Tools

Oracle Database

Oracle Cloud

Tableau

Power BI

Oracle Fusion

ADW

ATP

OAC

OCI Data Integration

Object Storage

Job description

Calance is seeking a Data Engineer III for its Irvine, CA IT department. This 100% onsite role involves designing and maintaining data architectures, pipelines and curated data layers to support analytics and reporting across multiple teams.

You will collaborate with analytics, product and engineering teams, optimize data flows, and ensure data quality and security. Transition to a San Dimas, CA office is planned for 2027; willingness to relocate is required.