IT Data Engineer IV is expected to use their strong business acumen skills to effectively work with business partners to understand their data needs and develop technical designs and requirements to meet those needs. This role takes the lead in helping 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 provides leadership in 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
- 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 line of business customers to gain a better understanding of their business processes and of the customers evolving data needs in order to 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 leader to other team members, reviewing proposed solution designs, conducting code reviews, and troubleshooting advanced technical issues
- Ensures data governance 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
Education
Bachelor s Degree in Computer Science, Information Management, Mathematics, or Statistics, preferredExperience
Five (5) or more years working as a data engineer, data analyst or in similar analyst roles, requiredFive (5) or more years working with PowerBI, Tableau or similar data visualization products, requiredDemonstrable proficiency in developing and understanding custom and ad-hoc SQL queries, requiredFive (5) or more years working within commercial cloud platforms such as Microsoft Azure, AWS, or GCP, preferredExperience working within a large, complex enterprise with significant regulatory and compliance requirements, preferredExperience using version control tools (Azure DevOps, GitHub), preferredExperience using a modern scripting language such as Python, Scala, R, or Java, preferredProfessional service firm experience, preferredSoftware
Strong proficiency in the use of Microsoft Office suite, specifically Excel, requiredStrong proficiency in the use of SQL Server Management Studio (SSMS), or similar, requiredStrong proficiency in the use of PowerBI, Tableau, Looker, Qlik, or similar, requiredOther Knowledge, Skills & Abilities
Strong analytical, organizational, and problem-solving skillsExcellent written communication skills, maintaining accurate documentation and technical authorship of complex documentsAbility to facilitate meetings efficiently and effectivelyAbility to follow an issue through to its logical conclusion, and escalate as necessaryAbility to work independently as well as part of a team, including providing technical leadership to less experienced colleaguesExcellent interpersonal and customer relationship skillsAbility to work in a deadline-driven environment, while handling multiple complex projects / tasks simultaneously with a focus on detailsAbility to work well under pressure while dealing with unexpected issues in a professional mannerAbility to work after hours and weekends as neededAbility to travel as neededEducation
UG : Any Graduate
PG : Any Postgraduate
Skills Required
Data Extraction, Data Analytics, Sql, Python, Machine Learning, Project Management