Job Description

The Lead Data Engineer, Tax Product Development, works with the Data Engineering and Integration team to develop and support BDO’s Tax Data Warehouse and Tax Data Lake, manage and maintain data ingestion and Extract/Transform/Load (ETL) processes, as well as provide support for the Power BI business intelligence platform and enterprise applications supporting the tax practice.

The Lead Data Engineer builds and maintains tax data pipelines to support ad-hoc analytics and business intelligence applications as well as identify valuable development opportunities and ideas for improvement. This role collaborates closely with the data analytics teams to design, develop, and deploy new solutions that support strategic business priorities.

Job Duties:

• 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

Supervisory Responsibilities:

• Acts as a direct supervisor to team members, as assigned
• Acts as a career advisor, as assigned

Qualifications, Knowledge, Skills, and Abilities:

Education:

• Bachelor's degree required; focus in Computer Science, Technology, Engineering, Mathematics (STEM), Finance, or Accounting, preferred

Experience:

• Six (6) or more years of experience in a data engineer or related role, required
• 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

License/Certifications:

• Microsoft Azure Data Engineer, preferred

Software:

• One or more programming languages such as Python, Java, C#, C++, or Scala, with a focus on data engineering applications, required
• Experience with the following products, preferred:
  • Microsoft Office Suite
  • Microsoft Azure DevOps or GitHub
  • Microsoft SQL Server and/or Azure SQL DB

Other Knowledge, Skills, & Abilities:

• 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

Individual salaries that are offered to a candidate are determined after consideration of numerous factors including but not limited to the candidate’s qualifications, experience, skills, and geography.

National Range: $140,000 - $210,000
Maryland Range: $140,000 - $210,000
NYC/Long Island/Westchester Range: $140,000 - $210,000

Join us at BDO, where you will find more than a career, you’ll find a place where your work is impactful, and you are valued for your individuality. We offer flexibility and opportunities for advancement. Our culture is centered around making meaningful connections, approaching interactions with curiosity, and being true to yourself, all while making a positive difference in the world.

At BDO, our purpose of helping people thrive every day is at the heart of everything we do. Together, we are focused on delivering exceptional and sustainable outcomes and value for our people, our clients, and our communities. BDO is proud to be an ESOP company, reflecting a culture that puts people first, by sharing financially in our growth in value with our U.S. team. BDO professionals provide assurance, tax and advisory services for a diverse range of clients across the U.S. and in over 160 countries through our global organization.

BDO is the first large accounting and advisory organization to implement an Employee Stock Ownership Plan (ESOP). A qualified retirement plan, the ESOP offers participants a stake in the firm’s success through beneficial ownership and a unique opportunity to enhance their financial well-being. The ESOP stands as a compelling addition to our comprehensive compensation and Total Rewards benefits* offerings. The annual allocation to the ESOP is fully funded by BDO through investments in company stock and grants employees the chance to grow their wealth over time as their shares vest and grow in value with the firm’s success, with no employee contributions.

We are committed to delivering exceptional experiences to middle market leaders by sharing insight-driven perspectives, helping companies take business as usual to better than usual. With industry knowledge and experience, a breadth and depth of resources, and unwavering commitment to quality, we pride ourselves on:

• Welcoming diverse perspectives and understanding the experience of our professionals and clients
• Empowering team members to explore their full potential
• Our talented team who brings varying skills, knowledge and experience to proactively help our clients navigate an expanding array of complex challenges and opportunities
• Celebrating ingenuity and innovation to transform our business and help our clients transform theirs
• Focus on resilience and sustainability to positively impact our people, clients, and communities
• BDO Total Rewards that encompass so much more than traditional “benefits.” Click here to find out more!

*Benefits may be subject to eligibility requirements.

Equal Opportunity Employer, including disability/vets

Click here to find out more!