P1 - GP - Senior Data Engineer / Data Architect

Posted Yesterday
Be an Early Applicant
Bengaluru, Bengaluru Urban, Karnataka, IND
In-Office
Senior level
Artificial Intelligence • Cloud • Software
AI-powered platforms and IT services keeping healthcare and risk-critical operations accurate.
The Role
Build and operate end-to-end Databricks data pipelines using Bronze, Silver, and Gold layers. Develop incremental ingestion, dimensional models, data quality controls, reconciliations, migration processes, and performant Delta tables for Power BI and applications. Manage serving through Lakebase, Unity Catalog governance, orchestration, monitoring, documentation, and lineage. Collaborate with vendors, reporting and application teams, finance, and portfolio operations users.
Summary Generated by Built In

Job Description: Senior Data Engineer / Data Architect

About the role

We are hiring a Senior Data Engineer to build and run the pipelines that bring portfolio company data into one business-aligned model on Databricks.

The data comes from a third-party portfolio monitoring platform, with history carried over once from a legacy portfolio system. You will take it through Bronze, Silver and Gold layers and serve it to Power BI reporting and internal applications. You will own pipelines end to end: ingestion, transformation, data quality, performance and day-to-day operation.

What you'll do

  • Ingestion: build incremental loads from the source platform into Bronze using change timestamps and watermarks, with safe handling of late-arriving rows and full retention of raw history.
  • Silver: model source data close to its native structure, with deterministic deduplication, type-aware unit conversion, sign rules and quarantine of suspect rows rather than silent fixes.
  • Gold: implement a source-agnostic business model of dimensions, fact tables with different history rules and reference data, built as performant Delta tables for Power BI and application use.
  • Migration: support a single cutover from the legacy system, and load and freeze the history of companies that will not move.
  • Data modeling: work with the data model owner on the item catalog, dimensions (period, currency, fund and entity), cash transactions and derived measures such as multiples and FX conversion.
  • Data quality and reconciliation: build checks and quality flags, reconcile new figures against the legacy system before the cutover and run regression checks when the model changes.
  • Serving: publish Gold to downstream consumers, including Lakebase (Postgres) synced tables for applications and direct Delta access for BI.
  • Operations: orchestrate and monitor the pipelines, manage access in Unity Catalog, and keep documentation, lineage and runbooks current.
  • Collaboration: work closely with the vendor's data team, reporting and application teams, and finance and portfolio operations users on definitions and issues.

What you'll bring

  • 5+ years building production data pipelines, including 2+ years on Databricks with Delta Lake.
  • Strong SQL (Spark SQL and T-SQL) and Python or PySpark.
  • Hands-on experience with a medallion (Bronze, Silver, Gold) architecture and incremental processing: watermarks, MERGE, change data feed.
  • Dimensional modeling: facts at a clear grain, dimensions, surrogate keys, slowly changing dimensions.
  • A track record of data quality work: deduplication, reconciliation, and tracing a wrong number back to its source.
  • Experience with Unity Catalog or a comparable governance layer: permissions, lineage, documentation.
  • Performance tuning for BI workloads, such as file layout, clustering and query plans.
  • Clear written communication, including explaining data issues and trade-offs to non-technical users.

Nice to have

  • Private equity, asset management or fund administration data: portfolio monitoring, valuations, cash flows, fund and co-invest structures.
  • Financial reporting concepts: LTM and YTD periods, fiscal year ends, budgets and forecasts, restatements, currency conversion.
  • Databricks Lakebase or PostgreSQL, including serving data to applications.
  • Lakeflow (Delta Live Tables) or Databricks Workflows orchestration.
  • Azure SQL and migrating SQL Server logic to Databricks.
  • Power BI data modeling, or working closely with BI developers.
  • Infrastructure as code and CI/CD for data pipelines, for example Databricks Asset Bundles.

Our environment

Area

Tools

Lakehouse

Databricks, Delta Lake, Unity Catalog

Languages

Spark SQL, Python, PySpark, T-SQL

Application serving

Databricks Lakebase (Postgres) synced tables

Legacy and transition

