Data Engineer

Bentley Systems is seeking a Data Engineer to join our Consumption Operations team and help architect the data foundation that powers our consumption-based business model.

This role is centered on Bentley's modern cloud data platform, with Snowflake and dbt serving as core technologies for data transformation, modeling, governance, and analytics delivery. The ideal candidate has hands-on experience designing scalable ELT pipelines, building dimensional data models, and ensuring the quality and reliability of enterprise data assets.

Success in this role means engineering robust, highly optimized data pipelines that support accurate and timely usage billing, trusted business reporting, and data-driven decision-making across the organization. You will work closely with stakeholders across Finance, Operations, Product, and Engineering to deliver reliable, scalable, and well-governed data solutions., * Design, build, and optimize scalable ELT/ETL pipelines to ingest, process, and transform large volumes of structured and unstructured data.

• Develop and maintain reusable data transformation frameworks using dbt and SQL-based modeling best practices.
• Build and optimize Snowflake-based data models that support analytics, reporting, and operational use cases.

Data Integration

• Architect and maintain integrations across internal and external data sources including databases, APIs, business applications, and third-party platforms.
• Leverage tools such as Fivetran and custom ingestion frameworks to support scalable, reliable data movement., * Champion data integrity, accuracy, and reliability through automated testing, validation, and monitoring frameworks.
• Implement rigorous data quality controls within dbt and Snowflake environments.
• Ensure compliance with applicable financial controls and regulatory requirements, including SOX compliance.

Snowflake Platform Ownership

• Design, maintain, and optimize Snowflake objects including schemas, tables, views, tasks, and data-sharing capabilities.
• Monitor and optimize Snowflake performance, storage utilization, and compute costs.
• Implement dimensional models, semantic layers, and analytics-ready datasets that support business stakeholders.

Infrastructure Management

• Monitor system performance, troubleshoot bottlenecks, and continuously optimize the data platform for scalability, speed, reliability, and cost efficiency.
• Support orchestration, scheduling, and pipeline observability across the data ecosystem.

Cross-Functional Collaboration

• Partner closely with business analysts, finance teams, data consumers, and leadership to gather requirements and deliver trusted datasets.
• Translate business needs into scalable technical solutions and data models.

Continuous Innovation

• Maintain comprehensive documentation for data models, pipelines, and architecture decisions.
• Stay current with evolving Snowflake and dbt capabilities and drive adoption of industry best practices.

• Bachelor's degree in Computer Science, Engineering, Mathematics, or related field, or equivalent practical experience.
• 3+ years of experience as a Data Engineer or closely related data platform role.
• Advanced proficiency with SQL and Python.
• 2+ years of hands-on experience building and maintaining production workloads in Snowflake.
• 2+ years of hands-on experience developing, testing, and deploying dbt models in production environments.
• Experience building dimensional models, star schemas, and analytics-ready datasets.
• Experience designing and maintaining ELT/ETL pipelines and modern cloud data platforms.
• Experience implementing data quality, data validation, and monitoring frameworks.
• Strong problem-solving skills and attention to detail.
• Ability to work independently and collaboratively within a distributed team environment.

Preferred Qualifications

• Experience with Fivetran and modern ingestion frameworks.
• Experience with SQL Server and enterprise data warehouse environments.
• Experience with Airflow or similar orchestration platforms.
• Experience supporting financial, billing, revenue, usage, or consumption-based data models.
• Experience operating in SOX-regulated environments.
• Experience optimizing Snowflake performance and managing compute/storage costs.
• SnowPro and/or dbt certifications.

• A great Team and culture - please see our colleague video.
• An exciting career as an integral part of a world-leading software company providing solutions for architecture, engineering, and construction - watch this short documentary about how we got our start.
• An attractive salary and benefits package.
• A commitment to inclusion, belonging, and colleague well-being through global initiatives and resource groups.
• A company committed to making a real difference by advancing the world's infrastructure for a better quality of life, where your contributions help build a more sustainable, connected, and resilient world. Discover our latest user success stories for an insight into our global impact.

Around the world, infrastructure professionals rely on software from Bentley Systems to help them design, build, and operate better and more resilient infrastructure for transportation, water, energy, cities, and more. Founded in 1984 by engineers for engineers, Bentley is the partner of choice for engineering firms and owner-operators worldwide, with software that spans engineering disciplines, industry sectors, and all phases of the infrastructure lifecycle. Through our digital twin solutions, we help infrastructure professionals unlock the value of their data to transform project delivery and asset performance. www.bentley.com