Data Engineer
3b staffingRosemead, CA
About the role
Role: Data Engineer
Location:
Hybrid - Tuesday/Wednesday in office (Rosemead, CA).Duration : 3 months - potential for contract duration to be extended for long term contract
Position Summary:
We are seeking a Mid/Senior Data Engineer to design, develop, and support scalable data pipelines and integrations across enterprise data platforms. This role will focus on building reliable data workflows, managing data ingestion and transformation processes, and supporting reporting infrastructure through standardized data delivery. The ideal candidate will have strong experience working with Oracle databases, workflow orchestration tools, and Python-based data engineering solutions. This role will primarily support enterprise data movement, transformation, and integration activities, with limited involvement in reporting visualization development.
Key Responsibilities:
Design, build, and maintain scalable data pipelines to ingest, transform, and deliver structured and semi-structured data.
Develop and optimize ETL/ELT workflows using orchestration and data integration tools.
Build and maintain data ingestion frameworks using enterprise data integration tools.
Write efficient, scalable SQL queries for data transformation and performance tuning.
Develop reusable Python-based scripts for automation, transformation, and data validation.
Configure and manage workflows using orchestration tools to ensure reliable pipeline execution.
Integrate new data sources into existing reporting environments.
Support Power BI connectivity by configuring new data source connections to existing reports (no dashboard design responsibilities).
Monitor pipeline performance and troubleshoot failures or performance bottlenecks.
Implement logging, error handling, and data validation controls.
Collaborate with business analysts, reporting teams, and platform engineers to ensure reliable data delivery.
Maintain technical documentation related to data pipelines, data flows, and integration patterns.
Support data quality initiatives and enforce data governance best practices.
Primary Technical Skills (Required)
Oracle Database (Oracle DB)
Schema design and data modeling fundamentals
Performance tuning and query optimization
Stored procedures and data transformation
Apache NiFi
Data flow development
Data ingestion and transformation pipelines
Flow monitoring and troubleshooting
Apache Airflow
Workflow orchestration
DAG creation and scheduling
Pipeline automation
Python
Data processing scripts
API integrations
Automation workflows
SQL
Complex queries and joins
Performance optimization
Data validation logic
Power BI (Limited Scope)
Configure new data source connections
Support existing reports
No dashboard development or redesign responsibilities
Secondary / Nice-to-Have SkillsApache Spark
Distributed data processing
Batch and large-scale data transformation
Trino
Query federation across distributed data sources
Kubeflow
Pipeline orchestration in containerized environments
ML workflow support
PostgreSQL
Database development and administration
Query optimization
Preferred Qualifications:
Bachelor's degree in Computer Science, Data Engineering, Information Systems, or related field (or equivalent experience).
5-10+ years of experience in data engineering or related roles.
Experience working within enterprise or regulated environments.
Familiarity with data governance, data quality, and data lineage concepts.
Experience supporting data integration for reporting platforms.
Ability to work independently and collaborate across cross-functional teams.
Matching similar jobs
JOB OVERVIEW
Experience level
Senior
Location
Rosemead, CA
Occupation
Data Warehousing Specialists
Industry
Computer Systems Design Services
Posted
2 days ago
Tired of running searches?
Rank the roles you'd take once, and matches like these arrive on their own.
CREATE PROFILE (opens in a new tab)