Data Engineer - L3

Job Description

Job Description Job Summary Data Engineer II is expected to use their business acumen to effectively work with business partners to understand their data needs and develop technical designs and requirements to meet those needs. This role works to help extract, transform, and store the Firm s valuable data assets to achieve better operational efficiencies and provide better services to its users 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 responsible for supporting technologies for the benefit of the Firm. Job Duties Works closely with stakeholders and other data engineering team members to define, design, and implement data solutions to support the Firm s data initiatives Designs and builds pipelines using no-code/low-code cloud technology for extracting, transforming, and loading data from a wide range of source systems file types into various data stores Use PowerBI to create source of truth datasets used across operational dashboards, enabling end-users without direct access to source systems to consume and build reports for their areas of expertise 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 Documents metadata and maintains the Firm s metadata catalog and data dictionaries Ensures master data management principles are followed through the course of day-to-day data usage and solution design 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 Qualifications, Knowledge, Skills and Abilities Education Bachelor s Degree in Computer Science, Information Management, Mathematics, or Statistics, preferred Experience One (1) or more years working as a data engineer, data analyst or similar analyst roles, required One (1) or more years working with PowerBI, Tableau or similar data visualization products, required Demonstrable proficiency in developing and understanding custom and ad-hoc SQL queries, required One (1) or more years working within commercial cloud platforms such as Microsoft Azure, AWS, or GCP, preferred Experience working within a large, complex enterprise with significant regulatory and compliance requirements, preferred Experience using version control tools (Azure DevOps, GitHub), preferred Experience using a modern scripting language such as Python, Scala, R, or Java, preferred Professional service firm experience, preferred License(s)/Certification(s) N/A 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 Language(s) English, 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 escalate 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