Data Engineer

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 Skills Apache 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. 3B Staffing LLC