IT Lead Data Engineer

BDO USA is a leading accounting and advisory firm that values individuality and impactful work. They are seeking a Lead Data Engineer who will collaborate with business partners to understand data needs and develop solutions, while also leading the data engineering team in operationalizing data extraction and ingestion platforms.

Responsibilities:

• 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

Requirements:

• High School Diploma or GED
• Eight (8) or more years working as a data engineer, data analyst or similar analyst/engineer roles
• Eight (8) or more years working with PowerBI, Tableau or similar data visualization products
• Five (5) or more years working within commercial cloud platforms such as Microsoft Azure, AWS, or GCP
• Three (3) or more years using version control tools (Azure DevOps, GitHub)
• Demonstrable proficiency in developing and understanding custom and ad-hoc SQL queries
• Strong proficiency in the use of Microsoft Office suite, specifically Excel
• Strong proficiency in the use of SQL Server Management Studio (SSMS), or similar
• Strong proficiency in the use of PowerBI, Tableau, Looker, Qlik, or similar
• Bachelor's Degree in Computer Science, Information Management, Mathematics, or Statistics
• Experience working within a large, complex enterprise with significant regulatory and compliance requirements
• Experience using a modern scripting language such as Python, Scala, R, or Java
• Professional service firm experience