Data Engineer (Azure)

About TMF GroupTMF Group is a leading provider of critical administrative services, helping clients invest and operate safely around the world. Our 10,000 experts and 120 offices in 85 jurisdictions worldwide serve corporates, financial institutions, asset managers, private clients, and family offices, providing the combination of accounting, tax, payroll, fund administration, compliance, and entity management services essential to global business success.TMF India is a Great Place to Work, ISO & ISAE certified organization.Discover the roleThe primary role of the Data Engineer is to ensure the timely design and delivery of Data Lake / Data Warehouse / ETL Processes and PowerBI Reports & dashboards assigned by the development manager. The Developer is expected to work within the security standards and code quality requirements of the group including full documentation and use of source control.The Data Engineer will report to the Data & Analytics Technical Lead, and will be supported for growth by TMF Business Academy.Key ResponsibilitiesYou will produce high-quality, secure, and maintainable code in an agile environment;Understanding Business requirements and existing ecosystemParticipate in Effort Estimation, Work scheduling process with LeadsOrganize, store, analyze, and transform data from different sources and large datasets into information that can be utilized to make business decisions and actions, using various techniques and modelling of outputsCreate complex reports and dashboards using various technologies (Alteryx, Tableau/Power BI)Maintain regular reports and amend changes based on stakeholders' requirementsAnalyze, understand, and model data being used in the process and (re)define process flows, reporting, and data visualization that improves efficiency in how we deliver outputs and insights to our ClientsDesign Data Lake / Datawarehouse as per requirementsDesign and develop ETL process using SSIS/ADF/DatabricksDesign schema to manage Master DataDeliver the reports using Iterative, Agile, or Waterfall models as necessaryIdentify and test for bugs and bottlenecks in the solutionEnsure good performance and quality of reports/dashboards/ETL processesEnsure process complianceProvide Daily / Weekly updates on the progress of workIdentify areas of improvement and propose solutionsCandidate Profile3+ years of development experience in a Data Engineering roleUnderstanding of Data modeling techniquesWorking knowledge of Data Warehouses, Big Data, and Data LakesUnderstanding of Master data management and Data QualityWorking experience on any RDBMS SQL Server / Oracle / MySQLExperience handling Structured and semi-unstructured datasets like json, xmlStrong query writing skills, ability to write complex SQL queriesExperienced in extracting, cleaning, transforming, and integrating data across heterogeneous source systemsExperience in designing & developing pipelines for ETL / ELT scenariosGood working knowledge of ADF / DatabricksExperience working with Azure DevOpsGood experience in monitoring and troubleshooting Data pipelinesExperience working in an agile and iterative landscapeMicrosoft certifications are considered a plusWhat's in it for you?Pathways for career developmentWork with colleagues and clients around the world on interesting and challenging work.We provide internal career opportunities, so you can take your career further within TMF.Continuous development is supported through global learning opportunities from the TMF Business Academy.Making an impactYou'll be helping us to make the world a simpler place to do business for our clients.Through our corporate social responsibility program, you'll also be making a difference in the communities where we work.A supportive environmentStrong feedback culture to help build an engaging workplace.Our inclusive work environment allows you to work from our offices around the world, as well as from home, helping you find the right work-life balance to perform at your best.We are looking forward to getting to know you! PRB