Back to jobs
New

Sr. Data Engineer

Oklahoma City

Objectstream is an award-winning small business dedicated to providing innovative products and services in many areas, including information technology, management consulting, and logistics, for customers including the FAA, DOD, and state governments. We accomplish this mission by forging long-term trusted relationships with our employees, customers, and strategic partners; building an organizational culture that promotes empowerment and accountability; assuring a talented, well-trained, and qualified workforce; continuously improving our efficiency and productivity; and being socially and environmentally responsible corporate citizens. We pride ourselves on fostering a collaborative and innovative work environment where employees are encouraged to share ideas and take ownership of their projects.

We are currently seeking a talented Sr. Data Engineer to join our dynamic team supporting our client in Oklahoma City, Oklahoma.

Job Description – Objectstream is seeking a Senior Data Engineer to lead a strategic data migration initiative that moves structured and semi-structured data from Microsoft Azure Blob Storage into Salesforce, with the platform surface delivered through Salesforce Experience Cloud. This role sits at the intersection of cloud data engineering, data quality management, and CRM integration, requiring both technical depth and a sharp analytical mindset.

The source data landscape is heterogeneous: schemas may be inconsistent, field names will differ, data types may require transformation, and business logic must be applied before records can be loaded into Salesforce objects. You will own the end-to-end migration pipeline, from raw ingestion and profiling through cleansing, transformation, schema mapping, and final load validation.

KEY RESPONSIBILITIES

Data Ingestion & Profiling

  • Connect to Azure Blob Storage containers and extract files across formats including CSV, Parquet, JSON, and Avro
  • Profile source datasets to identify schema drift, null patterns, cardinality anomalies, and referential integrity gaps
  • Document data dictionaries and lineage maps for all source-to-target field mappings

Schema Mapping & Transformation

  • Design and implement cross-schema mapping logic where source table structures do not align with Salesforce standard or custom objects
  • Build transformation pipelines using Azure Data Factory, or equivalent ETL tooling to normalize, reshape, and enrich source data
  • Apply business rules and data derivation logic to generate missing or computed fields required by Salesforce objects
  • Handle many-to-one and one-to-many relationship resolution between source tables and Salesforce object hierarchies (Accounts, Contacts, Cases, custom objects)

Data Cleaning & Quality Assurance

  • Detect and remediate duplicate records, invalid formats, out-of-range values, broken foreign keys, and encoding inconsistencies
  • Implement data quality scoring and rejection workflows with clear audit trails for records that fail validation thresholds
  • Collaborate with business stakeholders to define and codify data quality rules and acceptable transformation logic
  • Produce data quality reports pre- and post-migration to demonstrate completeness and accuracy

Salesforce Integration & Loading

  • Load transformed data into Salesforce using Bulk API 2.0, Data Loader, or Salesforce CLI with appropriate error handling and retry logic
  • Work within the Salesforce Experience Cloud data model to ensure migrated records are correctly scoped to the right communities, portals, and sharing rules
  • Manage external ID strategies, upsert operations, and record ownership assignment during migration
  • Coordinate with Salesforce admins and developers to validate object relationships, validation rules, triggers, and process automation that may affect data loading

Pipeline Engineering & Orchestration

  • Design idempotent, resumable migration pipelines capable of incremental and full-load modes
  • Implement orchestration and scheduling using Azure Data Factory or Apache Airflow
  • Build monitoring, alerting, and logging infrastructure for pipeline health and data throughput
  • Write and maintain infrastructure-as-code and pipeline configuration in version-controlled repositories

Stakeholder Collaboration

  • Communicate migration progress, blockers, and data quality findings to technical and non-technical stakeholders
  • Partner with Salesforce Experience Cloud administrators to align portal data structures with migrated records
  • Contribute to post-migration hypercare activities, including reconciliation validation and end-user data access verification

REQUIRED QUALIFICATIONS

  • Bachelor’s or Master’s degree in Computer Science, Engineering, or related field
  • 8+ years of experience in data engineering, ETL development, or data migration roles
  • Demonstrated experience migrating data into Salesforce, including use of Bulk API 2.0, Data Loader, or similar tooling
  • Hands-on experience with Azure Blob Storage and Azure Data Factory
  • Proficiency in Python for data transformation, particularly pandas, PySpark, or similar libraries
  • Strong SQL skills with experience querying, profiling, and transforming large datasets
  • Experience with cross-schema or heterogeneous data mapping where source and target structures differ significantly
  • Familiarity with Salesforce data model fundamentals: standard objects, relationships, sharing model, and record types
  • Understanding of Salesforce Experience Cloud portal data scoping and community user access patterns
  • Experience implementing data quality frameworks: validation rules, rejection workflows, and audit logging
  • Proficiency with Git and version-controlled development practices

PREFERRED QUALIFICATIONS

  • Salesforce Certified Administrator or Platform App Builder certification
  • Experience with Salesforce CLI (sf / sfdx) for data operations and org management
  • Familiarity with Apache Airflow or similar workflow orchestration platforms
  • Experience with dbt for data transformation documentation and lineage
  • Experience with data cataloging and lineage tools
  • Familiarity with Salesforce MuleSoft

WHAT SUCCESS LOOKS LIKE

  • All target Salesforce objects populated with complete, accurate data within agreed migration milestones
  • Full field-level lineage documented from Azure Blob source to Salesforce target
  • Experience Cloud portal users can access migrated records with correct sharing and visibility rules applied
  • Migration pipelines are idempotent, re-runnable, and fully logged for audit purposes
  • Post-migration reconciliation report signed off by business stakeholders

 Benefits of working at Objectstream:

  • Collaborative, innovation‑focused culture
  • Competitive salary and benefits package

 

Create a Job Alert

Interested in building your career at Objectstream? Get future opportunities sent straight to your email.

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf

Education

Select...
Select...

U.S. Standard Demographic Questions

We invite applicants to share their demographic background. If you choose to complete this survey, your responses may be used to identify areas of improvement in our hiring process.
Select...
Select...
Select...
Select...
Select...
Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Objectstream’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.