Senior Data Engineer (Azure & Databricks) New York

SOCOTEC, Inc.; New York (NY); Hybrid; USD 120,000 - 190,000; Full time

Benefits offered by this job

Great Place to Work

Job summary

SOCOTEC, Inc. is seeking a Senior Data Engineer to design and build scalable data systems powering its digital platforms and enterprise analytics. You will help architect the modern data stack, enabling reliable ingestion, transformation, and modeling across enterprise systems.

You will lead data initiatives, work with engineering and business teams, and ensure the data ecosystem is reliable, scalable, and optimized for analytics and AI across SOCOTEC's platforms.

Qualifications

• 7-10 years hands-on Databricks experience.
• Experience owning large enterprise data projects.
• Strong SQL and Python skills.
• Experience in enterprise environments with complex data systems.
• Experience building ETL/ELT pipelines.
• Experience with Master Data Management (MDM) systems.

Responsibilities

• Design and implement scalable data pipelines from enterprise systems (ERP, CRM) to analytics.
• Develop and maintain data pipelines in Databricks using Spark and Delta Lake.
• Build and maintain data models that support analytics and AI applications.

Skills

Databricks

Python

SQL

Data modeling

Data architecture

Distributed systems

Tools

Delta Lake

Databricks

Cloud platforms (AWS/Azure/GCP)

Job 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.