DataBricks Data Engineer

Software Guidance & Assistance, Inc. (SGA, Inc.); New York (NY); On-site; USD 123,984 - 206,640; Full time

Job summary

Software Guidance & Assistance, Inc. (SGA), is seeking a Databricks Data Engineer for a contract assignment with an Insurance Services client in New York, NY. You will design, develop, and implement Databricks-based data pipelines to support ingestion, transformation, and analytics across enterprise data.

The role emphasizes end-to-end data solutions and collaboration with cross-functional teams. Ideal candidates have 7+ years in data engineering with 3+ years hands-on Databricks experience,

Qualifications

• 7+ years in data engineering
• 3+ years with Databricks solutions
• Strong Python/SQL skills
• Experience with Delta Lake, Unity Catalog and Databricks Workflows
• In-depth knowledge of ETL/ELT, data ingestion and modeling
• Familiarity with SIC platforms (e.g., Anaplan, Oracle ICM, Varicent)
• Experience integrating Databricks with cloud platforms and data sources

Responsibilities

• Design and develop Databricks-based data pipelines and dashboards/notebooks
• Maintain and optimize Databricks workspaces and pipelines
• Develop data models and Delta Lake tables
• Support Sales Incentive Compensation processes including quota, attainment, commissions, payouts
• Collaborate with Finance, IT, and BI teams
• Document technical specifications and data architectures
• Provide production support and troubleshoot data issues

Skills

Databricks

Python

SQL

ETL/ELT

Data modeling

Delta Lake

Databricks Workflows

Unity Catalog

Sales Incentive Compensation (SIC)

Cloud platforms (Azure/AWS/GCP)

Problem solving

Tools

Delta Live Tables

Photon

Job description

Software Guidance & Assistance, Inc., (SGA), is searching for a DataBricks Data Engineer for a CONTRACT assignment with one of our premier Insurance Services clients in New York, NY.

We are seeking a skilled and experienced Databricks Data Engineer to join our team. As a Databricks Data Engineer, you will be responsible for designing, developing, and implementing data engineering solutions using the Databricks platform to support data ingestion, transformation, performance reporting, analytics, sales incentive compensation processing, and enterprise data pipeline processes.

Responsibilities

• Collaborate with business stakeholders to understand their data requirements and translate them into scalable technical solutions.
• Design and develop Databricks-based data pipelines, including data models, Delta Lake tables, and dashboards/notebooks.
• Responsible for the overall Databricks architecture to ensure new pipelines and enhancements to existing workflows are designed in an integrated and optimal manner.
• Maintain and optimize all current Databricks workspaces and pipelines; capture and deliver requirements for new or improved functionality to achieve further automation and integration of data and processes.
• Design and implement data pipelines to support Sales Incentive Compensation (SIC) processes, including quota management, attainment calculations, commission processing, and payout reporting.
• Partner with Sales Operations and Finance teams to understand incentive plan rules and translate them into accurate, auditable data transformations and models.
• Perform testing and debugging of data pipelines and notebooks to identify and resolve issues and ensure optimal performance.
• Provide technical support and troubleshooting for Databricks-based solutions, working closely with end-users and analysts to address their needs and resolve any data-related problems.
• Stay up to date with Databricks features and enhancements (Unity Catalog, Delta Live Tables, Photon, etc.), and proactively identify opportunities to leverage them to improve data quality, performance, and analytics capabilities.
• Collaborate with cross-functional teams, including finance, IT, and business intelligence teams, to ensure seamless integration and alignment of Databricks with other systems and processes.
• Document technical specifications, data models, pipeline configurations, and development processes to ensure knowledge transfer and maintain system documentation.

Required Skills

• At least 7 years of experience in data engineering, with a minimum of 3 years hands‑on experience building and managing Databricks solutions.
• Extensive experience with Databricks platform components: Delta Lake, Delta Live Tables, Unity Catalog and Databricks Workflows.
• Strong proficiency in Python and/or Scala for data engineering; SQL expertise required.
• Strong experience with core data engineering practices including data ingestion, transformation (ETL/ELT), data modeling, and pipeline orchestration.
• Functional and technical experience with Sales Incentive Compensation (SIC) — including incentive plan design, quota allocation, attainment tracking, commission calculations, and payout processing.
• Familiarity with SIC platforms (e.g., Anaplan, Oracle ICM, Varicent) and experience integrating them with data engineering platforms is a strong plus.
• Ability to understand complex incentive compensation rules and model them accurately in data pipelines and transformation logic.
• Experience integrating Databricks with cloud platforms (Azure, AWS, or GCP) and data sources such as Azure Data Factory, Event Hubs, Kafka, or equivalent.
• Passion and ability to create holistic, end‑to‑end, integrated data solutions.
• Stakeholder management skills; ability to challenge constructively and translate complex business requirements into scalable data architectures — not just gather requirements.
• Strong analytical and problem‑solving skills, with the ability to understand complex data requirements and implement reliable, efficient solutions.
• Excellent communication and collaboration skills, with the ability to work effectively with cross‑functional teams and stakeholders.
• Must work well in a team environment while being a resourceful, independent self‑starter able to work effectively with minimal direction.
• Skilled at documenting complex data architectures and pipelines in a professional manner.
• Ability to work independently and manage multiple tasks and priorities in a fast‑paced environment.
• Passion for data quality, performance optimization, and delivering excellent end‑user data experiences.

Preferred Skills

• Databricks Certified Data Engineer Associate or Professional certification is a plus.

SGA is a technology and resource solutions provider driven to stand out. We are a women‑owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at https://sgainc.com/.

SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company EEO page to request an accommodation or assistance regarding our policy.