IT Lead Data Engineer

Job Description The Lead Data Engineer is expected to be an expert at effectively working with business partners to understand their data needs and develop technical designs and requirements to meet those needs. This role is the team leader in helping extract, transform, and store the Firm’s valuable data assets to achieve better operational efficiencies and provide better services to its clients through modern data movement pipelines. This role, in collaboration with other data engineers, data architects, and other IT teams, will operationalize and document data extraction and ingestion platforms. This role is the team’s leader for developing strategies, policies, and governance models to ensure the Firm’s data remains accurate, timely and relevant to the Firm’s goals. This role will provide guidance and mentorship to junior data engineers, as well as helping delegate work items and tickets across the Data Engineering team. Job Summary The Lead Data Engineer is expected to be an expert at effectively working with business partners to understand their data needs and develop technical designs and requirements to meet those needs. This role is the team leader in helping extract, transform, and store the Firm’s valuable data assets to achieve better operational efficiencies and provide better services to its clients through modern data movement pipelines. This role, in collaboration with other data engineers, data architects, and other IT teams, will operationalize and document data extraction and ingestion platforms. This role is the team’s leader for developing strategies, policies, and governance models to ensure the Firm’s data remains accurate, timely and relevant to the Firm’s goals. This role will provide guidance and mentorship to junior data engineers, as well as helping delegate work items and tickets across the Data Engineering team. Job Duties Works with stakeholders and data architects to define and design data solutions to support the Firm’s data initiatives Understands and locates where data assets exist within the Firm’s systems and design solutions integrating disparate data sources to solve problems and provide business value Collaborates with project managers to provide effort estimates and provides technical leadership in solution design and requirements Works closely with data governance to ensure principles are followed through the course of day-to-day data usage and solution design Prepares mock-up solution designs, visualizations and reports to effectively demonstrate proposed solutions and deliverables Acts as a subject matter expert, evangelist and catalyst to educate on the Firm’s data platforms and best practices as they relate to the usage and hygiene of the Firm’s data assets Meets regularly with business line customers to gain a better understanding of their business processes and of the customer's evolving data needs to help identify potential data-related projects Works with data scientists and developers to use emerging and advanced technologies such as artificial intelligence and machine learning to identify and extrapolate hidden patterns and trends, increasing the value of the Firm’s data Builds and maintains constructive working relationships with project team members, vendors and other departments involved with projects, systems, and IT strategies Serves as a technical expert and lead to other team members, reviewing proposed solution designs, conducting code reviews, and troubleshooting advanced technical issues Identifies and executes continuous improvement efforts to ensure the Firm’s data remains accurate and timely Works closely with the Information Security and Compliance teams to ensure the firm’s data strategy and technologies meet or exceed both internal policies and external regulatory requirements Collaborates with BDO Global and other BDO member firms to ensure standards between organizations are followed in support of reusable models and rapid deployment of shared technology Understands and follows Project Management basics and Project Management Office policies and procedures Other duties as required Supervisory Responsibilities N/A Education High School Diploma or GED, required Bachelor’s Degree in Computer Science, Information Management, Mathematics, or Statistics, preferred Qualifications, Knowledge, Skills, and Abilities High School Diploma or GED, required Bachelor’s Degree in Computer Science, Information Management, Mathematics, or Statistics, preferred Experience Eight (8) or more years working as a data engineer, data analyst or similar analyst/engineer roles, required Eight (8) or more years working with PowerBI, Tableau or similar data visualization products, required Five (5) or more years working within commercial cloud platforms such as Microsoft Azure, AWS, or GCP, required Three (3) or more years using version control tools (Azure DevOps, GitHub), required Demonstrable proficiency in developing and understanding custom and ad-hoc SQL queries, required Experience working within a large, complex enterprise with significant regulatory and compliance requirements, preferred Experience using a modern scripting language such as Python, Scala, R, or Java, preferred Professional service firm experience, preferred Software Strong proficiency in the use of Microsoft Office suite, specifically Excel, required Strong proficiency in the use of SQL Server Management Studio (SSMS), or similar, required Strong proficiency in the use of PowerBI, Tableau, Looker, Qlik, or similar, required Other Knowledge, Skills & Abilities Strong analytical, organizational and problem-solving skills Excellent written communication skills, maintaining accurate documentation and technical authorship of complex documents Ability to facilitate meetings efficiently and effectively Ability to follow an issue through to its logical conclusion, and elevate as necessary Ability to work independently as well as part of a team, including providing technical leadership to less experienced colleagues Excellent interpersonal and customer relationship skills Capable of working in a deadline-driven environment, while handling multiple complex projects/tasks simultaneously with a focus on details Capable of working well under pressure while dealing with unexpected issues in a professional manner Ability to work after hours and weekends as needed Capacity to travel as needed 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: $138,000 - $170,000 Maryland Range: $138,000 - $170,000 NYC/Long Island/Westchester Range: $138,000 - $170,000 About Us At BDO, how we show up matters. We build strong relationships by supporting one another, our clients, and our communities with care, curiosity, and a commitment to helping one another grow and succeed. Here, you’ll find meaningful work, leaders invested in your success, and opportunities to build a career around what matters most to you. Our purpose is to be the people our clients count on to grow with confidence and achieve what matters most. Our values guide how we bring that purpose to life each day. Together, they shape how we work with one another, serve our clients, and create meaningful impact. BDO provides assurance, tax, and advisory services to clients across the U.S. and around the world. No matter your role, you’ll be part of a team helping clients navigate complexity and move forward with clarity. We are proud to be an ESOP company, offering participants a stake in the firm’s success through beneficial ownership and a unique opportunity to enhance their financial well-being. As a qualified retirement plan, the ESOP is a meaningful addition to our comprehensive compensation and Total Rewards benefits* offerings. It also reinforces an ownership mindset that strengthens our connection to one another, our clients, and the future we’re building together. Learn more about our benefits: BDO Total Rewards encompass more than traditional benefits. Click here to find out more ! Benefits may be subject to eligibility requirements. Equal Opportunity Employer, including disability/vets All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status. "BDO USA, P.A. is an EO employer M/F/Veteran/Disability" #J-18808-Ljbffr BDO USA