Data Engineer jobs in United States
cer-icon
Apply on Employer Site
company-logo

Brooksource · 16 hours ago

Data Engineer

Brooksource is seeking a hands-on, mid-level Data Engineer to support a security-focused data lake initiative. This role focuses on building reliable API ingestion pipelines and preparing data for downstream analytics and future AI use cases.

EmploymentHuman ResourcesInformation Technology
check
Growth Opportunities
check
H1B Sponsor Likelynote
Hiring Manager
Jenny Ashurov
linkedin

Responsibilities

Build and own API-based ingestion pipelines pulling data from third-party systems
Handle authentication, pagination, retries, failures, and schema changes
Ingest, transform, and structure raw data into SQL-based datasets
Validate incoming data for accuracy, completeness, and consistency
Create and maintain clear documentation for datasets, fields, and ingestion logic
Manage and support datasets across multiple data sources (approx. 14 total)
Prepare clean, well-structured data for downstream analytics and AI consumption
Operate independently and take ownership of deliverables with minimal hand-holding

Qualification

API ingestion pipelinesSQL / SQL ServerAWS S3AWS LambdaAWS EC2Data validationData modelingDocumentation skillsCommunication skills

Required

2+ years of hands-on experience writing and maintaining API ingestion pipelines in a big data environment, managing datasets across 14 known data sources and supporting datasets with 10–15K+ fields
3–6 years of hands-on experience as a Data Engineer or similar role
Strong experience building API-based ingestion pipelines
Proficiency with SQL / SQL Server and relational data modeling
Experience working in AWS (S3, Lambda, EC2, RDS, or similar)
Ability to validate and QA large, complex datasets
Comfortable working with large field counts and evolving schemas
Strong documentation and communication skills

Preferred

Exposure to security, device, endpoint, or asset data
Experience with tools such as Qualys, CrowdStrike, Intune, JAMF, Wiz, or SCCM
Familiarity with data lake concepts (raw vs curated layers)
Experience supporting analytics or AI teams (data prep only, not model building)

Company

Brooksource

company-logo
Brooksource is a single source for project and supplemental support through contract employment, contract-to-hire labor employment.

H1B Sponsorship

Brooksource has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2020 (10)

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Ashley Cigolotti
Director, Global Partnerships
linkedin
leader-logo
Matt Ayala
National Account Executive (Global Partnerships)
linkedin
Company data provided by crunchbase