Data Engineer

  • Lima
  • Confidencial

The Role At TRANZACT, we strive to deliver go: to: market, data: driven solutions to top insurances companies in the USA. We are looking for a highly motivated, analytical and skilled Data Engineer / BI Developer to join our international teamResponsibilities: Provide ad hoc reporting support. Ability to quickly understand data landscape and source systems Investigate data discrepancies Develop automated file exports Support Analyst and Quality Engineering teams Collaborate with data and software engineers as well as non: technical business users. Design, build, and optimize analysis: friendly tables in our data warehouse. Partner with other business groups to build advanced reports and dashboards. Design and implement data models in our BI tool. Help implement andmaintain a comprehensive data dictionary. Drive training on metrics and self: service data platforms to enable a stronger data culture.

Requirements : Advanced English level. Strong drive to learn new systems and data models quickly. Solid knowledge of MS SQL Server and Transact SQL with a minimum 3 years of hands: on experience (Window functions, JSON Parsing, Date parsing, CTE, Merge statements), MDX /DAX knowledge a plus Solid knowledge of data warehousing principles, data base design, data cleansing and data integrity techniques, ETL processes and tools Strong data analysis skills Ability to work with data in various formats Experience with Python programming language

At TRANZACT, our hiring processes ensure equal conditions, objectivity and non: discrimination.