Azure SQL Database

Reporting

Power BI

Cloud

Microsoft Azure

 

Skills Required

  • 5+ years building production data pipelines
  • 2+ years of Databricks experience with Delta Lake
  • Strong SQL skills, including Spark SQL and T-SQL
  • Python or PySpark experience
  • Hands-on experience with medallion architecture using Bronze, Silver, and Gold layers
  • Experience with incremental processing, including watermarks, MERGE, and change data feed
  • Dimensional modeling experience, including fact grain, dimensions, surrogate keys, and slowly changing dimensions
  • Data quality experience involving deduplication, reconciliation, and source tracing
  • Experience with Unity Catalog or a comparable governance layer, including permissions, lineage, and documentation
  • Performance tuning for BI workloads, including file layout, clustering, and query plans
  • Clear written communication with technical and non-technical users
  • Experience with private equity, asset management, or fund administration data
  • Knowledge of financial reporting concepts including LTM, YTD, fiscal year ends, budgets, forecasts, restatements, and currency conversion
  • Databricks Lakebase or PostgreSQL experience serving application data
  • Experience with Lakeflow, Delta Live Tables, or Databricks Workflows orchestration
  • Azure SQL and experience migrating SQL Server logic to Databricks
  • Power BI data modeling experience or collaboration with BI developers
  • Infrastructure as code and CI/CD experience for data pipelines, such as Databricks Asset Bundles
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: East Brunswick, New Jersey
200 Employees
Year Founded: 2003

What We Do

Atlas Systems is a technology company founded in 2003 in Princeton, New Jersey, serving Fortune 1000 and mid-sized clients across healthcare, financial services, manufacturing, and other regulated industries. We build AI-powered platforms that solve operational problems most enterprises still handle manually or through legacy systems: PRIME®: A provider data management platform used across U.S. healthcare, covering payers, providers, health systems, and provider groups. PRIME keeps provider directories accurate, automates credentialing and enrollment, and helps organizations meet compliance and directory accuracy requirements. ComplyScore®: A risk and compliance management platform covering third-party risk management, continuous compliance, and internal risk domains, including a Headless TPRM offering. Used by regulated industries including healthcare, financial services, manufacturing, and life sciences across the US, EU, APAC, and India. AInfinity®: An agentic AI automation platform that applies AI to workflows across healthcare and risk and compliance. Beyond our platforms, our IT Services division works alongside client teams and systems, providing managed IT services, infrastructure support, application development, database services, cloud migration, and IT security to organizations that need dependable, hands-on technical partners. We manage 6,000+ database instances, and our platforms are built to hold up at enterprise scale: accurate enough to pass an audit or regulatory review, and simple enough that clients get more value at a lower total cost of ownership than comparable solutions. We're small enough to know our clients by name and big enough to support Fortune 1000 operations across geographies.

Why Work With Us

We're a team-first culture where people grow fast, own real problems, and see their work reach Fortune 1000 clients from day one. We promote from within and invest in ongoing development, because our platforms are only as good as the people building them.

Similar Jobs

Expedia Group Logo Expedia Group

Development Engineer

AdTech • eCommerce • Information Technology • Software • Travel • Generative AI
Hybrid
Bangalore, Bengaluru Urban, Karnataka, IND
16000 Employees

Expedia Group Logo Expedia Group

Data Engineer

AdTech • eCommerce • Information Technology • Software • Travel • Generative AI
Hybrid
Bangalore, Bengaluru Urban, Karnataka, IND
16000 Employees

Toast Logo Toast

Senior Software Engineer

Cloud • Fintech • Food • Information Technology • Software • Hospitality
In-Office
Bangalore, Bengaluru Urban, Karnataka, IND
5000 Employees

Toast Logo Toast

Quality Assurance Engineer

Cloud • Fintech • Food • Information Technology • Software • Hospitality
In-Office
Bangalore, Bengaluru Urban, Karnataka, IND
5000 Employees

Similar Companies Hiring

Blee Thumbnail
Artificial Intelligence • Marketing Tech • Software
New York, New York
33 Employees
Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
65 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account