Lead Data Engineer - Tax Product Development

BDO USA provides assurance, tax, and advisory services to clients across the U.S. and around the world. The Lead Data Engineer, Tax Product Development, develops and supports tax data warehouses, data lakes, ingestion and ETL processes, Power BI, and enterprise applications. The role leads data pipeline and product development, collaborates with analytics and cross-functional teams, mentors engineers, and supports data quality, security, integrity, and scalability.

Responsibilities:

• Owns 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
• Applies modern software engineering principles throughout the software lifecycle for data-related applications, including ETL/ELT processes and database systems
• Reviews business requirements for technical feasibility, and collaborates with various teams, including internal developers and external peers, to deliver quality data integration solutions
• 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 product roadmaps, production support processes, and compliance with IT, security, and business mandates, ensuring data consistency, integrity, and scalability
• Effectively communicates with stakeholders and cross functional teams such as technical architects and security teams and others
• Other duties as required
• Acts as a direct supervisor to team members, as assigned
• Acts as a career advisor, as assigned

Requirements:

• Bachelor's degree required
• Six (6) or more years of experience in a data engineer or related role, required
• One or more programming languages such as Python, Java, C#, C++, or Scala, with a focus on data engineering applications, required
• Ability to work well in hybrid and remote environments
• Solid verbal and written communication skills
• Strong interpersonal and customer relationship skills, including training/instruction with professionals at all levels
• Sound decision-making skills
• Ability to work in a deadline-driven environment while handling multiple complex projects/tasks simultaneously with a focus on details
• Capable of successfully multi-tasking while working independently or within a group environment
• Ability to rely on extensive experience and judgment to plan and accomplish goals
• Capable of working well under pressure while dealing with unexpected problems in a professional manner
• Ability to communicate and interact with all levels of employees and management
• focus in Computer Science, Technology, Engineering, Mathematics (STEM), Finance, or Accounting, preferred
• Hands-on experience architecting, building, and optimizing large-scale relational (e.g., SQL Server, PostgreSQL, Oracle) and non-relational (e.g., CosmosDB, MongoDB, Cassandra, DynamoDB) databases to support both OLTP and OLAP workloads, preferred
• Experience writing and optimizing complex queries, stored procedures, functions, and triggers using SQL and comparable languages for high-volume transactional systems and analytical platforms, preferred
• Data Definition Language (DDL) and Data Manipulation Language (DML), with experience developing and maintaining database objects (tables, views, indexes, partitions) at scale, preferred
• Experience with data modeling principles, including normalization, denormalization, star and snowflake schema design, and semantic layer construction for enterprise data warehouses and data lakes, preferred
• Experience with design and implement ETL/ELT pipelines using modern data engineering frameworks and tools (e.g., Apache Spark, Databricks, Airflow, Talend, Informatica), preferred
• Experience implementing data governance, data quality, and data security best practices in large, distributed environments, preferred
• Tax experience, preferred
• Public accounting experience, preferred
• Microsoft Azure Data Engineer, preferred
• Experience with the following products, preferred:
• Microsoft Office Suite
• Microsoft Azure DevOps or GitHub
• Microsoft SQL Server and/or Azure SQL DB