Data Engineer

Match Point Solutions; Rosemead (CA); On-site; USD 110,000 - 138,000; Full time

Job summary

MatchPoint Solutions is seeking a Mid/Senior Data Engineer in Rosemead, CA for a 3-month contract. You will design, develop, and support scalable data pipelines, focusing on Oracle DB, data ingestion, and transformation with Python-based solutions.

The role emphasizes enterprise data movement and integration, with limited involvement in reporting visualization, and requires experience with Airflow and NiFi for workflow orchestration.

Qualifications

• Experience designing scalable data pipelines in enterprise environments.
• Strong Oracle DB, SQL, and data modeling skills.
• Experience with ETL/ELT workflows and data integration.
• Knowledge of data governance and data quality concepts.

Responsibilities

• Design, build, and maintain scalable data pipelines across enterprise platforms.
• Develop and optimize ETL/ELT workflows.
• Write efficient SQL for data transformation and performance tuning.
• Configure and manage workflows using Airflow/NiFi.
• Support Power BI connectivity and data source integration.

Skills

Oracle DB

Schema design

Performance tuning

SQL

Python

Data ingestion

Data transformation

Airflow

NiFi

Power BI

API integrations

Education

Bachelor's degree in CS or related

Tools

Apache NiFi

Apache Airflow

Trino

Kubeflow

PostgreSQL

Job description

MatchPoint is a fast-growing, young, energetic global IT-Engineering services company with clients across the US. We provide technology solutions to various clients like Uber, Robinhood, Netflix, Airbnb, Google, Sephora and more! More recently, we have expanded to working internationally in Canada, China, Ireland, UK, Brazil and India. Through our culture of innovation, we inspire, build, and deliver business results, from idea to outcome. We keep our clients on the cutting edge of the latest technologies and provide solutions by using industry specific best practices and expertise.

We are excited to be continuously expanding our team.

Role: Data Engineer

Contract Length: 3 months

Location: Rosemead, CA

Rate: $90/hr on W2

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.

MatchPoint Solutions provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.