Data Engineer Job at Business Needs Inc, California

Nys3M0I4c1U5VGJhMEdFVkNzSzZKVkVtenc9PQ==
  • Business Needs Inc
  • California

Job Description

Client: Adobe

Location: USA (remote, must be able to work Mountain Time hours)

Duration: 2-4 months to start

Title: Data Engineer

Key Skills: Data Engineer, Spark, SQL, Experience building production ETL/data-integration pipelines, schema, Databricks

Cybersecurity Experience/ security schemas/ vulnerability scanners would be a HUGE plus

Description:

Data Engineer-Vulnerability Data Integration Engineer

Deliverables

Two production-ready source integrations (ingestion, normalization, merge, ticketing) with validation/reconciliation checks and documentation.

Summary

We operate a large-scale security data platform on a modern lakehouse that normalizes vulnerability findings from multiple scanners into a common, standardized schema and drives downstream ticketing. We are onboarding two new scanner sources - one cloud-security-posture scanner and one web-application (DAST) scanner - and need an engineer to build and productionize those integrations end to end.

Key Responsibilities

  • Design and build incremental ingestion pipelines (watermarking, deduplication) for the two new sources against upstream data tables.
  • Map each source's native findings into the platform's common security schema, including severity/risk normalization and first-seen/last-seen handling.
  • Solve asset/target correlation for each source - associating findings with the right infrastructure or application entities and their ownership.
  • Integrate findings into downstream ticketing and exception-handling workflows, including which findings are ticketable and how ownership is attributed.
  • Merge new sources into a central large-scale table safely (schema evolution, unique-key handling, collision checks) and validate propagation into reporting/history views.
  • Reconcile output against each source's console (counts, coverage, dedup), and produce documentation and operational runbooks.

Work as an embedded member of the existing security data engineering team (not an isolated solo contributor) - collaborating day-to-day with the platform/security engineering team and other team members on shared schema conventions, merge patterns, and table ownership so new-source integration work lands safely alongside everyone else's changes.

Required Qualifications

  • Strong distributed data-processing skills (Spark or equivalent) and advanced SQL; comfortable with large-table upserts/MERGE, schema evolution, and incremental/watermark patterns.
  • Experience building production ETL/data-integration pipelines that normalize heterogeneous sources into a shared schema.
  • Solid data modeling; able to reason about join fan-out, deduplication, and entity correlation at large scale.
  • Self-directed, but collaborative - comfortable working as an embedded member of a larger existing engineering team, coordinating with other team members, and taking an integration from upstream discovery through validated production output.

Proficient in SQL (complex joins, window functions, CTEs) and Python (PySpark) for building and maintaining production data pipelines.

Hands-on experience with Databricks (notebooks, jobs/workflows, SQL warehouses) and Delta Lake tables - MERGE/upsert patterns, schema evolution, clustering/partitioning, and table maintenance (OPTIMIZE, VACUUM).

Preferred

  • Experience integrating commercial security/vulnerability scanners and/or working with standardized security schemas.
  • Ticketing/workflow-automation integration experience (e.g., issue trackers).
  • Application-security (DAST) domain awareness for the web-scanner workstream.

Job Tags

Full time, Part time, Internship, Seasonal work

Similar Jobs

Woongjin

Warehouse Manager Job at Woongjin

 ...Insurance401(k)Paid Sick hoursJob DescriptionManage multiple warehouse productivity and automation projectsDevelop and maintain detailed...  ...in Microsoft Office (Excel, PowerPoint, Word) and warehouse management systems (WMS/TMS).Data & Analysis: Strong analytical skills, including... 

Lennar

Regional Interior Design Assistant Job at Lennar

 ...consistently ranked among the top homebuilders in the United States.A Career that Empowers You to Build Your FutureRegional Interior Design Assistant requires assisting the Manager, Interior Design and Interior Designers with the development and implementation of model... 

Perceptyx Inc

Program Manager Job at Perceptyx Inc

 ...Program Manager Company: Perceptyx Work Type: Remote Employment: Full Time Location: US, CA Seniority: Mid Level Technologies: Certinia, Gainsight, enterprise tools Requirements: 3-4+ years in program or project management within SaaS/consulting/employee experience; enterprise... 

Peoples Financial Services

Senior Personal Banker Job at Peoples Financial Services

 ...experience to customers and prospects with a focus on meeting the financial needs of all areas of our community. Counsels clients,...  ...needs-based financial solutions. Capable of supporting clients in-person or virtually. Responsible for working as an active member of the... 

Omni Inclusive

React js Developer Job at Omni Inclusive

 ...Experience Manager. The implementation will require knowledge of responsive styling and modern JavaScript frameworks such as Next.js, React. Extensive AEM implementation experience Expertise with Apache Sling Expertise with the Java Content Repository ...