Senior Data Engineer; Azure & Databricks

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

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.

• 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…