Senior Data Engineer (Azure & Databricks)

Socotec; New York (NY); Hybrid; USD 140,000 - 190,000; Full time

Job summary

SOCOTEC in the United States is seeking a Senior Data Engineer to design and build scalable data systems powering our enterprise analytics and digital platforms. You will help architect the modern data stack, enabling reliable ingestion, transformation, and modeling across ERP, CRM, and operational databases.

The role requires hands-on experience with Databricks, Apache Spark, and Delta Lake, plus the ability to lead large data initiatives and collaborate with engineering and business teams.

Qualifications

• 7-10 years hands-on experience with Databricks
• Experience designing and owning large enterprise data projects
• Strong SQL and Python skills

Responsibilities

• Build SOCOTEC's Enterprise Data Platform
• Design and implement scalable data pipelines ingesting data from ERP, CRM, and databases
• Develop and maintain data models for analytics, AI, and operations
• Architect and implement MDM platforms using Databricks
• Design data models for golden records across systems
• Implement data governance, lineage, and quality frameworks
• Build ingestion pipelines for large-scale structured and semi-structured data
• Implement batch and near-real-time data processing pipelines
• Optimize large-scale data processing for performance and cost efficiency
• Partner with AI teams to deliver high-quality datasets for ML/AI applications
• Support data architecture standards, monitoring, and security across the platform
• Define data modeling, pipeline design, and data quality standards

Skills

Databricks

Spark

Python

SQL

Data modeling

Distributed systems

Tools

Databricks

Apache Spark

Delta Lake

Job description

• Full-time
• Department: US - Corporate IT

Company Description

SOCOTEC is a provider of niche consulting services within the architecture, engineering and construction industries focusing on high-performance buildings and specialty structures. Through an integrated, holistic approach, our professionals provide solutions for building envelope, energy efficiency, sustainability, code advisory and construction advisory projects

SOCOTEC's combination of expertise, experience and methods are increasingly recognized as best-in-class fueling significant growth.

SOCOTEC is proud to announce that it has been officially certified as a Great Place to Work by the renowned global authority on workplace culture, Great Place to Work.

Job Description

As a Senior Data Engineer, you will design and build scalable data systems that power SOCOTEC's digital platforms and enterprise analytics. You will play a key role in architecting our modern data stack, enabling reliable ingestion, transformation, and modeling of data across multiple enterprise systems.

This role requires strong experience in Databricks, distributed data processing, and enterprise data architecture, along with the ability to lead large data initiatives and collaborate with engineering and business teams.

You will work closely with software engineers and platform teams to ensure SOCOTEC's data ecosystem is reliable, scalable, and optimized for both operational systems and advanced analytics.

Key Responsibilities
Build SOCOTEC's Enterprise Data Platform

• Design and implement scalable data pipelines that ingest and transform data from enterprise systems such as ERP, CRM, and operational databases.
• Develop and maintain data pipelines in Databricks using Spark and Delta Lake.
• Build and maintain data models that support analytics, AI applications, and operational systems.

Lead Master Data Management (MDM) Initiatives

• Architect and implement SOCOTEC's custom MDM platform using Databricks.
• Design data models that establish consistent "golden records" across multiple enterprise systems.
• Implement data governance, lineage, and quality frameworks.
• Build reliable ingestion pipelines for large-scale structured and semi-structured data.
• Implement batch and near-real-time data processing pipelines.
• Optimize large-scale data processing jobs for performance and cost efficiency.

Enable Data for AI and Advanced Analytics

• Partner with AI and software engineering teams to deliver high-quality datasets for machine learning and AI applications.
• Build data pipelines that support SOCOTEC's digital products, analytics dashboards, and operational platforms.

Drive Data Architecture and Best Practices

• Define standards for data modeling, pipeline design, and data quality.
• Implement monitoring, observability, and alerting data systems.
• Ensure scalability, reliability, and security across the data platform.

Qualifications

• 7-10 years with hands on experience with Databricks
• Experience designing and owning large enterprise data projects
• Strong hands-on experience with Databricks, Apache Spark, and Delta Lake
• Experience building enterprise-scale ETL/ELT pipelines
• Experience working in enterprise environments with complex data systems
• Strong SQL and Python skills

Preferred Experience

• Experience building Master Data Management (MDM) systems
• Experience with modern cloud data stacks (AWS, Azure, or GCP)
• Experience integrating data from ERP systems such as Deltek, SAP, or Oracle
• Experience with data governance, data lineage, and metadata management
• Familiarity with lakehouse architectures and modern data platforms

Technical Skills

• Databricks
• Python
• SQL
• Data modeling
• Data architecture and distributed systems

We are looking for someone who:

• Has owned and delivered large-scale data platforms
• Is comfortable working in complex enterprise environments
• Can design systems that scale across multiple business units and data sources
• Is passionate about building reliable data infrastructure that enables analytics and AI

This role requires both deep technical expertise and architectural thinking, as you will play a key role in shaping SOCOTEC's long-term data strategy.

Why Join SOCOTEC Digital Assurance

You will be joining a growing technology group building advanced platforms for the built environment, including:

• AI-powered compliance systems
• Enterprise analytics platforms

Our goal is to transform how data and expertise flow across the built environment, enabling smarter decisions, faster compliance, and more efficient infrastructure.

If you are passionate about building modern data platforms and solving complex data challenges at scale, we'd love to hear from you.

Additional Information

Additional information

For more information, please visit www.socotec.us

Job Type: Full-Time, 4 days a week in office with one hybrid/ remote day

Applicants must be legally authorized to work in the United States without the need for current or future employer sponsorship.

All your information will be kept confidential according to EEO guidelines.

SOCOTEC is an Equal Opportunity Employer.