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. The role focuses on designing scalable data pipelines and ensuring the quality and reliability of enterprise data assets to support data-driven decision-making across the organization.

Responsibilities:

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

Requirements:

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