Data Engineer

EMCOR Mechanical Services (EMS) companies provide mechanical automation and energy solutions as well as a range of other professional services. From healthcare and education to technology transportation retail government and more EMS companies operate in a wide array of environments.

EMCOR Mechanical Services has an opportunity for a Data Engineer in Irvine CA. The Data Engineer is responsible for designing building and maintaining scalable data pipelines and infrastructure to support analytics reporting and data-driven decision-making. This role is an individual contributor with specific oversight of projects and process. This individual will interact with members of Finance Management IT QA BA teams and various business stakeholders.

#EMS!

#LI-NS1

• Develop and maintain ETL (Extract Transform Load) processes for data ingestion and transformation.
• Design and optimize data models for structured and unstructured data.
• Implement and manage data storage solutions (e.g. relational databases data lakes).
• Ensure data quality integrity and security across systems.
• Collaborate with data analysts and business stakeholders to understand data requirements.
• Monitor and improve performance of data pipelines and workflows.
• Automate data processes and implement best practices for data engineering.

• Bachelors degree in Computer Sciences/Engineering associated discipline or equivalent technical experience.
• Minimum of 5 plus years of experience of hands-on application development or data engineering experience.
• Expertise in SQL and Python as well as strong working knowledge with various Microsoft Fabric Components including OneLake Data Factory Data Engineering Data Warehousing Data Science Real-time Analytics and Power BI (BI/Visualization).
• Experience in Construction or Mechanical Services industry preferred.
• Proficiency in SQL and programming languages (Python Java or Scala).
• Experience with ETL tools and cloud platforms (AWS Azure GCP).
• Knowledge of data warehousing concepts and tools.
• Familiarity with workflow orchestration tools (Airflow Luigi).
• Strong understanding of data governance and security principles.

Ability to work in an office environment using laptop cell phone and office phones.

This position works in a typical office environment.

Please review our Affirmative Action Policy.

Compensation Range: $115000 - $145000 annual salary

Other Compensation: Eligible for discretionary Bonus

Benefits: We arecommitted to providing employees a comprehensive benefits package which includes medical dental and vision coverage along with health savings and flexible spending accounts life insurance disability a 401(k) Savings Plan College Coach and employee assistance program.