Data Warehouse Engineer

Informatica, Talend, Azure Data Factory, Snowflake, Azure Synapse Analytics, or Amazon Redshift

You will ideally haveexperience in building solutions using a variety of tools, and a proven track record in delivering high quality work to tight deadlines.

Your main responsibilities will be:

• Design, develop, and maintain scalable data warehouse solutions using modern cloud-based platforms such as Snowflake, Azure Synapse Analytics, or Amazon Redshift to support enterprise-level analytics and reporting needs.
• Core responsibilities include building efficient Extract, Transform, Load (ETL) or Extract, Load, Transform (ELT) pipelines using tools like Informatica, Talend, or Azure Data Factory, conducting thorough data validation to ensure accuracy and consistency, and providing support for Business Intelligence (BI) reporting initiatives.
• Strong proficiency in SQL is required for querying and data manipulation, along with experience in dimensional data modeling to optimize analytical performance.
• Familiarity with reporting and visualization tools such as Power BI or Tableau is essential.
• Developing scalable and re-usable frameworks for ingestion and transformation of large data sets
• Integrating the end to end data pipeline to take data from source systems to target data repositories ensuring the quality and consistency of data is maintained at all times
• Working with other members of the project team to support delivery of additional project components (Reporting tools, API interfaces, Search)
• Evaluating the performance and applicability of multiple tools against customer requirements
• Working within an Agile delivery / DevOps methodology to deliver proof of concept and production implementation in iterative sprints.

• Bachelors or master's degree in Computer Science, Business Information Systems, Mathematics, or related quantitative field
• 3+ years of experience in DWH implementation
• Candidates must possess hands-on experience with Structured Query Language (SQL), data quality management tools, and should be proficient in facilitating data exchange through Application Programming Interfaces (APIs).
• Deep knowledge of operating systems and relational database with advanced SQL and Python skills
• Proficiency in the data concepts related to curation, archival, analysis, visualization and integrity
• Good knowledge in at least one business intelligence solution (e.g., Power BI)
• Strong analytical, critical-thinking, and problem-solving skills
• Excellent communication skills and team-oriented approach
• Have led minimum 2 mid-scale Data Warehouse projects
• Direct experience of building data piplines using Azure Data Factory and Databricks
• Experience building data warehouse solutions using ETL / ELT tools like Informatica, Talend, Azure DataFactory
• Comprehensive understanding of data management best practices including demonstrated experience with data profiling, sourcing, and cleansing routines utilizing typical data quality functions involving standardization, transformation, rationalization, linking and matching.

Nice to have

• Additional knowledge of data governance principles and metadata management practices is considered a valuable asset.