Data Analytics & Engineering

Job Title: Data Engineer IV

Location: CA (Remote)

Duration: Contract - 6 months

Pay Range: $81/hr $84/hr (W2)

Job ID: 373299

About BCforward

BCforward is a leading global IT consulting and workforce solutions firm providing services and support to Fortune 500 and government clients. Founded in 1998, BCforward has grown with our customers needs into a full-service business solutions provider. With delivery centers and offices across North America and India, we take pride in building long-term relationships and delivering excellence through innovation, collaboration, and integrity.

Job Description

We are seeking a Data Engineer IV to join our team and lead a strategic data platform migration initiative. The ideal candidate will have strong experience in building large-scale ETL/ELT pipelines, Salesforce data extraction, and distributed data warehouse ecosystems and a proven ability to design bidirectional data flows, ensure data quality and reconciliation, and deliver reliable batch and streaming integrations.

Responsibilities:

• Design and build bidirectional data pipelines between Salesforce, distributed data warehouses (Hadoop/Spark/Hive ecosystems), and operational entity-modeled data stores.


• Develop and maintain scheduled batch ETL jobs using Airflow, Dagster, or equivalent for daily and hourly data synchronization.


• Build streaming data pipelines using Kafka or equivalent pub/sub systems for near-real-time propagation.


• Implement Salesforce extraction patterns including Bulk API, REST API, SOQL, change data capture, and platform events.


• Design and maintain dimensional and entity schemas, with lineage and column-level mappings.


• Build validation, reconciliation, and quality monitoring frameworks to ensure system parity during migration.


• Develop and maintain documentation including schema definitions, transformation logic, and source-to-target mappings.


• Use AI-assisted development tools such as Claude Code, Cursor, or Copilot to accelerate development and migrations.


• Partner with engineers, Salesforce administrators, and business stakeholders to define data contracts, SLAs, and cutover criteria.


• Investigate and resolve data quality incidents, pipeline failures, and reconciliation discrepancies.

Required Skills & Qualifications:

• Strong proficiency in SQL and one general-purpose language (Python preferred; Java, Scala, or TypeScript acceptable).


• Hands-on experience building and operating large-scale ETL/ELT pipelines in Hive, Spark, Presto/Trino, BigQuery, Snowflake, or Databricks.


• Experience with workflow orchestration tools such as Airflow, Dagster, or Prefect.


• Familiarity with Kafka, Pulsar, Kinesis, or equivalent for real-time ingestion.


• Salesforce data extraction experience, including Bulk API, REST API, SOQL, CDC, platform events, and Salesforce data model knowledge.


• Comfort with entity modeling, dimensional modeling, and data lineage tooling.


• Hands-on use of AI coding assistants in daily development workflows.


• Strong understanding of data quality engineering, testing, validation, monitoring, and reconciliation.


• Experience with migrations between heterogeneous systems.


• Effective communication, problem solving, customer service, and interpersonal skills.


• Ability to work independently and manage time.


• Knowledge of the full data engineering lifecycle from requirements through production operations.


• Ability to troubleshoot data issues and implement system changes to resolve them.

Preferred Skills:

• Experience with AWS or Azure data services for warehousing and streaming.


• Prior work in Agile or Scrum environments with documented SLAs.

Education/Experience:

• Bachelor's degree in computer science, data engineering, information systems, or a relevant field.


• 3+ years of professional data engineering experience preferred.

Why BCforward?

At BCforward, we believe in advancing lives and careers. When you join our team, you gain access to:

• Competitive compensation and benefits.


• Opportunities for growth with global clients.


• A supportive, inclusive culture that values innovation and people.


• Exposure to cutting-edge technologies and projects.

About Our Commitment

BCforward is an equal opportunity employer. We value diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability, or veteran status.

Fair Chance Notice

Pursuant to the California Fair Chance Act, Los Angeles County Fair Chance Ordinance for Employers, Los Angeles Fair Chance Initiative for Hiring Ordinance, and San Francisco Fair Chance Ordinance, qualified applicants will be considered for assignment with arrest and conviction records. Criminal history may have a direct, adverse, and negative relationship with some of the material job duties of this position. These include the duties and responsibilities listed above, as well as the abilities to adhere to company policies, exercise sound judgment, effectively manage stress and work safely and respectfully with others, exhibit trustworthiness, meet client expectations, standards, and accompanying requirements, and safeguard business operations and company reputation.

Interested? Apply Now!

If this sounds like the right opportunity for you, please apply with your most recent resume.

Email:

Phone: