Senior Data Engineer -Tax Product Development - Bangalore/ Hyderabad

BDO RISE -Senior Data Engineer I - Bangalore/ Hyderabad

The Senior Data Engineer I, Tax Product Development, works with the Data Engineering and Integration team to develop and support BDOs 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.

You will be responsible for implementing and participate in delivery of Data related engagements, including Data modeling, Data cleansing, Data enrichments and Analytical solutions to our clients. Your experience will be instrumental in optimizing data processes, ensuring data quality, and driving data-driven decision-making within the organization.

Job Duties

• Reviewing and understanding complex data sets to establish data quality and highlighting where data cleansing is required to remediate the data
• Translating business requirements into data models with proper data dictionary to manage data within the organization, using sound technical expertise
• Support in Data migrations, data cleansing and data enrichment engagements
• Designing and implementing end-to-end reporting solutions, KPIs, from data integration to visualization and ready to use product that provides business with valuable insights
• Migrating data from one system to another using multiple sources, identifying and implementing storage requirements
• Resolving escalated design and implementation issues with limited complexity
• Monitoring and reporting on the uses of emerging technologies, and seeking areas for continuous improvement
• Ensuring all activities adhere to the relevant data visualization and data modelling processes, procedures and standards

Qualifications, Knowledge, Skills, and Abilities:

Education:

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

Experience:

• Four (4) or more years of experience in SQL, including complex queries, optimization, and performance tuning, with advanced expertise in Python for data manipulation, analysis, and automation tasks, required
• Four (4) or more years of experience in Data Definition Language (DDL), Data Manipulation Language (DML), and developing views, functions, and stored procedures, required
• Four (4) or more years of experience in Data Warehousing, Data Modeling, Semantic Model Definition, and Star Schema Construction, required
• Four (4) or more years of experience in one or more programming languages such as Java, C#, C++, or Scala, with a focus on data engineering applications, required
• Data Visualization Power BI, Tableau, SQL Server Reporting Services
• Data Access Tools – MS SQL Server Management Studio,
• ETL / ELT / Data Fabric Tools – Power BI Dataflows, Power Query M, Alteryx, SQL Server Integration Services, Power BI Composite Models
• Design, develop, and maintain data pipelines using Azure services such as Azure Data Factory, Azure Databricks, and Azure Synapse Analytics
• Programming Languages – SQL, T-SQL, DAX – Ability to write SQL queries
• Source Control / Release Pipelines – Azure DevOps
• Familiarity with big data formats such as Parquet, Avro, and ORC, enhancing the ability to efficiently handle and process large datasets, along with experience in tax and/or accounting data to work with industry-specific datasets, preferred

License/Certifications:

• Microsoft Azure Data Engineer, preferred

Software:

• Experience with the following products, preferred:
• Microsoft Office Suite
• Microsoft Azure DevOps or GitHub
• Microsoft SQL Server and/or Azure SQL DB

Language:

• N/A

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