Data Engineer

Date: Jul 12, 2024

Location: Exton, PA, US

Company: Bentley Systems

Data Engineer

 

Location: This position can be located from a home-based office in the US in Eastern or Central time zone

 

Bentley Systems is hiring a Data Engineer for our Data group with experience across the entire Cloud Data stack. The ideal candidate will have experience in data pipelines (ELT/ETL), data warehousing and dimensional modeling, and curation of data sets for Data Scientists and Business Intelligence users. This candidate will also have excellent problem-solving ability dealing with large volumes of data.

  

Responsibilities

  • Build scalable Cloud data solutions using MPP Data Warehouses (Snowflake and/or Azure Data Warehouse/Synapse), data storage (Azure Blob Storage)
  • Create and maintain data pipelines and transformations (ELT – Matillion, ADF)
  • Write complex SQL queries, stored procedures, etc.
  • Create data integrations with scripting languages such as Python a plus
  • Design data models for the data warehouse.
  • Work as part of the Data Office - Architecture and Engineering team to support the organization's data management and engineering needs.
  • Work closely with business stakeholders to ensure we communicate and meet expectations and requirements.
  • Act as the Data lead to provide project estimates and status updates to the wider team.

 

Required Skills

  • Bachelor’s degree, or equivalent experience, in Computer Science, Engineering, Mathematics or a related field. Commensurate work experience will be considered in lieu of degree
  • Experience building scalable Cloud data solutions using MPP Data Warehouses (Snowflake, Redshift, or Azure Data Warehouse/Synapse), data storage (S3 or Azure Blob Storage) and analytics platforms (i.e. Spark, Databricks, etc.)
  • 2+ years with complex SQL queries and scripting
  • 1+ years' experience with Azure and Snowflake
  • 2+ years developing, and deploying scalable enterprise data solutions (Enterprise Data Warehouses, Data Marts, ETL/ELT pipelines, etc.)
  • 2+ years of supporting business intelligence and analytic projects
  • Excellent written and oral communication skills

 

Desired Skills

  • Familiarity with Power BI
  • Analytics platforms a plus (i.e. Spark, Databricks, etc.)
  • Scripting languages such as Python a plus
  • Good understanding of code repositories such as GIT a plus

 

What We Offer:

 

  • A great Team and culture – please see our Recruitment Video.
  • An exciting career as an integral part of a world-leading software company providing solutions for architecture, engineering, and construction.
  • Competitive Salary and benefits.
  • The opportunity to work within a global and diversely international team.
  • A supportive and collaborative environment.
  • Colleague Recognition Awards.


#LI-Remote #LI-RV

About Bentley Systems

Bentley Systems (Nasdaq: BSY) is the infrastructure engineering software company. We provide innovative software to advance the world’s infrastructure – sustaining both the global economy and environment. Our industry-leading software solutions are used by professionals, and organizations of every size, for the design, construction, and operations of roads and bridges, rail and transit, water and wastewater, public works and utilities, buildings and campuses, mining, and industrial facilities. Our offerings, powered by the iTwin Platform for infrastructure digital twins, include MicroStation and Bentley Open applications for modeling and simulation, Seequent’s software for geoprofessionals, and Bentley Infrastructure Cloud encompassing ProjectWise for project delivery, SYNCHRO for construction management, and AssetWise for asset operations. Bentley Systems’ 5,200 colleagues generate annual revenues of more than $1 billion in 194 countries.
www.bentley.com

Equal Opportunity Employer:

 

Bentley is an equal opportunity employer and considers all qualified applicants for employment without regard to race, color, sex, sexual orientation, gender identity, disability, pregnancy, protected veteran status, religion, national origin, age, genetic information or any other protected characteristic.  This commitment extends to all aspects of employment, including, but not limited to, hiring, placement, promotion, compensation, and training. Know Your Rights as an applicant under the law.

 

Bentley Policy on EEO, Affirmative Action and Pay Transparency Non-Discrimination

Bentley participates in e-Verify / Bentley participate in e-Verify / Right to Work Notice

 

Links:

Know your rights: https://www.dol.gov/agencies/ofccp/posters

EEO Policy: https://www.bentley.com/wp-content/uploads/Bentley-EEOAA-Statement-of-Policy.pdf

E-Verify Participation poster: https://www.bentley.com/wp-content/uploads/E-Verify-Poster.pdf


Nearest Major Market: Philadelphia

Job Segment: Construction, Wastewater, Water Treatment, Engineer, Data Management, Engineering, Data