Lead Data Engineer, Tax Data & Analytics Platform

BDO USA, LLP; City of Rochester (NY); Hybrid; USD 120,000 - 160,000; Full time

Job summary

BDO USA, LLP seeks a Lead Data Engineer in Tax Product Development to build and maintain data warehouses and data lakes, manage ETL/ELT processes, and support Power BI analytics across the tax practice.

The role leads end-to-end data features, designs complex pipelines, mentors engineers, and collaborates with architects and security teams to ensure data quality, governance, and scalability.

Qualifications

• Bachelor's degree required in STEM, Finance, or Accounting.
• Six+ years of data engineering experience.
• Experience with OLTP/OLAP databases.
• Experience with data governance and security best practices.

Responsibilities

• Own end-to-end delivery of large features and systems, defining technical requirements and architecture for data processing and integration solutions.
• Leads design and implementation of major data structures and pipelines within an Agile team focused on data engineering solutions.
• Designs, develops, and tests data products, pipelines, and solutions using web and cloud technologies for innovative data processing and analytics.
• Mentors junior engineers to enhance code quality and ensure compliance with standards in data pipeline and analytics platform development.
• Maintains data products and platforms based on roadmaps, production support processes, and IT/security compliance.

Skills

Python

SQL

Data modeling

ETL/ELT

Education

Bachelor's degree in STEM, Finance, or Accounting

Tools

SQL Server

PostgreSQL

CosmosDB

Airflow

Job description

BDO USA, LLP seeks a Lead Data Engineer in Tax Product Development to build and maintain data warehouses and data lakes, manage ETL/ELT processes, and support Power BI analytics across the tax practice.

The role leads end-to-end data features, designs complex pipelines, mentors engineers, and collaborates with architects and security teams to ensure data quality, governance, and scalability.